array_concat(array x1, array x2, ..) – Returns a concatenated array SELECT array_concat(array(1),array(2,3)); [1,2,3] Platforms: WhereOS,

array_contains(array, value) – Returns true if the array contains the value. Platforms: WhereOS, Spark, Hive

argmin_kld(float mean, float covar) – Returns mean or covar that minimize a KL-distance among distributions

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

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

approx_count_distinct(expr[, relativeSD]) – Returns the estimated cardinality by HyperLogLog++. `relativeSD` defines the maximum estimation error