Blog

unix_timestamp([timeExp[, format]]) – Returns the UNIX timestamp of current or specified time. Platforms: WhereOS, Spark,

union_map(x) – Returns a map which contains the union of an aggregation of maps Platforms:

union_hyperloglog(x) – Merges multiple hyperloglogs together. Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.hll.UnionHyperLogLogUDAF More functions can

unhex(expr) – Converts hexadecimal `expr` to binary. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.Unhex More functions

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

unbits(long[] bitset) – Returns an long array of the give bitset representation SELECT unbits(to_bits(array(1,4,2,3))); [1,2,3,4]