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 31ac10ec1b Publish built docs triggered by
4d389c2590370d85bfe3af77f5243d5b40f5a222
31ac10ec1b is described below
commit 31ac10ec1b60977c848eaecfced3e98b2192e1a5
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Tue Jan 30 19:47:30 2024 +0000
Publish built docs triggered by 4d389c2590370d85bfe3af77f5243d5b40f5a222
---
_sources/user-guide/sql/dml.md.txt | 2 +-
_sources/user-guide/sql/write_options.md.txt | 12 +++++-------
searchindex.js | 2 +-
user-guide/sql/dml.html | 2 +-
user-guide/sql/write_options.html | 13 ++++---------
5 files changed, 12 insertions(+), 19 deletions(-)
diff --git a/_sources/user-guide/sql/dml.md.txt
b/_sources/user-guide/sql/dml.md.txt
index c3226936e7..79b1d6625e 100644
--- a/_sources/user-guide/sql/dml.md.txt
+++ b/_sources/user-guide/sql/dml.md.txt
@@ -49,7 +49,7 @@ 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, SINGLE_FILE_OUTPUT false);
+> COPY source_table TO 'dir_name' (FORMAT parquet);
+-------+
| count |
+-------+
diff --git a/_sources/user-guide/sql/write_options.md.txt
b/_sources/user-guide/sql/write_options.md.txt
index 75aa0d77b9..150da7c53d 100644
--- a/_sources/user-guide/sql/write_options.md.txt
+++ b/_sources/user-guide/sql/write_options.md.txt
@@ -46,7 +46,7 @@ NULL_VALUE 'NAN'
);
```
-When running `INSERT INTO my_table ...`, the options from the `CREATE TABLE`
will be respected (gzip compression, special delimiter, and header row
included). Note that compression, header, and delimiter settings can also be
specified within the `OPTIONS` tuple list. Dedicated syntax within the SQL
statement always takes precedence over arbitrary option tuples, so if both are
specified the `OPTIONS` setting will be ignored. NULL_VALUE is a CSV format
specific option that determines how n [...]
+When running `INSERT INTO my_table ...`, the options from the `CREATE TABLE`
will be respected (gzip compression, special delimiter, and header row
included). There will be a single output file if the output path doesn't have
folder format, i.e. ending with a `\`. Note that compression, header, and
delimiter settings can also be specified within the `OPTIONS` tuple list.
Dedicated syntax within the SQL statement always takes precedence over
arbitrary option tuples, so if both are specifi [...]
Finally, options can be passed when running a `COPY` command.
@@ -54,13 +54,12 @@ Finally, options can be passed when running a `COPY`
command.
COPY source_table
TO 'test/table_with_options'
(format parquet,
-single_file_output false,
compression snappy,
'compression::col1' 'zstd(5)',
)
```
-In this example, we write the entirety of `source_table` out to a folder of
parquet files. The option `single_file_output` set to false, indicates that the
destination path should be interpreted as a folder to which the query will
output multiple files. One parquet file will be written in parallel to the
folder for each partition in the query. The next option `compression` set to
`snappy` indicates that unless otherwise specified all columns should use the
snappy compression codec. The o [...]
+In this example, we write the entirety of `source_table` out to a folder of
parquet files. One parquet file will be written in parallel to the folder for
each partition in the query. The next option `compression` set to `snappy`
indicates that unless otherwise specified all columns should use the snappy
compression codec. The option `compression::col1` sets an override, so that the
column `col1` in the parquet file will use `ZSTD` compression codec with
compression level `5`. In general, [...]
## Available Options
@@ -68,10 +67,9 @@ In this example, we write the entirety of `source_table` out
to a folder of parq
The following special options are specific to the `COPY` command.
-| Option | Description
| Default Value |
-| ------------------ |
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| ------------- |
-| SINGLE_FILE_OUTPUT | If true, COPY query will write output to a single file.
Otherwise, multiple files will be written to a directory in parallel.
| true |
-| FORMAT | Specifies the file format COPY query will write out. If
single_file_output is false or the format cannot be inferred from the file
extension, then FORMAT must be specified. | N/A |
+| Option | Description
| Default Value |
+| ------ |
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| ------------- |
+| FORMAT | Specifies the file format COPY query will write out. If there're
more than one output file or the format cannot be inferred from the file
extension, then FORMAT must be specified. | N/A |
### JSON Format Specific Options
diff --git a/searchindex.js b/searchindex.js
index 7198ae6d84..342293f7de 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/sql/dml.html b/user-guide/sql/dml.html
index d25a277f79..fe6c0cb8be 100644
--- a/user-guide/sql/dml.html
+++ b/user-guide/sql/dml.html
@@ -432,7 +432,7 @@ COPY { <i><b>table_name</i></b> | <i><b>query</i></b> } TO
'<i><b>file_name</i><
</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 [...]
+<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 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>
diff --git a/user-guide/sql/write_options.html
b/user-guide/sql/write_options.html
index 2b82c46145..55554a915e 100644
--- a/user-guide/sql/write_options.html
+++ b/user-guide/sql/write_options.html
@@ -455,18 +455,17 @@
<span class="p">);</span>
</pre></div>
</div>
-<p>When running <code class="docutils literal notranslate"><span
class="pre">INSERT</span> <span class="pre">INTO</span> <span
class="pre">my_table</span> <span class="pre">...</span></code>, the options
from the <code class="docutils literal notranslate"><span
class="pre">CREATE</span> <span class="pre">TABLE</span></code> will be
respected (gzip compression, special delimiter, and header row included). Note
that compression, header, and delimiter settings can also be specified within t
[...]
+<p>When running <code class="docutils literal notranslate"><span
class="pre">INSERT</span> <span class="pre">INTO</span> <span
class="pre">my_table</span> <span class="pre">...</span></code>, the options
from the <code class="docutils literal notranslate"><span
class="pre">CREATE</span> <span class="pre">TABLE</span></code> will be
respected (gzip compression, special delimiter, and header row included). There
will be a single output file if the output path doesn’t have folder format, i.
[...]
<p>Finally, options can be passed when running a <code class="docutils literal
notranslate"><span class="pre">COPY</span></code> command.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">COPY</span><span class="w">
</span><span class="n">source_table</span>
<span class="k">TO</span><span class="w"> </span><span
class="s1">'test/table_with_options'</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="n">single_file_output</span><span class="w"> </span><span
class="k">false</span><span class="p">,</span>
<span class="n">compression</span><span class="w"> </span><span
class="n">snappy</span><span class="p">,</span>
<span class="s1">'compression::col1'</span><span class="w">
</span><span class="s1">'zstd(5)'</span><span class="p">,</span>
<span class="p">)</span>
</pre></div>
</div>
-<p>In this example, we write the entirety of <code class="docutils literal
notranslate"><span class="pre">source_table</span></code> out to a folder of
parquet files. The option <code class="docutils literal notranslate"><span
class="pre">single_file_output</span></code> set to false, indicates that the
destination path should be interpreted as a folder to which the query will
output multiple files. One parquet file will be written in parallel to the
folder for each partition in the quer [...]
+<p>In this example, we write the entirety of <code class="docutils literal
notranslate"><span class="pre">source_table</span></code> out to a folder of
parquet files. One parquet file will be written in parallel to the folder for
each partition in the query. The next option <code class="docutils literal
notranslate"><span class="pre">compression</span></code> set to <code
class="docutils literal notranslate"><span class="pre">snappy</span></code>
indicates that unless otherwise specified [...]
</section>
<section id="available-options">
<h2>Available Options<a class="headerlink" href="#available-options"
title="Link to this heading">¶</a></h2>
@@ -481,12 +480,8 @@
</tr>
</thead>
<tbody>
-<tr class="row-even"><td><p>SINGLE_FILE_OUTPUT</p></td>
-<td><p>If true, COPY query will write output to a single file. Otherwise,
multiple files will be written to a directory in parallel.</p></td>
-<td><p>true</p></td>
-</tr>
-<tr class="row-odd"><td><p>FORMAT</p></td>
-<td><p>Specifies the file format COPY query will write out. If
single_file_output is false or the format cannot be inferred from the file
extension, then FORMAT must be specified.</p></td>
+<tr class="row-even"><td><p>FORMAT</p></td>
+<td><p>Specifies the file format COPY query will write out. If there’re more
than one output file or the format cannot be inferred from the file extension,
then FORMAT must be specified.</p></td>
<td><p>N/A</p></td>
</tr>
</tbody>
