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/10/14 13:50:58 UTC
[arrow-datafusion] branch master updated: Document SHOW ALL in the users guide (#3826)
This is an automated email from the ASF dual-hosted git repository.
agrove pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/arrow-datafusion.git
The following commit(s) were added to refs/heads/master by this push:
new 87dd4ff60 Document SHOW ALL in the users guide (#3826)
87dd4ff60 is described below
commit 87dd4ff605110cfc491f8022798f226d257bcce4
Author: Andrew Lamb <an...@nerdnetworks.org>
AuthorDate: Fri Oct 14 09:50:52 2022 -0400
Document SHOW ALL in the users guide (#3826)
---
docs/source/user-guide/sql/information_schema.md | 23 +++++++++++++++++++++--
1 file changed, 21 insertions(+), 2 deletions(-)
diff --git a/docs/source/user-guide/sql/information_schema.md b/docs/source/user-guide/sql/information_schema.md
index 3e04fad55..a3964e9c3 100644
--- a/docs/source/user-guide/sql/information_schema.md
+++ b/docs/source/user-guide/sql/information_schema.md
@@ -24,7 +24,7 @@ views of the ISO SQL `information_schema` schema or the DataFusion specific `SHO
To show tables in the DataFusion catalog, use the `SHOW TABLES` command or the `information_schema.tables` view:
-```text
+```sql
> show tables;
or
> select * from information_schema.tables;
@@ -41,7 +41,7 @@ or
To show the schema of a table in DataFusion, use the `SHOW COLUMNS` command or the `information_schema.columns` view:
-```text
+```sql
> show columns from t;
or
> select table_catalog, table_schema, table_name, column_name, data_type, is_nullable from information_schema.columns;
@@ -51,3 +51,22 @@ or
| datafusion | public | t1 | Int64(1) | Int64 | NO |
+---------------+--------------+------------+-------------+-----------+-------------+
```
+
+To show the current session configuration options, use the `SHOW ALL` command or the `information_schema.df_settings` view:
+
+```sql
+❯ select * from information_schema.df_settings;
+
++-------------------------------------------------+---------+
+| name | setting |
++-------------------------------------------------+---------+
+| datafusion.execution.batch_size | 8192 |
+| datafusion.execution.coalesce_batches | true |
+| datafusion.execution.coalesce_target_batch_size | 4096 |
+| datafusion.execution.time_zone | UTC |
+| datafusion.explain.logical_plan_only | false |
+| datafusion.explain.physical_plan_only | false |
+| datafusion.optimizer.filter_null_join_keys | false |
+| datafusion.optimizer.skip_failed_rules | true |
++-------------------------------------------------+---------+
+```