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 0f8a9bbedc Publish built docs triggered by
f3941b207eeaa7768d840e17c32fa61f3b6fca71
0f8a9bbedc is described below
commit 0f8a9bbedcddc8a7cc78c56ab0fea6a69cd2f282
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Aug 15 20:51:32 2025 +0000
Publish built docs triggered by f3941b207eeaa7768d840e17c32fa61f3b6fca71
---
_sources/user-guide/sql/select.md.txt | 9 +++++++++
searchindex.js | 2 +-
user-guide/sql/index.html | 1 +
user-guide/sql/select.html | 13 +++++++++++++
4 files changed, 24 insertions(+), 1 deletion(-)
diff --git a/_sources/user-guide/sql/select.md.txt
b/_sources/user-guide/sql/select.md.txt
index 84aac431a6..39163cf492 100644
--- a/_sources/user-guide/sql/select.md.txt
+++ b/_sources/user-guide/sql/select.md.txt
@@ -35,6 +35,7 @@ DataFusion supports the following syntax for queries:
[ [WHERE](#where-clause) condition ] <br/>
[ [GROUP BY](#group-by-clause) grouping_element [, ...] ] <br/>
[ [HAVING](#having-clause) condition] <br/>
+[ [QUALIFY](#qualify-clause) condition] <br/>
[ [UNION](#union-clause) [ ALL | select ] <br/>
[ [ORDER BY](#order-by-clause) expression [ ASC | DESC ][, ...] ] <br/>
[ [LIMIT](#limit-clause) count ] <br/>
@@ -261,6 +262,14 @@ Example:
SELECT a, b, MAX(c) FROM table GROUP BY a, b HAVING MAX(c) > 10
```
+## QUALIFY clause
+
+Example:
+
+```sql
+SELECT ROW_NUMBER() OVER (PARTITION BY region) AS rk FROM table QUALIFY rk > 1;
+```
+
## UNION clause
Example:
diff --git a/searchindex.js b/searchindex.js
index a8ba80a622..ef07334cb5 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"alltitles":{"!=":[[57,"op-neq"]],"!~":[[57,"op-re-not-match"]],"!~*":[[57,"op-re-not-match-i"]],"!~~":[[57,"id19"]],"!~~*":[[57,"id20"]],"#":[[57,"op-bit-xor"]],"%":[[57,"op-modulo"]],"&":[[57,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[57,"op-multiply"]],"+":[[57,"op-plus"]],"-":[[57,"op-minus"]],"/":[[57,"op-divide"]],"<":[[57,"op-lt"]],"<
[...]
\ No newline at end of file
+Search.setIndex({"alltitles":{"!=":[[57,"op-neq"]],"!~":[[57,"op-re-not-match"]],"!~*":[[57,"op-re-not-match-i"]],"!~~":[[57,"id19"]],"!~~*":[[57,"id20"]],"#":[[57,"op-bit-xor"]],"%":[[57,"op-modulo"]],"&":[[57,"op-bit-and"]],"(relation,
name) tuples in logical fields and logical columns are
unique":[[12,"relation-name-tuples-in-logical-fields-and-logical-columns-are-unique"]],"*":[[57,"op-multiply"]],"+":[[57,"op-plus"]],"-":[[57,"op-minus"]],"/":[[57,"op-divide"]],"<":[[57,"op-lt"]],"<
[...]
\ No newline at end of file
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index e1da6d2039..4024e7958f 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -594,6 +594,7 @@
<li class="toctree-l2"><a class="reference internal"
href="select.html#join-clause">JOIN clause</a></li>
<li class="toctree-l2"><a class="reference internal"
href="select.html#group-by-clause">GROUP BY clause</a></li>
<li class="toctree-l2"><a class="reference internal"
href="select.html#having-clause">HAVING clause</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="select.html#qualify-clause">QUALIFY clause</a></li>
<li class="toctree-l2"><a class="reference internal"
href="select.html#union-clause">UNION clause</a></li>
<li class="toctree-l2"><a class="reference internal"
href="select.html#order-by-clause">ORDER BY clause</a></li>
<li class="toctree-l2"><a class="reference internal"
href="select.html#limit-clause">LIMIT clause</a></li>
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index a4ed126c13..86e4d744b3 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -636,6 +636,11 @@
HAVING clause
</a>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#qualify-clause">
+ QUALIFY clause
+ </a>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#union-clause">
UNION clause
@@ -718,6 +723,7 @@ In this documentation we describe the SQL syntax in
DataFusion.</p>
[ <a class="reference internal" href="#where-clause">WHERE</a> condition ]
<br/>
[ <a class="reference internal" href="#group-by-clause">GROUP BY</a>
grouping_element [, …] ] <br/>
[ <a class="reference internal" href="#having-clause">HAVING</a> condition]
<br/>
+[ <a class="reference internal" href="#qualify-clause">QUALIFY</a> condition]
<br/>
[ <a class="reference internal" href="#union-clause">UNION</a> [ ALL | select
] <br/>
[ <a class="reference internal" href="#order-by-clause">ORDER BY</a>
expression [ ASC | DESC ][, …] ] <br/>
[ <a class="reference internal" href="#limit-clause">LIMIT</a> count ] <br/>
@@ -919,6 +925,13 @@ aggregation is calculated in the order of the
requirement.</p>
</pre></div>
</div>
</section>
+<section id="qualify-clause">
+<h2>QUALIFY clause<a class="headerlink" href="#qualify-clause" title="Link to
this heading">¶</a></h2>
+<p>Example:</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">SELECT</span><span
class="w"> </span><span class="n">ROW_NUMBER</span><span
class="p">()</span><span class="w"> </span><span class="n">OVER</span><span
class="w"> </span><span class="p">(</span><span class="n">PARTITION</span><span
class="w"> </span><span class="k">BY</span><span class="w"> </span><span
class="n">region</span><span class="p">)</span><span class="w"> </span><span
class="k">AS</ [...]
+</pre></div>
+</div>
+</section>
<section id="union-clause">
<h2>UNION clause<a class="headerlink" href="#union-clause" title="Link to this
heading">¶</a></h2>
<p>Example:</p>
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@datafusion.apache.org
For additional commands, e-mail: commits-h...@datafusion.apache.org
