array_append(array arr, T elem) – Append an element to the end of an array SELECT

array_avg(array) – Returns an array in which each element is the mean of a set

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