[jira] [Commented] (CALCITE-5570) Support nested map type for SqlDataTypeSpec

["Sergey Nuyanzin (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CALCITE-5570?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17699318#comment-17699318 ] 

Sergey Nuyanzin commented on CALCITE-5570:
------------------------------------------

[~jiajunbernoulli] thanks for the PR.

I think it would make sense to add a test in {{misq.iq}}.

I thing that I would clarify is if it is ok to use angle brackets here (as done in PR right now) since it is unusual for Calcite and SQL.... //cc [~julianhyde]

> 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: 20m
>  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)