[FLINK-32256] Add ARRAY_MIN support in SQL & Table API

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Implemented
• Affects Version/s: 1.18.0
• Fix Version/s: 1.19.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available stale-assigned
• Assignee: Hanyu Zheng
• Reporter: Bonnie Varghese
• Created: 05/Jun/23 17:55
• Updated: 12/Jan/24 09:10
• Resolved: 12/Jan/24 09:10

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:

SELECT array_min(array(1, 20, NULL, 3));
-- 1

See also
spark https://spark.apache.org/docs/latest/api/sql/index.html#array_min

presto https://prestodb.io/docs/current/functions/array.html

Issue Links

• links to: GitHub Pull Request #22922
• links to: GitHub Pull Request #24071