[CALCITE-5570] Support nested map type for SqlDataTypeSpec

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.36.0
• Component/s: core
• Labels: pull-request-available
• Assignee: Jiajun Xie
• Reporter: Sergey Nuyanzin
• Created: 09/Mar/23 17:16
• Updated: 28/Dec/23 15:33
• Resolved: 01/Oct/23 06:58

Description

There was added a similar support for arrays/multisets at https://issues.apache.org/jira/browse/CALCITE-3250
however there is no support for maps so far.

The issue is to add such support.

 

I think I'd like to clarify is syntax for maps since it has 2 internal subtypes for keys and values may be something similar to ROW with delimiter like

SELECT CAST(NULL AS MAP(INT, INT));
-- or with square brackets similar to map constructor
SELECT CAST(NULL AS MAP[INT, INT]);
-- or with angle (Flink syntax)
SELECT CAST(NULL AS MAP<INT, INT>);

 

 
 

Issue Links

• is duplicated by: CALCITE-5956 Support parsing non-standard collection types
• is related to: CALCITE-5956 Support parsing non-standard collection types
• relates to: CALCITE-5658 Collection types are un-parsed incorrectly for Apache Spark
• links to: GitHub Pull Request #3105
• links to: GitHub Pull Request #3469