SQL Functions

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

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

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