[CALCITE-5956] Support parsing non-standard collection types

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.35.0
• Component/s: core
• Assignee: hongyu guo
• Reporter: hongyu guo
• Created: 25/Aug/23 11:11
• Updated: 28/Dec/23 15:33
• Resolved: 28/Dec/23 15:33

Description

Calcite support SQL standard collection types. For example:

INTEGER ARRAY;
INTEGER ARRAY ARRAY;
VARCHAR(5) MULTISET;
INTEGER MULTISET ARRAY;

Many DBMS support a dialect of ARRAY<T> and MULITSET<T>,
I think Calcite can also support this dialect in core Parser.

Issue Links

• duplicates: CALCITE-5570 Support nested map type for SqlDataTypeSpec
• is related to: CALCITE-5658 Collection types are un-parsed incorrectly for Apache Spark
• relates to: CALCITE-5570 Support nested map type for SqlDataTypeSpec