This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 89c4dcc80d Publish built docs triggered by
6479e43f864e64359119e5453e008f4a5e124079
89c4dcc80d is described below
commit 89c4dcc80d3751280940da6683c2e1ca2639232f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Oct 10 02:09:25 2025 +0000
Publish built docs triggered by 6479e43f864e64359119e5453e008f4a5e124079
---
_sources/user-guide/sql/select.md.txt | 26 ++++++++++++++++++++++++++
objects.inv | Bin 2136 -> 2150 bytes
searchindex.js | 2 +-
user-guide/sql/select.html | 29 +++++++++++++++++++++++++++++
4 files changed, 56 insertions(+), 1 deletion(-)
diff --git a/_sources/user-guide/sql/select.md.txt
b/_sources/user-guide/sql/select.md.txt
index 8c1bc401d3..baacf432f5 100644
--- a/_sources/user-guide/sql/select.md.txt
+++ b/_sources/user-guide/sql/select.md.txt
@@ -350,6 +350,7 @@ DataFusion currently supports the following pipe operators:
- [INTERSECT](#pipe_intersect)
- [EXCEPT](#pipe_except)
- [AGGREGATE](#pipe_aggregate)
+- [JOIN](#pipe_join)
(pipe_where)=
@@ -514,3 +515,28 @@ select * from range(0,3)
| 3 |
+-------+
```
+
+(pipe_join)=
+
+### JOIN
+
+```sql
+(
+ SELECT 'apples' AS item, 2 AS sales
+ UNION ALL
+ SELECT 'bananas' AS item, 5 AS sales
+)
+|> AS produce_sales
+|> LEFT JOIN
+ (
+ SELECT 'apples' AS item, 123 AS id
+ ) AS produce_data
+ ON produce_sales.item = produce_data.item
+|> SELECT produce_sales.item, sales, id;
++--------+-------+------+
+| item | sales | id |
++--------+-------+------+
+| apples | 2 | 123 |
+| bananas| 5 | NULL |
++--------+-------+------+
+```
diff --git a/objects.inv b/objects.inv
index adeda570fb..2ff8fe19c9 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/searchindex.js b/searchindex.js
index 56d1fce315..a78e63de14 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[58,"op-neq"]],"!~":[[58,"op-re-not-match"]],"!~*":[[58,"op-re-not-match-i"]],"!~~":[[58,"id19"]],"!~~*":[[58,"id20"]],"#":[[58,"op-bit-xor"]],"%":[[58,"op-modulo"]],"&":[[58,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[13,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[58,"op-multiply"]],"+":[[58,"op-plus"]],"-":[[58,"op-minus"]],"/":[[58,"op-divide"]],"<":[[58,"op-lt"]],"<
[...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[58,"op-neq"]],"!~":[[58,"op-re-not-match"]],"!~*":[[58,"op-re-not-match-i"]],"!~~":[[58,"id19"]],"!~~*":[[58,"id20"]],"#":[[58,"op-bit-xor"]],"%":[[58,"op-modulo"]],"&":[[58,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[13,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[58,"op-multiply"]],"+":[[58,"op-plus"]],"-":[[58,"op-minus"]],"/":[[58,"op-divide"]],"<":[[58,"op-lt"]],"<
[...]
\ No newline at end of file
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 366be69650..06b42e1e2b 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -728,6 +728,11 @@
AGGREGATE
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#join">
+ JOIN
+ </a>
+ </li>
</ul>
</li>
</ul>
@@ -1071,6 +1076,7 @@ The SQL dialect can be set like this:</p>
<li><p><a class="reference internal"
href="#pipe-intersect">INTERSECT</a></p></li>
<li><p><a class="reference internal" href="#pipe-except">EXCEPT</a></p></li>
<li><p><a class="reference internal"
href="#pipe-aggregate">AGGREGATE</a></p></li>
+<li><p><a class="reference internal" href="#pipe-join">JOIN</a></p></li>
</ul>
<section id="where">
<span id="pipe-where"></span><h3>WHERE<a class="headerlink" href="#where"
title="Link to this heading">¶</a></h3>
@@ -1216,6 +1222,29 @@ The SQL dialect can be set like this:</p>
</pre></div>
</div>
</section>
+<section id="join">
+<span id="pipe-join"></span><h3>JOIN<a class="headerlink" href="#join"
title="Link to this heading">¶</a></h3>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="p">(</span>
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="s1">'apples'</span><span class="w"> </span><span
class="k">AS</span><span class="w"> </span><span class="n">item</span><span
class="p">,</span><span class="w"> </span><span class="mi">2</span><span
class="w"> </span><span class="k">AS</span><span class="w"> </span><span
class="n">sales</span>
+<span class="w"> </span><span class="k">UNION</span><span class="w">
</span><span class="k">ALL</span>
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="s1">'bananas'</span><span class="w"> </span><span
class="k">AS</span><span class="w"> </span><span class="n">item</span><span
class="p">,</span><span class="w"> </span><span class="mi">5</span><span
class="w"> </span><span class="k">AS</span><span class="w"> </span><span
class="n">sales</span>
+<span class="p">)</span>
+<span class="o">|></span><span class="w"> </span><span
class="k">AS</span><span class="w"> </span><span class="n">produce_sales</span>
+<span class="o">|></span><span class="w"> </span><span
class="k">LEFT</span><span class="w"> </span><span class="k">JOIN</span>
+<span class="w"> </span><span class="p">(</span>
+<span class="w"> </span><span class="k">SELECT</span><span class="w">
</span><span class="s1">'apples'</span><span class="w"> </span><span
class="k">AS</span><span class="w"> </span><span class="n">item</span><span
class="p">,</span><span class="w"> </span><span class="mi">123</span><span
class="w"> </span><span class="k">AS</span><span class="w"> </span><span
class="n">id</span>
+<span class="w"> </span><span class="p">)</span><span class="w">
</span><span class="k">AS</span><span class="w"> </span><span
class="n">produce_data</span>
+<span class="w"> </span><span class="k">ON</span><span class="w">
</span><span class="n">produce_sales</span><span class="p">.</span><span
class="n">item</span><span class="w"> </span><span class="o">=</span><span
class="w"> </span><span class="n">produce_data</span><span
class="p">.</span><span class="n">item</span>
+<span class="o">|></span><span class="w"> </span><span
class="k">SELECT</span><span class="w"> </span><span
class="n">produce_sales</span><span class="p">.</span><span
class="n">item</span><span class="p">,</span><span class="w"> </span><span
class="n">sales</span><span class="p">,</span><span class="w"> </span><span
class="n">id</span><span class="p">;</span>
+<span class="o">+</span><span class="c1">--------+-------+------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">item</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="n">sales</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">id</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">--------+-------+------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">apples</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="mi">2</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="mi">123</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">|</span><span class="w"> </span><span
class="n">bananas</span><span class="o">|</span><span class="w"> </span><span
class="mi">5</span><span class="w"> </span><span class="o">|</span><span
class="w"> </span><span class="k">NULL</span><span class="w"> </span><span
class="o">|</span>
+<span class="o">+</span><span class="c1">--------+-------+------+</span>
+</pre></div>
+</div>
+</section>
</section>
</section>
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
