[CALCITE-5772] Add MAP_CONCAT, MAP_FROM_ENTRIES for Spark dialect

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Resolved
• Affects Version/s: 1.35.0
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jacky Lau
• Reporter: Jacky Lau
• Created: 08/Jun/23 09:48
• Updated: 30/Jun/23 02:11
• Resolved: 30/Jun/23 02:07

Description

map_concat

map_concat(map, ...) - Returns the union of all the given maps

Examples:

 

> SELECT map_concat(map(1, 'a', 2, 'b'), map(3, 'c'));
 {1:"a",2:"b",3:"c"} 

 

 

map_from_entries

map_from_entries(arrayOfEntries) - Returns a map created from the given array of entries.

Examples:

 

> SELECT map_from_entries(array(struct(1, 'a'), struct(2, 'b')));
 {1:"a",2:"b"} 

 

 

Issue Links

• links to: GitHub Pull Request #3262