[ https://issues.apache.org/jira/browse/FLINK-19962?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17225921#comment-17225921 ]
Mulan commented on FLINK-19962: ------------------------------- Please assign this fix to me, thanks. > 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 > Reporter: Mulan > Priority: Minor > > 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)