instr(str, substr) – Returns the (1-based) index of the first occurrence of `substr` in `str`.

int(expr) – Casts the value `expr` to the target data type `int`. Platforms: WhereOS, Spark,

intersect_array(array1, array2, …) – Returns the intersection of a set of arrays Platforms: WhereOS, Spark,

is_finite(x) – Determine if x is finite. SELECT is_finite(333), is_finite(infinity()); true false Platforms: WhereOS, Spark,

input_file_block_length() – Returns the length of the block being read, or -1 if not available.

input_file_block_start() – Returns the start offset of the block being read, or -1 if not