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 6570e2fc25 Publish built docs triggered by
39e9f41a21e8e2ffac39feabd13d6aa7eda5f213
6570e2fc25 is described below
commit 6570e2fc25887810cdc3711cca0c9fb69cbcf0a7
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Fri Dec 22 11:56:58 2023 +0000
Publish built docs triggered by 39e9f41a21e8e2ffac39feabd13d6aa7eda5f213
---
_sources/user-guide/sql/write_options.md.txt | 15 ++-------
searchindex.js | 2 +-
user-guide/sql/write_options.html | 48 +++-------------------------
3 files changed, 9 insertions(+), 56 deletions(-)
diff --git a/_sources/user-guide/sql/write_options.md.txt
b/_sources/user-guide/sql/write_options.md.txt
index 94adee9609..470591afaf 100644
--- a/_sources/user-guide/sql/write_options.md.txt
+++ b/_sources/user-guide/sql/write_options.md.txt
@@ -42,12 +42,11 @@ WITH HEADER ROW
DELIMITER ';'
LOCATION '/test/location/my_csv_table/'
OPTIONS(
-CREATE_LOCAL_PATH 'true',
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. CREATE_LOCAL_PATH is a special
option that indicates if DataFusi [...]
+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 [...]
Finally, options can be passed when running a `COPY` command.
@@ -70,17 +69,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 |
-
-### CREATE EXTERNAL TABLE Specific Options
-
-The following special options are specific to creating an external table.
-
-| Option | Description
| Default Value |
-| ----------- |
---------------------------------------------------------------------------------------------------------------------
| ------------- |
-| SINGLE_FILE | If true, indicates that this external table is backed by a
single file. INSERT INTO queries will append to this file. | false |
+| 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 | |
### JSON Format Specific Options
diff --git a/searchindex.js b/searchindex.js
index 9da3976092..3b9db18356 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/write_options.html
b/user-guide/sql/write_options.html
index f906b4148e..8e6c23be21 100644
--- a/user-guide/sql/write_options.html
+++ b/user-guide/sql/write_options.html
@@ -367,11 +367,6 @@
COPY Specific Options
</a>
</li>
- <li class="toc-h3 nav-item toc-entry">
- <a class="reference internal nav-link"
href="#create-external-table-specific-options">
- CREATE EXTERNAL TABLE Specific Options
- </a>
- </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link"
href="#json-format-specific-options">
JSON Format Specific Options
@@ -456,12 +451,11 @@
<span class="k">DELIMITER</span><span class="w"> </span><span
class="s1">';'</span>
<span class="k">LOCATION</span><span class="w"> </span><span
class="s1">'/test/location/my_csv_table/'</span>
<span class="k">OPTIONS</span><span class="p">(</span>
-<span class="n">CREATE_LOCAL_PATH</span><span class="w"> </span><span
class="s1">'true'</span><span class="p">,</span>
<span class="n">NULL_VALUE</span><span class="w"> </span><span
class="s1">'NAN'</span>
<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). Note
that compression, header, and delimiter settings can also be specified within t
[...]
<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>
@@ -479,42 +473,10 @@
<section id="copy-specific-options">
<h3>COPY Specific Options<a class="headerlink" href="#copy-specific-options"
title="Link to this heading">¶</a></h3>
<p>The following special options are specific to the <code class="docutils
literal notranslate"><span class="pre">COPY</span></code> command.</p>
-<table class="table">
-<thead>
-<tr class="row-odd"><th class="head"><p>Option</p></th>
-<th class="head"><p>Description</p></th>
-<th class="head"><p>Default Value</p></th>
-</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>
-<td><p>N/A</p></td>
-</tr>
-</tbody>
-</table>
-</section>
-<section id="create-external-table-specific-options">
-<h3>CREATE EXTERNAL TABLE Specific Options<a class="headerlink"
href="#create-external-table-specific-options" title="Link to this
heading">¶</a></h3>
-<p>The following special options are specific to creating an external
table.</p>
-<table class="table">
-<thead>
-<tr class="row-odd"><th class="head"><p>Option</p></th>
-<th class="head"><p>Description</p></th>
-<th class="head"><p>Default Value</p></th>
-</tr>
-</thead>
-<tbody>
-<tr class="row-even"><td><p>SINGLE_FILE</p></td>
-<td><p>If true, indicates that this external table is backed by a single file.
INSERT INTO queries will append to this file.</p></td>
-<td><p>false</p></td>
-</tr>
-</tbody>
-</table>
+<p>| 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 | |</p>
</section>
<section id="json-format-specific-options">
<h3>JSON Format Specific Options<a class="headerlink"
href="#json-format-specific-options" title="Link to this heading">¶</a></h3>
