yaooqinn commented on a change in pull request #29202:
URL: https://github.com/apache/spark/pull/29202#discussion_r459871040
##########
File path: docs/sql-ref-syntax-aux-conf-mgmt-reset.md
##########
@@ -21,19 +21,34 @@ license: |
### Description
-Reset any runtime configurations specific to the current session which were
set via the [SET](sql-ref-syntax-aux-conf-mgmt-set.html) command to their
default values.
+The RESET command resets runtime configurations specific to the current
session which were set via the [SET](sql-ref-syntax-aux-conf-mgmt-set.html)
command to their default values.
### Syntax
```sql
-RESET
+RESET;
+
+RESET configuration_key;
```
+### Parameters
+
+* **(none)**
+
+ Reset any runtime configurations specific to the current session which
were set via the [SET](sql-ref-syntax-aux-conf-mgmt-set.html) command to their
default values.
+
+* **configuration_key**
+
+ Restore the value of the `configuration_key` to the default value. If the
default value is undefined, the `configuration_key` will be removed.
+
### Examples
```sql
-- Reset any runtime configurations specific to the current session which were
set via the SET command to their default values.
RESET;
+
+-- If you start your application with --conf spark.foo=bar and set
spark.foo=foobar in runtime, the example below will restore it to 'bar'. If
spark.foo is not specified during starting, the example bellow will remove this
config from the SQLConf if you set it in runtime. It will do nothing for the
nonexistent keys.
Review comment:
thanks for the suggestions
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
