[FLINK-31621] Add ARRAY_REVERSE supported in SQL & Table API

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Affects Version/s: 1.18.0
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Jacky Lau
• Reporter: Jacky Lau
• Created: 27/Mar/23 05:24
• Updated: 31/Mar/23 11:11
• Resolved: 31/Mar/23 11:11

Description

array_reverse(array) - Returns an array in reverse order.

Syntax:
array_reverse(array)

Arguments:
array: An ARRAY to be handled.

Returns:

Returns an array in reverse order.

Returns null if the argument is null

> SELECT array_reverse(array(1, 2, 2, NULL));
 NULL, 2, 2, 1

See also
bigquery https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#array_reverse

Issue Links

• is a child of: FLINK-22484 Built-in functions for collections
• links to: GitHub Pull Request #22277