This is an automated email from the ASF dual-hosted git repository.
agrove pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/arrow-site.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 75358e94e35 Update `https://arrow.apache.org/datafusion/` to
DataFusion 15.0.0 (#281)
75358e94e35 is described below
commit 75358e94e3513f30769a73d8e43481e1a22f0003
Author: Andy Grove <[email protected]>
AuthorDate: Mon Dec 5 15:42:25 2022 -0700
Update `https://arrow.apache.org/datafusion/` to DataFusion 15.0.0 (#281)
* DataFusion 15.0.0
* remove _downloads and _sources
---
datafusion/contributor-guide/index.html | 11 +++++
datafusion/objects.inv | Bin 5007 -> 5023 bytes
datafusion/searchindex.js | 2 +-
datafusion/user-guide/cli.html | 22 ++++++----
datafusion/user-guide/configs.html | 47 +++++++++++++++++++---
datafusion/user-guide/dataframe.html | 2 +-
datafusion/user-guide/example-usage.html | 10 +++--
datafusion/user-guide/sql/data_types.html | 17 +++++++-
datafusion/user-guide/sql/explain.html | 2 +-
datafusion/user-guide/sql/information_schema.html | 2 +-
10 files changed, 91 insertions(+), 24 deletions(-)
diff --git a/datafusion/contributor-guide/index.html
b/datafusion/contributor-guide/index.html
index d80f954e093..66e52e37f5b 100644
--- a/datafusion/contributor-guide/index.html
+++ b/datafusion/contributor-guide/index.html
@@ -314,6 +314,11 @@
Rust Integration Tests
</a>
</li>
+ <li class="toc-h3 nav-item toc-entry">
+ <a class="reference internal nav-link" href="#sqllogictests-tests">
+ sqllogictests Tests
+ </a>
+ </li>
<li class="toc-h3 nav-item toc-entry">
<a class="reference internal nav-link"
href="#sql-postgres-integration-tests">
SQL / Postgres Integration Tests
@@ -545,6 +550,12 @@ and tries to follow <a class="reference external"
href="https://doc.rust-lang.or
</div>
<p>One very important test is the <a class="reference external"
href="https://github.com/apache/arrow-datafusion/blob/master/datafusion/core/tests/sql_integration.rs";>sql_integration</a>
test which validates DataFusion’s ability to run a large assortment of SQL
queries against an assortment of data setups.</p>
</section>
+<section id="sqllogictests-tests">
+<h3>sqllogictests Tests<a class="headerlink" href="#sqllogictests-tests"
title="Permalink to this heading">¶</a></h3>
+<p>The <a class="reference external"
href="https://github.com/apache/arrow-datafusion/blob/master/datafusion/core/tests/sqllogictests";>sqllogictests</a>
also validate DataFusion SQL against an assortment of data setups.</p>
+<p>Data Driven tests have many benefits including being easier to write and
maintain. We are in the process of <a class="reference external"
href="https://github.com/apache/arrow-datafusion/issues/4460";>migrating
sql_integration tests</a> and encourage
+you to add new tests using sqllogictests if possible.</p>
+</section>
<section id="sql-postgres-integration-tests">
<h3>SQL / Postgres Integration Tests<a class="headerlink"
href="#sql-postgres-integration-tests" title="Permalink to this
heading">¶</a></h3>
<p>The <a class="reference external"
href="https://github.com/apache/arrow-datafusion/blob/master/integration-tests";>integration-tests</a>
directory contains a harness that runs certain queries against both postgres
and datafusion and compares results</p>
diff --git a/datafusion/objects.inv b/datafusion/objects.inv
index a7f69714c94..ce6713b92ca 100644
Binary files a/datafusion/objects.inv and b/datafusion/objects.inv differ
diff --git a/datafusion/searchindex.js b/datafusion/searchindex.js
index 3d7e1c93b2e..a052178f56e 100644
--- a/datafusion/searchindex.js
+++ b/datafusion/searchindex.js
@@ -1 +1 @@
-Search.setIndex({"docnames": ["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",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq",
"user-guide/introduction", "user-guide [...]
\ No newline at end of file
+Search.setIndex({"docnames": ["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",
"user-guide/cli", "user-guide/configs", "user-guide/dataframe",
"user-guide/example-usage", "user-guide/expressions", "user-guide/faq",
"user-guide/introduction", "user-guide [...]
\ No newline at end of file
diff --git a/datafusion/user-guide/cli.html b/datafusion/user-guide/cli.html
index 813c77db3af..87c27135e67 100644
--- a/datafusion/user-guide/cli.html
+++ b/datafusion/user-guide/cli.html
@@ -494,24 +494,30 @@ Type <span class="sb">`</span><span
class="nb">exit</span><span class="sb">`</sp
<h2>Querying S3 Data Sources<a class="headerlink"
href="#querying-s3-data-sources" title="Permalink to this heading">¶</a></h2>
<p>The CLI can query data in S3 if the following environment variables are
defined:</p>
<ul class="simple">
-<li><p><code class="docutils literal notranslate"><span
class="pre">AWS_REGION</span></code></p></li>
+<li><p><code class="docutils literal notranslate"><span
class="pre">AWS_DEFAULT_REGION</span></code></p></li>
<li><p><code class="docutils literal notranslate"><span
class="pre">AWS_ACCESS_KEY_ID</span></code></p></li>
<li><p><code class="docutils literal notranslate"><span
class="pre">AWS_SECRET_ACCESS_KEY</span></code></p></li>
</ul>
-<p>Note that the region must be set to the region where the bucket exists
until the following issue is resolved:</p>
+<p>Details of the environment variables that can be used are</p>
<ul class="simple">
-<li><p>https://github.com/apache/arrow-rs/issues/2795</p></li>
+<li><p>AWS_ACCESS_KEY_ID -> access_key_id</p></li>
+<li><p>AWS_SECRET_ACCESS_KEY -> secret_access_key</p></li>
+<li><p>AWS_DEFAULT_REGION -> region</p></li>
+<li><p>AWS_ENDPOINT -> endpoint</p></li>
+<li><p>AWS_SESSION_TOKEN -> token</p></li>
+<li><p>AWS_CONTAINER_CREDENTIALS_RELATIVE_URI -> <a class="reference
external"
href="https://docs.aws.amazon.com/AmazonECS/latest/developerguide/task-iam-roles.html";>https://docs.aws.amazon.com/AmazonECS/latest/developerguide/task-iam-roles.html</a></p></li>
+<li><p>AWS_ALLOW_HTTP -> set to “true” to permit HTTP connections without
TLS</p></li>
</ul>
<p>Example:</p>
<div class="highlight-bash notranslate"><div
class="highlight"><pre><span></span>$ aws s3 cp test.csv s3://my-bucket/
upload: ./test.csv to s3://my-bucket/test.csv
-$ <span class="nb">export</span> <span class="nv">AWS_REGION</span><span
class="o">=</span>us-east-2
+$ <span class="nb">export</span> <span
class="nv">AWS_DEFAULT_REGION</span><span class="o">=</span>us-east-2
$ <span class="nb">export</span> <span
class="nv">AWS_SECRET_ACCESS_KEY</span><span
class="o">=</span>***************************
$ <span class="nb">export</span> <span
class="nv">AWS_ACCESS_KEY_ID</span><span class="o">=</span>**************
-$ ./target/release/datafusion-cli
-DataFusion CLI v12.0.0
+$ datafusion-cli
+DataFusion CLI v14.0.0
❯ create external table <span class="nb">test</span> stored as csv location
<span class="s1">'s3://my-bucket/test.csv'</span><span
class="p">;</span>
<span class="m">0</span> rows <span class="k">in</span> set. Query took <span
class="m">0</span>.374 seconds.
❯ <span class="k">select</span> * from test<span class="p">;</span>
@@ -566,7 +572,7 @@ DataFusion CLI v12.0.0
<ul class="simple">
<li><p>Search and describe function</p></li>
</ul>
-<div class="highlight-bash notranslate"><div
class="highlight"><pre><span></span>> <span class="se">\h</span>
function_table
+<div class="highlight-bash notranslate"><div
class="highlight"><pre><span></span>> <span class="se">\h</span> <span
class="k">function</span>
</pre></div>
</div>
<ul class="simple">
@@ -600,7 +606,7 @@ DataFusion CLI v12.0.0
<p>All available configuration options can be seen using <code class="docutils
literal notranslate"><span class="pre">SHOW</span> <span
class="pre">ALL</span></code> as described above.</p>
<p>You can change the configuration options using environment
variables. <code class="docutils literal notranslate"><span
class="pre">datafusion-cli</span></code> looks in the corresponding environment
-variable with an upper case name and all <code class="docutils literal
notranslate"><span class="pre">.</span></code> is converted to <code
class="docutils literal notranslate"><span class="pre">_</span></code>.</p>
+variable with an upper case name and all <code class="docutils literal
notranslate"><span class="pre">.</span></code> converted to <code
class="docutils literal notranslate"><span class="pre">_</span></code>.</p>
<p>For example, to set <code class="docutils literal notranslate"><span
class="pre">datafusion.execution.batch_size</span></code> to <code
class="docutils literal notranslate"><span class="pre">1024</span></code> you
would set the <code class="docutils literal notranslate"><span
class="pre">DATAFUSION_EXECUTION_BATCH_SIZE</span></code> environment variable
appropriately:</p>
diff --git a/datafusion/user-guide/configs.html
b/datafusion/user-guide/configs.html
index b97e424f44c..3ae271b6fb0 100644
--- a/datafusion/user-guide/configs.html
+++ b/datafusion/user-guide/configs.html
@@ -330,12 +330,12 @@ Environment variables are read during <code
class="docutils literal notranslate"
<tr class="row-even"><td><p>datafusion.catalog.location</p></td>
<td><p>Utf8</p></td>
<td><p>NULL</p></td>
-<td><p>Location scanned to load tables for <code class="docutils literal
notranslate"><span class="pre">default</span></code> schema</p></td>
+<td><p>Location scanned to load tables for <code class="docutils literal
notranslate"><span class="pre">default</span></code> schema, defaults to
None</p></td>
</tr>
<tr class="row-odd"><td><p>datafusion.catalog.type</p></td>
<td><p>Utf8</p></td>
<td><p>NULL</p></td>
-<td><p>Type of <code class="docutils literal notranslate"><span
class="pre">TableProvider</span></code> to use when loading <code
class="docutils literal notranslate"><span class="pre">default</span></code>
schema</p></td>
+<td><p>Type of <code class="docutils literal notranslate"><span
class="pre">TableProvider</span></code> to use when loading <code
class="docutils literal notranslate"><span class="pre">default</span></code>
schema. Defaults to None</p></td>
</tr>
<tr class="row-even"><td><p>datafusion.execution.batch_size</p></td>
<td><p>UInt64</p></td>
@@ -357,6 +357,16 @@ Environment variables are read during <code
class="docutils literal notranslate"
<td><p>false</p></td>
<td><p>If true, uses parquet data page level metadata (Page Index) statistics
to reduce the number of rows decoded.</p></td>
</tr>
+<tr
class="row-even"><td><p>datafusion.execution.parquet.metadata_size_hint</p></td>
+<td><p>UInt64</p></td>
+<td><p>NULL</p></td>
+<td><p>If specified, the parquet reader will try and fetch the last <code
class="docutils literal notranslate"><span class="pre">size_hint</span></code>
bytes of the parquet file optimistically. If not specified, two read are
required: One read to fetch the 8-byte parquet footer and another to fetch the
metadata length encoded in the footer.</p></td>
+</tr>
+<tr class="row-odd"><td><p>datafusion.execution.parquet.pruning</p></td>
+<td><p>Boolean</p></td>
+<td><p>true</p></td>
+<td><p>If true, the parquet reader attempts to skip entire row groups based on
the predicate in the query and the metadata (min/max values) stored in the
parquet file.</p></td>
+</tr>
<tr
class="row-even"><td><p>datafusion.execution.parquet.pushdown_filters</p></td>
<td><p>Boolean</p></td>
<td><p>false</p></td>
@@ -367,10 +377,20 @@ Environment variables are read during <code
class="docutils literal notranslate"
<td><p>false</p></td>
<td><p>If true, filter expressions evaluated during the parquet decoding
opearation will be reordered heuristically to minimize the cost of evaluation.
If false, the filters are applied in the same order as written in the
query.</p></td>
</tr>
-<tr class="row-even"><td><p>datafusion.execution.time_zone</p></td>
+<tr class="row-even"><td><p>datafusion.execution.parquet.skip_metadata</p></td>
+<td><p>Boolean</p></td>
+<td><p>true</p></td>
+<td><p>If true, the parquet reader skip the optional embedded metadata that
may be in the file Schema. This setting can help avoid schema conflicts when
querying multiple parquet files with schemas containing compatible types but
different metadata.</p></td>
+</tr>
+<tr class="row-odd"><td><p>datafusion.execution.time_zone</p></td>
<td><p>Utf8</p></td>
-<td><p>UTC</p></td>
-<td><p>The session time zone which some function require e.g. EXTRACT(HOUR
from SOME_TIME) shift the underline datetime according to the time zone, then
extract the hour.</p></td>
+<td><p>+00:00</p></td>
+<td><p>The session time zone which some function require e.g. EXTRACT(HOUR
from SOME_TIME) shift the underline datetime according to the time
zone,</p></td>
+</tr>
+<tr class="row-even"><td><p>then extract the hour.</p></td>
+<td><p></p></td>
+<td><p></p></td>
+<td><p></p></td>
</tr>
<tr class="row-odd"><td><p>datafusion.explain.logical_plan_only</p></td>
<td><p>Boolean</p></td>
@@ -387,16 +407,31 @@ Environment variables are read during <code
class="docutils literal notranslate"
<td><p>false</p></td>
<td><p>When set to true, the optimizer will insert filters before a join
between a nullable and non-nullable column to filter out nulls on the nullable
side. This filter can add additional overhead when the file format does not
fully support predicate push down.</p></td>
</tr>
-<tr class="row-even"><td><p>datafusion.optimizer.max_passes</p></td>
+<tr
class="row-even"><td><p>datafusion.optimizer.hash_join_single_partition_threshold</p></td>
+<td><p>UInt64</p></td>
+<td><p>1048576</p></td>
+<td><p>The maximum estimated size in bytes for one input side of a HashJoin
will be collected into a single partition</p></td>
+</tr>
+<tr class="row-odd"><td><p>datafusion.optimizer.max_passes</p></td>
<td><p>UInt64</p></td>
<td><p>3</p></td>
<td><p>Number of times that the optimizer will attempt to optimize the
plan</p></td>
</tr>
+<tr class="row-even"><td><p>datafusion.optimizer.prefer_hash_join</p></td>
+<td><p>Boolean</p></td>
+<td><p>true</p></td>
+<td><p>When set to true, the physical plan optimizer will prefer HashJoin over
SortMergeJoin. HashJoin can work more efficientlythan SortMergeJoin but
consumes more memory. Defaults to true</p></td>
+</tr>
<tr class="row-odd"><td><p>datafusion.optimizer.skip_failed_rules</p></td>
<td><p>Boolean</p></td>
<td><p>true</p></td>
<td><p>When set to true, the logical plan optimizer will produce warning
messages if any optimization rules produce errors and then proceed to the next
rule. When set to false, any rules that produce errors will cause the query to
fail.</p></td>
</tr>
+<tr
class="row-even"><td><p>datafusion.optimizer.top_down_join_key_reordering</p></td>
+<td><p>Boolean</p></td>
+<td><p>true</p></td>
+<td><p>When set to true, the physical plan optimizer will run a top down
process to reorder the join keys. Defaults to true</p></td>
+</tr>
</tbody>
</table>
</section>
diff --git a/datafusion/user-guide/dataframe.html
b/datafusion/user-guide/dataframe.html
index 1d202efe901..69afc2a941d 100644
--- a/datafusion/user-guide/dataframe.html
+++ b/datafusion/user-guide/dataframe.html
@@ -347,7 +347,7 @@ to build up a query definition.</p>
</pre></div>
</div>
<p>The DataFrame API is well documented in the <a class="reference external"
href="https://docs.rs/datafusion/latest/datafusion/dataframe/struct.DataFrame.html";>API
reference on docs.rs</a>.</p>
-<p>Refer to the <a class="reference internal" href="expressions.html"><span
class="doc std std-doc">Expressions Refence</span></a> for available functions
for building logical expressions for use with the
+<p>Refer to the <a class="reference internal" href="expressions.html"><span
class="doc std std-doc">Expressions Reference</span></a> for available
functions for building logical expressions for use with the
DataFrame API.</p>
<section id="dataframe-transformations">
<h2>DataFrame Transformations<a class="headerlink"
href="#dataframe-transformations" title="Permalink to this heading">¶</a></h2>
diff --git a/datafusion/user-guide/example-usage.html
b/datafusion/user-guide/example-usage.html
index 364fe409a2e..e3b40604abc 100644
--- a/datafusion/user-guide/example-usage.html
+++ b/datafusion/user-guide/example-usage.html
@@ -404,10 +404,11 @@
<span class="w"> </span><span class="kd">let</span><span class="w">
</span><span class="n">df</span><span class="w"> </span><span
class="o">=</span><span class="w"> </span><span class="n">ctx</span><span
class="p">.</span><span class="n">read_csv</span><span class="p">(</span><span
class="s">"tests/example.csv"</span><span class="p">,</span><span
class="w"> </span><span class="n">CsvReadOptions</span>::<span
class="n">new</span><span class="p">()).</span><span class="k">await< [...]
<span class="w"> </span><span class="kd">let</span><span class="w">
</span><span class="n">df</span><span class="w"> </span><span
class="o">=</span><span class="w"> </span><span class="n">df</span><span
class="p">.</span><span class="n">filter</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s">"a"</span><span class="p">).</span><span
class="n">lt_eq</span><span class="p">(</span><span class="n">col</span><span
class="p">(</span><spa [...]
-<span class="w"> </span><span class="p">.</span><span
class="n">aggregate</span><span class="p">(</span><span
class="fm">vec!</span><span class="p">[</span><span class="n">col</span><span
class="p">(</span><span class="s">"a"</span><span
class="p">)],</span><span class="w"> </span><span class="fm">vec!</span><span
class="p">[</span><span class="n">min</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s">"b"</span><s [...]
+<span class="w"> </span><span class="p">.</span><span
class="n">aggregate</span><span class="p">(</span><span
class="fm">vec!</span><span class="p">[</span><span class="n">col</span><span
class="p">(</span><span class="s">"a"</span><span
class="p">)],</span><span class="w"> </span><span class="fm">vec!</span><span
class="p">[</span><span class="n">min</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s">"b"</span><s [...]
+<span class="w"> </span><span class="p">.</span><span
class="n">limit</span><span class="p">(</span><span class="mi">0</span><span
class="p">,</span><span class="w"> </span><span class="nb">Some</span><span
class="p">(</span><span class="mi">100</span><span class="p">))</span><span
class="o">?</span><span class="p">;</span><span class="w"></span>
<span class="w"> </span><span class="c1">// execute and print results</span>
-<span class="w"> </span><span class="n">df</span><span
class="p">.</span><span class="n">show_limit</span><span
class="p">(</span><span class="mi">100</span><span class="p">).</span><span
class="k">await</span><span class="o">?</span><span class="p">;</span><span
class="w"></span>
+<span class="w"> </span><span class="n">df</span><span
class="p">.</span><span class="n">show</span><span class="p">().</span><span
class="k">await</span><span class="o">?</span><span class="p">;</span><span
class="w"></span>
<span class="w"> </span><span class="nb">Ok</span><span
class="p">(())</span><span class="w"></span>
<span class="p">}</span><span class="w"></span>
</pre></div>
@@ -459,10 +460,11 @@
<span class="w"> </span><span class="kd">let</span><span class="w">
</span><span class="n">df</span><span class="w"> </span><span
class="o">=</span><span class="w"> </span><span class="n">ctx</span><span
class="p">.</span><span class="n">read_csv</span><span class="p">(</span><span
class="s">"tests/capitalized_example.csv"</span><span
class="p">,</span><span class="w"> </span><span
class="n">CsvReadOptions</span>::<span class="n">new</span><span
class="p">()).</span><span clas [...]
<span class="w"> </span><span class="kd">let</span><span class="w">
</span><span class="n">df</span><span class="w"> </span><span
class="o">=</span><span class="w"> </span><span class="n">df</span><span
class="p">.</span><span class="n">filter</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s">"A"</span><span class="p">).</span><span
class="n">lt_eq</span><span class="p">(</span><span class="n">col</span><span
class="p">(</span><spa [...]
-<span class="w"> </span><span class="p">.</span><span
class="n">aggregate</span><span class="p">(</span><span
class="fm">vec!</span><span class="p">[</span><span class="n">col</span><span
class="p">(</span><span class="s">"A"</span><span
class="p">)],</span><span class="w"> </span><span class="fm">vec!</span><span
class="p">[</span><span class="n">min</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s">"b"</span><s [...]
+<span class="w"> </span><span class="p">.</span><span
class="n">aggregate</span><span class="p">(</span><span
class="fm">vec!</span><span class="p">[</span><span class="n">col</span><span
class="p">(</span><span class="s">"A"</span><span
class="p">)],</span><span class="w"> </span><span class="fm">vec!</span><span
class="p">[</span><span class="n">min</span><span class="p">(</span><span
class="n">col</span><span class="p">(</span><span
class="s">"b"</span><s [...]
+<span class="w"> </span><span class="p">.</span><span
class="n">limit</span><span class="p">(</span><span class="mi">0</span><span
class="p">,</span><span class="w"> </span><span class="nb">Some</span><span
class="p">(</span><span class="mi">100</span><span class="p">))</span><span
class="o">?</span><span class="p">;</span><span class="w"></span>
<span class="w"> </span><span class="c1">// execute and print results</span>
-<span class="w"> </span><span class="n">df</span><span
class="p">.</span><span class="n">show_limit</span><span
class="p">(</span><span class="mi">100</span><span class="p">).</span><span
class="k">await</span><span class="o">?</span><span class="p">;</span><span
class="w"></span>
+<span class="w"> </span><span class="n">df</span><span
class="p">.</span><span class="n">show</span><span class="p">().</span><span
class="k">await</span><span class="o">?</span><span class="p">;</span><span
class="w"></span>
<span class="w"> </span><span class="nb">Ok</span><span
class="p">(())</span><span class="w"></span>
<span class="p">}</span><span class="w"></span>
</pre></div>
diff --git a/datafusion/user-guide/sql/data_types.html
b/datafusion/user-guide/sql/data_types.html
index deb9ca86940..0e93829c5a3 100644
--- a/datafusion/user-guide/sql/data_types.html
+++ b/datafusion/user-guide/sql/data_types.html
@@ -372,44 +372,57 @@ This mapping occurs when defining the schema in a <code
class="docutils literal
<thead>
<tr class="row-odd"><th class="head"><p>SQL DataType</p></th>
<th class="head text-left"><p>Arrow DataType</p></th>
+<th class="head"><p>Notes</p></th>
</tr>
</thead>
<tbody>
<tr class="row-even"><td><p><code class="docutils literal notranslate"><span
class="pre">TINYINT</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Int8</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">SMALLINT</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Int16</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-even"><td><p><code class="docutils literal notranslate"><span
class="pre">INT</span></code> or <code class="docutils literal
notranslate"><span class="pre">INTEGER</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Int32</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">BIGINT</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Int64</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-even"><td><p><code class="docutils literal notranslate"><span
class="pre">TINYINT</span> <span class="pre">UNSIGNED</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">UInt8</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">SMALLINT</span> <span class="pre">UNSIGNED</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">UInt16</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-even"><td><p><code class="docutils literal notranslate"><span
class="pre">INT</span> <span class="pre">UNSIGNED</span></code> or <code
class="docutils literal notranslate"><span class="pre">INTEGER</span> <span
class="pre">UNSIGNED</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">UInt32</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">BIGINT</span> <span class="pre">UNSIGNED</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">UInt64</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-even"><td><p><code class="docutils literal notranslate"><span
class="pre">FLOAT</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Float32</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">REAL</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Float32</span></code></p></td>
+<td><p></p></td>
</tr>
<tr class="row-even"><td><p><code class="docutils literal notranslate"><span
class="pre">DOUBLE</span></code></p></td>
<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Float64</span></code></p></td>
+<td><p></p></td>
</tr>
-<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">DECIMAL(p,s)</span></code></p></td>
-<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Decimal128(p,s)</span></code></p></td>
+<tr class="row-odd"><td><p><code class="docutils literal notranslate"><span
class="pre">DECIMAL(precision,scale)</span></code></p></td>
+<td class="text-left"><p><code class="docutils literal notranslate"><span
class="pre">Decimal128(precision,scale)</span></code></p></td>
+<td><p>Decimal support is currently experimental (<a class="reference
external"
href="https://github.com/apache/arrow-datafusion/issues/3523";>#3523</a>)</p></td>
</tr>
</tbody>
</table>
diff --git a/datafusion/user-guide/sql/explain.html
b/datafusion/user-guide/sql/explain.html
index adce52d0e83..97fb05a36ac 100644
--- a/datafusion/user-guide/sql/explain.html
+++ b/datafusion/user-guide/sql/explain.html
@@ -349,7 +349,7 @@ If you need more details output, try to use <code
class="docutils literal notran
</section>
<section id="explain-analyze">
<h2>EXPLAIN ANALYZE<a class="headerlink" href="#explain-analyze"
title="Permalink to this heading">¶</a></h2>
-<p>Shows the execution plan and metrics of a statment.
+<p>Shows the execution plan and metrics of a statement.
If you need more information output, try to use <code class="docutils literal
notranslate"><span class="pre">EXPLAIN</span> <span class="pre">ANALYZE</span>
<span class="pre">VERBOSE</span></code>.</p>
<div class="highlight-sql notranslate"><div
class="highlight"><pre><span></span>EXPLAIN ANALYZE SELECT SUM(x) FROM table
GROUP BY b;
+-------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------+
diff --git a/datafusion/user-guide/sql/information_schema.html
b/datafusion/user-guide/sql/information_schema.html
index e32fb7b0c20..1e9fb2e6b8f 100644
--- a/datafusion/user-guide/sql/information_schema.html
+++ b/datafusion/user-guide/sql/information_schema.html
@@ -328,7 +328,7 @@ views of the ISO SQL <code class="docutils literal
notranslate"><span class="pre
<span class="o">+</span><span
class="c1">---------------+--------------+------------+-------------+-----------+-------------+</span>
<span class="o">|</span><span class="w"> </span><span
class="n">table_catalog</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span
class="n">table_schema</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span
class="k">table_name</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span
class="k">column_name</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">da [...]
<span class="o">+</span><span
class="c1">---------------+--------------+------------+-------------+-----------+-------------+</span>
-<span class="o">|</span><span class="w"> </span><span
class="n">datafusion</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="k">public</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="n">t1</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">Int64</span><span
class="p">(</span><span class="mi">1</span><span class="p">)</span><span
class="w"> </s [...]
+<span class="o">|</span><span class="w"> </span><span
class="n">datafusion</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="k">public</span><span
class="w"> </span><span class="o">|</span><span class="w"> </span><span
class="n">t</span><span class="w"> </span><span
class="o">|</span><span class="w"> </span><span class="n">Int64</span><span
class="p">(</span><span class="mi">1</span><span class="p">)</span><span
class="w"> </s [...]
<span class="o">+</span><span
class="c1">---------------+--------------+------------+-------------+-----------+-------------+</span>
</pre></div>
</div>
