ARRAY_SLICE

Reference material for ARRAY_SLICE function

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;

levels array(int)
[1, 2, 3]

Rows: 1Execution time: 12.61ms