SQL Functions

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,

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:

infinity() – Returns the constant representing positive infinity. Platforms: WhereOS, Spark, Hive Class: hivemall.tools.math.InfinityUDF More