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 5b2bdd98ff Publish built docs triggered by
0b3a0545e37c42a1856fd4545850a72938f825a6
5b2bdd98ff is described below
commit 5b2bdd98ff62775bd556aca176dc6fa3c3d7ee8f
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Thu Sep 7 16:55:09 2023 +0000
Publish built docs triggered by 0b3a0545e37c42a1856fd4545850a72938f825a6
---
_sources/user-guide/sql/ddl.md.txt | 12 +++++++++++-
searchindex.js | 2 +-
user-guide/sql/ddl.html | 10 +++++++++-
3 files changed, 21 insertions(+), 3 deletions(-)
diff --git a/_sources/user-guide/sql/ddl.md.txt
b/_sources/user-guide/sql/ddl.md.txt
index 751159c305..54a9af6c23 100644
--- a/_sources/user-guide/sql/ddl.md.txt
+++ b/_sources/user-guide/sql/ddl.md.txt
@@ -77,7 +77,7 @@ LOCATION <literal>
<key_value_list> := (<literal> <literal, <literal> <literal>, ...)
```
-`file_type` is one of `CSV`, `PARQUET`, `AVRO` or `JSON`
+`file_type` is one of `CSV`, `ARROW`, `PARQUET`, `AVRO` or `JSON`
`LOCATION <literal>` specifies the location to find the data. It can be
a path to a file or directory of partitioned files locally or on an
@@ -102,6 +102,16 @@ WITH HEADER ROW
LOCATION '/path/to/aggregate_simple.csv';
```
+It is also possible to use compressed files, such as `.csv.gz`:
+
+```sql
+CREATE EXTERNAL TABLE test
+STORED AS CSV
+COMPRESSION TYPE GZIP
+WITH HEADER ROW
+LOCATION '/path/to/aggregate_simple.csv.gz';
+```
+
It is also possible to specify the schema manually.
```sql
diff --git a/searchindex.js b/searchindex.js
index 42bdae006a..ae6739057c 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/ddl.html b/user-guide/sql/ddl.html
index f4fe220b4e..0dcad8a66f 100644
--- a/user-guide/sql/ddl.html
+++ b/user-guide/sql/ddl.html
@@ -480,7 +480,7 @@ file system or remote object store as a named table which
can be queried.</p>
<span class="o"><</span><span class="n">key_value_list</span><span
class="o">></span> <span class="o">:=</span> <span class="p">(</span><span
class="o"><</span><span class="n">literal</span><span class="o">></span>
<span class="o"><</span><span class="n">literal</span><span
class="p">,</span> <span class="o"><</span><span
class="n">literal</span><span class="o">></span> <span
class="o"><</span><span class="n">literal</span><span
class="o">></span><span class="p [...]
</pre></div>
</div>
-<p><code class="docutils literal notranslate"><span
class="pre">file_type</span></code> is one of <code class="docutils literal
notranslate"><span class="pre">CSV</span></code>, <code class="docutils literal
notranslate"><span class="pre">PARQUET</span></code>, <code class="docutils
literal notranslate"><span class="pre">AVRO</span></code> or <code
class="docutils literal notranslate"><span class="pre">JSON</span></code></p>
+<p><code class="docutils literal notranslate"><span
class="pre">file_type</span></code> is one of <code class="docutils literal
notranslate"><span class="pre">CSV</span></code>, <code class="docutils literal
notranslate"><span class="pre">ARROW</span></code>, <code class="docutils
literal notranslate"><span class="pre">PARQUET</span></code>, <code
class="docutils literal notranslate"><span class="pre">AVRO</span></code> or
<code class="docutils literal notranslate"><span class="pre">JSON [...]
<p><code class="docutils literal notranslate"><span
class="pre">LOCATION</span> <span class="pre"><literal></span></code>
specifies the location to find the data. It can be
a path to a file or directory of partitioned files locally or on an
object store.</p>
@@ -499,6 +499,14 @@ scanning a subset of the file.</p>
<span class="k">LOCATION</span><span class="w"> </span><span
class="s1">'/path/to/aggregate_simple.csv'</span><span
class="p">;</span>
</pre></div>
</div>
+<p>It is also possible to use compressed files, such as <code class="docutils
literal notranslate"><span class="pre">.csv.gz</span></code>:</p>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">CREATE</span><span
class="w"> </span><span class="k">EXTERNAL</span><span class="w"> </span><span
class="k">TABLE</span><span class="w"> </span><span class="n">test</span>
+<span class="n">STORED</span><span class="w"> </span><span
class="k">AS</span><span class="w"> </span><span class="n">CSV</span>
+<span class="n">COMPRESSION</span><span class="w"> </span><span
class="k">TYPE</span><span class="w"> </span><span class="n">GZIP</span>
+<span class="k">WITH</span><span class="w"> </span><span
class="n">HEADER</span><span class="w"> </span><span class="k">ROW</span>
+<span class="k">LOCATION</span><span class="w"> </span><span
class="s1">'/path/to/aggregate_simple.csv.gz'</span><span
class="p">;</span>
+</pre></div>
+</div>
<p>It is also possible to specify the schema manually.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="k">CREATE</span><span
class="w"> </span><span class="k">EXTERNAL</span><span class="w"> </span><span
class="k">TABLE</span><span class="w"> </span><span class="n">test</span><span
class="w"> </span><span class="p">(</span>
<span class="w"> </span><span class="n">c1</span><span class="w">
</span><span class="nb">VARCHAR</span><span class="w"> </span><span
class="k">NOT</span><span class="w"> </span><span class="k">NULL</span><span
class="p">,</span>
