SQL Functions

array(expr, …) – Returns an array with the given elements. Platforms: WhereOS, Spark, Hive Class:

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

expr1 and expr2 – Logical AND. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.And More functions can

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