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

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

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