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 ee54e7743d Publish built docs triggered by
b6fe8159fd21ea101b84abc2629dbb484c8ad326
ee54e7743d is described below
commit ee54e7743d9b1d7af340ee69501963473af487dd
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Wed Aug 23 17:35:47 2023 +0000
Publish built docs triggered by b6fe8159fd21ea101b84abc2629dbb484c8ad326
---
_sources/user-guide/sql/dml.md.txt | 69 +++++++
_sources/user-guide/sql/index.rst.txt | 1 +
contributor-guide/architecture.html | 5 +
contributor-guide/communication.html | 5 +
contributor-guide/index.html | 5 +
contributor-guide/quarterly_roadmap.html | 5 +
contributor-guide/roadmap.html | 5 +
contributor-guide/specification/index.html | 5 +
contributor-guide/specification/invariants.html | 5 +
.../specification/output-field-name-semantic.html | 5 +
genindex.html | 5 +
index.html | 5 +
library-user-guide/adding-udfs.html | 5 +
library-user-guide/building-logical-plans.html | 5 +
library-user-guide/catalogs.html | 5 +
library-user-guide/custom-table-providers.html | 5 +
library-user-guide/extending-operators.html | 5 +
library-user-guide/index.html | 5 +
library-user-guide/using-the-dataframe-api.html | 5 +
library-user-guide/using-the-sql-api.html | 5 +
library-user-guide/working-with-exprs.html | 5 +
objects.inv | Bin 1084 -> 1092 bytes
search.html | 5 +
searchindex.js | 2 +-
user-guide/cli.html | 5 +
user-guide/configs.html | 5 +
user-guide/dataframe.html | 5 +
user-guide/example-usage.html | 5 +
user-guide/expressions.html | 5 +
user-guide/faq.html | 5 +
user-guide/introduction.html | 5 +
user-guide/sql/aggregate_functions.html | 5 +
user-guide/sql/data_types.html | 5 +
user-guide/sql/ddl.html | 11 +-
user-guide/sql/{index.html => dml.html} | 199 ++++++++++-----------
user-guide/sql/explain.html | 11 +-
user-guide/sql/index.html | 10 ++
user-guide/sql/information_schema.html | 5 +
user-guide/sql/operators.html | 5 +
user-guide/sql/scalar_functions.html | 5 +
user-guide/sql/select.html | 5 +
user-guide/sql/sql_status.html | 5 +
user-guide/sql/subqueries.html | 5 +
user-guide/sql/window_functions.html | 5 +
44 files changed, 371 insertions(+), 112 deletions(-)
diff --git a/_sources/user-guide/sql/dml.md.txt
b/_sources/user-guide/sql/dml.md.txt
new file mode 100644
index 0000000000..26f291c15a
--- /dev/null
+++ b/_sources/user-guide/sql/dml.md.txt
@@ -0,0 +1,69 @@
+<!---
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+-->
+
+# DML
+
+## COPY
+
+Copy a table to file(s). Supported file formats are `parquet`, `csv`, and
`json`.
+
+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> [, ... ] ) ]
+
+where <i><b>option</i></b> can be one of:
+ FORMAT <i><b>format_name</i></b>
+ PER_THREAD_OUTPUT <i><b>boolean</i></b>
+ ROW_GROUP_SIZE <i><b>integer</i></b>
+ ROW_GROUP_LIMIT_BYTES <i><b>integer</i></b>
+</pre>
+
+```sql
+> COPY source_table TO 'file_name.json';
++-------+
+| count |
++-------+
+| 2 |
++-------+
+
+> COPY source_table TO 'dir_name' (FORMAT parquet, PER_THREAD_OUTPUT true);
++-------+
+| count |
++-------+
+| 2 |
++-------+
+```
+
+## INSERT
+
+Insert values into a table.
+
+<pre>
+INSERT INTO <i><b>table_name</i></b> { VALUES ( <i><b>expression</i></b> [,
...] ) [, ...] | <i><b>query</i></b> }
+</pre>
+
+```sql
+> INSERT INTO target_table VALUES (1, 'Foo'), (2, 'Bar');
++-------+
+| count |
++-------+
+| 2 |
++-------+
+```
diff --git a/_sources/user-guide/sql/index.rst.txt
b/_sources/user-guide/sql/index.rst.txt
index 00fd20c7b7..b282fbddd6 100644
--- a/_sources/user-guide/sql/index.rst.txt
+++ b/_sources/user-guide/sql/index.rst.txt
@@ -25,6 +25,7 @@ SQL Reference
select
subqueries
ddl
+ dml
explain
information_schema
operators
diff --git a/contributor-guide/architecture.html
b/contributor-guide/architecture.html
index 7599d26d6a..e24e78efbb 100644
--- a/contributor-guide/architecture.html
+++ b/contributor-guide/architecture.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/communication.html
b/contributor-guide/communication.html
index a72997e05f..e0dea939e2 100644
--- a/contributor-guide/communication.html
+++ b/contributor-guide/communication.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/index.html b/contributor-guide/index.html
index 2a605de1cb..0c7a2974ac 100644
--- a/contributor-guide/index.html
+++ b/contributor-guide/index.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/quarterly_roadmap.html
b/contributor-guide/quarterly_roadmap.html
index ce1d26937e..b0214b0309 100644
--- a/contributor-guide/quarterly_roadmap.html
+++ b/contributor-guide/quarterly_roadmap.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/roadmap.html b/contributor-guide/roadmap.html
index 20dcfa0a6d..3c9dd117e2 100644
--- a/contributor-guide/roadmap.html
+++ b/contributor-guide/roadmap.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/specification/index.html
b/contributor-guide/specification/index.html
index 200cdd73f3..85ffc96cc4 100644
--- a/contributor-guide/specification/index.html
+++ b/contributor-guide/specification/index.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/specification/invariants.html
b/contributor-guide/specification/invariants.html
index 91b5ca5a53..9a1d0fce84 100644
--- a/contributor-guide/specification/invariants.html
+++ b/contributor-guide/specification/invariants.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../../user-guide/sql/explain.html">
EXPLAIN
diff --git a/contributor-guide/specification/output-field-name-semantic.html
b/contributor-guide/specification/output-field-name-semantic.html
index cc9b409538..d4a6c3ed03 100644
--- a/contributor-guide/specification/output-field-name-semantic.html
+++ b/contributor-guide/specification/output-field-name-semantic.html
@@ -152,6 +152,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../../user-guide/sql/explain.html">
EXPLAIN
diff --git a/genindex.html b/genindex.html
index 881b5ed2b5..a23d4794b0 100644
--- a/genindex.html
+++ b/genindex.html
@@ -150,6 +150,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/explain.html">
EXPLAIN
diff --git a/index.html b/index.html
index 495e20a889..bdd06e69bc 100644
--- a/index.html
+++ b/index.html
@@ -152,6 +152,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/adding-udfs.html
b/library-user-guide/adding-udfs.html
index 15d674d66d..ea40f5f202 100644
--- a/library-user-guide/adding-udfs.html
+++ b/library-user-guide/adding-udfs.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/building-logical-plans.html
b/library-user-guide/building-logical-plans.html
index 7d7ae3c8d3..00c94bb351 100644
--- a/library-user-guide/building-logical-plans.html
+++ b/library-user-guide/building-logical-plans.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/catalogs.html b/library-user-guide/catalogs.html
index 1ad49ae433..4d65548994 100644
--- a/library-user-guide/catalogs.html
+++ b/library-user-guide/catalogs.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/custom-table-providers.html
b/library-user-guide/custom-table-providers.html
index a9dcbb6bf9..51041168d8 100644
--- a/library-user-guide/custom-table-providers.html
+++ b/library-user-guide/custom-table-providers.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/extending-operators.html
b/library-user-guide/extending-operators.html
index c00b64b9d2..b55012f34d 100644
--- a/library-user-guide/extending-operators.html
+++ b/library-user-guide/extending-operators.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/index.html b/library-user-guide/index.html
index 7445189f98..cb0df4c0fd 100644
--- a/library-user-guide/index.html
+++ b/library-user-guide/index.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/using-the-dataframe-api.html
b/library-user-guide/using-the-dataframe-api.html
index e38a85b276..81f0202a20 100644
--- a/library-user-guide/using-the-dataframe-api.html
+++ b/library-user-guide/using-the-dataframe-api.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/using-the-sql-api.html
b/library-user-guide/using-the-sql-api.html
index bc1b339786..6412458b3a 100644
--- a/library-user-guide/using-the-sql-api.html
+++ b/library-user-guide/using-the-sql-api.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/library-user-guide/working-with-exprs.html
b/library-user-guide/working-with-exprs.html
index 85409dce55..f92571e205 100644
--- a/library-user-guide/working-with-exprs.html
+++ b/library-user-guide/working-with-exprs.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="../user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="../user-guide/sql/explain.html">
EXPLAIN
diff --git a/objects.inv b/objects.inv
index 587269830f..7a2a98b996 100644
Binary files a/objects.inv and b/objects.inv differ
diff --git a/search.html b/search.html
index bcbc8c5c8b..2a1b503b5a 100644
--- a/search.html
+++ b/search.html
@@ -156,6 +156,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="user-guide/sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="user-guide/sql/explain.html">
EXPLAIN
diff --git a/searchindex.js b/searchindex.js
index 0ca75b13f1..9d7f718cdf 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 cf600791a4..6d0f809ed5 100644
--- a/user-guide/cli.html
+++ b/user-guide/cli.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/configs.html b/user-guide/configs.html
index 5cb41b5932..0351e301f1 100644
--- a/user-guide/configs.html
+++ b/user-guide/configs.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/dataframe.html b/user-guide/dataframe.html
index c3e8500102..002899c218 100644
--- a/user-guide/dataframe.html
+++ b/user-guide/dataframe.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/example-usage.html b/user-guide/example-usage.html
index 9bdb2ac363..209cb57193 100644
--- a/user-guide/example-usage.html
+++ b/user-guide/example-usage.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/expressions.html b/user-guide/expressions.html
index 96635fb822..718c0b25d8 100644
--- a/user-guide/expressions.html
+++ b/user-guide/expressions.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/faq.html b/user-guide/faq.html
index e33c1429c6..96027ae06d 100644
--- a/user-guide/faq.html
+++ b/user-guide/faq.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/introduction.html b/user-guide/introduction.html
index 4cf4d2f8b0..907b56d0e6 100644
--- a/user-guide/introduction.html
+++ b/user-guide/introduction.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="sql/dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="sql/explain.html">
EXPLAIN
diff --git a/user-guide/sql/aggregate_functions.html
b/user-guide/sql/aggregate_functions.html
index ae98c01c3a..12a3874ef3 100644
--- a/user-guide/sql/aggregate_functions.html
+++ b/user-guide/sql/aggregate_functions.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/data_types.html b/user-guide/sql/data_types.html
index 1921b8f6c0..51fe6cc69f 100644
--- a/user-guide/sql/data_types.html
+++ b/user-guide/sql/data_types.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/ddl.html b/user-guide/sql/ddl.html
index 41327bd40f..95b5746833 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -33,7 +33,7 @@
<script src="../../_static/sphinx_highlight.js?v=dc90522c"></script>
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="EXPLAIN" href="explain.html" />
+ <link rel="next" title="DML" href="dml.html" />
<link rel="prev" title="Subqueries" href="subqueries.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
@@ -655,10 +660,10 @@ DROP VIEW [ IF EXISTS ] <b><i>view_name</i></b>;
<p class="prev-next-title">Subqueries</p>
</div>
</a>
- <a class='right-next' id="next-link" href="explain.html" title="next page">
+ <a class='right-next' id="next-link" href="dml.html" title="next page">
<div class="prev-next-info">
<p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">EXPLAIN</p>
+ <p class="prev-next-title">DML</p>
</div>
<i class="fas fa-angle-right"></i>
</a>
diff --git a/user-guide/sql/index.html b/user-guide/sql/dml.html
similarity index 56%
copy from user-guide/sql/index.html
copy to user-guide/sql/dml.html
index a403435769..8a3bc6beda 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/dml.html
@@ -5,7 +5,7 @@
<meta charset="utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0"
/><meta name="viewport" content="width=device-width, initial-scale=1" />
- <title>SQL Reference — Arrow DataFusion documentation</title>
+ <title>DML — Arrow DataFusion documentation</title>
<link href="../../_static/styles/theme.css?digest=1999514e3f237ded88cf"
rel="stylesheet">
<link
href="../../_static/styles/pydata-sphinx-theme.css?digest=1999514e3f237ded88cf"
rel="stylesheet">
@@ -33,8 +33,8 @@
<script src="../../_static/sphinx_highlight.js?v=dc90522c"></script>
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
- <link rel="next" title="Data Types" href="data_types.html" />
- <link rel="prev" title="Expression API" href="../expressions.html" />
+ <link rel="next" title="EXPLAIN" href="explain.html" />
+ <link rel="prev" title="DDL" href="ddl.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -124,7 +124,7 @@
</a>
</li>
<li class="toctree-l1 current active has-children">
- <a class="current reference internal" href="#">
+ <a class="reference internal" href="index.html">
SQL Reference
</a>
<input checked="" class="toctree-checkbox" id="toctree-checkbox-1"
name="toctree-checkbox-1" type="checkbox"/>
@@ -132,7 +132,7 @@
<i class="fas fa-chevron-down">
</i>
</label>
- <ul>
+ <ul class="current">
<li class="toctree-l2">
<a class="reference internal" href="data_types.html">
Data Types
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2 current active">
+ <a class="current reference internal" href="#">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
@@ -329,9 +334,24 @@
<div class="toc-item">
+<div class="tocsection onthispage pt-5 pb-3">
+ <i class="fas fa-list"></i> On this page
+</div>
<nav id="bd-toc-nav">
-
+ <ul class="visible nav section-nav flex-column">
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#copy">
+ COPY
+ </a>
+ </li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#insert">
+ INSERT
+ </a>
+ </li>
+</ul>
+
</nav>
</div>
@@ -339,7 +359,7 @@
<div class="tocsection editthispage">
- <a
href="https://github.com/apache/arrow-datafusion/edit/main/docs/source/user-guide/sql/index.rst";>
+ <a
href="https://github.com/apache/arrow-datafusion/edit/main/docs/source/user-guide/sql/dml.md";>
<i class="fas fa-pencil-alt"></i> Edit this page
</a>
</div>
@@ -358,101 +378,70 @@
<div>
- <section id="sql-reference">
-<h1>SQL Reference<a class="headerlink" href="#sql-reference" title="Link to
this heading">¶</a></h1>
-<div class="toctree-wrapper compound">
-<ul>
-<li class="toctree-l1"><a class="reference internal"
href="data_types.html">Data Types</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#character-types">Character Types</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#numeric-types">Numeric Types</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#date-time-types">Date/Time Types</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#boolean-types">Boolean Types</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#binary-types">Binary Types</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#unsupported-sql-types">Unsupported SQL Types</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="data_types.html#supported-arrow-types">Supported Arrow Types</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal" href="select.html">SELECT
syntax</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="select.html#with-clause">WITH clause</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="select.html#select-clause">SELECT clause</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="select.html#from-clause">FROM clause</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="select.html#where-clause">WHERE clause</a></li>
-<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#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>
-<li class="toctree-l2"><a class="reference internal"
href="subqueries.html#exists">EXISTS</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="subqueries.html#not-exists">NOT EXISTS</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="subqueries.html#in">IN</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="subqueries.html#not-in">NOT IN</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="subqueries.html#scalar-subquery">Scalar Subquery</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="ddl.html">DDL</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-database">CREATE DATABASE</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-schema">CREATE SCHEMA</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-external-table">CREATE EXTERNAL TABLE</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-table">CREATE TABLE</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#drop-table">DROP TABLE</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#create-view">CREATE VIEW</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="ddl.html#drop-view">DROP VIEW</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="explain.html">EXPLAIN</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="explain.html#id1">EXPLAIN</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="explain.html#explain-analyze">EXPLAIN ANALYZE</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="information_schema.html">Information Schema</a></li>
-<li class="toctree-l1"><a class="reference internal"
href="operators.html">Operators</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="operators.html#numerical-operators">Numerical Operators</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="operators.html#comparison-operators">Comparison Operators</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="operators.html#logical-operators">Logical Operators</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="operators.html#bitwise-operators">Bitwise Operators</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="operators.html#other-operators">Other Operators</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="aggregate_functions.html">Aggregate Functions</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="aggregate_functions.html#general">General</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="aggregate_functions.html#statistical">Statistical</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="aggregate_functions.html#approximate">Approximate</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="window_functions.html">Window Functions</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#syntax">Syntax</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#aggregate-functions">Aggregate functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#ranking-functions">Ranking functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="window_functions.html#analytical-functions">Analytical functions</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="scalar_functions.html">Scalar Functions</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#math-functions">Math Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#conditional-functions">Conditional
Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#string-functions">String Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#binary-string-functions">Binary String
Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#regular-expression-functions">Regular Expression
Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#time-and-date-functions">Time and Date
Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#array-functions">Array Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#struct-functions">Struct Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#hashing-functions">Hashing Functions</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="scalar_functions.html#other-functions">Other Functions</a></li>
-</ul>
-</li>
-<li class="toctree-l1"><a class="reference internal"
href="sql_status.html">Status</a><ul>
-<li class="toctree-l2"><a class="reference internal"
href="sql_status.html#general">General</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="sql_status.html#sql-support">SQL Support</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="sql_status.html#runtime">Runtime</a></li>
-<li class="toctree-l2"><a class="reference internal"
href="sql_status.html#data-sources">Data Sources</a></li>
-</ul>
-</li>
-</ul>
+ <!---
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+-->
+<section id="dml">
+<h1>DML<a class="headerlink" href="#dml" title="Link to this
heading">¶</a></h1>
+<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>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> [, ... ] ) ]
+
+where <i><b>option</i></b> can be one of:
+ FORMAT <i><b>format_name</i></b>
+ PER_THREAD_OUTPUT <i><b>boolean</i></b>
+ ROW_GROUP_SIZE <i><b>integer</i></b>
+ ROW_GROUP_LIMIT_BYTES <i><b>integer</i></b>
+</pre>
+<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 [...]
+<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>
+</section>
+<section id="insert">
+<h2>INSERT<a class="headerlink" href="#insert" title="Link to this
heading">¶</a></h2>
+<p>Insert values into a table.</p>
+<pre>
+INSERT INTO <i><b>table_name</i></b> { VALUES ( <i><b>expression</i></b> [,
...] ) [, ...] | <i><b>query</i></b> }
+</pre>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="o">></span><span class="w">
</span><span class="k">INSERT</span><span class="w"> </span><span
class="k">INTO</span><span class="w"> </span><span
class="n">target_table</span><span class="w"> </span><span
class="k">VALUES</span><span class="w"> </span><span class="p">(</span><span
class="mi">1</span><span class="p">,</span><span class="w"> </span><span
class="s1">'Foo'</span><span class [...]
+<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>
+</section>
</section>
@@ -461,17 +450,17 @@
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="../expressions.html"
title="previous page">
+ <a class='left-prev' id="prev-link" href="ddl.html" title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">Expression API</p>
+ <p class="prev-next-title">DDL</p>
</div>
</a>
- <a class='right-next' id="next-link" href="data_types.html" title="next
page">
+ <a class='right-next' id="next-link" href="explain.html" title="next page">
<div class="prev-next-info">
<p class="prev-next-subtitle">next</p>
- <p class="prev-next-title">Data Types</p>
+ <p class="prev-next-title">EXPLAIN</p>
</div>
<i class="fas fa-angle-right"></i>
</a>
diff --git a/user-guide/sql/explain.html b/user-guide/sql/explain.html
index 6d24ce453f..4222649106 100644
--- a/user-guide/sql/explain.html
+++ b/user-guide/sql/explain.html
@@ -34,7 +34,7 @@
<link rel="index" title="Index" href="../../genindex.html" />
<link rel="search" title="Search" href="../../search.html" />
<link rel="next" title="Information Schema" href="information_schema.html"
/>
- <link rel="prev" title="DDL" href="ddl.html" />
+ <link rel="prev" title="DML" href="dml.html" />
<meta name="viewport" content="width=device-width, initial-scale=1" />
<meta name="docsearch:language" content="en">
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2 current active">
<a class="current reference internal" href="#">
EXPLAIN
@@ -448,11 +453,11 @@ If you need more information output, use <code
class="docutils literal notransla
<!-- Previous / next buttons -->
<div class='prev-next-area'>
- <a class='left-prev' id="prev-link" href="ddl.html" title="previous page">
+ <a class='left-prev' id="prev-link" href="dml.html" title="previous page">
<i class="fas fa-angle-left"></i>
<div class="prev-next-info">
<p class="prev-next-subtitle">previous</p>
- <p class="prev-next-title">DDL</p>
+ <p class="prev-next-title">DML</p>
</div>
</a>
<a class='right-next' id="next-link" href="information_schema.html"
title="next page">
diff --git a/user-guide/sql/index.html b/user-guide/sql/index.html
index a403435769..50267df590 100644
--- a/user-guide/sql/index.html
+++ b/user-guide/sql/index.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
@@ -404,6 +409,11 @@
<li class="toctree-l2"><a class="reference internal"
href="ddl.html#drop-view">DROP VIEW</a></li>
</ul>
</li>
+<li class="toctree-l1"><a class="reference internal"
href="dml.html">DML</a><ul>
+<li class="toctree-l2"><a class="reference internal"
href="dml.html#copy">COPY</a></li>
+<li class="toctree-l2"><a class="reference internal"
href="dml.html#insert">INSERT</a></li>
+</ul>
+</li>
<li class="toctree-l1"><a class="reference internal"
href="explain.html">EXPLAIN</a><ul>
<li class="toctree-l2"><a class="reference internal"
href="explain.html#id1">EXPLAIN</a></li>
<li class="toctree-l2"><a class="reference internal"
href="explain.html#explain-analyze">EXPLAIN ANALYZE</a></li>
diff --git a/user-guide/sql/information_schema.html
b/user-guide/sql/information_schema.html
index 4ae34984c7..0e1f97ad2c 100644
--- a/user-guide/sql/information_schema.html
+++ b/user-guide/sql/information_schema.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/operators.html b/user-guide/sql/operators.html
index 162c3bba5c..c0a78bb87a 100644
--- a/user-guide/sql/operators.html
+++ b/user-guide/sql/operators.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/scalar_functions.html
b/user-guide/sql/scalar_functions.html
index 5ec314b9e5..31fdda611a 100644
--- a/user-guide/sql/scalar_functions.html
+++ b/user-guide/sql/scalar_functions.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/select.html b/user-guide/sql/select.html
index 0f46fb0b58..9ccdea5050 100644
--- a/user-guide/sql/select.html
+++ b/user-guide/sql/select.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/sql_status.html b/user-guide/sql/sql_status.html
index 31e8cb7664..1d4c1b1a2f 100644
--- a/user-guide/sql/sql_status.html
+++ b/user-guide/sql/sql_status.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/subqueries.html b/user-guide/sql/subqueries.html
index f66a7daa49..596c6065b4 100644
--- a/user-guide/sql/subqueries.html
+++ b/user-guide/sql/subqueries.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
diff --git a/user-guide/sql/window_functions.html
b/user-guide/sql/window_functions.html
index 1ea06c5f87..ce08285c42 100644
--- a/user-guide/sql/window_functions.html
+++ b/user-guide/sql/window_functions.html
@@ -153,6 +153,11 @@
DDL
</a>
</li>
+ <li class="toctree-l2">
+ <a class="reference internal" href="dml.html">
+ DML
+ </a>
+ </li>
<li class="toctree-l2">
<a class="reference internal" href="explain.html">
EXPLAIN
