[ https://issues.apache.org/jira/browse/FLINK-32256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dawid Wysakowicz updated FLINK-32256: ------------------------------------- Description: Find the minimum among all elements in the array for which ordering is supported. Syntax: array_min(array) Arguments: array: An ARRAY to be handled. 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: {code:sql} SELECT array_min(array(1, 20, NULL, 3)); -- 1 {code} See also spark [https://spark.apache.org/docs/latest/api/sql/index.html#array_min] presto [https://prestodb.io/docs/current/functions/array.html] was: 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] > Add ARRAY_MIN support in SQL & Table API > ---------------------------------------- > > Key: FLINK-32256 > URL: https://issues.apache.org/jira/browse/FLINK-32256 > Project: Flink > Issue Type: Bug > Components: Table SQL / Planner > Affects Versions: 1.18.0 > Reporter: Bonnie Varghese > Assignee: Hanyu Zheng > Priority: Major > Fix For: 1.18.0 > > > Find the minimum among all elements in the array for which ordering is > supported. > Syntax: > array_min(array) > Arguments: > array: An ARRAY to be handled. > 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: > {code:sql} > SELECT array_min(array(1, 20, NULL, 3)); > -- 1 > {code} > See also > spark [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)