You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/12/10 00:22:24 UTC

[6/6] drill-site git commit: updates for SET RESET commands

updates for SET RESET commands


Project: http://git-wip-us.apache.org/repos/asf/drill-site/repo
Commit: http://git-wip-us.apache.org/repos/asf/drill-site/commit/e6f79da8
Tree: http://git-wip-us.apache.org/repos/asf/drill-site/tree/e6f79da8
Diff: http://git-wip-us.apache.org/repos/asf/drill-site/diff/e6f79da8

Branch: refs/heads/asf-site
Commit: e6f79da83640dd4f70163d785c39b27c0bee3f92
Parents: 0038c6c
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Wed Dec 9 15:21:55 2015 -0800
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Wed Dec 9 15:21:55 2015 -0800

----------------------------------------------------------------------
 data/index.html                                 |   12 +-
 docs/about-sql-function-examples/index.html     |    4 +-
 docs/about-the-mapr-sandbox/index.html          |    4 +-
 .../adding-custom-functions-to-drill/index.html |    4 +-
 .../index.html                                  |    4 +-
 docs/aggregate-window-functions/index.html      |    4 +-
 docs/alter-system/index.html                    |   67 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/analyzing-social-media/index.html          |    4 +-
 .../index.html                                  |    4 +-
 docs/aol-search/index.html                      |    4 +-
 .../apache-drill-0-4-0-release-notes/index.html |    4 +-
 .../apache-drill-0-5-0-release-notes/index.html |    4 +-
 .../apache-drill-0-6-0-release-notes/index.html |    4 +-
 .../apache-drill-0-7-0-release-notes/index.html |    4 +-
 .../apache-drill-0-8-0-release-notes/index.html |    4 +-
 .../apache-drill-0-9-0-release-notes/index.html |    4 +-
 .../apache-drill-1-0-0-release-notes/index.html |    4 +-
 .../apache-drill-1-1-0-release-notes/index.html |    4 +-
 .../apache-drill-1-2-0-release-notes/index.html |    4 +-
 .../apache-drill-1-3-0-release-notes/index.html |    4 +-
 .../index.html                                  |    4 +-
 docs/apache-drill-contribution-ideas/index.html |    4 +-
 .../index.html                                  |    4 +-
 docs/architecture-introduction/index.html       |    4 +-
 docs/architecture/index.html                    |    4 +-
 .../browsing-data-and-defining-views/index.html |    4 +-
 docs/case/index.html                            |    4 +-
 docs/choosing-a-storage-format/index.html       |    4 +-
 docs/compiling-drill-from-source/index.html     |    4 +-
 .../index.html                                  |    4 +-
 docs/configuration-options/index.html           |    4 +-
 docs/configure-drill-introduction/index.html    |    4 +-
 docs/configure-drill/index.html                 |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/configuring-drill-memory/index.html        |    4 +-
 docs/configuring-jreport-with-drill/index.html  |    4 +-
 .../index.html                                  |    4 +-
 docs/configuring-odbc-on-linux/index.html       |    4 +-
 docs/configuring-odbc-on-mac-os-x/index.html    |    4 +-
 docs/configuring-odbc-on-windows/index.html     |    4 +-
 docs/configuring-odbc/index.html                |    4 +-
 .../index.html                                  |    4 +-
 docs/configuring-the-drill-shell/index.html     |    4 +-
 .../index.html                                  |    4 +-
 docs/configuring-user-authentication/index.html |    4 +-
 .../index.html                                  |    4 +-
 docs/configuring-user-impersonation/index.html  |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/connect-a-data-source/index.html           |    4 +-
 .../index.html                                  |    4 +-
 docs/contribute-to-drill/index.html             |    4 +-
 .../index.html                                  |    4 +-
 docs/core-modules/index.html                    |    4 +-
 docs/create-table-as-ctas/index.html            |    4 +-
 docs/create-view/index.html                     |    4 +-
 docs/custom-function-interfaces/index.html      |    4 +-
 .../index.html                                  |    4 +-
 docs/data-sources-and-file-formats/index.html   |    4 +-
 docs/data-type-conversion/index.html            |    4 +-
 docs/data-types/index.html                      |    4 +-
 docs/date-time-and-timestamp/index.html         |    4 +-
 .../index.html                                  |    4 +-
 docs/deploying-and-using-a-hive-udf/index.html  |    4 +-
 docs/describe/index.html                        |    4 +-
 docs/design-docs/index.html                     |    4 +-
 .../index.html                                  |    4 +-
 docs/develop-custom-functions/index.html        |    4 +-
 docs/develop-drill/index.html                   |    4 +-
 docs/developer-information/index.html           |    4 +-
 docs/developing-a-simple-function/index.html    |    4 +-
 .../developing-an-aggregate-function/index.html |    4 +-
 docs/distributed-mode-prerequisites/index.html  |    4 +-
 docs/drill-default-input-format/index.html      |    4 +-
 docs/drill-explorer-introduction/index.html     |    4 +-
 docs/drill-in-10-minutes/index.html             |    4 +-
 docs/drill-introduction/index.html              |    4 +-
 docs/drill-patch-review-tool/index.html         |    4 +-
 docs/drill-plan-syntax/index.html               |    4 +-
 docs/drill-query-execution/index.html           |    4 +-
 docs/drop-table/index.html                      |    4 +-
 docs/drop-view/index.html                       |    4 +-
 docs/embedded-mode-prerequisites/index.html     |    4 +-
 docs/enabling-query-queuing/index.html          |    4 +-
 docs/enron-emails/index.html                    |    4 +-
 docs/error-messages/index.html                  |    4 +-
 docs/explain/index.html                         |    4 +-
 docs/file-system-storage-plugin/index.html      |    4 +-
 docs/flatten/index.html                         |    4 +-
 docs/from-clause/index.html                     |    4 +-
 docs/functions-for-handling-nulls/index.html    |    4 +-
 docs/getting-started/index.html                 |    4 +-
 .../index.html                                  |    4 +-
 docs/group-by-clause/index.html                 |    4 +-
 .../index.html                                  |    4 +-
 docs/handling-different-data-types/index.html   |    4 +-
 docs/having-clause/index.html                   |    4 +-
 docs/hbase-storage-plugin/index.html            |    4 +-
 docs/hive-storage-plugin/index.html             |    4 +-
 docs/hive-to-drill-data-type-mapping/index.html |    4 +-
 docs/identifying-performance-issues/index.html  |    4 +-
 docs/index.html                                 |    4 +-
 docs/install-drill-introduction/index.html      |    4 +-
 docs/install-drill/index.html                   |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/installing-drill-on-the-cluster/index.html |    4 +-
 docs/installing-drill-on-windows/index.html     |    4 +-
 .../index.html                                  |    4 +-
 docs/installing-the-driver-on-linux/index.html  |    4 +-
 .../index.html                                  |    4 +-
 .../installing-the-driver-on-windows/index.html |    4 +-
 docs/installing-the-odbc-driver/index.html      |    4 +-
 .../index.html                                  |    4 +-
 docs/interfaces-introduction/index.html         |    4 +-
 docs/join-planning-guidelines/index.html        |    4 +-
 docs/json-data-model/index.html                 |    4 +-
 docs/kvgen/index.html                           |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/lexical-structure/index.html               |    4 +-
 docs/limit-clause/index.html                    |    4 +-
 docs/log-and-debug-introduction/index.html      |    4 +-
 docs/log-and-debug/index.html                   |    4 +-
 docs/mapr-db-format/index.html                  |    4 +-
 docs/math-and-trig/index.html                   |    4 +-
 docs/modify-logback-xml/index.html              |    4 +-
 .../modifying-query-planning-options/index.html |    4 +-
 docs/mongodb-storage-plugin/index.html          |    4 +-
 .../index.html                                  |    4 +-
 docs/nested-data-functions/index.html           |    4 +-
 docs/nested-data-limitations/index.html         |    4 +-
 docs/odbc-configuration-reference/index.html    |    4 +-
 docs/odbc-jdbc-interfaces/index.html            |    4 +-
 docs/offset-clause/index.html                   |    4 +-
 docs/operators/index.html                       |    4 +-
 .../index.html                                  |    4 +-
 docs/order-by-clause/index.html                 |    4 +-
 docs/parquet-format/index.html                  |    4 +-
 docs/partition-by-clause/index.html             |    4 +-
 docs/partition-pruning/index.html               |    4 +-
 docs/performance-tuning-introduction/index.html |    4 +-
 docs/performance-tuning-reference/index.html    |    4 +-
 docs/performance-tuning/index.html              |    4 +-
 docs/performance/index.html                     |    4 +-
 .../persistent-configuration-storage/index.html |    4 +-
 docs/physical-operators/index.html              |    4 +-
 docs/planning-and-execution-options/index.html  |    6 +-
 docs/plugin-configuration-basics/index.html     |    4 +-
 docs/ports-used-by-drill/index.html             |    4 +-
 docs/project-bylaws/index.html                  |    4 +-
 docs/query-audit-logging/index.html             |    4 +-
 docs/query-data-introduction/index.html         |    4 +-
 docs/query-data/index.html                      |    4 +-
 docs/query-directory-functions/index.html       |    4 +-
 .../index.html                                  |    4 +-
 docs/query-plans-and-tuning/index.html          |    4 +-
 docs/query-plans/index.html                     |    4 +-
 .../index.html                                  |    4 +-
 docs/query-profiles/index.html                  |    4 +-
 docs/query-stages/index.html                    |    4 +-
 .../index.html                                  |    4 +-
 docs/querying-a-file-system/index.html          |    4 +-
 .../index.html                                  |    4 +-
 docs/querying-complex-data/index.html           |    4 +-
 docs/querying-directories/index.html            |    4 +-
 docs/querying-hbase/index.html                  |    4 +-
 docs/querying-hive/index.html                   |    4 +-
 docs/querying-json-files/index.html             |    4 +-
 docs/querying-parquet-files/index.html          |    4 +-
 docs/querying-plain-text-files/index.html       |    4 +-
 docs/querying-sequence-files/index.html         |    4 +-
 docs/querying-system-tables/index.html          |    4 +-
 docs/querying-the-information-schema/index.html |    4 +-
 docs/ranking-window-functions/index.html        |    4 +-
 docs/rdbms-storage-plugin/index.html            |    4 +-
 docs/release-notes/index.html                   |    4 +-
 docs/repeated-contains/index.html               |    4 +-
 docs/repeated-count/index.html                  |    4 +-
 docs/reserved-keywords/index.html               |    4 +-
 docs/reset/index.html                           | 1128 +++++++++++++++++
 docs/rest-api/index.html                        |    4 +-
 docs/review-the-java-stack-trace/index.html     |    4 +-
 docs/rpc-overview/index.html                    |    4 +-
 docs/s3-storage-plugin/index.html               |    4 +-
 docs/sample-data-donuts/index.html              |    4 +-
 docs/sample-datasets/index.html                 |    4 +-
 docs/select-list/index.html                     |    4 +-
 docs/select/index.html                          |    4 +-
 docs/selecting-flat-data/index.html             |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/sequence-files/index.html                  |    4 +-
 docs/set/index.html                             | 1131 ++++++++++++++++++
 docs/show-databases-and-show-schemas/index.html |    4 +-
 docs/show-files/index.html                      |    4 +-
 docs/show-tables/index.html                     |    4 +-
 .../index.html                                  |    4 +-
 docs/sql-commands/index.html                    |    9 +-
 docs/sql-conditional-expressions/index.html     |    4 +-
 docs/sql-extensions/index.html                  |    4 +-
 docs/sql-functions/index.html                   |    4 +-
 docs/sql-reference-introduction/index.html      |    4 +-
 docs/sql-reference/index.html                   |    8 +-
 docs/sql-window-functions-examples/index.html   |    4 +-
 .../index.html                                  |    4 +-
 docs/sql-window-functions/index.html            |    4 +-
 docs/start-up-options/index.html                |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/starting-drill-on-windows/index.html       |    4 +-
 docs/starting-the-web-console/index.html        |    4 +-
 docs/storage-plugin-configuration/index.html    |    4 +-
 docs/storage-plugin-registration/index.html     |    4 +-
 docs/string-manipulation/index.html             |    4 +-
 docs/summary/index.html                         |    4 +-
 docs/supported-data-types/index.html            |    4 +-
 docs/supported-sql-commands/index.html          |   40 +-
 docs/tableau-examples/index.html                |    4 +-
 docs/testing-the-odbc-connection/index.html     |    4 +-
 docs/text-files-csv-tsv-psv/index.html          |    4 +-
 docs/troubleshooting/index.html                 |    4 +-
 .../index.html                                  |    4 +-
 docs/tutorials-introduction/index.html          |    4 +-
 docs/tutorials/index.html                       |    4 +-
 docs/union-set-operator/index.html              |    4 +-
 docs/use/index.html                             |    4 +-
 docs/useful-research/index.html                 |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/using-drill-explorer/index.html            |    4 +-
 .../index.html                                  |    4 +-
 docs/using-drill-with-bi-tools/index.html       |    4 +-
 .../index.html                                  |    4 +-
 .../index.html                                  |    4 +-
 docs/using-qlik-sense-with-drill/index.html     |    4 +-
 .../index.html                                  |    4 +-
 docs/using-the-jdbc-driver/index.html           |    4 +-
 .../index.html                                  |    4 +-
 docs/value-vectors/index.html                   |    4 +-
 docs/value-window-functions/index.html          |    4 +-
 docs/where-clause/index.html                    |    4 +-
 docs/why-drill/index.html                       |    4 +-
 docs/wikipedia-edit-history/index.html          |    4 +-
 docs/with-clause/index.html                     |    4 +-
 docs/workspaces/index.html                      |    4 +-
 feed.xml                                        |    4 +-
 team/index.html                                 |   40 +-
 255 files changed, 3102 insertions(+), 323 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/data/index.html
----------------------------------------------------------------------
diff --git a/data/index.html b/data/index.html
index 40f4c43..97bb9b5 100644
--- a/data/index.html
+++ b/data/index.html
@@ -1200,10 +1200,16 @@
     "relative_path": "_docs/sql-reference/sql-commands/005-supported-sql-commands.md"
 },
 {
-    "url": "/docs/alter-session/",
-    "title": "ALTER SESSION",
+    "url": "/docs/set/",
+    "title": "SET",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/010-alter-session.md"
+    "relative_path": "_docs/sql-reference/sql-commands/010-set.md"
+},
+{
+    "url": "/docs/reset/",
+    "title": "RESET",
+    "parent": "SQL Commands",
+    "relative_path": "_docs/sql-reference/sql-commands/012-reset.md"
 },
 {
     "url": "/docs/alter-system/",

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/about-sql-function-examples/index.html
----------------------------------------------------------------------
diff --git a/docs/about-sql-function-examples/index.html b/docs/about-sql-function-examples/index.html
index b186eb3..423265b 100644
--- a/docs/about-sql-function-examples/index.html
+++ b/docs/about-sql-function-examples/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/about-the-mapr-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/about-the-mapr-sandbox/index.html b/docs/about-the-mapr-sandbox/index.html
index f4abaab..a473605 100644
--- a/docs/about-the-mapr-sandbox/index.html
+++ b/docs/about-the-mapr-sandbox/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/adding-custom-functions-to-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/adding-custom-functions-to-drill/index.html b/docs/adding-custom-functions-to-drill/index.html
index a446752..c541abb 100644
--- a/docs/adding-custom-functions-to-drill/index.html
+++ b/docs/adding-custom-functions-to-drill/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/aggregate-and-aggregate-statistical/index.html
----------------------------------------------------------------------
diff --git a/docs/aggregate-and-aggregate-statistical/index.html b/docs/aggregate-and-aggregate-statistical/index.html
index b6bfc58..a1c3bc5 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/aggregate-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/aggregate-window-functions/index.html b/docs/aggregate-window-functions/index.html
index 1e3c5bf..41bfc32 100644
--- a/docs/aggregate-window-functions/index.html
+++ b/docs/aggregate-window-functions/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/alter-system/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-system/index.html b/docs/alter-system/index.html
index 4cb55dc..fad0a5b 100644
--- a/docs/alter-system/index.html
+++ b/docs/alter-system/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3 current"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               
@@ -1038,7 +1040,9 @@ settings.</p>
 <h2 id="syntax">Syntax</h2>
 
 <p>The ALTER SYSTEM command supports the following syntax:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `option_name` =  value;
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `option_name` = value;  
+ALTER SYSTEM RESET `option_name`;
+ALTER SYSTEM RESET ALL;
 </code></pre></div>
 <h2 id="parameters">Parameters</h2>
 
@@ -1053,42 +1057,27 @@ or float. Use the appropriate value type for each option that you set.</p>
 
 <h2 id="usage-notes">Usage Notes</h2>
 
-<p>Use the ALTER SYSTEM command to permanently set Drill query planning and
+<p>Use the ALTER SYSTEM SET command to permanently set Drill query planning and
 execution options per cluster. Options set at the system level affect the
 entire system and persist between restarts.</p>
 
+<p>Using ALTER SYSTEM RESET changes the value of an option back to the default system setting. </p>
+
+<p>Using ALTER SYSTEM RESET ALL changes the value of every option back to the default system setting.  </p>
+
 <p>You can run the following query to see a complete list of planning and
-execution options that you can set at the system level:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select name, type, num_val, string_val, bool_val, float_val from sys.options where type like &#39;SYSTEM&#39; order by name;
-+------------+------------+------------+------------+------------+------------+
-|    name    |    type    |  num_val   | string_val |  bool_val  | float_val  |
-+------------+------------+------------+------------+------------+------------+
-| drill.exec.functions.cast_empty_string_to_null | SYSTEM     | null       | null       | false      | null       |
-| drill.exec.storage.file.partition.column.label | SYSTEM     | null       | dir        | null       | null       |
-| exec.errors.verbose | SYSTEM     | null       | null       | false      | null       |
-| exec.java_compiler | SYSTEM     | null       | DEFAULT    | null       | null       |
-| exec.java_compiler_debug | SYSTEM     | null       | null       | true       | null       |
-| exec.java_compiler_janino_maxsize | SYSTEM     | 262144     | null       | null       | null       |
-| exec.queue.timeout_millis | SYSTEM     | 400000     | null       | null       | null       |
-| planner.add_producer_consumer | SYSTEM     | null       | null       | true       | null       |
-| planner.affinity_factor | SYSTEM     | null       | null       | null       | 1.2        |
-| planner.broadcast_threshold | SYSTEM     | 1000000    | null       | null       | null       |
-| planner.disable_exchanges | SYSTEM     | null       | null       | false      | null       |
-| planner.enable_broadcast_join | SYSTEM     | null       | null       | true       | null       |
-| planner.enable_hash_single_key | SYSTEM     | null       | null       | true       | null       |
-| planner.enable_hashagg | SYSTEM     | null       | null       | true       | null       |
-| planner.enable_hashjoin | SYSTEM     | null       | null       | true       | null       |
-| planner.slice_target | SYSTEM     | 100000     | null       | null       | null       |
-| planner.width.max_per_node | SYSTEM     | 2          | null       | null       | null       |
-| planner.width.max_per_query | SYSTEM     | 1000       | null       | null       | null       |
-| store.format | SYSTEM     | null       | parquet    | null       | null       |
-| store.json.all_text_mode | SYSTEM     | null       | null       | false      | null       |
-| store.mongo.all_text_mode | SYSTEM     | null       | null       | false      | null       |
-| store.parquet.block-size | SYSTEM     | 536870912  | null       | null       | null       |
-| store.parquet.use_new_reader | SYSTEM     | null       | null       | false      | null       |
-| store.parquet.vector_fill_check_threshold | SYSTEM     | 10         | null       | null       | null       |
-| store.parquet.vector_fill_threshold | SYSTEM     | 85         | null       | null       | null       |
-+------------+------------+------------+------------+------------+------------+
+execution options that are currently set at the system or session level:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; SELECT name, type FROM sys.options WHERE type in (&#39;SYSTEM&#39;,&#39;SESSION&#39;) order by name;
++------------+------------------------------------------------+
+|   name                                         |    type    |
++----------------------------------------------+--------------+
+| drill.exec.functions.cast_empty_string_to_null | SYSTEM     |
+| drill.exec.storage.file.partition.column.label | SYSTEM     |
+| exec.errors.verbose                            | SYSTEM     |
+| exec.java_compiler                             | SYSTEM     |
+| exec.java_compiler_debug                       | SYSTEM     |
+…
++------------+------------------------------------------------+
 </code></pre></div>
 <div class="admonition note">
   <p class="first admonition-title">Note</p>
@@ -1124,13 +1113,19 @@ Note that the option type is case-sensitive.</p>
 | planner.enable_streamagg | SYSTEM     | true      |
 | planner.enable_hashjoin | SYSTEM  | true      |
 +------------+------------+------------+
-9 rows selected (0.159 seconds)
+9 rows selected (0.159 seconds)  
+</code></pre></div>
+<p>Issuing the ALTER SYSTEM RESET command resets the option back to the default system value (false):  </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; ALTER SYSTEM RESET `planner.add_producer_consumer`;  
+</code></pre></div>
+<p>Issuing the ALTER SYSTEM RESET ALL command resets all options back to their default system values:  </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; ALTER SYSTEM RESET ALL;
 </code></pre></div>
     
       
         <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/alter-session/">← ALTER SESSION</a></span><span class="next-toc"><a href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS) →</a></span>
+  <span class="previous-toc"><a href="/docs/reset/">← RESET</a></span><span class="next-toc"><a href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS) →</a></span>
 </div>
 
     

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/analyzing-data-using-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-data-using-window-functions/index.html b/docs/analyzing-data-using-window-functions/index.html
index af0bf3b..404282a 100644
--- a/docs/analyzing-data-using-window-functions/index.html
+++ b/docs/analyzing-data-using-window-functions/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/analyzing-highly-dynamic-datasets/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-highly-dynamic-datasets/index.html b/docs/analyzing-highly-dynamic-datasets/index.html
index 50e2831..de30789 100644
--- a/docs/analyzing-highly-dynamic-datasets/index.html
+++ b/docs/analyzing-highly-dynamic-datasets/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/analyzing-social-media/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-social-media/index.html b/docs/analyzing-social-media/index.html
index 3bcfa23..bb48b03 100644
--- a/docs/analyzing-social-media/index.html
+++ b/docs/analyzing-social-media/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/analyzing-the-yelp-academic-dataset/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-the-yelp-academic-dataset/index.html b/docs/analyzing-the-yelp-academic-dataset/index.html
index 0a0a58c..1067bf3 100644
--- a/docs/analyzing-the-yelp-academic-dataset/index.html
+++ b/docs/analyzing-the-yelp-academic-dataset/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/aol-search/index.html
----------------------------------------------------------------------
diff --git a/docs/aol-search/index.html b/docs/aol-search/index.html
index 0e6b000..2c2d5c2 100644
--- a/docs/aol-search/index.html
+++ b/docs/aol-search/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-0-4-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-4-0-release-notes/index.html b/docs/apache-drill-0-4-0-release-notes/index.html
index e727fb9..050e26b 100644
--- a/docs/apache-drill-0-4-0-release-notes/index.html
+++ b/docs/apache-drill-0-4-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-0-5-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-5-0-release-notes/index.html b/docs/apache-drill-0-5-0-release-notes/index.html
index 8522e25..699f4cb 100644
--- a/docs/apache-drill-0-5-0-release-notes/index.html
+++ b/docs/apache-drill-0-5-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-0-6-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-6-0-release-notes/index.html b/docs/apache-drill-0-6-0-release-notes/index.html
index 38a6a2d..1fb041c 100644
--- a/docs/apache-drill-0-6-0-release-notes/index.html
+++ b/docs/apache-drill-0-6-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-0-7-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-7-0-release-notes/index.html b/docs/apache-drill-0-7-0-release-notes/index.html
index 689282d..e3ebf7d 100644
--- a/docs/apache-drill-0-7-0-release-notes/index.html
+++ b/docs/apache-drill-0-7-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-0-8-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-8-0-release-notes/index.html b/docs/apache-drill-0-8-0-release-notes/index.html
index 7982c30..7dad0a5 100644
--- a/docs/apache-drill-0-8-0-release-notes/index.html
+++ b/docs/apache-drill-0-8-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-0-9-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-9-0-release-notes/index.html b/docs/apache-drill-0-9-0-release-notes/index.html
index 0781530..5f5507d 100644
--- a/docs/apache-drill-0-9-0-release-notes/index.html
+++ b/docs/apache-drill-0-9-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-1-0-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-1-0-0-release-notes/index.html b/docs/apache-drill-1-0-0-release-notes/index.html
index 5f8d387..40d0eba 100644
--- a/docs/apache-drill-1-0-0-release-notes/index.html
+++ b/docs/apache-drill-1-0-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-1-1-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-1-1-0-release-notes/index.html b/docs/apache-drill-1-1-0-release-notes/index.html
index 4420586..0ef3745 100644
--- a/docs/apache-drill-1-1-0-release-notes/index.html
+++ b/docs/apache-drill-1-1-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-1-2-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-1-2-0-release-notes/index.html b/docs/apache-drill-1-2-0-release-notes/index.html
index 5f5cbd7..fafd84d 100644
--- a/docs/apache-drill-1-2-0-release-notes/index.html
+++ b/docs/apache-drill-1-2-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-1-3-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-1-3-0-release-notes/index.html b/docs/apache-drill-1-3-0-release-notes/index.html
index 4733ce3..a1c9d49 100644
--- a/docs/apache-drill-1-3-0-release-notes/index.html
+++ b/docs/apache-drill-1-3-0-release-notes/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-contribution-guidelines/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-contribution-guidelines/index.html b/docs/apache-drill-contribution-guidelines/index.html
index d65f73e..c4ae837 100644
--- a/docs/apache-drill-contribution-guidelines/index.html
+++ b/docs/apache-drill-contribution-guidelines/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-contribution-ideas/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-contribution-ideas/index.html b/docs/apache-drill-contribution-ideas/index.html
index b86a59c..ab36dc4 100644
--- a/docs/apache-drill-contribution-ideas/index.html
+++ b/docs/apache-drill-contribution-ideas/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html b/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html
index 7ef4632..3a92d75 100644
--- a/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html
+++ b/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/architecture-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/architecture-introduction/index.html b/docs/architecture-introduction/index.html
index eae6686..0ef9523 100644
--- a/docs/architecture-introduction/index.html
+++ b/docs/architecture-introduction/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/architecture/index.html
----------------------------------------------------------------------
diff --git a/docs/architecture/index.html b/docs/architecture/index.html
index c6244ed..bcddf15 100644
--- a/docs/architecture/index.html
+++ b/docs/architecture/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/browsing-data-and-defining-views/index.html
----------------------------------------------------------------------
diff --git a/docs/browsing-data-and-defining-views/index.html b/docs/browsing-data-and-defining-views/index.html
index 0a4f64f..1246564 100644
--- a/docs/browsing-data-and-defining-views/index.html
+++ b/docs/browsing-data-and-defining-views/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/case/index.html
----------------------------------------------------------------------
diff --git a/docs/case/index.html b/docs/case/index.html
index a170f5f..814b4c4 100644
--- a/docs/case/index.html
+++ b/docs/case/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/choosing-a-storage-format/index.html
----------------------------------------------------------------------
diff --git a/docs/choosing-a-storage-format/index.html b/docs/choosing-a-storage-format/index.html
index 69c168d..77185ae 100644
--- a/docs/choosing-a-storage-format/index.html
+++ b/docs/choosing-a-storage-format/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/compiling-drill-from-source/index.html
----------------------------------------------------------------------
diff --git a/docs/compiling-drill-from-source/index.html b/docs/compiling-drill-from-source/index.html
index 85103dc..a38addd 100644
--- a/docs/compiling-drill-from-source/index.html
+++ b/docs/compiling-drill-from-source/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuration-options-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/configuration-options-introduction/index.html b/docs/configuration-options-introduction/index.html
index 7832b1d..2d0f7b5 100644
--- a/docs/configuration-options-introduction/index.html
+++ b/docs/configuration-options-introduction/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuration-options/index.html
----------------------------------------------------------------------
diff --git a/docs/configuration-options/index.html b/docs/configuration-options/index.html
index efd4b45..5b13dc8 100644
--- a/docs/configuration-options/index.html
+++ b/docs/configuration-options/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configure-drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/configure-drill-introduction/index.html b/docs/configure-drill-introduction/index.html
index 7ce3e10..bc2b7d7 100644
--- a/docs/configure-drill-introduction/index.html
+++ b/docs/configure-drill-introduction/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configure-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/configure-drill/index.html b/docs/configure-drill/index.html
index 16fc1ec..c7963ac 100644
--- a/docs/configure-drill/index.html
+++ b/docs/configure-drill/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-a-multitenant-cluster-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-a-multitenant-cluster-introduction/index.html b/docs/configuring-a-multitenant-cluster-introduction/index.html
index 4830d65..da8db60 100644
--- a/docs/configuring-a-multitenant-cluster-introduction/index.html
+++ b/docs/configuring-a-multitenant-cluster-introduction/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-a-multitenant-cluster/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-a-multitenant-cluster/index.html b/docs/configuring-a-multitenant-cluster/index.html
index 7daf1f2..9325330 100644
--- a/docs/configuring-a-multitenant-cluster/index.html
+++ b/docs/configuring-a-multitenant-cluster/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-drill-memory/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-drill-memory/index.html b/docs/configuring-drill-memory/index.html
index 3321b81..17c65a3 100644
--- a/docs/configuring-drill-memory/index.html
+++ b/docs/configuring-drill-memory/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-jreport-with-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-jreport-with-drill/index.html b/docs/configuring-jreport-with-drill/index.html
index 31df97d..aa268e0 100644
--- a/docs/configuring-jreport-with-drill/index.html
+++ b/docs/configuring-jreport-with-drill/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-multitenant-resources/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-multitenant-resources/index.html b/docs/configuring-multitenant-resources/index.html
index a0e94e2..fa75b0b 100644
--- a/docs/configuring-multitenant-resources/index.html
+++ b/docs/configuring-multitenant-resources/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-odbc-on-linux/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-linux/index.html b/docs/configuring-odbc-on-linux/index.html
index b996f5c..bcf5373 100644
--- a/docs/configuring-odbc-on-linux/index.html
+++ b/docs/configuring-odbc-on-linux/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-odbc-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-mac-os-x/index.html b/docs/configuring-odbc-on-mac-os-x/index.html
index 9c44334..af7c354 100644
--- a/docs/configuring-odbc-on-mac-os-x/index.html
+++ b/docs/configuring-odbc-on-mac-os-x/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-odbc-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc-on-windows/index.html b/docs/configuring-odbc-on-windows/index.html
index e2ab9ae..ac67c5e 100644
--- a/docs/configuring-odbc-on-windows/index.html
+++ b/docs/configuring-odbc-on-windows/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-odbc/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc/index.html b/docs/configuring-odbc/index.html
index 1aa8b09..43337fc 100644
--- a/docs/configuring-odbc/index.html
+++ b/docs/configuring-odbc/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-resources-for-a-shared-drillbit/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-resources-for-a-shared-drillbit/index.html b/docs/configuring-resources-for-a-shared-drillbit/index.html
index 7c8b30e..489fa2f 100644
--- a/docs/configuring-resources-for-a-shared-drillbit/index.html
+++ b/docs/configuring-resources-for-a-shared-drillbit/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-the-drill-shell/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-the-drill-shell/index.html b/docs/configuring-the-drill-shell/index.html
index 44bd864..6917167 100644
--- a/docs/configuring-the-drill-shell/index.html
+++ b/docs/configuring-the-drill-shell/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-tibco-spotfire-server-with-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-tibco-spotfire-server-with-drill/index.html b/docs/configuring-tibco-spotfire-server-with-drill/index.html
index af63e89..05e06a1 100644
--- a/docs/configuring-tibco-spotfire-server-with-drill/index.html
+++ b/docs/configuring-tibco-spotfire-server-with-drill/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-user-authentication/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-user-authentication/index.html b/docs/configuring-user-authentication/index.html
index 37329eb..6352e7b 100644
--- a/docs/configuring-user-authentication/index.html
+++ b/docs/configuring-user-authentication/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-user-impersonation-with-hive-authorization/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-user-impersonation-with-hive-authorization/index.html b/docs/configuring-user-impersonation-with-hive-authorization/index.html
index 67a7294..0cdad6e 100644
--- a/docs/configuring-user-impersonation-with-hive-authorization/index.html
+++ b/docs/configuring-user-impersonation-with-hive-authorization/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-user-impersonation/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-user-impersonation/index.html b/docs/configuring-user-impersonation/index.html
index c8faa93..8adcfaa 100644
--- a/docs/configuring-user-impersonation/index.html
+++ b/docs/configuring-user-impersonation/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/configuring-web-console-and-rest-api-security/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-web-console-and-rest-api-security/index.html b/docs/configuring-web-console-and-rest-api-security/index.html
index e9590b3..61b1291 100644
--- a/docs/configuring-web-console-and-rest-api-security/index.html
+++ b/docs/configuring-web-console-and-rest-api-security/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/connect-a-data-source-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/connect-a-data-source-introduction/index.html b/docs/connect-a-data-source-introduction/index.html
index 7ef61d3..683905e 100644
--- a/docs/connect-a-data-source-introduction/index.html
+++ b/docs/connect-a-data-source-introduction/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/connect-a-data-source/index.html
----------------------------------------------------------------------
diff --git a/docs/connect-a-data-source/index.html b/docs/connect-a-data-source/index.html
index f84b94d..1cf8a71 100644
--- a/docs/connect-a-data-source/index.html
+++ b/docs/connect-a-data-source/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/connecting-drill-explorer-to-data/index.html
----------------------------------------------------------------------
diff --git a/docs/connecting-drill-explorer-to-data/index.html b/docs/connecting-drill-explorer-to-data/index.html
index aa7ad7a..5e0cee3 100644
--- a/docs/connecting-drill-explorer-to-data/index.html
+++ b/docs/connecting-drill-explorer-to-data/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/contribute-to-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/contribute-to-drill/index.html b/docs/contribute-to-drill/index.html
index ef9ddb9..5f0c980 100644
--- a/docs/contribute-to-drill/index.html
+++ b/docs/contribute-to-drill/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/index.html
----------------------------------------------------------------------
diff --git a/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/index.html b/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/index.html
index b3ae147..8c87f75 100644
--- a/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/index.html
+++ b/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/core-modules/index.html
----------------------------------------------------------------------
diff --git a/docs/core-modules/index.html b/docs/core-modules/index.html
index 9497124..4971889 100644
--- a/docs/core-modules/index.html
+++ b/docs/core-modules/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/create-table-as-ctas/index.html
----------------------------------------------------------------------
diff --git a/docs/create-table-as-ctas/index.html b/docs/create-table-as-ctas/index.html
index 9a73c95..2d9d01c 100644
--- a/docs/create-table-as-ctas/index.html
+++ b/docs/create-table-as-ctas/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/create-view/index.html
----------------------------------------------------------------------
diff --git a/docs/create-view/index.html b/docs/create-view/index.html
index ad9eada..a98c870 100644
--- a/docs/create-view/index.html
+++ b/docs/create-view/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/custom-function-interfaces/index.html
----------------------------------------------------------------------
diff --git a/docs/custom-function-interfaces/index.html b/docs/custom-function-interfaces/index.html
index 1df46ee..57006cd 100644
--- a/docs/custom-function-interfaces/index.html
+++ b/docs/custom-function-interfaces/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6f79da8/docs/data-sources-and-file-formats-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/data-sources-and-file-formats-introduction/index.html b/docs/data-sources-and-file-formats-introduction/index.html
index 3d244cb..108cc62 100644
--- a/docs/data-sources-and-file-formats-introduction/index.html
+++ b/docs/data-sources-and-file-formats-introduction/index.html
@@ -724,7 +724,9 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>