array_slice(array values, int offset [, int length]) – Slices the given array by the given

array_intersect(array1, array2) – Returns an array of the elements in the intersection of array1 andarray2,

array_join(array, delimiter[, nullReplacement]) – Concatenates the elements of the given array using the delimiter and

array_max(array) – Returns the maximum value in the array. NULL elements are skipped. Platforms: WhereOS,

array_min(array) – Returns the minimum value in the array. NULL elements are skipped. Platforms: WhereOS,

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,