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

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

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

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