[ https://issues.apache.org/jira/browse/FLINK-32257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17738974#comment-17738974 ]
Dawid Wysakowicz commented on FLINK-32257: ------------------------------------------ The thing is I merged it again with a fix for tests. Now [~jackylau] pointed an issue in the logic. > Add ARRAY_MAX support in SQL & Table API > ---------------------------------------- > > Key: FLINK-32257 > URL: https://issues.apache.org/jira/browse/FLINK-32257 > Project: Flink > Issue Type: Improvement > Components: Table SQL / Planner > Affects Versions: 1.18.0 > Reporter: Bonnie Varghese > Assignee: Hanyu Zheng > Priority: Major > Labels: pull-request-available > Fix For: 1.18.0 > > > This is an implementation of ARRAY_MAX > The array_max() function concatenates get the maximum element from input > array. > The result matches the type of the elements. NULL elements are skipped. If > array is empty, or contains only NULL elements, NULL is returned. > > Syntax > array_max(array) > Arguments > array: Any ARRAY with elements for which order is supported. > > Returns > The result matches the type of the elements. NULL elements are skipped. If > array is empty, or contains only NULL elements, NULL is returned. > > Examples > SQL > > > SELECT array_max(array(1, 20, NULL, 3)); 20 > > {code:java} > // Fink SQL-> select array_max(array[1, 20, null, 3]) > 20{code} > > See also > spark > [https://spark.apache.org/docs/latest/api/sql/index.html#array_max|https://spark.apache.org/docs/latest/api/sql/index.html#array_min] > presto [https://prestodb.io/docs/current/functions/array.html] -- This message was sent by Atlassian Jira (v8.20.10#820010)