This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
ARRAY_SLICE
Returns a slice of the array based on the indicated offset and length.
Syntax
ARRAY_SLICE(<array>, <start>[, <length>])
Parameters
| Parameter | Description | Supported input types |
|---|---|---|
<array> | The array of data to be sliced | ARRAY |
<start> | Indicates starting point of the array slice | INTEGER |
<length> | The length of the required slice | INTEGER |
Return Type
ARRAY of the same type as input array
Example
The following example slices the levels array to a different length:
SELECT
ARRAY_SLICE([ 1, 2, 3, 4, 5 ], 1, 3) AS levels;
Returns: [1, 2, 3]