[FLINK-26948] Add SORT_ARRAY supported in SQL & Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Fix Version/s: 1.20.0
• Component/s: Table SQL / API
• Labels: pull-request-available stale-assigned
• Assignee: Hanyu Zheng
• Reporter: dalongliu
• Created: 31/Mar/22 07:46
• Updated: 16/Feb/24 09:40
• Resolved: 16/Feb/24 09:40

Description

Returns the array in expr in sorted order.

Syntax:

sort_array(expr [, ascendingOrder] ) 

Arguments:

• expr: An ARRAY expression of sortable elements.

• ascendingOrder: An optional BOOLEAN expression defaulting to true.

Returns:

The result type matches expr.

Sorts the input array in ascending or descending order according to the natural ordering of the array elements. NULL elements are placed at the beginning of the returned array in ascending order or at the end of the returned array in descending order.

Examples:

> SELECT sort_array(array('b', 'd', NULL, 'c', 'a'), true);
 [NULL,a,b,c,d] 

See more:

• Spark
• Hive

Issue Links

• is duplicated by: FLINK-32258 Add ARRAY_SORT support in SQL & Table API
• links to: GitHub Pull Request #22951