[hotfix] [docs] Fix UDTF join description in SQL docs.
Project: http://git-wip-us.apache.org/repos/asf/flink/repo Commit: http://git-wip-us.apache.org/repos/asf/flink/commit/6bf24b96 Tree: http://git-wip-us.apache.org/repos/asf/flink/tree/6bf24b96 Diff: http://git-wip-us.apache.org/repos/asf/flink/diff/6bf24b96 Branch: refs/heads/release-1.3 Commit: 6bf24b9680cea0a16e0a62120c1a67255491c542 Parents: c8b4539 Author: Fabian Hueske <fhue...@apache.org> Authored: Wed Nov 8 00:12:49 2017 +0100 Committer: Fabian Hueske <fhue...@apache.org> Committed: Wed Nov 8 00:20:42 2017 +0100 ---------------------------------------------------------------------- docs/dev/table/sql.md | 13 ++++++++++--- 1 file changed, 10 insertions(+), 3 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/flink/blob/6bf24b96/docs/dev/table/sql.md ---------------------------------------------------------------------- diff --git a/docs/dev/table/sql.md b/docs/dev/table/sql.md index 00222ef..bb5f31c 100644 --- a/docs/dev/table/sql.md +++ b/docs/dev/table/sql.md @@ -386,11 +386,18 @@ FROM Orders CROSS JOIN UNNEST(tags) AS t (tag) </td> <td> <p>UDTFs must be registered in the TableEnvironment. See the <a href="udfs.html">UDF documentation</a> for details on how to specify and register UDTFs. </p> - <p><b>Note:</b> Currently only literal <code>TRUE</code> can be accepted as the predicate for the left outer join against a lateral table.</p> + <p>Inner Join</p> {% highlight sql %} -SELECT users, tag -FROM Orders LATERAL VIEW UNNEST_UDTF(tags) t AS tag +SELECT users, tag +FROM Orders, LATERAL TABLE(unnest_udtf(tags)) t AS tag +{% endhighlight %} + <p>Left Outer Join</p> +{% highlight sql %} +SELECT users, tag +FROM Orders LEFT JOIN LATERAL TABLE(unnest_udtf(tags)) t AS tag ON TRUE {% endhighlight %} + +<p><b>Note:</b> Currently, only literal <code>TRUE</code> is supported as predicate for a left outer join against a lateral table.</p> </td> </tr> </tbody>