[FLINK-31199] Add MAP_KEYS supported in SQL & Table API

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jacky Lau
• Created: 23/Feb/23 11:27
• Updated: 23/Feb/23 12:25
• Resolved: 23/Feb/23 12:06

Description

Returns an unordered array containing the keys of the map.

Syntax:
map_keys(map)

Arguments:
map An Map to be handled.

Returns:

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

> SELECT map_keys(map(1, 'a', 2, 'b'));
 [1,2] 

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

 

 

Issue Links

• is duplicated by: FLINK-22484 Built-in functions for collections
• links to: GitHub Pull Request #22005