You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@flink.apache.org by fh...@apache.org on 2017/11/07 23:15:07 UTC
[2/2] flink git commit: [hotfix] [docs] Fix UDTF join description in
SQL docs.
[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/dc1ca78a
Tree: http://git-wip-us.apache.org/repos/asf/flink/tree/dc1ca78a
Diff: http://git-wip-us.apache.org/repos/asf/flink/diff/dc1ca78a
Branch: refs/heads/release-1.4
Commit: dc1ca78a4e4cb339e9fbf0c90700f3204e091c53
Parents: b677c8d
Author: Fabian Hueske <fh...@apache.org>
Authored: Wed Nov 8 00:12:49 2017 +0100
Committer: Fabian Hueske <fh...@apache.org>
Committed: Wed Nov 8 00:15:21 2017 +0100
----------------------------------------------------------------------
docs/dev/table/sql.md | 11 +++++++++--
1 file changed, 9 insertions(+), 2 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/flink/blob/dc1ca78a/docs/dev/table/sql.md
----------------------------------------------------------------------
diff --git a/docs/dev/table/sql.md b/docs/dev/table/sql.md
index 8525ecf..2318271 100644
--- a/docs/dev/table/sql.md
+++ b/docs/dev/table/sql.md
@@ -440,11 +440,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
+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>