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 eda5c94db0 Publish built docs triggered by
50b1fac22cc9a56f7751ba4d001243bd2c28c9c9
eda5c94db0 is described below
commit eda5c94db0c1ffa5e32019c3c5adc540b54f30ac
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Aug 24 13:41:37 2023 +0000
Publish built docs triggered by 50b1fac22cc9a56f7751ba4d001243bd2c28c9c9
---
_sources/user-guide/sql/ddl.md.txt | 3 +++
_sources/user-guide/sql/dml.md.txt | 29 ++++++++++++++++++++--
contributor-guide/architecture.html | 2 +-
contributor-guide/communication.html | 2 +-
contributor-guide/index.html | 2 +-
contributor-guide/quarterly_roadmap.html | 2 +-
contributor-guide/roadmap.html | 2 +-
contributor-guide/specification/index.html | 2 +-
contributor-guide/specification/invariants.html | 2 +-
.../specification/output-field-name-semantic.html | 2 +-
genindex.html | 2 +-
index.html | 2 +-
library-user-guide/adding-udfs.html | 2 +-
library-user-guide/building-logical-plans.html | 2 +-
library-user-guide/catalogs.html | 2 +-
library-user-guide/custom-table-providers.html | 2 +-
library-user-guide/extending-operators.html | 2 +-
library-user-guide/index.html | 2 +-
library-user-guide/using-the-dataframe-api.html | 2 +-
library-user-guide/using-the-sql-api.html | 2 +-
library-user-guide/working-with-exprs.html | 2 +-
search.html | 2 +-
searchindex.js | 2 +-
user-guide/cli.html | 2 +-
user-guide/configs.html | 2 +-
user-guide/dataframe.html | 2 +-
user-guide/example-usage.html | 2 +-
user-guide/expressions.html | 2 +-
user-guide/faq.html | 2 +-
user-guide/introduction.html | 2 +-
user-guide/sql/aggregate_functions.html | 2 +-
user-guide/sql/data_types.html | 2 +-
user-guide/sql/ddl.html | 4 ++-
user-guide/sql/dml.html | 29 ++++++++++++++++++----
user-guide/sql/explain.html | 2 +-
user-guide/sql/index.html | 2 +-
user-guide/sql/information_schema.html | 2 +-
user-guide/sql/operators.html | 2 +-
user-guide/sql/scalar_functions.html | 2 +-
user-guide/sql/select.html | 2 +-
user-guide/sql/sql_status.html | 2 +-
user-guide/sql/subqueries.html | 2 +-
user-guide/sql/window_functions.html | 2 +-
43 files changed, 96 insertions(+), 47 deletions(-)
diff --git a/_sources/user-guide/sql/ddl.md.txt
b/_sources/user-guide/sql/ddl.md.txt
index 0dcc4517b5..f566b8342e 100644
--- a/_sources/user-guide/sql/ddl.md.txt
+++ b/_sources/user-guide/sql/ddl.md.txt
@@ -19,6 +19,9 @@
# DDL
+DDL stands for "Data Definition Language" and relates to creating and
+modifying catalog objects such as Tables.
+
## CREATE DATABASE
Create catalog with specified name.
diff --git a/_sources/user-guide/sql/dml.md.txt
b/_sources/user-guide/sql/dml.md.txt
index 26f291c15a..9794fba4aa 100644
--- a/_sources/user-guide/sql/dml.md.txt
+++ b/_sources/user-guide/sql/dml.md.txt
@@ -19,14 +19,19 @@
# DML
+DML stands for "Data Manipulation Language" and relates to inserting
+and modifying data in tables.
+
## COPY
-Copy a table to file(s). Supported file formats are `parquet`, `csv`, and
`json`.
+Copies the contents of a table or query to file(s). Supported file
+formats are `parquet`, `csv`, and `json` and can be inferred based on
+filename if writing to a single file.
The `PER_THREAD_OUTPUT` option treats `file_name` as a directory and writes a
file per thread within it.
<pre>
-COPY <i><b>table_name</i></b> TO '<i><b>file_name</i></b>' [ (
<i><b>option</i></b> [, ... ] ) ]
+COPY { <i><b>table_name</i></b> | <i><b>query</i></b> } TO
'<i><b>file_name</i></b>' [ ( <i><b>option</i></b> [, ... ] ) ]
where <i><b>option</i></b> can be one of:
FORMAT <i><b>format_name</i></b>
@@ -35,6 +40,8 @@ where <i><b>option</i></b> can be one of:
ROW_GROUP_LIMIT_BYTES <i><b>integer</i></b>
</pre>
+Copy the contents of `source_table` to `file_name.json` in JSON format:
+
```sql
> COPY source_table TO 'file_name.json';
+-------+
@@ -42,7 +49,12 @@ where <i><b>option</i></b> can be one of:
+-------+
| 2 |
+-------+
+```
+
+Copy the contents of `source_table` to one or more Parquet formatted
+files in the `dir_name` directory:
+```sql
> COPY source_table TO 'dir_name' (FORMAT parquet, PER_THREAD_OUTPUT true);
+-------+
| count |
@@ -51,6 +63,19 @@ where <i><b>option</i></b> can be one of:
+-------+
```
+Run the query `SELECT * from source ORDER BY time` and write the
+results (maintaining the order) to a parquet file named
+`output.parquet` with a maximum parquet row group size of 10MB:
+
+```sql
+> COPY (SELECT * from source ORDER BY time) TO 'output.parquet'
(ROW_GROUP_LIMIT_BYTES 10000000);
++-------+
+| count |
++-------+
+| 2 |
++-------+
+```
+
## INSERT
Insert values into a table.
diff --git a/contributor-guide/architecture.html
b/contributor-guide/architecture.html
index e24e78efbb..1b3eb3dd7e 100644
--- a/contributor-guide/architecture.html
+++ b/contributor-guide/architecture.html
@@ -428,7 +428,7 @@ possible. You can find the most up to date version in the
<a class="reference ex
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/communication.html
b/contributor-guide/communication.html
index e0dea939e2..41bc6cd513 100644
--- a/contributor-guide/communication.html
+++ b/contributor-guide/communication.html
@@ -499,7 +499,7 @@ for the video call link, add topics and to see what others
plan to discuss.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/index.html b/contributor-guide/index.html
index 0c7a2974ac..5a76422151 100644
--- a/contributor-guide/index.html
+++ b/contributor-guide/index.html
@@ -842,7 +842,7 @@ new specifications as you see fit.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/quarterly_roadmap.html
b/contributor-guide/quarterly_roadmap.html
index b0214b0309..b6e428fd3d 100644
--- a/contributor-guide/quarterly_roadmap.html
+++ b/contributor-guide/quarterly_roadmap.html
@@ -591,7 +591,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/roadmap.html b/contributor-guide/roadmap.html
index 3c9dd117e2..fd9ac7cd7a 100644
--- a/contributor-guide/roadmap.html
+++ b/contributor-guide/roadmap.html
@@ -462,7 +462,7 @@ make review efficient and avoid surprises.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/specification/index.html
b/contributor-guide/specification/index.html
index 85ffc96cc4..734cf2682d 100644
--- a/contributor-guide/specification/index.html
+++ b/contributor-guide/specification/index.html
@@ -413,7 +413,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/specification/invariants.html
b/contributor-guide/specification/invariants.html
index 9a1d0fce84..1d659871aa 100644
--- a/contributor-guide/specification/invariants.html
+++ b/contributor-guide/specification/invariants.html
@@ -930,7 +930,7 @@ schemas.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/contributor-guide/specification/output-field-name-semantic.html
b/contributor-guide/specification/output-field-name-semantic.html
index d4a6c3ed03..a2b771665c 100644
--- a/contributor-guide/specification/output-field-name-semantic.html
+++ b/contributor-guide/specification/output-field-name-semantic.html
@@ -848,7 +848,7 @@ DataFusion queries planned from both SQL queries and
Dataframe APIs.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/genindex.html b/genindex.html
index a23d4794b0..5fd6960ce3 100644
--- a/genindex.html
+++ b/genindex.html
@@ -372,7 +372,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/index.html b/index.html
index bdd06e69bc..a46400256a 100644
--- a/index.html
+++ b/index.html
@@ -459,7 +459,7 @@ community.</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/adding-udfs.html
b/library-user-guide/adding-udfs.html
index ea40f5f202..4dcc621dcf 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -426,7 +426,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/building-logical-plans.html
b/library-user-guide/building-logical-plans.html
index 00c94bb351..3a9e01c3e5 100644
--- a/library-user-guide/building-logical-plans.html
+++ b/library-user-guide/building-logical-plans.html
@@ -426,7 +426,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/catalogs.html b/library-user-guide/catalogs.html
index 4d65548994..9a6dc538f6 100644
--- a/library-user-guide/catalogs.html
+++ b/library-user-guide/catalogs.html
@@ -613,7 +613,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/custom-table-providers.html
b/library-user-guide/custom-table-providers.html
index 51041168d8..3266aa63bb 100644
--- a/library-user-guide/custom-table-providers.html
+++ b/library-user-guide/custom-table-providers.html
@@ -595,7 +595,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/extending-operators.html
b/library-user-guide/extending-operators.html
index b55012f34d..d2b3da0a56 100644
--- a/library-user-guide/extending-operators.html
+++ b/library-user-guide/extending-operators.html
@@ -426,7 +426,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/index.html b/library-user-guide/index.html
index cb0df4c0fd..4d893b3782 100644
--- a/library-user-guide/index.html
+++ b/library-user-guide/index.html
@@ -427,7 +427,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/using-the-dataframe-api.html
b/library-user-guide/using-the-dataframe-api.html
index 81f0202a20..b3cb515ce8 100644
--- a/library-user-guide/using-the-dataframe-api.html
+++ b/library-user-guide/using-the-dataframe-api.html
@@ -426,7 +426,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/using-the-sql-api.html
b/library-user-guide/using-the-sql-api.html
index 6412458b3a..c088f8b8e9 100644
--- a/library-user-guide/using-the-sql-api.html
+++ b/library-user-guide/using-the-sql-api.html
@@ -426,7 +426,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/library-user-guide/working-with-exprs.html
b/library-user-guide/working-with-exprs.html
index f92571e205..927524b5da 100644
--- a/library-user-guide/working-with-exprs.html
+++ b/library-user-guide/working-with-exprs.html
@@ -426,7 +426,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/search.html b/search.html
index 2a1b503b5a..681063e249 100644
--- a/search.html
+++ b/search.html
@@ -401,7 +401,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/searchindex.js b/searchindex.js
index f2ce180c27..42cf8231b5 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",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ 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",
"library-user-guide/adding-udfs", "library-user-guide/building-logical-plans",
"library-user-guide/catalogs", "library-user-guide/custom-tab [...]
\ No newline at end of file
diff --git a/user-guide/cli.html b/user-guide/cli.html
index 6d0f809ed5..59bb7088bd 100644
--- a/user-guide/cli.html
+++ b/user-guide/cli.html
@@ -883,7 +883,7 @@ DataFusion<span class="w"> </span>CLI<span class="w">
</span>v13.0.0
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/configs.html b/user-guide/configs.html
index 7e220e9f74..313715ba92 100644
--- a/user-guide/configs.html
+++ b/user-guide/configs.html
@@ -680,7 +680,7 @@ Environment variables are read during <code class="docutils
literal notranslate"
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/dataframe.html b/user-guide/dataframe.html
index 002899c218..8e96c34acd 100644
--- a/user-guide/dataframe.html
+++ b/user-guide/dataframe.html
@@ -603,7 +603,7 @@ execution. The plan is evaluated (executed) when an action
method is invoked, su
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index 209cb57193..aef98cea6b 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -689,7 +689,7 @@ with <code class="docutils literal notranslate"><span
class="pre">native</span><
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 718c0b25d8..673ac1f2fd 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -1210,7 +1210,7 @@ expressions such as <code class="docutils literal
notranslate"><span class="pre"
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/faq.html b/user-guide/faq.html
index 96027ae06d..c953397f87 100644
--- a/user-guide/faq.html
+++ b/user-guide/faq.html
@@ -494,7 +494,7 @@ targets end-users rather than developers of other database
systems.</p></li>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/introduction.html b/user-guide/introduction.html
index 907b56d0e6..c716d7cf59 100644
--- a/user-guide/introduction.html
+++ b/user-guide/introduction.html
@@ -601,7 +601,7 @@ provide integrations with other systems, some of which are
described below:</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index 12a3874ef3..6ef7d1ed1c 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -1681,7 +1681,7 @@ Can be a constant, column, or function, and any
combination of arithmetic operat
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index 51fe6cc69f..1557a17e9d 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -755,7 +755,7 @@ For example, to cast the output of <code class="docutils
literal notranslate"><s
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index 95b5746833..5016898e8a 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -430,6 +430,8 @@
-->
<section id="ddl">
<h1>DDL<a class="headerlink" href="#ddl" title="Link to this
heading">¶</a></h1>
+<p>DDL stands for “Data Definition Language” and relates to creating and
+modifying catalog objects such as Tables.</p>
<section id="create-database">
<h2>CREATE DATABASE<a class="headerlink" href="#create-database" title="Link
to this heading">¶</a></h2>
<p>Create catalog with specified name.</p>
@@ -687,7 +689,7 @@ DROP VIEW [ IF EXISTS ] <b><i>view_name</i></b>;
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/dml.html b/user-guide/sql/dml.html
index 8a3bc6beda..1af6cffd5b 100644
--- a/user-guide/sql/dml.html
+++ b/user-guide/sql/dml.html
@@ -398,12 +398,16 @@
-->
<section id="dml">
<h1>DML<a class="headerlink" href="#dml" title="Link to this
heading">¶</a></h1>
+<p>DML stands for “Data Manipulation Language” and relates to inserting
+and modifying data in tables.</p>
<section id="copy">
<h2>COPY<a class="headerlink" href="#copy" title="Link to this
heading">¶</a></h2>
-<p>Copy a table to file(s). Supported file formats are <code class="docutils
literal notranslate"><span class="pre">parquet</span></code>, <code
class="docutils literal notranslate"><span class="pre">csv</span></code>, and
<code class="docutils literal notranslate"><span
class="pre">json</span></code>.</p>
+<p>Copies the contents of a table or query to file(s). Supported file
+formats are <code class="docutils literal notranslate"><span
class="pre">parquet</span></code>, <code class="docutils literal
notranslate"><span class="pre">csv</span></code>, and <code class="docutils
literal notranslate"><span class="pre">json</span></code> and can be inferred
based on
+filename if writing to a single file.</p>
<p>The <code class="docutils literal notranslate"><span
class="pre">PER_THREAD_OUTPUT</span></code> option treats <code class="docutils
literal notranslate"><span class="pre">file_name</span></code> as a directory
and writes a file per thread within it.</p>
<pre>
-COPY <i><b>table_name</i></b> TO '<i><b>file_name</i></b>' [ (
<i><b>option</i></b> [, ... ] ) ]
+COPY { <i><b>table_name</i></b> | <i><b>query</i></b> } TO
'<i><b>file_name</i></b>' [ ( <i><b>option</i></b> [, ... ] ) ]
where <i><b>option</i></b> can be one of:
FORMAT <i><b>format_name</i></b>
@@ -411,14 +415,29 @@ where <i><b>option</i></b> can be one of:
ROW_GROUP_SIZE <i><b>integer</i></b>
ROW_GROUP_LIMIT_BYTES <i><b>integer</i></b>
</pre>
+<p>Copy the contents of <code class="docutils literal notranslate"><span
class="pre">source_table</span></code> to <code class="docutils literal
notranslate"><span class="pre">file_name.json</span></code> in JSON format:</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="n">source_table</span><span class="w"> </span><span
class="k">TO</span><span class="w"> </span><span
class="s1">'file_name.json'</span><span class="p">;</span>
<span class="o">+</span><span class="c1">-------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">count</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="mi">2</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="k">COPY</span><span class="w"> </span><span
class="n">source_table</span><span class="w"> </span><span
class="k">TO</span><span class="w"> </span><span
class="s1">'dir_name'</span><span class="w"> </span><span
class="p">(</span><span class="n">FORMAT</span><span class="w"> </span><span
class="n">parquet</span><span class="p">,</span><span class="w"> </span><span
class="n">PER_THREAD_OUTPUT</span><span class="w"> </sp [...]
+</pre></div>
+</div>
+<p>Copy the contents of <code class="docutils literal notranslate"><span
class="pre">source_table</span></code> to one or more Parquet formatted
+files in the <code class="docutils literal notranslate"><span
class="pre">dir_name</span></code> directory:</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="n">source_table</span><span class="w"> </span><span
class="k">TO</span><span class="w"> </span><span
class="s1">'dir_name'</span><span class="w"> </span><span
class="p">(</span><span class="n">FORMAT</span><span class="w"> </span><span
class="n">parquet</span><span class="p">,</span><span [...]
+<span class="o">+</span><span class="c1">-------+</span>
+<span class="o">|</span><span class="w"> </span><span
class="k">count</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="mi">2</span><span
class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">-------+</span>
+</pre></div>
+</div>
+<p>Run the query <code class="docutils literal notranslate"><span
class="pre">SELECT</span> <span class="pre">*</span> <span
class="pre">from</span> <span class="pre">source</span> <span
class="pre">ORDER</span> <span class="pre">BY</span> <span
class="pre">time</span></code> and write the
+results (maintaining the order) to a parquet file named
+<code class="docutils literal notranslate"><span
class="pre">output.parquet</span></code> with a maximum parquet row group size
of 10MB:</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">COPY</span><span class="w"> </span><span
class="p">(</span><span class="k">SELECT</span><span class="w"> </span><span
class="o">*</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="k">source</span><span class="w"> </span><span
class="k">ORDER</span><span class="w"> </span><span class="k">BY</span><spa
[...]
<span class="o">+</span><span class="c1">-------+</span>
<span class="o">|</span><span class="w"> </span><span
class="k">count</span><span class="w"> </span><span class="o">|</span>
<span class="o">+</span><span class="c1">-------+</span>
@@ -484,7 +503,7 @@ INSERT INTO <i><b>table_name</i></b> { VALUES (
<i><b>expression</i></b> [, ...]
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index 4222649106..d40cbf747c 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -487,7 +487,7 @@ If you need more information output, use <code
class="docutils literal notransla
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index 50267df590..7cb3c3058f 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -505,7 +505,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/information_schema.html
b/user-guide/sql/information_schema.html
index 0e1f97ad2c..c509ddce9e 100644
--- a/user-guide/sql/information_schema.html
+++ b/user-guide/sql/information_schema.html
@@ -468,7 +468,7 @@ views of the ISO SQL <code class="docutils literal
notranslate"><span class="pre
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index c0a78bb87a..0c6be594c3 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -1099,7 +1099,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 31fdda611a..a4741cdc46 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -5609,7 +5609,7 @@ string operators.</p></li>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 9ccdea5050..abd652e6b6 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -732,7 +732,7 @@ This order can be changed to descending by adding <code
class="docutils literal
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/sql_status.html b/user-guide/sql/sql_status.html
index 1d4c1b1a2f..5cc7bc04a4 100644
--- a/user-guide/sql/sql_status.html
+++ b/user-guide/sql/sql_status.html
@@ -557,7 +557,7 @@ trait, DataFusion includes built in support for the
following formats:</p>
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/subqueries.html b/user-guide/sql/subqueries.html
index 596c6065b4..786b29faac 100644
--- a/user-guide/sql/subqueries.html
+++ b/user-guide/sql/subqueries.html
@@ -525,7 +525,7 @@ is an example of a filter using a scalar subquery. Only
correlated subqueries ar
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index ce08285c42..a039d387e7 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -836,7 +836,7 @@
<div class="footer-item">
<p class="sphinx-version">
-Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.2.<br>
+Created using <a href="http://sphinx-doc.org/";>Sphinx</a> 7.2.3.<br>
</p>
</div>
