| ARRAY_AVG | Returns the average of all non-null elements of a list. |
| ARRAY_CAT | Returns a concatenation of two arrays. |
| ARRAY_COMPACT | Returns the input array without null values. |
| ARRAY_CONTAINS | Returns whether a list contains a given value. |
| ARRAY_GENERATE_RANGE | Returns an array of integers in the specified range. |
| ARRAY_MAX | Returns the maximum value of a list. |
| ARRAY_MIN | Returns the minimum value of a list. |
| ARRAY_POSITION | Returns the index of the first occurrence of an element in an array. |
| ARRAY_REMOVE | Removes all elements that equal a given value from a list. |
| ARRAY_REMOVE_AT | Returns the input array with the element at the specified position removed. |
| ARRAY_SIZE | Returns the size of the input array. |
| ARRAY_SUM | Returns the sum of all non-null elements of a list. |
| CARDINALITY | Returns the number of elements contained in the specified list or map. |
| FLATTEN | Explodes compound values into multiple rows. This function takes a LIST column and produces a lateral view (that is, an inline view that contains correlation referring to other tables that precede it in the FROM clause). |
| MAP_KEYS | Returns all keys from a map expression. |
| MAP_VALUES | Returns all values from a map expression. |