guess_attribute_types

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

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

hash

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

hash_md5

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

greatest

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

group_count

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