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

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

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

Shang Yuanchun (Jira)
Mulan created FLINK-19962:
-----------------------------

             Summary: 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


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)