| ARRAYS_OVERLAP | Compares whether two arrays have at least one element in common. Returns true if the arrays have one or more elements in common; otherwise returns false. |
| ARRAY_AGG | Aggregates the provided expression into an array. |
| ARRAY_APPEND | Appends an element to the end of an array. |
| 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_DISTINCT | Given an input array, returns an equivalent array that includes only distinct elements. |
| ARRAY_FREQUENCY | Returns a map of key-value pairs: keys are the unique elements in the input array and values specify how many times the keys appear in the input array. |
| ARRAY_GENERATE_RANGE | Returns an array of integers in the specified range. |
| ARRAY_INSERT | Returns an array that contains all of the elements from the input array as well as a new element inserted in the specified position. |
| 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_PREPEND | Prepends an element to the beginning of 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_SLICE | Returns an array constructed from the specified subset of elements in the input array. |
| ARRAY_SUM | Returns the sum of all non-null elements of a list. |
| ARRAY_TO_STRING | Returns a string of the values from the input array, with the values separated by the specified delimiter string. |
| CARDINALITY | Returns the number of elements contained in the specified list or map. |
| FLATTEN | Explodes compound values into multiple rows. The FLATTEN 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. |
| SET_UNION | Given two arrays, returns a single array that includes all of the elements in the given arrays, without duplicates. |
| SUBLIST | Returns an array constructed from the specified subset of elements of the input array. |