| ARRAY_AVG | Returns the average of all non-null elements of a list. |
| ARRAY_CONTAINS | Returns whether a list contains a given value. |
| ARRAY_MAX | Returns the maximum value of a list. |
| ARRAY_MIN | Returns the minimum value of a list. |
| ARRAY_REMOVE | Removes all elements that equal a given value from a list. |
| 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. |