[
https://issues.apache.org/jira/browse/CALCITE-1250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15292203#comment-15292203
]
Julian Hyde commented on CALCITE-1250:
--------------------------------------
It's not in the standard, but
[Presto|https://prestodb.io/docs/current/sql/select.html#unnest] also does
this, and it's a very useful feature.
I quickly reviewed the PR, and it looks as if you're on the right track. Can
you add a test (maybe in SqlValidatorTest) to make sure that the columns are
called KEY and VALUE when not aliased. Can you also make it work if UNNEST has
more than one argument.
> Unnest should work with map data types
> --------------------------------------
>
> Key: CALCITE-1250
> URL: https://issues.apache.org/jira/browse/CALCITE-1250
> Project: Calcite
> Issue Type: New Feature
> Components: core
> Reporter: Johannes Schulte
> Assignee: Julian Hyde
> Priority: Minor
>
> Unnest should also work with map data types and emit two columns for key and
> value of all entries, similar to what drill is doing with kv_gen() and hive
> with explode()
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
