Blog

unbase91(string) – Convert a BASE91 string to a binary SELECT inflate(unbase91(base91(deflate(‘aaaaaaaaaaaaaaaabbbbccc’)))); aaaaaaaaaaaaaaaabbbbccc Platforms: WhereOS, Spark,

try_cast(ANY src, const string typeName) – Explicitly cast a value as a type. Returns null

ucase(str) – Returns `str` with all characters changed to uppercase. Platforms: WhereOS, Spark, Hive Class:

udfarrayconcat(values) – Concatenates the array arguments Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.UDFArrayConcat More functions can

Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.collect.TruncateArrayUDF More functions can be added to WhereOS via Python

trunc(date, fmt) – Returns `date` with the time portion of the day truncated to the