array_flatten(array) – Returns an array with the elements flattened. SELECT array_flatten(array(array(1,2,3),array(4,5),array(6,7,8))); [1,2,3,4,5,6,7,8] Platforms: WhereOS, Spark,

array_hash_values(array values, [string prefix [, int numFeatures], boolean useIndexAsPrefix]) returns hash values in array Platforms:

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

array_distinct(array) – Removes duplicate values from the array. Platforms: WhereOS, Spark, Hive Class: org.apache.spark.sql.catalyst.expressions.ArrayDistinct More

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