[ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17699870#comment-17699870 ]
Julian Hyde edited comment on CALCITE-5570 at 3/13/23 11:25 PM: ---------------------------------------------------------------- [~zabetak], We're using slightly different terminology - what I call a type constructor (in the [Standard ML sense|http://mlton.org/TypeConstructor]) is what you would call a type definition minus the angle brackets and arguments, {{UNIONTYPE}} for example - but we are in agreement that those things should use angle brackets. That 'thing' already exists in Calcite as [ApplySqlType|https://github.com/apache/calcite/blob/ee9b80b0b68d442991dfaa142722e3488ec73e79/core/src/main/java/org/apache/calcite/sql/type/ApplySqlType.java#L25]. [~Sergey Nuyanzin], Yes {{MULTISET<INTEGER>}} should be a synonym for INTEGER MULTISET. My list wasn't exhaustive. was (Author: julianhyde): [~zabetak], We're using slightly different terminology - what I call a type constructor (in the [Standard ML sense|http://mlton.org/TypeConstructor]) is what you would call a type definition minus the angle brackets and arguments, {{UNIONTYPE}} for example - but we are in agreement that those things should use angle brackets. [~Sergey Nuyanzin], Yes {{MULTISET<INTEGER>}} should be a synonym for INTEGER MULTISET. My list wasn't exhaustive. > Support nested map type for SqlDataTypeSpec > ------------------------------------------- > > Key: CALCITE-5570 > URL: https://issues.apache.org/jira/browse/CALCITE-5570 > Project: Calcite > Issue Type: Improvement > Components: core > Reporter: Sergey Nuyanzin > Assignee: Jiajun Xie > Priority: Major > Labels: pull-request-available > Time Spent: 40m > Remaining Estimate: 0h > > 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 > {code:sql} > 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>); > {code} > > -- This message was sent by Atlassian Jira (v8.20.10#820010)