You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@arrow.apache.org by ag...@apache.org on 2022/12/05 22:42:39 UTC
[arrow-site] branch asf-site updated: Update `https://arrow.apache.org/datafusion/` to DataFusion 15.0.0 (#281)
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 <an...@gmail.com>
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>