You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by gi...@apache.org on 2023/06/02 18:09:41 UTC
[arrow-datafusion] branch asf-site updated: Publish built docs triggered by 5ec14e1757b04c69a6c24a1f29f6499aea1ef795
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/arrow-datafusion.git
The following commit(s) were added to refs/heads/asf-site by this push:
new b7c68e22af Publish built docs triggered by 5ec14e1757b04c69a6c24a1f29f6499aea1ef795
b7c68e22af is described below
commit b7c68e22af6818c95c04b06c1e5e03b457fbf4bf
Author: github-actions[bot] <gi...@users.noreply.github.com>
AuthorDate: Fri Jun 2 18:09:33 2023 +0000
Publish built docs triggered by 5ec14e1757b04c69a6c24a1f29f6499aea1ef795
---
_sources/user-guide/sql/select.md.txt | 17 +++++++++++++++++
searchindex.js | 2 +-
user-guide/sql/index.html | 1 +
user-guide/sql/select.html | 21 ++++++++++++++++++++-
4 files changed, 39 insertions(+), 2 deletions(-)
diff --git a/_sources/user-guide/sql/select.md.txt b/_sources/user-guide/sql/select.md.txt
index cb73e08520..4cffd4ce91 100644
--- a/_sources/user-guide/sql/select.md.txt
+++ b/_sources/user-guide/sql/select.md.txt
@@ -38,6 +38,7 @@ DataFusion supports the following syntax for queries:
[ [UNION](#union-clause) [ ALL | select ] <br/>
[ [ORDER BY](#order-by-clause) expression [ ASC | DESC ][, ...] ] <br/>
[ [LIMIT](#limit-clause) count ] <br/>
+[ [EXCLUDE | EXCEPT](#exclude-and-except-clause) ] <br/>
</code>
@@ -247,3 +248,19 @@ Example:
SELECT age, person FROM table
LIMIT 10
```
+
+## EXCLUDE and EXCEPT clause
+
+Excluded named columns from query results.
+
+Example selecting all columns except for `age` and `person`:
+
+```sql
+SELECT * EXCEPT(age, person)
+FROM table;
+```
+
+```sql
+SELECT * EXCLUDE(age, person)
+FROM table;
+```
diff --git a/searchindex.js b/searchindex.js
index 88d0156493..4662ddd6ec 100644
--- a/searchindex.js
+++ b/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["contributor-guide/architecture", "contributor-guide/communication", "contributor-guide/index", "contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", "contributor-guide/specification/index", "contributor-guide/specification/invariants", "contributor-guide/specification/output-field-name-semantic", "index", "user-guide/cli", "user-guide/configs", "user-guide/dataframe", "user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["contributor-guide/architecture", "contributor-guide/communication", "contributor-guide/index", "contributor-guide/quarterly_roadmap", "contributor-guide/roadmap", "contributor-guide/specification/index", "contributor-guide/specification/invariants", "contributor-guide/specification/output-field-name-semantic", "index", "user-guide/cli", "user-guide/configs", "user-guide/dataframe", "user-guide/example-usage", "user-guide/expressions", "user-guide/faq", "use [...]
\ No newline at end of file
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index b930c4e81a..cd75c30a1d 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -331,6 +331,7 @@
<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>
+<li class="toctree-l2"><a class="reference internal" href="select.html#exclude-and-except-clause">EXCLUDE and EXCEPT clause</a></li>
</ul>
</li>
<li class="toctree-l1"><a class="reference internal" href="subqueries.html">Subqueries</a><ul>
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 081d2bfdc9..7ebf98bb80 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -365,6 +365,11 @@
LIMIT clause
</a>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#exclude-and-except-clause">
+ EXCLUDE and EXCEPT clause
+ </a>
+ </li>
</ul>
</nav>
@@ -429,7 +434,8 @@ In this documentation we describe the SQL syntax in DataFusion.</p>
[ <a class="reference internal" href="#having-clause">HAVING</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/></p>
+[ <a class="reference internal" href="#limit-clause">LIMIT</a> count ] <br/>
+[ <a class="reference internal" href="#exclude-and-except-clause">EXCLUDE | EXCEPT</a> ] <br/></p>
</code>
<section id="with-clause">
<h2>WITH clause<a class="headerlink" href="#with-clause" title="Permalink to this heading">¶</a></h2>
@@ -614,6 +620,19 @@ This order can be changed to descending by adding <code class="docutils literal
</pre></div>
</div>
</section>
+<section id="exclude-and-except-clause">
+<h2>EXCLUDE and EXCEPT clause<a class="headerlink" href="#exclude-and-except-clause" title="Permalink to this heading">¶</a></h2>
+<p>Excluded named columns from query results.</p>
+<p>Example selecting all columns except for <code class="docutils literal notranslate"><span class="pre">age</span></code> and <code class="docutils literal notranslate"><span class="pre">person</span></code>:</p>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="k">EXCEPT</span><span class="p">(</span><span class="n">age</span><span class="p">,</span><span class="w"> </span><span class="n">person</span><span class="p">)</span>
+<span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="p">;</span>
+</pre></div>
+</div>
+<div class="highlight-sql notranslate"><div class="highlight"><pre><span></span><span class="k">SELECT</span><span class="w"> </span><span class="o">*</span><span class="w"> </span><span class="n">EXCLUDE</span><span class="p">(</span><span class="n">age</span><span class="p">,</span><span class="w"> </span><span class="n">person</span><span class="p">)</span>
+<span class="k">FROM</span><span class="w"> </span><span class="k">table</span><span class="p">;</span>
+</pre></div>
+</div>
+</section>
</section>