[CALCITE-5695] Add MAP_KEYS and MAP_VALUES for Spark dialect

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.35.0
• Fix Version/s: 1.35.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Unassigned
• Reporter: Jacky Lau
• Created: 10/May/23 06:03
• Updated: 27/Jul/23 10:22
• Resolved: 21/May/23 02:33

Description

MAP_KEYS - Returns the keys of the map as an array, the order of the entries is not defined

MAP_VALUES - Returns the values of the map as an array, the order of the entries is not defined

For more details
https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html

Issue Links

• links to: GitHub Pull Request #3194