Uploaded image for project: 'Flink'
  1. Flink
  2. FLINK-19140

Join with Table Function (UDTF) SQL example is incorrect

    XMLWordPrintableJSON

    Details

      Description

      Section "Join with Table Function (UDTF)" of https://ci.apache.org/projects/flink/flink-docs-master/dev/table/sql/queries.html currently is:

      SELECT users, tag
      FROM Orders, LATERAL TABLE(unnest_udtf(tags)) t AS tag
      -- and 
      SELECT users, tag
      FROM Orders LEFT JOIN LATERAL TABLE(unnest_udtf(tags)) t AS tag ON TRUE
      

       
      however, it should be:

      SELECT users, tag
      FROM Orders, LATERAL TABLE(unnest_udtf(tags)) AS t(tag)
      -- and 
      SELECT users, tag
      FROM Orders LEFT JOIN LATERAL TABLE(unnest_udtf(tags)) AS t(tag) ON TRUE
      

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                libenchao Benchao Li
                Reporter:
                libenchao Benchao Li
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: