[FLINK-31677] Add MAP_ENTRIES supported in SQL & Table API

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.18.0
• Fix Version/s: 1.18.0
• Component/s: Table SQL / Planner
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jacky Lau
• Created: 31/Mar/23 04:00
• Updated: 08/Jun/23 09:37
• Resolved: 08/Jun/23 09:37

Description

map_entries(map) - Returns an unordered array of all entries in the given map.

Syntax:
map_entries(map)

Arguments:
map: An MAP to be handled.

Returns:

Returns an unordered array of all entries in the given map.

Returns null if the argument is null

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

See also
presto https://prestodb.io/docs/current/functions/map.html

spark https://spark.apache.org/docs/latest/api/sql/index.html#map_entries

Issue Links

• is a child of: FLINK-22484 Built-in functions for collections
• links to: GitHub Pull Request #22312