SQL Functions

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

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

initcap(str) – Returns `str` with the first letter of each word in uppercase. All other

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

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

expr1 in(expr2, expr3, …) – Returns true if `expr` equals to any valN. Platforms: WhereOS,