This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
ARRAY_UNNEST (deprecated)
ARRAY_UNNEST is deprecated. Instead, we recommend using the UNNEST clause in a SELECT statement. For more information and examples, see SELECT.
This function “unfolds” a given array by creating a column result containing the individual members from the array’s values.
Syntax
ARRAY_UNNEST(<arr>)
| Parameter | Description |
|---|---|
<arr> | The array to be unfolded. |
Example
SELECT
ARRAY_UNNEST([ 1, 2, 3, 4 ]) AS res;
Returns:
| res |
|---|
| 1 |
| 2 |
| 3 |
| 4 |