SQL Functions

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

add_bias(feature_vector in array) – Returns features with a bias in array Platforms: WhereOS, Spark, Hive

Platforms: WhereOS, Spark, Hive Class: brickhouse.udf.date.AddDaysUDF More functions can be added to WhereOS via Python

add_feature_index(ARRAY[DOUBLE]: dense feature vector) – Returns a feature vector with feature indices Platforms: WhereOS, Spark,

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