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

input_file_name() – Returns the name of the file being read, or empty string if not

inline(expr) – Explodes an array of structs into a table. Platforms: WhereOS, Spark, Hive Class: