[
https://issues.apache.org/jira/browse/FLINK-19962?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Wong Mulan reopened FLINK-19962:
--------------------------------
> fix doc: more examples for expanding arrays into a relation
> -----------------------------------------------------------
>
> Key: FLINK-19962
> URL: https://issues.apache.org/jira/browse/FLINK-19962
> Project: Flink
> Issue Type: Improvement
> Components: Documentation, Table SQL / API
> Reporter: Wong Mulan
> Assignee: Wong Mulan
> Priority: Minor
> Labels: pull-request-available
>
> https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/queries.html
> The ' Expanding arrays into a relation ' section is so simple. I can not
> understand the usage when I see this section.
> It should be added more examples.
> The following examples
> {quote}SELECT a, b, v FROM T CROSS JOIN UNNEST(c) as f (k, v){quote}
> {quote}SELECT a, s FROM t2 LEFT JOIN UNNEST(t2.`set`) AS A(s){quote}
> {quote}SELECT a, km v FROM t2 CROSS JOIN UNNEST(t2.c) AS A(k, v){quote}
> or add some Table field description. For example, field 'set' type of table
> t2 is array or map.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
