SQL Functions

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

euclid_distance(ftvec1, ftvec2) – Returns the square root of the sum of the squared differences: sqrt(sum((x

euclid_similarity(ftvec1, ftvec2) – Returns a euclid distance based similarity, which is `1.0 / (1.0 +

exists(expr, pred) – Tests whether a predicate holds for one or more elements in the

encode(str, charset) – Encodes the first argument using the second argument character set. Platforms: WhereOS,

estimated_reach(x) – Estimate reach from a sketch set of Strings. Platforms: WhereOS, Spark, Hive Class: