[FLINK-31200] Add MAP_VALUES supported in SQL & Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.18.0
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Assignee: Unassigned
• Reporter: Jacky Lau
• Created: 23/Feb/23 11:30
• Updated: 30/Mar/23 05:08
• Resolved: 21/Mar/23 06:59

Description

Returns an unordered array containing the values of the map.

Syntax:
map_values(map)

Arguments:
map An Map to be handled.

Returns:

An Map. If value is NULL, the result is NULL. 
Examples:

> SELECT map_values(map(1, 'a', 2, 'b'));
 - ["a","b"]

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

Issue Links

• is a child of: FLINK-22484 Built-in functions for collections