Blog

hash_md5(x) – Hash MD5. Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.sketch.HashMD5UDF More functions can be added

greatest(expr, …) – Returns the greatest value of all parameters, skipping null values. Platforms: WhereOS,

A sequence id for all rows with the same value for a specific grouping Platforms:

grouping(col) – indicates whether a specified column in a GROUP BY is aggregated or not,

grouping_id([col1[, col2 ..]]) – returns the level of grouping, equals to `(grouping(c1)

Platforms: WhereOS, Spark, Hive Class: com.whereos.udf.GeoKeysUDTF More functions can be added to WhereOS via Python