Blog

haversine_distance(double lat1, double lon1, double lat2, double lon2, [const boolean mile=false])::double – return distance between

hbase_balanced_key(keyStr,numRegions) – Returns an HBase key balanced evenly across regions Platforms: WhereOS, Spark, Hive Class:

hbase_batch_get(table,key,family) – Do a single HBase Get on a table Platforms: WhereOS, Spark, Hive Class:

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