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 f0be0be141 Publish built docs triggered by
840499fbd3c25bf82a6ee0641ef6888079e096da
f0be0be141 is described below
commit f0be0be141483c59f4c932a36a90656bb4d2a221
Author: github-actions[bot] <github-actions[bot]@users.noreply.github.com>
AuthorDate: Sun Feb 4 16:03:11 2024 +0000
Publish built docs triggered by 840499fbd3c25bf82a6ee0641ef6888079e096da
---
_sources/user-guide/cli.md.txt | 21 +++++++++++++++++++++
searchindex.js | 2 +-
user-guide/cli.html | 24 ++++++++++++++++++++++++
3 files changed, 46 insertions(+), 1 deletion(-)
diff --git a/_sources/user-guide/cli.md.txt b/_sources/user-guide/cli.md.txt
index 30ab7d1495..4b909bbb1e 100644
--- a/_sources/user-guide/cli.md.txt
+++ b/_sources/user-guide/cli.md.txt
@@ -260,6 +260,27 @@ STORED AS CSV
LOCATION '/path/to/aggregate_test_100.csv';
```
+## Registering Remote Data Sources
+
+`datafusion-cli` can read from remote locations using a variety of protocols.
+For example to read from a remote parquet file via HTTP(S) you can use the
following:
+
+```sql
+CREATE EXTERNAL TABLE hits
+STORED AS PARQUET
+LOCATION
'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet';
+```
+
+```sql
+❯ select count(*) from hits;
++----------+
+| COUNT(*) |
++----------+
+| 1000000 |
++----------+
+1 row in set. Query took 0.344 seconds.
+```
+
## Registering S3 Data Sources
[AWS S3](https://aws.amazon.com/s3/) data sources can be registered by
executing a `CREATE EXTERNAL TABLE` SQL statement.
diff --git a/searchindex.js b/searchindex.js
index c3f3184a27..efa69ff2d6 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 3f61099da9..06ee182457 100644
--- a/user-guide/cli.html
+++ b/user-guide/cli.html
@@ -409,6 +409,11 @@
Registering CSV Data Sources
</a>
</li>
+ <li class="toc-h2 nav-item toc-entry">
+ <a class="reference internal nav-link"
href="#registering-remote-data-sources">
+ Registering Remote Data Sources
+ </a>
+ </li>
<li class="toc-h2 nav-item toc-entry">
<a class="reference internal nav-link" href="#registering-s3-data-sources">
Registering S3 Data Sources
@@ -706,6 +711,25 @@ via <code class="docutils literal notranslate"><span
class="pre">CREATE</span> <
</pre></div>
</div>
</section>
+<section id="registering-remote-data-sources">
+<h2>Registering Remote Data Sources<a class="headerlink"
href="#registering-remote-data-sources" title="Link to this heading">¶</a></h2>
+<p><code class="docutils literal notranslate"><span
class="pre">datafusion-cli</span></code> can read from remote locations using a
variety of protocols.
+For example to read from a remote parquet file via HTTP(S) you can use the
following:</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">hits</span>
+<span class="n">STORED</span><span class="w"> </span><span
class="k">AS</span><span class="w"> </span><span class="n">PARQUET</span>
+<span class="k">LOCATION</span><span class="w"> </span><span
class="s1">'https://datasets.clickhouse.com/hits_compatible/athena_partitioned/hits_1.parquet'</span><span
class="p">;</span>
+</pre></div>
+</div>
+<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span><span class="err">❯</span><span class="w">
</span><span class="k">select</span><span class="w"> </span><span
class="k">count</span><span class="p">(</span><span class="o">*</span><span
class="p">)</span><span class="w"> </span><span class="k">from</span><span
class="w"> </span><span class="n">hits</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="p">(</span><span class="o">*</span><span
class="p">)</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">1000000</span><span class="w"> </span><span class="o">|</span>
+<span class="o">+</span><span class="c1">----------+</span>
+<span class="mi">1</span><span class="w"> </span><span
class="k">row</span><span class="w"> </span><span class="k">in</span><span
class="w"> </span><span class="k">set</span><span class="p">.</span><span
class="w"> </span><span class="n">Query</span><span class="w"> </span><span
class="n">took</span><span class="w"> </span><span class="mi">0</span><span
class="p">.</span><span class="mi">344</span><span class="w"> </span><span
class="n">seconds</span><span class="p">.</span>
+</pre></div>
+</div>
+</section>
<section id="registering-s3-data-sources">
<h2>Registering S3 Data Sources<a class="headerlink"
href="#registering-s3-data-sources" title="Link to this heading">¶</a></h2>
<p><a class="reference external" href="https://aws.amazon.com/s3/";>AWS S3</a>
data sources can be registered by executing a <code class="docutils literal
notranslate"><span class="pre">CREATE</span> <span class="pre">EXTERNAL</span>
<span class="pre">TABLE</span></code> SQL statement.</p>
