[jira] [Reopened] (FLINK-19962) fix doc: more examples for expanding arrays into a relation

["Wong Mulan (Jira)" <ji...@apache.org>]

     [ 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)