hash(expr1, expr2, …) – Returns a hash value of the arguments. Platforms: WhereOS, Spark, Hive

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)