[
https://issues.apache.org/jira/browse/FLINK-20796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Nico Kruber updated FLINK-20796:
--------------------------------
Comment: was deleted
(was: Isn't this already there in Flink 1.11 (albeit a bit hidden):
{code}
SELECT users, tag
FROM Orders CROSS JOIN UNNEST(tags) AS t (tag)
{code}
Also works in this form:
{code}
SELECT users, tag
FROM Orders, UNNEST(tags) AS t (tag)
{code}
You'll find it under "Expanding arrays into a relation" in
https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/sql/queries.html)
> Support unnest in the Table API
> -------------------------------
>
> Key: FLINK-20796
> URL: https://issues.apache.org/jira/browse/FLINK-20796
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: Dian Fu
> Priority: Major
> Fix For: 1.13.0
>
>
> Currently, there is no corresponding functionality in Table API for the
> following SQL:
> {code:java}
> SELECT a, s FROM T, UNNEST(T.b) as A(s) {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
