[ https://issues.apache.org/jira/browse/FLINK-26948?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dawid Wysakowicz closed FLINK-26948. ------------------------------------ Fix Version/s: 1.20.0 Assignee: Hanyu Zheng (was: Jörn Kottmann) Resolution: Implemented Implemented in 620e5975985944a02886b82362a2bc1774c733e3 > 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 > Assignee: Hanyu Zheng > Priority: Major > Labels: pull-request-available, stale-assigned > Fix For: 1.20.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.10#820010)