ARRAY_UPPER

Reference material for ARRAY_UPPER function

Returns the maximum index that can be used for an array. Produces NULL for NULL arrays.

Because Firebolt currently does not support array slices, the maximum index is always the length of the array. This function is currently only implemented for the second parameter being 1.

Syntax

ARRAY_UPPER(<array>, <int>)

Parameters

Parameter	Description	Supported input types
<array>	The array whose upper bound should be calculated	ARRAY
<int>	The dimension to look at, for multi-dimensional arrays	INTEGER

Return Type

INTEGER

Examples

SELECT ARRAY_UPPER([1, 2, 3], 1);

array_upper int
3

Rows: 1Execution time: 5.12ms

SELECT ARRAY_UPPER([[1, 2], [3, 4], [5, 6]], 1);

array_upper int
3

Rows: 1Execution time: 4.58ms