You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/06/02 06:57:31 UTC

[16/16] drill-site git commit: Website update

Website update


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

Branch: refs/heads/asf-site
Commit: ba77798a65301a329ff2c579486299973a1855f4
Parents: 3e15e65
Author: Tomer Shiran <ts...@gmail.com>
Authored: Mon Jun 1 21:57:07 2015 -0700
Committer: Tomer Shiran <ts...@gmail.com>
Committed: Mon Jun 1 21:57:07 2015 -0700

----------------------------------------------------------------------
 data/index.html                                 |   62 +-
 docs/2014-q1-drill-report/index.html            |   20 +-
 docs/about-sql-function-examples/index.html     |   20 +-
 docs/about-the-mapr-sandbox/index.html          |   20 +-
 .../adding-custom-functions-to-drill/index.html |   20 +-
 docs/advanced-properties/index.html             |   20 +-
 .../index.html                                  |   20 +-
 docs/alter-session/index.html                   |   20 +-
 docs/alter-system/index.html                    |   20 +-
 .../index.html                                  |   20 +-
 docs/analyzing-social-media/index.html          |   20 +-
 .../index.html                                  |   20 +-
 docs/aol-search/index.html                      |   20 +-
 .../apache-drill-0-4-0-release-notes/index.html |   20 +-
 .../apache-drill-0-5-0-release-notes/index.html |   20 +-
 .../apache-drill-0-6-0-release-notes/index.html |   20 +-
 .../apache-drill-0-7-0-release-notes/index.html |   20 +-
 .../apache-drill-0-8-0-release-notes/index.html |   20 +-
 .../apache-drill-0-9-0-release-notes/index.html |   20 +-
 .../apache-drill-1-0-0-release-notes/index.html |   20 +-
 .../index.html                                  |   20 +-
 docs/apache-drill-contribution-ideas/index.html |   20 +-
 .../index.html                                  |   20 +-
 docs/architecture-introduction/index.html       |   20 +-
 docs/architecture/index.html                    |   20 +-
 docs/archived-pages/index.html                  |   20 +-
 docs/case/index.html                            |   20 +-
 docs/choosing-a-storage-format/index.html       |   20 +-
 docs/compiling-drill-from-source/index.html     |   20 +-
 .../index.html                                  |   20 +-
 docs/configuration-options/index.html           |   20 +-
 docs/configure-drill-introduction/index.html    |   20 +-
 docs/configure-drill/index.html                 |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/configuring-drill-memory/index.html        |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/configuring-the-drill-shell/index.html     |   20 +-
 .../index.html                                  |   20 +-
 docs/configuring-user-authentication/index.html |   22 +-
 docs/configuring-user-impersonation/index.html  |   40 +-
 .../index.html                                  |   20 +-
 docs/connect-a-data-source/index.html           |   20 +-
 docs/connecting-to-odbc-data-sources/index.html |   20 +-
 docs/contribute-to-drill/index.html             |   20 +-
 .../index.html                                  |   20 +-
 docs/core-modules/index.html                    |   20 +-
 docs/create-table-as-ctas/index.html            |   20 +-
 docs/create-view/index.html                     |   20 +-
 docs/custom-function-interfaces/index.html      |   20 +-
 .../index.html                                  |   20 +-
 docs/data-sources-and-file-formats/index.html   |   20 +-
 docs/data-type-conversion/index.html            |   20 +-
 docs/data-types/index.html                      |   20 +-
 docs/date-time-and-timestamp/index.html         |   20 +-
 .../index.html                                  |  115 +-
 docs/deploying-and-using-a-hive-udf/index.html  |   20 +-
 docs/describe/index.html                        |   20 +-
 docs/design-docs/index.html                     |   20 +-
 docs/develop-a-simple-function/index.html       |   20 +-
 .../index.html                                  |   20 +-
 docs/develop-custom-functions/index.html        |   20 +-
 docs/develop-drill/index.html                   |   20 +-
 docs/developer-information/index.html           |   20 +-
 .../developing-an-aggregate-function/index.html |   20 +-
 docs/distributed-mode-prerequisites/index.html  |   20 +-
 docs/drill-default-input-format/index.html      |   20 +-
 docs/drill-in-10-minutes/index.html             |   20 +-
 docs/drill-introduction/index.html              |   20 +-
 docs/drill-patch-review-tool/index.html         |   20 +-
 docs/drill-plan-syntax/index.html               |   20 +-
 docs/drill-query-execution/index.html           |   20 +-
 docs/driver-configuration-options/index.html    |   20 +-
 docs/drop-view/index.html                       |   20 +-
 docs/embedded-mode-prerequisites/index.html     |   20 +-
 docs/enabling-query-queuing/index.html          |   20 +-
 docs/enron-emails/index.html                    |   20 +-
 docs/error-messages/index.html                  |   20 +-
 docs/explain/index.html                         |   20 +-
 docs/file-system-storage-plugin/index.html      |   20 +-
 docs/flatten/index.html                         |   20 +-
 docs/from-clause/index.html                     | 1074 +++++++++++++++++
 docs/functions-for-handling-nulls/index.html    |   20 +-
 docs/getting-query-information/index.html       |   20 +-
 docs/getting-started/index.html                 |   20 +-
 .../index.html                                  |   20 +-
 docs/group-by-clause/index.html                 | 1051 +++++++++++++++++
 .../index.html                                  |   20 +-
 docs/handling-different-data-types/index.html   |   20 +-
 docs/having-clause/index.html                   | 1065 +++++++++++++++++
 docs/hbase-storage-plugin/index.html            |   20 +-
 docs/hive-storage-plugin/index.html             |   20 +-
 docs/hive-to-drill-data-type-mapping/index.html |   20 +-
 docs/how-to-run-the-drill-demo/index.html       |   20 +-
 docs/identifying-performance-issues/index.html  |   20 +-
 docs/img/user_hops_four.PNG                     |  Bin 0 -> 25601 bytes
 docs/img/user_hops_joined_view.PNG              |  Bin 0 -> 33467 bytes
 docs/img/user_hops_no_join.PNG                  |  Bin 0 -> 32306 bytes
 docs/index.html                                 |   20 +-
 docs/install-drill-introduction/index.html      |   20 +-
 docs/install-drill/index.html                   |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/installing-drill-on-the-cluster/index.html |   20 +-
 docs/installing-drill-on-windows/index.html     |   20 +-
 .../index.html                                  |   20 +-
 docs/installing-the-driver-on-linux/index.html  |   20 +-
 .../index.html                                  |   20 +-
 .../installing-the-driver-on-windows/index.html |   20 +-
 docs/interfaces-introduction/index.html         |   20 +-
 docs/join-planning-guidelines/index.html        |   20 +-
 docs/json-data-model/index.html                 |   20 +-
 docs/kvgen/index.html                           |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/lexical-structure/index.html               |   20 +-
 docs/limit-clause/index.html                    | 1057 +++++++++++++++++
 docs/log-and-debug-introduction/index.html      |   20 +-
 docs/log-and-debug/index.html                   |   20 +-
 docs/mapr-db-format/index.html                  |   20 +-
 docs/math-and-trig/index.html                   |   20 +-
 docs/modify-logback-xml/index.html              |   20 +-
 .../modifying-query-planning-options/index.html |   20 +-
 docs/mongodb-plugin-for-apache-drill/index.html |   20 +-
 .../index.html                                  |   20 +-
 docs/nested-data-functions/index.html           |   20 +-
 docs/nested-data-limitations/index.html         |   20 +-
 docs/odbc-jdbc-interfaces/index.html            |   20 +-
 .../index.html                                  |   20 +-
 docs/offset-clause/index.html                   | 1036 +++++++++++++++++
 docs/operators/index.html                       |   20 +-
 docs/order-by-clause/index.html                 | 1076 +++++++++++++++++
 docs/parquet-format/index.html                  |   20 +-
 docs/partition-pruning/index.html               |   20 +-
 docs/performance-tuning-introduction/index.html |   20 +-
 docs/performance-tuning-reference/index.html    |   20 +-
 docs/performance-tuning/index.html              |   20 +-
 docs/performance/index.html                     |   20 +-
 .../persistent-configuration-storage/index.html |   20 +-
 docs/physical-operators/index.html              |   20 +-
 docs/planning-and-execution-options/index.html  |   20 +-
 docs/plugin-configuration-basics/index.html     |   20 +-
 docs/ports-used-by-drill/index.html             |   20 +-
 docs/progress-reports/index.html                |   20 +-
 docs/project-bylaws/index.html                  |   20 +-
 docs/query-audit-logging/index.html             |   20 +-
 docs/query-data-introduction/index.html         |   20 +-
 docs/query-data/index.html                      |   20 +-
 docs/query-directory-functions/index.html       |   20 +-
 .../index.html                                  |   20 +-
 docs/query-plans-and-tuning/index.html          |   20 +-
 docs/query-plans/index.html                     |   20 +-
 .../index.html                                  |   20 +-
 docs/query-profiles/index.html                  |   20 +-
 docs/query-stages/index.html                    |   20 +-
 .../index.html                                  |   20 +-
 docs/querying-a-file-system/index.html          |   20 +-
 .../index.html                                  |   20 +-
 docs/querying-complex-data/index.html           |   20 +-
 docs/querying-directories/index.html            |   20 +-
 docs/querying-hbase/index.html                  |   20 +-
 docs/querying-hive/index.html                   |   20 +-
 docs/querying-json-files/index.html             |   20 +-
 docs/querying-parquet-files/index.html          |   20 +-
 docs/querying-plain-text-files/index.html       |   20 +-
 docs/querying-system-tables/index.html          |   20 +-
 docs/querying-the-information-schema/index.html |   20 +-
 docs/release-notes/index.html                   |   20 +-
 docs/repeated-contains/index.html               |   20 +-
 docs/repeated-count/index.html                  |   20 +-
 docs/reserved-keywords/index.html               |   20 +-
 docs/review-the-java-stack-trace/index.html     |   20 +-
 docs/rpc-overview/index.html                    |   20 +-
 docs/sample-data-donuts/index.html              |   20 +-
 docs/sample-datasets/index.html                 |   20 +-
 docs/select-list/index.html                     | 1076 +++++++++++++++++
 docs/select/index.html                          |   27 +-
 docs/selecting-flat-data/index.html             |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/show-databases-and-show-schemas/index.html |   22 +-
 docs/show-files/index.html                      |   20 +-
 docs/show-tables/index.html                     |   20 +-
 .../index.html                                  |   20 +-
 docs/sql-commands/index.html                    |   41 +-
 docs/sql-conditional-expressions/index.html     |   20 +-
 docs/sql-extensions/index.html                  |   20 +-
 docs/sql-functions/index.html                   |   20 +-
 docs/sql-reference-introduction/index.html      |   20 +-
 docs/sql-reference/index.html                   |   40 +-
 docs/start-up-options/index.html                |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/starting-drill-on-windows/index.html       |   20 +-
 docs/storage-plugin-configuration/index.html    |   20 +-
 docs/storage-plugin-registration/index.html     |   20 +-
 docs/string-manipulation/index.html             |   20 +-
 docs/summary/index.html                         |   20 +-
 docs/supported-data-types/index.html            |   20 +-
 docs/supported-sql-commands/index.html          |   20 +-
 docs/tableau-examples/index.html                |   20 +-
 docs/testing-the-odbc-connection/index.html     |   20 +-
 docs/troubleshooting/index.html                 |   83 +-
 docs/tutorials-introduction/index.html          |   20 +-
 docs/tutorials/index.html                       |   20 +-
 docs/union-set-operator/index.html              | 1052 +++++++++++++++++
 docs/use/index.html                             |   20 +-
 docs/useful-research/index.html                 |   20 +-
 docs/using-a-connection-string/index.html       |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 docs/using-drill-explorer-on-windows/index.html |   20 +-
 .../index.html                                  |   20 +-
 .../index.html                                  |   20 +-
 .../using-odbc-on-linux-and-mac-os-x/index.html |   20 +-
 docs/using-odbc-on-windows/index.html           |   20 +-
 .../index.html                                  |   20 +-
 docs/using-tibco-spotfire-with-drill/index.html |   20 +-
 docs/value-vectors/index.html                   |   20 +-
 docs/what-is-apache-drill/index.html            |   20 +-
 docs/where-clause/index.html                    | 1081 +++++++++++++++++
 docs/why-drill/index.html                       |   20 +-
 docs/wikipedia-edit-history/index.html          |   20 +-
 docs/with-clause/index.html                     | 1098 ++++++++++++++++++
 docs/workspaces/index.html                      |   20 +-
 feed.xml                                        |    4 +-
 toc/index.html                                  |  102 +-
 234 files changed, 13336 insertions(+), 2088 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/data/index.html
----------------------------------------------------------------------
diff --git a/data/index.html b/data/index.html
index b3fba8b..70938eb 100644
--- a/data/index.html
+++ b/data/index.html
@@ -1161,61 +1161,67 @@
     "url": "/docs/select/",
     "title": "SELECT",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/080-select.md"
+    "relative_path": "_docs/sql-reference/sql-commands/079-select.md"
 },
 {
-    "url": "/docs/select-from/",
-    "title": "SELECT FROM",
+    "url": "/docs/select-list/",
+    "title": "SELECT List",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/081-select-from.md"
+    "relative_path": "_docs/sql-reference/sql-commands/080-select-list.md"
 },
 {
-    "url": "/docs/select-group-by/",
-    "title": "SELECT GROUP BY",
+    "url": "/docs/from-clause/",
+    "title": "FROM Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/082-select-group-by.md"
+    "relative_path": "_docs/sql-reference/sql-commands/081-from-clause.md"
 },
 {
-    "url": "/docs/select-having/",
-    "title": "SELECT HAVING",
+    "url": "/docs/group-by-clause/",
+    "title": "GROUP BY Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/083-select-having.md"
+    "relative_path": "_docs/sql-reference/sql-commands/082-group-by-clause.md"
 },
 {
-    "url": "/docs/select-limit/",
-    "title": "SELECT LIMIT",
+    "url": "/docs/having-clause/",
+    "title": "HAVING Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/084-select-limit.md"
+    "relative_path": "_docs/sql-reference/sql-commands/083-having-clause.md"
 },
 {
-    "url": "/docs/select-offset/",
-    "title": "SELECT OFFSET",
+    "url": "/docs/limit-clause/",
+    "title": "LIMIT Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/085-select-offset.md"
+    "relative_path": "_docs/sql-reference/sql-commands/084-limit-clause.md"
 },
 {
-    "url": "/docs/select-order-by/",
-    "title": "SELECT ORDER BY",
+    "url": "/docs/offset-clause/",
+    "title": "OFFSET Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/086-select-order-by.md"
+    "relative_path": "_docs/sql-reference/sql-commands/085-offset-clause.md"
 },
 {
-    "url": "/docs/select-union/",
-    "title": "SELECT UNION",
+    "url": "/docs/order-by-clause/",
+    "title": "ORDER BY Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/087-select-union.md"
+    "relative_path": "_docs/sql-reference/sql-commands/086-order-by-clause.md"
 },
 {
-    "url": "/docs/select-where/",
-    "title": "SELECT WHERE",
+    "url": "/docs/union-set-operator/",
+    "title": "UNION Set Operator",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/088-select-where.md"
+    "relative_path": "_docs/sql-reference/sql-commands/087-union-set-operator.md"
 },
 {
-    "url": "/docs/select-with/",
-    "title": "SELECT WITH",
+    "url": "/docs/where-clause/",
+    "title": "WHERE Clause",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/089-select-with.md"
+    "relative_path": "_docs/sql-reference/sql-commands/088-where-clause.md"
+},
+{
+    "url": "/docs/with-clause/",
+    "title": "WITH Clause",
+    "parent": "SQL Commands",
+    "relative_path": "_docs/sql-reference/sql-commands/089-with-clause.md"
 },
 {
     "url": "/docs/show-databases-and-show-schemas/",

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/2014-q1-drill-report/index.html
----------------------------------------------------------------------
diff --git a/docs/2014-q1-drill-report/index.html b/docs/2014-q1-drill-report/index.html
index 12c04c8..629dba5 100644
--- a/docs/2014-q1-drill-report/index.html
+++ b/docs/2014-q1-drill-report/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 f8ea1a7..b97bc0f 100644
--- a/docs/about-sql-function-examples/index.html
+++ b/docs/about-sql-function-examples/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 e51c984..87bd5b4 100644
--- a/docs/about-the-mapr-sandbox/index.html
+++ b/docs/about-the-mapr-sandbox/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 20b6283..c80cf90 100644
--- a/docs/adding-custom-functions-to-drill/index.html
+++ b/docs/adding-custom-functions-to-drill/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/advanced-properties/index.html
----------------------------------------------------------------------
diff --git a/docs/advanced-properties/index.html b/docs/advanced-properties/index.html
index 70c43d0..73746c2 100644
--- a/docs/advanced-properties/index.html
+++ b/docs/advanced-properties/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 b457f56..53e2cc5 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/alter-session/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-session/index.html b/docs/alter-session/index.html
index 1ba7892..058b613 100644
--- a/docs/alter-session/index.html
+++ b/docs/alter-session/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/alter-system/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-system/index.html b/docs/alter-system/index.html
index 672fddd..cb323d7 100644
--- a/docs/alter-system/index.html
+++ b/docs/alter-system/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 66a6314..fa58b5f 100644
--- a/docs/analyzing-highly-dynamic-datasets/index.html
+++ b/docs/analyzing-highly-dynamic-datasets/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/analyzing-social-media/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-social-media/index.html b/docs/analyzing-social-media/index.html
index 279836b..f42920f 100644
--- a/docs/analyzing-social-media/index.html
+++ b/docs/analyzing-social-media/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 61f6a33..3f5931d 100644
--- a/docs/analyzing-the-yelp-academic-dataset/index.html
+++ b/docs/analyzing-the-yelp-academic-dataset/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/docs/aol-search/index.html
----------------------------------------------------------------------
diff --git a/docs/aol-search/index.html b/docs/aol-search/index.html
index e69ed2c..c3a7a1c 100644
--- a/docs/aol-search/index.html
+++ b/docs/aol-search/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 8be6335..078b595 100644
--- a/docs/apache-drill-0-4-0-release-notes/index.html
+++ b/docs/apache-drill-0-4-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 bc737cb..22ccf02 100644
--- a/docs/apache-drill-0-5-0-release-notes/index.html
+++ b/docs/apache-drill-0-5-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 c723f25..34646f9 100644
--- a/docs/apache-drill-0-6-0-release-notes/index.html
+++ b/docs/apache-drill-0-6-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 207835e..ef4fe84 100644
--- a/docs/apache-drill-0-7-0-release-notes/index.html
+++ b/docs/apache-drill-0-7-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 3b545e9..8c91555 100644
--- a/docs/apache-drill-0-8-0-release-notes/index.html
+++ b/docs/apache-drill-0-8-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 6d6bdfb..e4a5ee7 100644
--- a/docs/apache-drill-0-9-0-release-notes/index.html
+++ b/docs/apache-drill-0-9-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 f4f2ed9..71ed20a 100644
--- a/docs/apache-drill-1-0-0-release-notes/index.html
+++ b/docs/apache-drill-1-0-0-release-notes/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 5923c3e..e04696b 100644
--- a/docs/apache-drill-contribution-guidelines/index.html
+++ b/docs/apache-drill-contribution-guidelines/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 9592449..9296c5e 100644
--- a/docs/apache-drill-contribution-ideas/index.html
+++ b/docs/apache-drill-contribution-ideas/index.html
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ba77798a/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 1e77fda..58a1eb3 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
@@ -686,23 +686,25 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/union-set-operator/">UNION Set Operator</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>