Array functions
Array functions create, manage, and manipulate arrays (lists of indexed values).
Array | Returns an array containing specified values. |
ArrayContains | Searches for a specific value in an array. If the value is found, the function returns True , otherwise it returns False . |
ArrayDistinct | Returns the array without duplicate values. |
ArrayJoin | Joins elements of an array into a single text string. |
ArrayLength | Determines the number of entries in an array, or list. |
ArraySlice | Returns a portion of an array, defined by the starting index and length. |
Sequence | Returns an arithmetic sequence as an array of integers based on a specified range and increment |
The following aggregate functions also create arrays:
ArrayAgg | Identifies non-null row values in a column or group and aggregates them into a single array. |
ArrayAggDistinct | Identifies distinct non-null row values in a column or group and aggregates them into a single array. |
Updated 2 months ago