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

inflate(BINARY compressedData) – Returns a decompressed STRING by using Inflater SELECT inflate(unbase91(base91(deflate(‘aaaaaaaaaaaaaaaabbbbccc’)))); aaaaaaaaaaaaaaaabbbbccc Platforms: WhereOS,

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