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

elt(n, input1, input2, …) – Returns the `n`-th input, e.g., returns `input2` when `n` is

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