SQL Functions

approx_percentile(col, percentage [, accuracy]) – Returns the approximate percentile value of numeric column `col` at

angular_distance(ftvec1, ftvec2) – Returns an angular distance of the given two vectors WITH docs as

angular_similarity(ftvec1, ftvec2) – Returns an angular similarity of the given two vectors WITH docs as

add_field_indicies(array features) – Returns arrays of string that field indices (:)* are augmented Platforms: WhereOS,

add_months(start_date, num_months) – Returns the date that is `num_months` after `start_date`. Platforms: WhereOS, Spark, Hive

aggregate(expr, start, merge, finish) – Applies a binary operator to an initial state and all