[arrow-datafusion] branch master updated: [MINOR] Update `SET` in cli.md (#4098)

[al...@apache.org]

This is an automated email from the ASF dual-hosted git repository.

alamb 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 fc669d589 [MINOR] Update `SET` in cli.md  (#4098)
fc669d589 is described below

commit fc669d5892954cbd2612a272314785758a7cb176
Author: Wei-Ting Kuo <wa...@gmail.com>
AuthorDate: Sat Nov 5 00:51:31 2022 +0800

    [MINOR] Update `SET` in cli.md  (#4098)
    
    * Update cli.md
    
    add `SET`
    
    * prettier
    
    Co-authored-by: Andrew Lamb <an...@nerdnetworks.org>
---
 docs/source/user-guide/cli.md | 32 ++++++++++++++++++++++++++++++++
 1 file changed, 32 insertions(+)

diff --git a/docs/source/user-guide/cli.md b/docs/source/user-guide/cli.md
index 246ab9189..91fe37d0d 100644
--- a/docs/source/user-guide/cli.md
+++ b/docs/source/user-guide/cli.md
@@ -252,6 +252,12 @@ Available commands inside DataFusion CLI are:
 
 ```
 
+- Set configuration options
+
+```SQL
+> SET datafusion.execution.batch_size to 1024;
+```
+
 ## Changing Configuration Options
 
 All available configuration options can be seen using `SHOW ALL` as described above.
@@ -282,3 +288,29 @@ DataFusion CLI v12.0.0
 +-------------------------------------------------+---------+
 8 rows in set. Query took 0.002 seconds.
 ```
+
+You can change the configuration options using `SET` statement as well
+
+```shell
+$ datafusion-cli
+DataFusion CLI v13.0.0
+
+❯ show datafusion.execution.batch_size;
++---------------------------------+---------+
+| name                            | setting |
++---------------------------------+---------+
+| datafusion.execution.batch_size | 8192    |
++---------------------------------+---------+
+1 row in set. Query took 0.011 seconds.
+
+❯ set datafusion.execution.batch_size to 1024;
+0 rows in set. Query took 0.000 seconds.
+
+❯ show datafusion.execution.batch_size;
++---------------------------------+---------+
+| name                            | setting |
++---------------------------------+---------+
+| datafusion.execution.batch_size | 1024    |
++---------------------------------+---------+
+1 row in set. Query took 0.005 seconds.
+```