[
https://issues.apache.org/jira/browse/FLINK-32257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Bonnie Varghese updated FLINK-32257:
------------------------------------
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:
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_max(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]
> Add ARRAY_MIN 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
> 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)
