dalongliu created FLINK-26948:
---------------------------------
Summary: Add SORT_ARRAY supported in SQL & Table API
Key: FLINK-26948
URL: https://issues.apache.org/jira/browse/FLINK-26948
Project: Flink
Issue Type: Sub-task
Components: Table SQL / API
Reporter: dalongliu
Fix For: 1.16.0
Returns the array in {{expr}} in sorted order.
Syntax:
{code:java}
sort_array(expr [, ascendingOrder] ) {code}
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:
{code:java}
> SELECT sort_array(array('b', 'd', NULL, 'c', 'a'), true);
[NULL,a,b,c,d] {code}
See more:
*
[Spark|https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html#date-and-timestamp-functions]
* [Hive|https://cwiki.apache.org/confluence/display/hive/languagemanual+udf]
--
This message was sent by Atlassian Jira
(v8.20.1#820001)
