flink-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From fhue...@apache.org
Subject [2/2] flink git commit: [hotfix] [docs] Fix UDTF join description in SQL docs.
Date Tue, 07 Nov 2017 23:15:07 GMT
[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 <fhueske@apache.org>
Authored: Wed Nov 8 00:12:49 2017 +0100
Committer: Fabian Hueske <fhueske@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>


Mime
View raw message