input_file_block_length
input_file_block_length() – Returns the length of the block being read, or -1 if not available.
inflate
inflate(BINARY compressedData) – Returns a decompressed STRING by using Inflater SELECT inflate(unbase91(base91(deflate(‘aaaaaaaaaaaaaaaabbbbccc’)))); aaaaaaaaaaaaaaaabbbbccc Platforms: WhereOS,
initcap
initcap(str) – Returns `str` with the first letter of each word in uppercase. All other
inline
inline(expr) – Explodes an array of structs into a table. Platforms: WhereOS, Spark, Hive Class:
inline_outer
inline_outer(expr) – Explodes an array of structs into a table. Platforms: WhereOS, Spark, Hive Class:
in
expr1 in(expr2, expr3, …) – Returns true if `expr` equals to any valN. Platforms: WhereOS,
