Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.firebolt.io/llms.txt

Use this file to discover all available pages before exploring further.

Returns an array of the same size and type as the original array, with the elements in reverse order. Nulls are retained.

​
Syntax

ARRAY_REVERSE(<array>)

​
Parameters

ParameterDescriptionSupported input types
<array>The array to be reversedARRAY of any type

​
Return Type

ARRAY of the same type as the input array

​
Example

The following example returns the reverse of the input array: 
SELECT
	ARRAY_REVERSE([ 1, 2, 3, 6 ]);
Returns: [6,3,2,1] Only the outermost array is reversed for nested arrays: 
SELECT
	ARRAY_REVERSE([[1,2,3], [4,5], NULL, [7], [8,9]]);
Returns: [[8,9], [7], NULL, [4,5], [1,2,3]]