array_to_str(array arr [, string sep=’,’]) – Convert array to string using a sperator SELECT array_to_str(array(1,2,3),’-‘);

array_union(array1, array2) – Returns an array of the elements in the union of array1 and

array_sort(array) – Sorts the input array in ascending order. The elements of the input array

array_position(array, element) – Returns the (1-based) index of the first element of the array as

array_remove(array, element) – Remove all elements that equal to element from array. Platforms: WhereOS, Spark,

array_repeat(element, count) – Returns the array containing element count times. Platforms: WhereOS, Spark, Hive Class: