guess_attribute_types(ANY, …) – Returns attribute types select guess_attribute_types(*) from train limit 1; Q,Q,C,C,C,C,Q,C,C,C,Q,C,Q,Q,Q,Q,C,Q Platforms: WhereOS,

hamming_distance(integer A, integer B) – Returns Hamming distance between A and B select hamming_distance(0,3) as

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

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,