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/07/02 01:53:44 UTC

[1/4] drill-site git commit: Edits to Drill 1.1 Docs

Repository: drill-site
Updated Branches:
  refs/heads/asf-site 38b017ffb -> 47760316d


http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/toc/index.html
----------------------------------------------------------------------
diff --git a/toc/index.html b/toc/index.html
index 140ba25..af5bd94 100644
--- a/toc/index.html
+++ b/toc/index.html
@@ -501,6 +501,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -1010,6 +1012,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -1474,6 +1478,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/tutorials-introduction/">Tutorials Introduction</a></li>
           
           
@@ -1966,6 +1972,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
               
             
@@ -2694,6 +2702,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -3189,6 +3199,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -3509,6 +3521,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -4079,6 +4093,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -4601,6 +4617,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -5021,6 +5039,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -5627,6 +5647,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -6029,6 +6051,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -6742,6 +6766,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -7241,6 +7267,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -7736,6 +7764,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -8241,6 +8271,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -8521,6 +8553,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -9312,6 +9346,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -9820,6 +9856,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -10036,6 +10074,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -10809,6 +10849,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -11302,6 +11344,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -11795,6 +11839,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -12023,6 +12069,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -12537,6 +12585,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -12889,6 +12939,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li>
           
           
@@ -13267,6 +13319,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-data-types/">Supported Data Types</a></li>
               
             
@@ -13842,6 +13896,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
               
             
@@ -14359,6 +14415,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a></li>
               
             
@@ -14782,6 +14840,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/nested-data-limitations/">Nested Data Limitations</a></li>
               
             
@@ -15298,6 +15358,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
             
@@ -15883,6 +15945,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/case/">CASE</a></li>
               
             
@@ -16580,6 +16644,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -17099,6 +17165,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -17734,6 +17802,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -18227,6 +18297,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -18726,6 +18798,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -19074,6 +19148,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -19458,6 +19534,13 @@
         
       
         
+          <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+          
+          
+          
+        
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
           
           
@@ -19954,6 +20037,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/aol-search/">AOL Search</a></li>
           
           
@@ -20611,6 +20696,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -21105,6 +21192,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -21554,6 +21643,8 @@
 
   
 
+  
+
 </ul>
 
     </div>


[4/4] drill-site git commit: Edits to Drill 1.1 Docs

Posted by br...@apache.org.
Edits to Drill 1.1 Docs


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

Branch: refs/heads/asf-site
Commit: 47760316dd7fc424e5821513f03b0a62a54359b2
Parents: 38b017f
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Wed Jul 1 16:53:20 2015 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Wed Jul 1 16:53:20 2015 -0700

----------------------------------------------------------------------
 data/index.html                                 |   6 +
 docs/2014-q1-drill-report/index.html            |   4 +
 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      |  16 +-
 docs/alter-session/index.html                   |   6 +-
 docs/alter-system/index.html                    |   6 +-
 .../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 |   8 +-
 .../apache-drill-1-0-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 +
 docs/archived-pages/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                                  | 149 ++++++++-----------
 docs/configuring-user-impersonation/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            |   6 +-
 docs/create-view/index.html                     |   8 +-
 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                                  |   6 +-
 docs/deploying-and-using-a-hive-udf/index.html  |   4 +
 docs/describe/index.html                        |   4 +
 docs/design-docs/index.html                     |   4 +
 docs/develop-a-simple-function/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 +
 .../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-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                     |   6 +-
 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/how-to-run-the-drill-demo/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-plugin-for-apache-drill/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 +
 docs/order-by-clause/index.html                 |   4 +
 docs/parquet-format/index.html                  |   4 +
 docs/partition-by-clause/index.html             |   8 +-
 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  |   4 +
 docs/plugin-configuration-basics/index.html     |   4 +
 docs/ports-used-by-drill/index.html             |   4 +
 docs/progress-reports/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-system-tables/index.html          |   4 +
 docs/querying-the-information-schema/index.html |   4 +
 docs/ranking-window-functions/index.html        |  14 +-
 docs/release-notes/index.html                   |   7 +
 docs/repeated-contains/index.html               |   4 +
 docs/repeated-count/index.html                  |   4 +
 docs/reserved-keywords/index.html               |   4 +
 docs/review-the-java-stack-trace/index.html     |   4 +
 docs/rpc-overview/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/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                    |   4 +
 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                   |   4 +
 docs/sql-window-functions-examples/index.html   |   8 +-
 .../index.html                                  |  21 +--
 docs/sql-window-functions/index.html            |   4 +
 docs/start-up-options/index.html                |  28 ++--
 .../index.html                                  |   4 +
 .../index.html                                  |   4 +
 docs/starting-drill-on-windows/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          |  84 ++++++++++-
 docs/tableau-examples/index.html                |   4 +
 docs/testing-the-odbc-connection/index.html     |   4 +
 docs/troubleshooting/index.html                 |  16 +-
 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 +
 .../index.html                                  |   4 +
 docs/using-the-jdbc-driver/index.html           |   4 +
 .../index.html                                  |   4 +
 docs/value-vectors/index.html                   |   4 +
 docs/what-is-apache-drill/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                     |  11 +-
 docs/workspaces/index.html                      |   4 +
 feed.xml                                        |   4 +-
 toc/index.html                                  |  91 +++++++++++
 242 files changed, 1238 insertions(+), 155 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/data/index.html
----------------------------------------------------------------------
diff --git a/data/index.html b/data/index.html
index 2e805be..e509d0f 100644
--- a/data/index.html
+++ b/data/index.html
@@ -996,6 +996,12 @@
     "relative_path": "_docs/rn/070-0.9.0-rn copy.md"
 },
 {
+    "url": "/docs/apache-drill-0-9-0-release-notes/",
+    "title": "Apache Drill 0.9.0 Release Notes",
+    "parent": "Release Notes",
+    "relative_path": "_docs/rn/070-0.9.0-rn.md"
+},
+{
     "url": "/docs/apache-drill-1-0-0-release-notes/",
     "title": "Apache Drill 1.0.0 Release Notes",
     "parent": "Release Notes",

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 b1f9513..fa870f7 100644
--- a/docs/2014-q1-drill-report/index.html
+++ b/docs/2014-q1-drill-report/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 c247ba5..d145db8 100644
--- a/docs/about-sql-function-examples/index.html
+++ b/docs/about-sql-function-examples/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 6e3b35c..0d33b71 100644
--- a/docs/about-the-mapr-sandbox/index.html
+++ b/docs/about-the-mapr-sandbox/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 596d351..3b1f532 100644
--- a/docs/adding-custom-functions-to-drill/index.html
+++ b/docs/adding-custom-functions-to-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 bc10133..dd22c0c 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/aggregate-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/aggregate-window-functions/index.html b/docs/aggregate-window-functions/index.html
index f386937..d381ef3 100644
--- a/docs/aggregate-window-functions/index.html
+++ b/docs/aggregate-window-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -995,11 +999,9 @@
 
     <div class="int_text" align="left">
       
-        <h2 id="aggregate-window-functions">Aggregate Window Functions</h2>
-
-<p>Window functions operate on a set of rows and return a single value for each row from the underlying query. See SQL Window Functions. You can use certain aggregate functions as window functions in Drill. The OVER() clause differentiates window functions from other analytical and reporting functions. </p>
+        <p>Window functions operate on a set of rows and return a single value for each row from the underlying query. The OVER() clause differentiates window functions from other analytical and reporting functions. See <a href="/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a>. You can use certain aggregate functions as window functions in Drill. </p>
 
-<p>The following table lists the aggregate functions that you can use as window functions in Drill with supported data types and descriptions of each function:  </p>
+<p>The following table lists the aggregate window functions with supported data types and descriptions:  </p>
 
 <table><thead>
 <tr>
@@ -1042,7 +1044,7 @@
 </tbody></table>
 
 <h2 id="syntax">Syntax</h2>
-<div class="highlight"><pre><code class="language-text" data-lang="text">   window_function ( [ ALL ] &lt;expression&gt; ) 
+<div class="highlight"><pre><code class="language-text" data-lang="text">   window_function ( [ ALL ] expression ) 
    OVER ( [ PARTITION BY expr_list ] [ ORDER BY order_list frame_clause ] )
 </code></pre></div>
 <h2 id="arguments">Arguments</h2>
@@ -1071,7 +1073,7 @@ If an ORDER BY clause is used for an aggregate function, an explicit frame claus
 
 <h2 id="examples">Examples</h2>
 
-<p>The following examples show queries that use each of the aggregate window functions in Drill. See Window Function Examples for information about the data and setup for these examples.</p>
+<p>The following examples show queries that use each of the aggregate window functions in Drill. See <a href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a> for information about the data and setup for these examples.</p>
 
 <h3 id="avg()">AVG()</h3>
 
@@ -1174,7 +1176,7 @@ If an ORDER BY clause is used for an aggregate function, an explicit frame claus
 <h3 id="sum()">SUM()</h3>
 
 <p>The following query uses the SUM() window function to total the amount of sales for each dealer in Q1. The word sum is a reserved keyword in Drill and must be enclosed in back ticks (``).  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">   select dealer_id, emp_name, sales, sum(sales) over(partition by dealer_id) as `sum` from q2_sales;
+<div class="highlight"><pre><code class="language-text" data-lang="text">   select dealer_id, emp_name, sales, sum(sales) over(partition by dealer_id) as `sum` from q1_sales;
    +------------+-----------------+--------+--------+
    | dealer_id  |    emp_name     | sales  |  sum   |
    +------------+-----------------+--------+--------+

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/alter-session/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-session/index.html b/docs/alter-session/index.html
index 8591989..6c878b3 100644
--- a/docs/alter-session/index.html
+++ b/docs/alter-session/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1001,7 +1005,7 @@ session. Session level settings override system level settings.</p>
 <h2 id="syntax">Syntax</h2>
 
 <p>The ALTER SESSION command supports the following syntax:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SESSION SET `&lt;option_name&gt;`=&lt;value&gt;;
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SESSION SET `option_name` = value;
 </code></pre></div>
 <h2 id="parameters">Parameters</h2>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/alter-system/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-system/index.html b/docs/alter-system/index.html
index 9361005..1f5efc8 100644
--- a/docs/alter-system/index.html
+++ b/docs/alter-system/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1002,7 +1006,7 @@ 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 `&lt;option_name&gt;`=&lt;value&gt;;
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `option_name` =  value;
 </code></pre></div>
 <h2 id="parameters">Parameters</h2>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 ebb09dd..59a4084 100644
--- a/docs/analyzing-highly-dynamic-datasets/index.html
+++ b/docs/analyzing-highly-dynamic-datasets/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/analyzing-social-media/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-social-media/index.html b/docs/analyzing-social-media/index.html
index f35c294..c3d0ca9 100644
--- a/docs/analyzing-social-media/index.html
+++ b/docs/analyzing-social-media/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 1d84f07..ce2bc74 100644
--- a/docs/analyzing-the-yelp-academic-dataset/index.html
+++ b/docs/analyzing-the-yelp-academic-dataset/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/aol-search/index.html
----------------------------------------------------------------------
diff --git a/docs/aol-search/index.html b/docs/aol-search/index.html
index cc9907f..c1135bd 100644
--- a/docs/aol-search/index.html
+++ b/docs/aol-search/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 360d679..e5df22e 100644
--- a/docs/apache-drill-0-4-0-release-notes/index.html
+++ b/docs/apache-drill-0-4-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 d2a0f72..14458f8 100644
--- a/docs/apache-drill-0-5-0-release-notes/index.html
+++ b/docs/apache-drill-0-5-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 a847132..203fc05 100644
--- a/docs/apache-drill-0-6-0-release-notes/index.html
+++ b/docs/apache-drill-0-6-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 f2b2219..206cd59 100644
--- a/docs/apache-drill-0-7-0-release-notes/index.html
+++ b/docs/apache-drill-0-7-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 d930f63..cefa7e3 100644
--- a/docs/apache-drill-0-8-0-release-notes/index.html
+++ b/docs/apache-drill-0-8-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 ea1a39f..29171d7 100644
--- a/docs/apache-drill-0-9-0-release-notes/index.html
+++ b/docs/apache-drill-0-9-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2 current"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -981,7 +985,7 @@
   <div class="main-content">
 
     
-      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/rn/070-0.9.0-rn copy.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/rn/070-0.9.0-rn.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
     
 
     <div class="int_title left">
@@ -1020,7 +1024,7 @@ We now support a number of qualifiers including <code>$bin</code>, <code>$date</
       
         <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/apache-drill-0-8-0-release-notes/">← Apache Drill 0.8.0 Release Notes</a></span><span class="next-toc"><a href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes →</a></span>
+  <span class="previous-toc"><a href="/docs/apache-drill-0-9-0-release-notes/">← Apache Drill 0.9.0 Release Notes</a></span><span class="next-toc"><a href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes →</a></span>
 </div>
 
     

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 f8f83d8..a254d86 100644
--- a/docs/apache-drill-1-0-0-release-notes/index.html
+++ b/docs/apache-drill-1-0-0-release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2 current"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 6ca57c8..f0894f2 100644
--- a/docs/apache-drill-contribution-guidelines/index.html
+++ b/docs/apache-drill-contribution-guidelines/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 62449dc..432d391 100644
--- a/docs/apache-drill-contribution-ideas/index.html
+++ b/docs/apache-drill-contribution-ideas/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 7b71b03..a9d2f51 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
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/architecture-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/architecture-introduction/index.html b/docs/architecture-introduction/index.html
index 9eff0d4..9c4721c 100644
--- a/docs/architecture-introduction/index.html
+++ b/docs/architecture-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/architecture/index.html
----------------------------------------------------------------------
diff --git a/docs/architecture/index.html b/docs/architecture/index.html
index a4d9e18..f79dd35 100644
--- a/docs/architecture/index.html
+++ b/docs/architecture/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/archived-pages/index.html
----------------------------------------------------------------------
diff --git a/docs/archived-pages/index.html b/docs/archived-pages/index.html
index 11bb321..17cb8ac 100644
--- a/docs/archived-pages/index.html
+++ b/docs/archived-pages/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 6b3da7c..2304d81 100644
--- a/docs/browsing-data-and-defining-views/index.html
+++ b/docs/browsing-data-and-defining-views/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/case/index.html
----------------------------------------------------------------------
diff --git a/docs/case/index.html b/docs/case/index.html
index f583d69..e572a7c 100644
--- a/docs/case/index.html
+++ b/docs/case/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 b75fde9..123ce24 100644
--- a/docs/choosing-a-storage-format/index.html
+++ b/docs/choosing-a-storage-format/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 4bc77bd..7bbb062 100644
--- a/docs/compiling-drill-from-source/index.html
+++ b/docs/compiling-drill-from-source/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuration-options-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/configuration-options-introduction/index.html b/docs/configuration-options-introduction/index.html
index 91c2ce6..d27760c 100644
--- a/docs/configuration-options-introduction/index.html
+++ b/docs/configuration-options-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuration-options/index.html
----------------------------------------------------------------------
diff --git a/docs/configuration-options/index.html b/docs/configuration-options/index.html
index e657f41..5e2a807 100644
--- a/docs/configuration-options/index.html
+++ b/docs/configuration-options/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configure-drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/configure-drill-introduction/index.html b/docs/configure-drill-introduction/index.html
index 7f17d90..42ac4aa 100644
--- a/docs/configure-drill-introduction/index.html
+++ b/docs/configure-drill-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configure-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/configure-drill/index.html b/docs/configure-drill/index.html
index b0a9a0a..1a525b4 100644
--- a/docs/configure-drill/index.html
+++ b/docs/configure-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 380b048..664bbe8 100644
--- a/docs/configuring-a-multitenant-cluster-introduction/index.html
+++ b/docs/configuring-a-multitenant-cluster-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 ecf0d07..15cf987 100644
--- a/docs/configuring-a-multitenant-cluster/index.html
+++ b/docs/configuring-a-multitenant-cluster/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuring-drill-memory/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-drill-memory/index.html b/docs/configuring-drill-memory/index.html
index b504374..dd5b662 100644
--- a/docs/configuring-drill-memory/index.html
+++ b/docs/configuring-drill-memory/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 8c2696e..523d82e 100644
--- a/docs/configuring-jreport-with-drill/index.html
+++ b/docs/configuring-jreport-with-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuring-multitenant-resources/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-multitenant-resources/index.html b/docs/configuring-multitenant-resources/index.html
index 76f5921..2a3eace 100644
--- a/docs/configuring-multitenant-resources/index.html
+++ b/docs/configuring-multitenant-resources/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 110e72b..60cbcb9 100644
--- a/docs/configuring-odbc-on-linux/index.html
+++ b/docs/configuring-odbc-on-linux/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 aa3e6be..0d35d4d 100644
--- a/docs/configuring-odbc-on-mac-os-x/index.html
+++ b/docs/configuring-odbc-on-mac-os-x/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 3fce398..96f937d 100644
--- a/docs/configuring-odbc-on-windows/index.html
+++ b/docs/configuring-odbc-on-windows/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuring-odbc/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-odbc/index.html b/docs/configuring-odbc/index.html
index 10c9a03..f10dddc 100644
--- a/docs/configuring-odbc/index.html
+++ b/docs/configuring-odbc/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 422a7ab..9ffc5c7 100644
--- a/docs/configuring-resources-for-a-shared-drillbit/index.html
+++ b/docs/configuring-resources-for-a-shared-drillbit/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 3e8fe20..48a47a6 100644
--- a/docs/configuring-the-drill-shell/index.html
+++ b/docs/configuring-the-drill-shell/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 032e63b..538819d 100644
--- a/docs/configuring-tibco-spotfire-server-with-drill/index.html
+++ b/docs/configuring-tibco-spotfire-server-with-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuring-user-authentication/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-user-authentication/index.html b/docs/configuring-user-authentication/index.html
index fd6d094..2d3d802 100644
--- a/docs/configuring-user-authentication/index.html
+++ b/docs/configuring-user-authentication/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 35f9493..a933ca7 100644
--- a/docs/configuring-user-impersonation-with-hive-authorization/index.html
+++ b/docs/configuring-user-impersonation-with-hive-authorization/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1009,13 +1013,13 @@
 
 <h2 id="sql-standard-based-authorization">SQL Standard Based Authorization</h2>
 
-<p>You can configure Hive SQL standard based authorization in Hive version 1.0 to work with Drill impersonation. The SQL standard based authorization model can control which users have access to columns, rows, and views. Users with the appropriate permissions can issue the GRANT and REVOKE statements to manage privileges from Hive.</p>
+<p>You can configure Hive SQL standard based authorization in Hive version 1.0 to work with impersonation in Drill 1.1. The SQL standard based authorization model can control which users have access to columns, rows, and views. Users with the appropriate permissions can issue the GRANT and REVOKE statements to manage privileges from Hive.</p>
 
 <p>For more information, see <a href="https://cwiki.apache.org/confluence/display/HELIX/SQL+Standard+Based+Hive+Authorization">SQL Standard Based Hive Authorization</a>.  </p>
 
 <h2 id="configuration">Configuration</h2>
 
-<p>Once you determine which type of Hive authorization model that you want to use, enable impersonation in Drill. Update hive-site.xml with the relevant parameters for the type of authorization that you have decided to implement. Modify the Hive storage plugin instance in Drill with the relevant settings for the type of authorization.  </p>
+<p>Once you determine the Hive authorization model that you want to implement, enable impersonation in Drill. Update hive-site.xml with the relevant parameters for the authorization type. Modify the Hive storage plugin instance in Drill with the relevant settings for the authorization type.  </p>
 
 <h3 id="prerequisites">Prerequisites</h3>
 
@@ -1037,7 +1041,7 @@
          max_chained_user_hops: 3
   }
 </code></pre></div></li>
-<li><p>Verify that enabled is set to <code>‘true’</code>.</p></li>
+<li><p>Verify that enabled is set to <code>&quot;true&quot;</code>.</p></li>
 <li><p>Set the maximum number of chained user hops that you want Drill to allow.</p></li>
 <li><p>(MapR clusters only) Add the following lines to the <code>drill-env.sh</code> file:</p>
 
@@ -1067,48 +1071,31 @@
 
 <h3 id="storage-based-authorization">Storage Based Authorization</h3>
 
-<p>Add the required parameters to the hive-site.xml file to configure storage based authentication.  </p>
-
-<p>The following table lists the required authorization parameters and their descriptions:  </p>
-
-<table><thead>
-<tr>
-<th>Property</th>
-<th>Value</th>
-<th>Description</th>
-</tr>
-</thead><tbody>
-<tr>
-<td>hive.metastore.pre.event.listeners</td>
-<td>Set to: org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener</td>
-<td>Turns on metastore-side security.</td>
-</tr>
-<tr>
-<td>hive.security.metastore.authorization.manager</td>
-<td>Set to: org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider</td>
-<td>Tells Hive which metastore-side authorization provider to use. The default setting uses DefaultHiveMetastoreAuthorizationProvider, which implements the standard Hive grant/revoke model. To use an HDFS permission-based model (recommended) to do your authorization, use StorageBasedAuthorizationProvider.</td>
-</tr>
-<tr>
-<td>hive.security.metastore.authenticator.manager</td>
-<td>Set to:org.apache.hadoop.hive.ql.security.HadoopDefaultMetastoreAuthenticator</td>
-<td>The authenticator manager class name in the metastore for authentication.</td>
-</tr>
-<tr>
-<td>hive.security.metastore.authorization.auth.reads</td>
-<td>Set to “true”.</td>
-<td>Tells Hive metastore authorization checks for read access.</td>
-</tr>
-<tr>
-<td>hive.metastore.execute.setugi</td>
-<td>Set to “true”.</td>
-<td>Causes the metastore to execute file system operations using the client&#39;s reported user and group permissions. You must set this property on both the client and server sides. If client sets it to true and server sets it to false, the client setting is ignored.</td>
-</tr>
-<tr>
-<td>hive.server2.enable.doAs</td>
-<td>Set to “true”.</td>
-<td>Tells HiveServer2 to execute Hive operations as the user making the calls.</td>
-</tr>
-</tbody></table>
+<p>Add the following required authorization parameters in hive-site.xml to configure storage based authentication:  </p>
+
+<p><strong>hive.metastore.pre.event.listeners</strong><br>
+<strong>Description:</strong> Turns on metastore-side security.<br>
+<strong>Value:</strong> org.apache.hadoop.hive.ql.security.authorization.AuthorizationPreEventListener  </p>
+
+<p><strong>hive.security.metastore.authorization.manager</strong><br>
+<strong>Description:</strong> Tells Hive which metastore-side authorization provider to use. The default setting uses DefaultHiveMetastoreAuthorizationProvider, which implements the standard Hive grant/revoke model. To use an HDFS permission-based model (recommended) for authorization, use StorageBasedAuthorizationProvider.<br>
+<strong>Value:</strong> org.apache.hadoop.hive.ql.security.authorization.StorageBasedAuthorizationProvider  </p>
+
+<p><strong>hive.security.metastore.authenticator.manager</strong><br>
+<strong>Description:</strong> The authenticator manager class name in the metastore for authentication.<br>
+<strong>Value:</strong> org.apache.hadoop.hive.ql.security.HadoopDefaultMetastoreAuthenticator  </p>
+
+<p><strong>hive.security.metastore.authorization.auth.reads</strong><br>
+<strong>Description:</strong> Tells Hive metastore authorization checks for read access.<br>
+<strong>Value:</strong> true  </p>
+
+<p><strong>hive.metastore.execute.setugi</strong><br>
+<strong>Description:</strong> Causes the metastore to execute file system operations using the client&#39;s reported user and group permissions. You must set this property on both the client and server sides. If client sets it to true and server sets it to false, the client setting is ignored.
+<strong>Value:</strong> true </p>
+
+<p><strong>hive.server2.enable.doAs</strong><br>
+<strong>Description:</strong> Tells HiveServer2 to execute Hive operations as the user making the calls. 
+<strong>Value:</strong> true </p>
 
 <h3 id="example-hive-site.xml-settings-for-storage-based-authorization">Example hive-site.xml Settings for Storage Based Authorization</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   &lt;property&gt;
@@ -1143,48 +1130,31 @@
 </code></pre></div>
 <h2 id="sql-standard-based-authorization">SQL Standard Based Authorization</h2>
 
-<p>Add the required parameters to the hive-site.xml file to configure SQL standard based authorization.  </p>
-
-<p>The following table lists the required authorization parameters and their descriptions:  </p>
-
-<table><thead>
-<tr>
-<th>Property</th>
-<th>Value</th>
-<th>Description</th>
-</tr>
-</thead><tbody>
-<tr>
-<td>hive.security.authorization.enabled</td>
-<td>Set to true.</td>
-<td>Enables/disables Hive security authorization.</td>
-</tr>
-<tr>
-<td>hive.security.authenticator.manager</td>
-<td>Set to:org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator</td>
-<td>Class that implements HiveAuthenticationProvider to provide the client’s username and groups.</td>
-</tr>
-<tr>
-<td>hive.security.authorization.manager</td>
-<td>Set to:org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory</td>
-<td>The Hive client authorization manager class name.</td>
-</tr>
-<tr>
-<td>hive.server2.enable.doAs</td>
-<td>Set to false.</td>
-<td>Tells HiveServer2 to execute Hive operations as the user making the calls.</td>
-</tr>
-<tr>
-<td>hive.users.in.admin.role</td>
-<td>Set to the list of comma-separated users who need to be added to the admin role.</td>
-<td>A comma separated list of users which gets added to the ADMIN role when the metastore starts up. You can add more uses at any time. Note that a user who belongs to the admin role needs to run the &quot;set role&quot; command before getting the privileges of the admin role, as this role is not in the current roles by default.</td>
-</tr>
-<tr>
-<td>hive.metastore.execute.setugi</td>
-<td>Set to false.</td>
-<td>Causes the metastore to execute file system operations using the client&#39;s reported user and group permissions. You must set this property on both the client and server sides. If client sets it to true and server sets it to false, the client setting is ignored.</td>
-</tr>
-</tbody></table>
+<p>Add the following required authorization parameters in hive-site.xml to configure SQL standard based authentication:  </p>
+
+<p><strong>hive.security.authorization.enabled</strong><br>
+<strong>Description:</strong> Enables/disables Hive security authorization.<br>
+<strong>Value:</strong> true </p>
+
+<p><strong>hive.security.authenticator.manager</strong><br>
+<strong>Description:</strong> Class that implements HiveAuthenticationProvider to provide the client’s username and groups.<br>
+<strong>Value:</strong> Set to:org.apache.hadoop.hive.ql.security.SessionStateUserAuthenticator  </p>
+
+<p><strong>hive.security.authorization.manager</strong><br>
+<strong>Description:</strong> The Hive client authorization manager class name.<br>
+<strong>Value:</strong> org.apache.hadoop.hive.ql.security.authorization.plugin.sqlstd.SQLStdHiveAuthorizerFactory  </p>
+
+<p><strong>hive.server2.enable.doAs</strong><br>
+<strong>Description:</strong> Tells HiveServer2 to execute Hive operations as the user making the calls.<br>
+<strong>Value:</strong> false  </p>
+
+<p><strong>hive.users.in.admin.role</strong><br>
+<strong>Description:</strong> A comma separated list of users which gets added to the ADMIN role when the metastore starts up. You can add more uses at any time. Note that a user who belongs to the admin role needs to run the &quot;set role&quot; command before getting the privileges of the admin role, as this role is not in the current roles by default.<br>
+<strong>Value:</strong> Set to the list of comma-separated users who need to be added to the admin role. </p>
+
+<p><strong>hive.metastore.execute.setugi</strong><br>
+<strong>Description:</strong> Causes the metastore to execute file system operations using the client&#39;s reported user and group permissions. You must set this property on both the client and server side. If the client is set to true and the server is set to false, the client setting is ignored.<br>
+<strong>Value:</strong> false </p>
 
 <h3 id="example-hive-site.xml-settings-for-sql-standard-based-authorization">Example hive-site.xml Settings for SQL Standard Based Authorization</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   &lt;property&gt;
@@ -1226,8 +1196,8 @@
 <p>Complete the following steps to modify the Hive storage plugin:  </p>
 
 <ol>
-<li> Navigate to http://<drillbit_hostname>:8047, and select the Storage tab.<br></li>
-<li> Click Update next to the hive instance.<br></li>
+<li> Navigate to <code>http://&lt;drillbit_hostname&gt;:8047</code>, and select the <strong>Storage tab</strong>.<br></li>
+<li> Click <strong>Update</strong> next to the hive instance.<br></li>
 <li><p>In the configuration window, add the configuration settings for the authorization type.  </p>
 
 <ul>
@@ -1248,6 +1218,7 @@
 </ol>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   * For SQL standard based authorization, add the following settings:  
 
+
           {
            type:&quot;hive&quot;,
            enabled: true,

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/configuring-user-impersonation/index.html
----------------------------------------------------------------------
diff --git a/docs/configuring-user-impersonation/index.html b/docs/configuring-user-impersonation/index.html
index 78ce7b4..f570b6e 100644
--- a/docs/configuring-user-impersonation/index.html
+++ b/docs/configuring-user-impersonation/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 e218d85..4f3cd16 100644
--- a/docs/connect-a-data-source-introduction/index.html
+++ b/docs/connect-a-data-source-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 239597a..649dc41 100644
--- a/docs/connect-a-data-source/index.html
+++ b/docs/connect-a-data-source/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 71dac61..bebe4e2 100644
--- a/docs/connecting-drill-explorer-to-data/index.html
+++ b/docs/connecting-drill-explorer-to-data/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/contribute-to-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/contribute-to-drill/index.html b/docs/contribute-to-drill/index.html
index fe30535..90abcd5 100644
--- a/docs/contribute-to-drill/index.html
+++ b/docs/contribute-to-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 68da4e6..f33eff5 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
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/core-modules/index.html
----------------------------------------------------------------------
diff --git a/docs/core-modules/index.html b/docs/core-modules/index.html
index eeb9da8..40ee606 100644
--- a/docs/core-modules/index.html
+++ b/docs/core-modules/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 ae5a743..6cac839 100644
--- a/docs/create-table-as-ctas/index.html
+++ b/docs/create-table-as-ctas/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -998,7 +1002,7 @@
         <p>You can create tables in Drill by using the CTAS command.</p>
 
 <h2 id="syntax">Syntax</h2>
-<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE &lt;name&gt; [ (column list) ] AS &lt;query&gt;;
+<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE name [ (column list) ] AS query;
 </code></pre></div>
 <p><em>name</em> is a unique directory name, optionally prefaced by a storage plugin name, such as dfs, and a workspace, such as tmp using <a href="/docs/workspaces">dot notation</a>.<br>
 <em>column list</em> is an optional list of column names or aliases in the new table.<br>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/create-view/index.html
----------------------------------------------------------------------
diff --git a/docs/create-view/index.html b/docs/create-view/index.html
index f5f6632..a2a0cb2 100644
--- a/docs/create-view/index.html
+++ b/docs/create-view/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1006,13 +1010,13 @@ existing views or any other available storage plugin data sources.</p>
 <h2 id="syntax">Syntax</h2>
 
 <p>The CREATE VIEW command supports the following syntax:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS &lt;query&gt;;
+<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS query;
 </code></pre></div>
 <p>Use CREATE VIEW to create a new view. Use CREATE OR REPLACE VIEW to replace an
 existing view with the same name. When you replace a view, the query must
 generate the same set of columns with the same column names and data types.</p>
 
-<p><strong>Note:</strong> Follow Drill’s rules for identifiers when you name the view. See coming soon...</p>
+<p><strong>Note:</strong> Follow Drill’s rules for identifiers when you name the view. </p>
 
 <h2 id="parameters">Parameters</h2>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/custom-function-interfaces/index.html
----------------------------------------------------------------------
diff --git a/docs/custom-function-interfaces/index.html b/docs/custom-function-interfaces/index.html
index 3eb0527..fdacc00 100644
--- a/docs/custom-function-interfaces/index.html
+++ b/docs/custom-function-interfaces/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/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 1624ea2..ed126d6 100644
--- a/docs/data-sources-and-file-formats-introduction/index.html
+++ b/docs/data-sources-and-file-formats-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/data-sources-and-file-formats/index.html
----------------------------------------------------------------------
diff --git a/docs/data-sources-and-file-formats/index.html b/docs/data-sources-and-file-formats/index.html
index 7c5011f..59657bf 100644
--- a/docs/data-sources-and-file-formats/index.html
+++ b/docs/data-sources-and-file-formats/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/data-type-conversion/index.html
----------------------------------------------------------------------
diff --git a/docs/data-type-conversion/index.html b/docs/data-type-conversion/index.html
index 0440f75..a64974f 100644
--- a/docs/data-type-conversion/index.html
+++ b/docs/data-type-conversion/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/data-types/index.html b/docs/data-types/index.html
index 8bbae03..0c2df02 100644
--- a/docs/data-types/index.html
+++ b/docs/data-types/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/date-time-and-timestamp/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-and-timestamp/index.html b/docs/date-time-and-timestamp/index.html
index ca7c0ab..708f167 100644
--- a/docs/date-time-and-timestamp/index.html
+++ b/docs/date-time-and-timestamp/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/date-time-functions-and-arithmetic/index.html
----------------------------------------------------------------------
diff --git a/docs/date-time-functions-and-arithmetic/index.html b/docs/date-time-functions-and-arithmetic/index.html
index 7c9a648..2f4f0a9 100644
--- a/docs/date-time-functions-and-arithmetic/index.html
+++ b/docs/date-time-functions-and-arithmetic/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1079,7 +1083,7 @@
 +------------+
 1 row selected (0.064 seconds)
 </code></pre></div>
-<p>Find the interval between midnight today, May 21, 2015, and hire dates of employees 578 and 761 in the <code>employees.json</code> file included with the Drill installation.</p>
+<p>Find the interval between midnight today, May 21, 2015, and hire dates of employees 578 and 761 in the <code>employees.json</code> file. The file is installed with Drill and located in the Drill classpath.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT AGE(CAST(hire_date AS TIMESTAMP)) FROM cp.`employee.json` where employee_id IN( &#39;578&#39;,&#39;761&#39;);
 +------------------+
 |      EXPR$0      |

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/deploying-and-using-a-hive-udf/index.html
----------------------------------------------------------------------
diff --git a/docs/deploying-and-using-a-hive-udf/index.html b/docs/deploying-and-using-a-hive-udf/index.html
index 732a3b7..b0b9d76 100644
--- a/docs/deploying-and-using-a-hive-udf/index.html
+++ b/docs/deploying-and-using-a-hive-udf/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           


[2/4] drill-site git commit: Edits to Drill 1.1 Docs

Posted by br...@apache.org.
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-complex-data/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-complex-data/index.html b/docs/querying-complex-data/index.html
index 1d1f041..124e067 100644
--- a/docs/querying-complex-data/index.html
+++ b/docs/querying-complex-data/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-directories/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-directories/index.html b/docs/querying-directories/index.html
index 8c0b39d..670b19d 100644
--- a/docs/querying-directories/index.html
+++ b/docs/querying-directories/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-hbase/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-hbase/index.html b/docs/querying-hbase/index.html
index bbcf4cd..21568ba 100644
--- a/docs/querying-hbase/index.html
+++ b/docs/querying-hbase/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-hive/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-hive/index.html b/docs/querying-hive/index.html
index 9e179f1..63849d4 100644
--- a/docs/querying-hive/index.html
+++ b/docs/querying-hive/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-json-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-json-files/index.html b/docs/querying-json-files/index.html
index 3289477..697c091 100644
--- a/docs/querying-json-files/index.html
+++ b/docs/querying-json-files/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-parquet-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-parquet-files/index.html b/docs/querying-parquet-files/index.html
index cb5468c..b579555 100644
--- a/docs/querying-parquet-files/index.html
+++ b/docs/querying-parquet-files/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-plain-text-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-plain-text-files/index.html b/docs/querying-plain-text-files/index.html
index 7a89118..29ac5e4 100644
--- a/docs/querying-plain-text-files/index.html
+++ b/docs/querying-plain-text-files/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-system-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-system-tables/index.html b/docs/querying-system-tables/index.html
index aa32aa1..4b626da 100644
--- a/docs/querying-system-tables/index.html
+++ b/docs/querying-system-tables/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-the-information-schema/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-the-information-schema/index.html b/docs/querying-the-information-schema/index.html
index ac3f560..8b47539 100644
--- a/docs/querying-the-information-schema/index.html
+++ b/docs/querying-the-information-schema/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/ranking-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/ranking-window-functions/index.html b/docs/ranking-window-functions/index.html
index 32913d3..a1dbc9b 100644
--- a/docs/ranking-window-functions/index.html
+++ b/docs/ranking-window-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -995,11 +999,9 @@
 
     <div class="int_text" align="left">
       
-        <h2 id="ranking-window-functions">Ranking Window Functions</h2>
-
-<p>Window functions operate on a set of rows and return a single value for each row from the underlying query. See SQL Window Functions. The OVER() clause differentiates window functions from other analytical and reporting functions. </p>
+        <p>Window functions operate on a set of rows and return a single value for each row from the underlying query. The OVER() clause differentiates window functions from other analytical and reporting functions. See <a href="/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a>. You can use ranking functions in Drill to return a ranking value for each row in a partition.  </p>
 
-<p>The following table lists the ranking window functions in Drill with return data types and descriptions of each function:  </p>
+<p>The following table lists the ranking window functions with supported data types and descriptions:  </p>
 
 <table><thead>
 <tr>
@@ -1048,11 +1050,11 @@ CUME_DIST(), DENSE_RANK(), PERCENT_RANK(), RANK(), ROW_NUMBER() </p>
 The functions do not take arguments, however the empty parentheses are required.  </p>
 
 <p>OVER clause<br>
-The window clauses for the function. The OVER clause cannot contain an explicit frame specification, but must include an ORDER BY clause. See Window Function Syntax for OVER clause syntax.</p>
+The window clauses for the function. The OVER clause cannot contain an explicit frame specification, but must include an ORDER BY clause. See <a href="/docs/sql-window-functions-introduction/#syntax">Window Function Syntax</a> for OVER clause syntax.</p>
 
 <h2 id="examples">Examples</h2>
 
-<p>The following examples show queries that use each of the ranking window functions in Drill. See Window Function Examples for information about the data and setup for these examples.</p>
+<p>The following examples show queries that use each of the ranking window functions in Drill. See <a href="/docs/sql-window-functions-examples/">Window Functions Examples</a> for information about the data and setup for these examples.</p>
 
 <h3 id="cume_dist()">CUME_DIST()</h3>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/release-notes/index.html b/docs/release-notes/index.html
index 6210245..5dc6162 100644
--- a/docs/release-notes/index.html
+++ b/docs/release-notes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1017,6 +1021,9 @@
           <li><a href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
         
       
+          <li><a href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+        
+      
           <li><a href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/repeated-contains/index.html
----------------------------------------------------------------------
diff --git a/docs/repeated-contains/index.html b/docs/repeated-contains/index.html
index f3e0585..242bfef 100644
--- a/docs/repeated-contains/index.html
+++ b/docs/repeated-contains/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/repeated-count/index.html
----------------------------------------------------------------------
diff --git a/docs/repeated-count/index.html b/docs/repeated-count/index.html
index c64d6e5..bce65cd 100644
--- a/docs/repeated-count/index.html
+++ b/docs/repeated-count/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/reserved-keywords/index.html
----------------------------------------------------------------------
diff --git a/docs/reserved-keywords/index.html b/docs/reserved-keywords/index.html
index 09bfc77..b4bac3f 100644
--- a/docs/reserved-keywords/index.html
+++ b/docs/reserved-keywords/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/review-the-java-stack-trace/index.html
----------------------------------------------------------------------
diff --git a/docs/review-the-java-stack-trace/index.html b/docs/review-the-java-stack-trace/index.html
index 3d7010e..59bdb66 100644
--- a/docs/review-the-java-stack-trace/index.html
+++ b/docs/review-the-java-stack-trace/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/rpc-overview/index.html
----------------------------------------------------------------------
diff --git a/docs/rpc-overview/index.html b/docs/rpc-overview/index.html
index 0a101b0..5398bee 100644
--- a/docs/rpc-overview/index.html
+++ b/docs/rpc-overview/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sample-data-donuts/index.html
----------------------------------------------------------------------
diff --git a/docs/sample-data-donuts/index.html b/docs/sample-data-donuts/index.html
index 1091968..05d68c1 100644
--- a/docs/sample-data-donuts/index.html
+++ b/docs/sample-data-donuts/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sample-datasets/index.html
----------------------------------------------------------------------
diff --git a/docs/sample-datasets/index.html b/docs/sample-datasets/index.html
index 4b85b57..e4c4842 100644
--- a/docs/sample-datasets/index.html
+++ b/docs/sample-datasets/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/select-list/index.html
----------------------------------------------------------------------
diff --git a/docs/select-list/index.html b/docs/select-list/index.html
index 6aa91b3..229fdb2 100644
--- a/docs/select-list/index.html
+++ b/docs/select-list/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/select/index.html
----------------------------------------------------------------------
diff --git a/docs/select/index.html b/docs/select/index.html
index 22827a4..e38d542 100644
--- a/docs/select/index.html
+++ b/docs/select/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/selecting-flat-data/index.html
----------------------------------------------------------------------
diff --git a/docs/selecting-flat-data/index.html b/docs/selecting-flat-data/index.html
index 4bc283b..2895e33 100644
--- a/docs/selecting-flat-data/index.html
+++ b/docs/selecting-flat-data/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/selecting-multiple-columns-within-nested-data/index.html
----------------------------------------------------------------------
diff --git a/docs/selecting-multiple-columns-within-nested-data/index.html b/docs/selecting-multiple-columns-within-nested-data/index.html
index 9f78b7a..bd0a036 100644
--- a/docs/selecting-multiple-columns-within-nested-data/index.html
+++ b/docs/selecting-multiple-columns-within-nested-data/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/selecting-nested-data-for-a-column/index.html
----------------------------------------------------------------------
diff --git a/docs/selecting-nested-data-for-a-column/index.html b/docs/selecting-nested-data-for-a-column/index.html
index e70a6d7..6da3066 100644
--- a/docs/selecting-nested-data-for-a-column/index.html
+++ b/docs/selecting-nested-data-for-a-column/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/show-databases-and-show-schemas/index.html
----------------------------------------------------------------------
diff --git a/docs/show-databases-and-show-schemas/index.html b/docs/show-databases-and-show-schemas/index.html
index a07e607..044b4e4 100644
--- a/docs/show-databases-and-show-schemas/index.html
+++ b/docs/show-databases-and-show-schemas/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/show-files/index.html
----------------------------------------------------------------------
diff --git a/docs/show-files/index.html b/docs/show-files/index.html
index e3cad21..95e1878 100644
--- a/docs/show-files/index.html
+++ b/docs/show-files/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/show-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/show-tables/index.html b/docs/show-tables/index.html
index f0b8c0a..5cf27f6 100644
--- a/docs/show-tables/index.html
+++ b/docs/show-tables/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
----------------------------------------------------------------------
diff --git a/docs/sort-based-and-hash-based-memory-constrained-operators/index.html b/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
index 418b8a5..7c97b7e 100644
--- a/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
+++ b/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-commands/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-commands/index.html b/docs/sql-commands/index.html
index 30e8284..a274db8 100644
--- a/docs/sql-commands/index.html
+++ b/docs/sql-commands/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-conditional-expressions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-conditional-expressions/index.html b/docs/sql-conditional-expressions/index.html
index 1876c65..e5c3a44 100644
--- a/docs/sql-conditional-expressions/index.html
+++ b/docs/sql-conditional-expressions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-extensions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-extensions/index.html b/docs/sql-extensions/index.html
index cf41f73..b4dc6a9 100644
--- a/docs/sql-extensions/index.html
+++ b/docs/sql-extensions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-functions/index.html b/docs/sql-functions/index.html
index 7f1a546..e1482c9 100644
--- a/docs/sql-functions/index.html
+++ b/docs/sql-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-reference-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-reference-introduction/index.html b/docs/sql-reference-introduction/index.html
index d3e2804..f6e35fe 100644
--- a/docs/sql-reference-introduction/index.html
+++ b/docs/sql-reference-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-reference/index.html b/docs/sql-reference/index.html
index 74c2049..d83f8ea 100644
--- a/docs/sql-reference/index.html
+++ b/docs/sql-reference/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-window-functions-examples/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions-examples/index.html b/docs/sql-window-functions-examples/index.html
index b8166e3..1072b11 100644
--- a/docs/sql-window-functions-examples/index.html
+++ b/docs/sql-window-functions-examples/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -995,7 +999,7 @@
 
     <div class="int_text" align="left">
       
-        <p>The window function examples use a view named q1_sales that was created from a CSV file named emp_sales and stored in a directory on the local file system:</p>
+        <p>The window function examples use a view named q1_sales that was created from a CSV file named emp_sales and stored in a directory on the local file system.</p>
 
 <p>The emp_sales.csv file contains the following information:  </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   +-----------------+-----------------+------------+--------+
@@ -1041,7 +1045,7 @@
    | true  | Default schema changed to [dfs.emp]  |
    +-------+--------------------------------------+
 </code></pre></div>
-<p>To create the q1_sales view used in the examples, issue the following query with the CREATE VIEW command to Drill.</p>
+<p>To create the q1_sales view used in the examples, issue the following query with the CREATE VIEW command.</p>
 
 <p>Note: You must use column numbers when querying CSV files. Also, CAST the columns to a specific data type to avoid incorrect implicit casting by Drill. This can affect the accuracy of window function results. In Drill, the column array starts with 0 as the first column.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   0: jdbc:drill:zk=local&gt; create view q1_sales as select cast(columns[0] as varchar(30)) as emp_name, cast(columns[1] as varchar(30)) as emp_mgr, cast(columns[2] as int) as dealer_id, cast(columns[3] as int) as sales from `q1_sales.csv`;

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-window-functions-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions-introduction/index.html b/docs/sql-window-functions-introduction/index.html
index 30f6598..3536468 100644
--- a/docs/sql-window-functions-introduction/index.html
+++ b/docs/sql-window-functions-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1041,7 +1045,7 @@ To compare, you can run a query using the AVG() function as a standard set funct
 <p>Window functions are applied to the rows within each partition and sorted according to the order specification.  </p>
 
 <p>The following query uses the AVG() window function with the PARTITION BY clause to determine the average car sales for each dealer in Q1:  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">   select emp_name, dealer_id, sales, avg(sales) over (PARTITION BY dealer_id) as avgsales from q1_sales;
+<div class="highlight"><pre><code class="language-text" data-lang="text">   select emp_name, dealer_id, sales, avg(sales) over (partition by dealer_id) as avgsales from q1_sales;
    +-----------------+------------+--------+-----------+
    |    emp_name     | dealer_id  | sales  | avgsales  |
    +-----------------+------------+--------+-----------+
@@ -1062,7 +1066,7 @@ To compare, you can run a query using the AVG() function as a standard set funct
 
 <p>Currently, Drill supports the following aggregate and ranking window functions:  </p>
 
-<p>Aggregation  </p>
+<p>Aggregate   </p>
 
 <ul>
 <li>AVG()</li>
@@ -1082,15 +1086,14 @@ To compare, you can run a query using the AVG() function as a standard set funct
 <li>ROW_NUMBER()</li>
 </ul>
 
-<p>All of the ranking functions listed depend on the sort ordering specified by the ORDER BY clause of the associated window definition. Rows that are not distinct in the ordering are called peers. The ranking functions are defined so that they give the same answer for any two peer rows.  </p>
+<p>All of the ranking functions depend on the sort ordering specified by the ORDER BY clause of the associated window definition. Rows that are not distinct in the ordering are called peers. The ranking functions are defined so that they give the same answer for any two peer rows.  </p>
 
 <h2 id="syntax">Syntax</h2>
-<div class="highlight"><pre><code class="language-text" data-lang="text">   window_function (expression) 
-   OVER (
+<div class="highlight"><pre><code class="language-text" data-lang="text">   window_function (expression) OVER (
    [ PARTITION BY expr_list ]
    [ ORDER BY order_list ][ frame_clause ] )  
 </code></pre></div>
-<p>where function is one of the functions described, such as AVG() and <em>expr_list</em> is:  </p>
+<p>where function is one of the functions described, such as AVG(), and <em>expr_list</em> is:  </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   expression | column_name [, expr_list ]
 </code></pre></div>
 <p>and <em>order_list</em> is:  </p>
@@ -1127,13 +1130,13 @@ OVER() is a mandatory clause that defines a window within a query result set. OV
 PARTITION BY is an optional clause that subdivides the data into partitions. Including the partition clause divides the query result set into partitions, and the window function is applied to each partition separately. Computation restarts for each partition. If you do not include a partition clause, the function calculates on the entire table or file.  </p>
 
 <p>ORDER BY <em>order_list</em><br>
-The ORDER BY clause defines the logical order of the rows within each partition of the result set. If no PARTITION BY is specified, ORDER BY uses the entire table. ORDER BY is optional for the aggregation window functions, but required for the ranking functions. This ORDER BY clause does not relate to the ORDER BY clause that you use outside of the OVER clause.  </p>
+The ORDER BY clause defines the logical order of the rows within each partition of the result set. If no PARTITION BY is specified, ORDER BY uses the entire table. ORDER BY is optional for the aggregate window functions and required for the ranking functions. This ORDER BY clause does not relate to the ORDER BY clause used outside of the OVER clause.  </p>
 
 <p>The window function is applied to the rows within each partition sorted according to the order specification.  </p>
 
 <p>Column identifiers or expressions that evaluate to column identifiers are required in the order list. You can also use constants as substitutes for column names.  </p>
 
-<p>NULLS are treated as their own group, sorted and ranked last in ASC, and sorted and ranked first in DESC. ASC is the default sort order.  </p>
+<p>NULLS are treated as their own group, sorted and ranked last in ASC and sorted and ranked first in DESC. ASC is the default sort order.  </p>
 
 <p><em>column_name</em><br>
 The name of a column to be partitioned by or ordered by.  </p>
@@ -1148,7 +1151,7 @@ The frame_clause specifies the group of rows that create the window frame. Curre
 <div class="highlight"><pre><code class="language-text" data-lang="text">   RANGE UNBOUNDED PRECEDING
    RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW  
 </code></pre></div>
-<p>When OVER clause does not contain an ORDER BY clause, the following frames are equivalent to the default frame:  </p>
+<p>When the OVER clause does not contain an ORDER BY clause, the following frames are equivalent to the default frame:  </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">   RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
    ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING  
 </code></pre></div>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions/index.html b/docs/sql-window-functions/index.html
index 1ba445d..2b51e9e 100644
--- a/docs/sql-window-functions/index.html
+++ b/docs/sql-window-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/start-up-options/index.html
----------------------------------------------------------------------
diff --git a/docs/start-up-options/index.html b/docs/start-up-options/index.html
index b74ca9f..d7bc987 100644
--- a/docs/start-up-options/index.html
+++ b/docs/start-up-options/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1037,24 +1041,12 @@ override.conf</code> file located in Drill’s<code>/conf</code> directory.</p>
 <p>The summary of start-up options, also known as boot options, lists default values. The following descriptions provide more detail on key options that are frequently reconfigured:</p>
 
 <ul>
-<li>drill.exec.sys.store.provider.class<br></li>
-</ul>
-
-<p>Defines the persistent storage (PStore) provider. The <a href="/docs/persistent-configuration-storage">PStore</a> holds configuration and profile data. </p>
-
-<ul>
-<li>drill.exec.buffer.size</li>
-</ul>
-
-<p>Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option increases the speed at which Drill completes a query.</p>
-
-<ul>
-<li>drill.exec.sort.external.spill.directories</li>
-</ul>
-
-<p>Tells Drill which directory to use when spooling. Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the /tmp directory. Spooling performance (both writing and reading back from it) is constrained by the file system. For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Volumes improve performance and stripe data across as many disks as possible.</p>
-
-<ul>
+<li>drill.exec.sys.store.provider.class<br>
+Defines the persistent storage (PStore) provider. The <a href="/docs/persistent-configuration-storage">PStore</a> holds configuration and profile data.<br></li>
+<li>drill.exec.buffer.size<br>
+Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option increases the speed at which Drill completes a query.<br></li>
+<li>drill.exec.sort.external.spill.directories<br>
+Tells Drill which directory to use when spooling. Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the <code>/tmp</code> directory. Spooling performance (both writing and reading back from it) is constrained by the file system. For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Volumes improve performance and stripe data across as many disks as possible.<br></li>
 <li>drill.exec.zk.connect<br>
 Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.</li>
 </ul>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/starting-drill-in-distributed-mode/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-drill-in-distributed-mode/index.html b/docs/starting-drill-in-distributed-mode/index.html
index e90cd08..9ceee11 100644
--- a/docs/starting-drill-in-distributed-mode/index.html
+++ b/docs/starting-drill-in-distributed-mode/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/starting-drill-on-linux-and-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-drill-on-linux-and-mac-os-x/index.html b/docs/starting-drill-on-linux-and-mac-os-x/index.html
index 9e38c11..07c384a 100644
--- a/docs/starting-drill-on-linux-and-mac-os-x/index.html
+++ b/docs/starting-drill-on-linux-and-mac-os-x/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/starting-drill-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-drill-on-windows/index.html b/docs/starting-drill-on-windows/index.html
index 7ab2aae..b562d75 100644
--- a/docs/starting-drill-on-windows/index.html
+++ b/docs/starting-drill-on-windows/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/storage-plugin-configuration/index.html
----------------------------------------------------------------------
diff --git a/docs/storage-plugin-configuration/index.html b/docs/storage-plugin-configuration/index.html
index 2816fe7..7c92b16 100644
--- a/docs/storage-plugin-configuration/index.html
+++ b/docs/storage-plugin-configuration/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/storage-plugin-registration/index.html
----------------------------------------------------------------------
diff --git a/docs/storage-plugin-registration/index.html b/docs/storage-plugin-registration/index.html
index 9c0079e..c4a72d3 100644
--- a/docs/storage-plugin-registration/index.html
+++ b/docs/storage-plugin-registration/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/string-manipulation/index.html
----------------------------------------------------------------------
diff --git a/docs/string-manipulation/index.html b/docs/string-manipulation/index.html
index f7435b3..154d630 100644
--- a/docs/string-manipulation/index.html
+++ b/docs/string-manipulation/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/summary/index.html
----------------------------------------------------------------------
diff --git a/docs/summary/index.html b/docs/summary/index.html
index 3b0126a..eba4112 100644
--- a/docs/summary/index.html
+++ b/docs/summary/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/supported-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/supported-data-types/index.html b/docs/supported-data-types/index.html
index 3dbe977..eafe3d6 100644
--- a/docs/supported-data-types/index.html
+++ b/docs/supported-data-types/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/supported-sql-commands/index.html
----------------------------------------------------------------------
diff --git a/docs/supported-sql-commands/index.html b/docs/supported-sql-commands/index.html
index 6dc6c2f..7e3415d 100644
--- a/docs/supported-sql-commands/index.html
+++ b/docs/supported-sql-commands/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -998,8 +1002,84 @@
         <p>The following table provides a list of the SQL commands that Drill supports,
 with their descriptions and example syntax:</p>
 
-<table style='table-layout:fixed;width:100%'>
-    <tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td valign="top" width="15%"><a href="/docs/alter-session">ALTER SESSION</a></td><td valign="top" width="60%">Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to <a href="/docs/planning-and-execution-options">Planning and Execution Options</a>.</td><td valign="top"><pre>ALTER SESSION SET `&lt;option_name&gt;`=&lt;value&gt;;</pre></td></tr><tr><td valign="top" ><a href="/docs/alter-system">ALTER SYSTEM</a></td><td valign="top" >Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to <a href="/docs/planning-and-execution-options">Planning and Execution Options</a>.</td><td valign="top" ><pre>ALTER SYSTEM SET `&lt;option_name&gt;`=&lt;value&gt;;</pre></td></tr><tr><td valign="top" ><p><a href="/docs/create-table-as--cta
 s">CREATE TABLE AS<br />(CTAS)</a></p></td><td valign="top" >Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. When you issue the CTAS command, you create a directory that contains parquet or CSV files. Each workspace in a file system has a default file type.<br />You can specify which writer you want Drill to use when creating a table: parquet, CSV, or JSON (as specified with the <code>store.format</code> option).</td><td valign="top" ><pre class="programlisting">CREATE TABLE new_table_name AS &lt;query&gt;;</pre></td></tr><tr><td - valign="top" ><a href="/docs/create-view">CREATE VIEW </a></td><td - valign="top" >Creates a virtual structure for the result set of a stored query.-</td><td -valign="top" ><pre>CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS &lt;query&gt;;</pre></td></tr><tr><td  valign="top" ><a href="/docs/describe">DESCRIBE</a></td><td 
  valign="top" >Returns information about columns in a table or view.</td><td valign="top" ><pre>DESCRIBE [workspace.]table_name|view_name</pre></td></tr><tr><td valign="top" ><a href="/docs/drop-view">DROP VIEW</a></td><td valign="top" >Removes a view.</td><td valign="top" ><pre>DROP VIEW [workspace.]view_name ;</pre></td></tr><tr><td  valign="top" ><a href="/docs/explain">EXPLAIN PLAN FOR</a></td><td valign="top" >Returns the physical plan for a particular query.</td><td valign="top" ><pre>EXPLAIN PLAN FOR &lt;query&gt;;</pre></td></tr><tr><td valign="top" ><a href="/docs/explain">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td valign="top" >Returns the logical plan for a particular query.</td><td  valign="top" ><pre>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR &lt;query&gt;;</pre></td></tr><tr><td colspan="1" valign="top" ><a href="/docs/select" rel="nofollow">SELECT</a></td><td valign="top" >Retrieves data from tables and files.</td><td  valign="top" ><pre>[WITH subquery]<br />SEL
 ECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause]<br />[HAVING clause]<br />[ORDER BY clause];</pre></td></tr><tr><td  valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW DATABASES </a></td><td valign="top" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td valign="top" ><pre>SHOW DATABASES;</pre></td></tr><tr><td valign="top" ><a href="/docs/show-files" >SHOW FILES</a></td><td valign="top" >Returns a list of files in a file system schema.</td><td valign="top" ><pre>SHOW FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</pre></td></tr><tr><td valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW SCHEMAS</a></td><td - valign="top" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td valign="top" ><pre>SHOW SCHEMAS;</pre></td></tr><tr><td valign="top" ><a href="/docs/show-tables">SHOW TABLES</a></td><td valign="top" >Returns a list of tables and views.</t
 d><td valign="top" ><pre>SHOW TABLES;</pre></td></tr><tr><td valign="top" ><a href="/docs/use">USE</a></td><td valign="top" >Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td><td valign="top" ><pre>USE schema_name;</pre></td></tr></table>
+<table><thead>
+<tr>
+<th>Command</th>
+<th>Description</th>
+<th>Syntax</th>
+</tr>
+</thead><tbody>
+<tr>
+<td><a href="/docs/alter-session">ALTER SESSION</a></td>
+<td>Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to Planning and Execution Options.</td>
+<td>ALTER SESSION SET `option_name` = value;</td>
+</tr>
+<tr>
+<td><a href="/docs/alter-system">ALTER SYSTEM</a></td>
+<td>Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to Planning and Execution Options.</td>
+<td>ALTER SYSTEM SET `option_name`=value;</td>
+</tr>
+<tr>
+<td><a href="/docs/create-table-as--ctas">CREATE TABLE AS(CTAS) </a></td>
+<td>Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO.</td>
+<td>CREATE TABLE name AS query;</td>
+</tr>
+<tr>
+<td><a href="/docs/create-view">CREATE VIEW</a></td>
+<td>Creates a virtual structure for the result set of a stored query.-</td>
+<td>CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS query;</td>
+</tr>
+<tr>
+<td><a href="/docs/describe">DESCRIBE </a></td>
+<td>Returns information about columns in a table or view.</td>
+<td>DESCRIBE [workspace.]table_name</td>
+</tr>
+<tr>
+<td><a href="/docs/drop-view">DROP VIEW</a></td>
+<td>Removes a view.</td>
+<td>DROP VIEW [workspace.]view_name ;</td>
+</tr>
+<tr>
+<td><a href="/docs/explain">EXPLAIN PLAN FOR</a></td>
+<td>Returns the physical plan for a particular query.</td>
+<td>EXPLAIN PLAN FOR query;</td>
+</tr>
+<tr>
+<td><a href="/docs/explain">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td>
+<td>Returns the logical plan for a particular query.</td>
+<td>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR query;</td>
+</tr>
+<tr>
+<td><a href="/docs/select">SELECT</a></td>
+<td>Retrieves data from tables and files.</td>
+<td>[WITH subquery]SELECT column_list FROM table_name[WHERE clause] [GROUP BY clause][HAVING clause][ORDER BY clause];</td>
+</tr>
+<tr>
+<td><a href="/docs/show-databases-and-show-schemas">SHOW DATABASES</a></td>
+<td>Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td>
+<td>SHOW DATABASES;</td>
+</tr>
+<tr>
+<td><a href="/docs/show-files">SHOW FILES</a></td>
+<td>Returns a list of files in a file system schema.</td>
+<td>SHOW FILES IN&#124;FROM filesystem.`schema_name`;</td>
+</tr>
+<tr>
+<td><a href="/docs/show-databases-and-show-schemas">SHOW SCHEMAS</a></td>
+<td>Returns a list of available schemas. Equivalent to SHOW DATABASES.</td>
+<td>SHOW SCHEMAS;</td>
+</tr>
+<tr>
+<td><a href="/docs/show-tables">SHOW TABLES</a></td>
+<td>Returns a list of tables and views.</td>
+<td>SHOW TABLES;</td>
+</tr>
+<tr>
+<td><a href="/docs/use">USE</a></td>
+<td>Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td>
+<td>USE schema_name;</td>
+</tr>
+</tbody></table>
 
     
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/tableau-examples/index.html
----------------------------------------------------------------------
diff --git a/docs/tableau-examples/index.html b/docs/tableau-examples/index.html
index 50127ed..6b6ccf0 100644
--- a/docs/tableau-examples/index.html
+++ b/docs/tableau-examples/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/testing-the-odbc-connection/index.html
----------------------------------------------------------------------
diff --git a/docs/testing-the-odbc-connection/index.html b/docs/testing-the-odbc-connection/index.html
index 3e404b1..cd1908e 100644
--- a/docs/testing-the-odbc-connection/index.html
+++ b/docs/testing-the-odbc-connection/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/troubleshooting/index.html
----------------------------------------------------------------------
diff --git a/docs/troubleshooting/index.html b/docs/troubleshooting/index.html
index f0747a3..b225341 100644
--- a/docs/troubleshooting/index.html
+++ b/docs/troubleshooting/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1027,26 +1031,26 @@
 <li><a href="/docs/troubleshooting/#query-parsing-errors">Query Parsing Errors</a></li>
 <li><a href="/docs/troubleshooting/#query-parsing-errors-caused-by-reserved-words">Query Parsing Errors Caused by Reserved Words</a></li>
 <li><a href="/docs/troubleshooting/#table-not-found">Table Not Found</a></li>
-<li><a href="/docs/troubleshooting/#access-nested-fields-without-table-name/alias">Access Nested Fields without Table Name/Alias</a></li>
+<li><a href="/docs/troubleshooting/#access-nested-fields-without-table-name-alias">Access Nested Fields without Table Name/Alias</a></li>
 <li><a href="/docs/troubleshooting/#unexpected-null-values-for-columns-in-results">Unexpected Null Values for Columns in Results</a></li>
 <li><a href="/docs/troubleshooting/#using-functions-with-incorrect-data-types">Using Functions with Incorrect Data Types</a></li>
 <li><a href="/docs/troubleshooting/#query-takes-a-long-time-to-return">Query Takes a Long Time to Return</a></li>
 <li><a href="/docs/troubleshooting/#schema-changes">Schema Changes</a></li>
 <li><a href="/docs/troubleshooting/#timestamps-and-timezones-other-than-utc">Timestamps and Timezones Other Than UTC</a></li>
 <li><a href="/docs/troubleshooting/#unexpected-odbc-issues">Unexpected ODBC Issues</a></li>
-<li><a href="/docs/troubleshooting/#jdbc/odbc-connection-issues-with-zookeeper">JDBC/ODBC Connection Issues with ZooKeeper</a></li>
+<li><a href="/docs/troubleshooting/#jdbc-odbc-connection-issues-with-zookeeper">JDBC/ODBC Connection Issues with ZooKeeper</a></li>
 <li><a href="/docs/troubleshooting/#metadata-queries-take-a-long-time-to-return">Metadata Queries Take a Long Time to Return</a></li>
 <li><a href="/docs/troubleshooting/#unexpected-results-due-to-implicit-casting">Unexpected Results Due to Implicit Casting</a></li>
 <li><a href="/docs/troubleshooting/#column-alias-causes-an-error">Column Alias Causes an Error</a></li>
-<li><a href="/docs/troubleshooting/#list-(array)-contains-null">List (Array) Contains Null</a></li>
-<li><a href="/docs/troubleshooting/#select-count-(*)-takes-a-long-time-to-run">SELECT COUNT (*) Takes a Long Time to Run</a></li>
+<li><a href="/docs/troubleshooting/#list-array-contains-null">List (Array) Contains Null</a></li>
+<li><a href="/docs/troubleshooting/#select-count-takes-a-long-time-to-run">SELECT COUNT (*) Takes a Long Time to Run</a></li>
 <li><a href="/docs/troubleshooting/#tableau-issues">Tableau Issues</a></li>
 <li><a href="/docs/troubleshooting/#group-by-using-alias">GROUP BY Using Alias</a></li>
 <li><a href="/docs/troubleshooting/#casting-a-varchar-string-to-an-integer-causes-an-error">Casting a VARCHAR String to an INTEGER Causes an Error</a></li>
 <li><a href="/docs/troubleshooting/#unexpected-exception-during-fragment-initialization">Unexpected Exception during Fragment Initialization</a></li>
 <li><a href="/docs/troubleshooting/#queries-running-out-of-memory">Queries Running Out of Memory</a></li>
 <li><a href="/docs/troubleshooting/#unclear-error-message">Unclear Error Message</a></li>
-<li><a href="/docs/troubleshooting/#sqlline-error-starting-drill-in-embedded-mode">SQLLine Error Starting Drill in Embedded Mode</a></li>
+<li><a href="/docs/troubleshooting/#error-starting-drill-in-embedded-mode">Error Starting Drill in Embedded Mode</a></li>
 </ul>
 
 <h3 id="memory-issues">Memory Issues</h3>
@@ -1270,7 +1274,7 @@ Turn on ODBC driver debug logging to better understand failure.  </p>
 
 <p>Determine your currently connected drillbit using `SELECT * FROM sys.drillbits.  Then review logs Drill logs from that drillbit.</p>
 
-<h3 id="sqlline-error-starting-drill-in-embedded-mode">SQLLine Error Starting Drill in Embedded Mode</h3>
+<h3 id="error-starting-drill-in-embedded-mode">Error Starting Drill in Embedded Mode</h3>
 
 <p>Symptom:  </p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/tutorials-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorials-introduction/index.html b/docs/tutorials-introduction/index.html
index 030552d..5bd8acf 100644
--- a/docs/tutorials-introduction/index.html
+++ b/docs/tutorials-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/tutorials/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorials/index.html b/docs/tutorials/index.html
index b0951f2..c6f92a2 100644
--- a/docs/tutorials/index.html
+++ b/docs/tutorials/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/union-set-operator/index.html
----------------------------------------------------------------------
diff --git a/docs/union-set-operator/index.html b/docs/union-set-operator/index.html
index 21b705f..7c5d486 100644
--- a/docs/union-set-operator/index.html
+++ b/docs/union-set-operator/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/use/index.html
----------------------------------------------------------------------
diff --git a/docs/use/index.html b/docs/use/index.html
index 50fcf53..40a6538 100644
--- a/docs/use/index.html
+++ b/docs/use/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/useful-research/index.html
----------------------------------------------------------------------
diff --git a/docs/useful-research/index.html b/docs/useful-research/index.html
index 2005888..47ace20 100644
--- a/docs/useful-research/index.html
+++ b/docs/useful-research/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-apache-drill-with-tableau-9-desktop/index.html
----------------------------------------------------------------------
diff --git a/docs/using-apache-drill-with-tableau-9-desktop/index.html b/docs/using-apache-drill-with-tableau-9-desktop/index.html
index 8b92d43..dbf3f58 100644
--- a/docs/using-apache-drill-with-tableau-9-desktop/index.html
+++ b/docs/using-apache-drill-with-tableau-9-desktop/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-apache-drill-with-tableau-9-server/index.html
----------------------------------------------------------------------
diff --git a/docs/using-apache-drill-with-tableau-9-server/index.html b/docs/using-apache-drill-with-tableau-9-server/index.html
index bc46d0b..9ddb543 100644
--- a/docs/using-apache-drill-with-tableau-9-server/index.html
+++ b/docs/using-apache-drill-with-tableau-9-server/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-custom-functions-in-queries/index.html
----------------------------------------------------------------------
diff --git a/docs/using-custom-functions-in-queries/index.html b/docs/using-custom-functions-in-queries/index.html
index 8606220..b18be1b 100644
--- a/docs/using-custom-functions-in-queries/index.html
+++ b/docs/using-custom-functions-in-queries/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-drill-explorer/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-explorer/index.html b/docs/using-drill-explorer/index.html
index bf75cc4..13ce0db 100644
--- a/docs/using-drill-explorer/index.html
+++ b/docs/using-drill-explorer/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-drill-with-bi-tools-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-with-bi-tools-introduction/index.html b/docs/using-drill-with-bi-tools-introduction/index.html
index b2254a5..26693b3 100644
--- a/docs/using-drill-with-bi-tools-introduction/index.html
+++ b/docs/using-drill-with-bi-tools-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-drill-with-bi-tools/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-with-bi-tools/index.html b/docs/using-drill-with-bi-tools/index.html
index 70e9f16..7be7cf4 100644
--- a/docs/using-drill-with-bi-tools/index.html
+++ b/docs/using-drill-with-bi-tools/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-jdbc-with-squirrel-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/using-jdbc-with-squirrel-on-windows/index.html b/docs/using-jdbc-with-squirrel-on-windows/index.html
index 6ae49e6..19ad440 100644
--- a/docs/using-jdbc-with-squirrel-on-windows/index.html
+++ b/docs/using-jdbc-with-squirrel-on-windows/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-microstrategy-analytics-with-apache-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/using-microstrategy-analytics-with-apache-drill/index.html b/docs/using-microstrategy-analytics-with-apache-drill/index.html
index e95cb65..eb95759 100644
--- a/docs/using-microstrategy-analytics-with-apache-drill/index.html
+++ b/docs/using-microstrategy-analytics-with-apache-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-sql-functions-clauses-and-joins/index.html
----------------------------------------------------------------------
diff --git a/docs/using-sql-functions-clauses-and-joins/index.html b/docs/using-sql-functions-clauses-and-joins/index.html
index acb85ef..76ccc44 100644
--- a/docs/using-sql-functions-clauses-and-joins/index.html
+++ b/docs/using-sql-functions-clauses-and-joins/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-the-jdbc-driver/index.html
----------------------------------------------------------------------
diff --git a/docs/using-the-jdbc-driver/index.html b/docs/using-the-jdbc-driver/index.html
index 2778e00..95f9608 100644
--- a/docs/using-the-jdbc-driver/index.html
+++ b/docs/using-the-jdbc-driver/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-tibco-spotfire-desktop-with-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/using-tibco-spotfire-desktop-with-drill/index.html b/docs/using-tibco-spotfire-desktop-with-drill/index.html
index abf853b..a270cf9 100644
--- a/docs/using-tibco-spotfire-desktop-with-drill/index.html
+++ b/docs/using-tibco-spotfire-desktop-with-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/value-vectors/index.html
----------------------------------------------------------------------
diff --git a/docs/value-vectors/index.html b/docs/value-vectors/index.html
index 48ec396..a2ce775 100644
--- a/docs/value-vectors/index.html
+++ b/docs/value-vectors/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/what-is-apache-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/what-is-apache-drill/index.html b/docs/what-is-apache-drill/index.html
index 838eae1..835ad7e 100644
--- a/docs/what-is-apache-drill/index.html
+++ b/docs/what-is-apache-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/where-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/where-clause/index.html b/docs/where-clause/index.html
index 8d23379..b0c1e64 100644
--- a/docs/where-clause/index.html
+++ b/docs/where-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/why-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/why-drill/index.html b/docs/why-drill/index.html
index cb3ff2b..e3e1ca0 100644
--- a/docs/why-drill/index.html
+++ b/docs/why-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/wikipedia-edit-history/index.html
----------------------------------------------------------------------
diff --git a/docs/wikipedia-edit-history/index.html b/docs/wikipedia-edit-history/index.html
index 5038fc2..4f7f87c 100644
--- a/docs/wikipedia-edit-history/index.html
+++ b/docs/wikipedia-edit-history/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/with-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/with-clause/index.html b/docs/with-clause/index.html
index fe5a4cc..b10c6b6 100644
--- a/docs/with-clause/index.html
+++ b/docs/with-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1004,8 +1008,9 @@ name, an optional list of column names, and a SELECT statement.</p>
 
 <p>The WITH clause supports the following syntax:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">WITH with_subquery [, ...]
-where with_subquery is:
-with_subquery_table_name [ ( column_name [, ...] ) ] AS ( query ) 
+</code></pre></div>
+<p>where with_subquery is:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">with_subquery_table_name [ ( column_name [, ...] ) ] AS ( query ) 
 </code></pre></div>
 <h2 id="parameters">Parameters</h2>
 
@@ -1019,7 +1024,7 @@ An optional list of output column names for the WITH clause subquery,
 separated by commas. The number of column names specified must be equal to or
 less than the number of columns defined by the subquery.</p>
 
-<p>query<br>
+<p><em>query</em><br>
 Any SELECT query that Drill supports. See
 <a href="/docs/SELECT+Statements">SELECT</a>.</p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/workspaces/index.html
----------------------------------------------------------------------
diff --git a/docs/workspaces/index.html b/docs/workspaces/index.html
index 0449fdd..ecabf88 100644
--- a/docs/workspaces/index.html
+++ b/docs/workspaces/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index f60ea97..0e1f791 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
 </description>
     <link>/</link>
     <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Tue, 30 Jun 2015 18:35:04 -0700</pubDate>
-    <lastBuildDate>Tue, 30 Jun 2015 18:35:04 -0700</lastBuildDate>
+    <pubDate>Wed, 01 Jul 2015 16:49:25 -0700</pubDate>
+    <lastBuildDate>Wed, 01 Jul 2015 16:49:25 -0700</lastBuildDate>
     <generator>Jekyll v2.5.2</generator>
     
       <item>


[3/4] drill-site git commit: Edits to Drill 1.1 Docs

Posted by br...@apache.org.
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/describe/index.html
----------------------------------------------------------------------
diff --git a/docs/describe/index.html b/docs/describe/index.html
index f2e7382..8fe5b20 100644
--- a/docs/describe/index.html
+++ b/docs/describe/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/design-docs/index.html
----------------------------------------------------------------------
diff --git a/docs/design-docs/index.html b/docs/design-docs/index.html
index 4749534..8dd59a7 100644
--- a/docs/design-docs/index.html
+++ b/docs/design-docs/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/develop-a-simple-function/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-a-simple-function/index.html b/docs/develop-a-simple-function/index.html
index f94b678..06b9492 100644
--- a/docs/develop-a-simple-function/index.html
+++ b/docs/develop-a-simple-function/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/develop-custom-functions-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-custom-functions-introduction/index.html b/docs/develop-custom-functions-introduction/index.html
index 0f510e6..a378a3c 100644
--- a/docs/develop-custom-functions-introduction/index.html
+++ b/docs/develop-custom-functions-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/develop-custom-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-custom-functions/index.html b/docs/develop-custom-functions/index.html
index db41450..66a1398 100644
--- a/docs/develop-custom-functions/index.html
+++ b/docs/develop-custom-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/develop-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/develop-drill/index.html b/docs/develop-drill/index.html
index d217c92..7575038 100644
--- a/docs/develop-drill/index.html
+++ b/docs/develop-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/developer-information/index.html
----------------------------------------------------------------------
diff --git a/docs/developer-information/index.html b/docs/developer-information/index.html
index 798179b..20b94d7 100644
--- a/docs/developer-information/index.html
+++ b/docs/developer-information/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/developing-an-aggregate-function/index.html
----------------------------------------------------------------------
diff --git a/docs/developing-an-aggregate-function/index.html b/docs/developing-an-aggregate-function/index.html
index 3b61d0d..cc46cad 100644
--- a/docs/developing-an-aggregate-function/index.html
+++ b/docs/developing-an-aggregate-function/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/distributed-mode-prerequisites/index.html
----------------------------------------------------------------------
diff --git a/docs/distributed-mode-prerequisites/index.html b/docs/distributed-mode-prerequisites/index.html
index ea8908f..2372af9 100644
--- a/docs/distributed-mode-prerequisites/index.html
+++ b/docs/distributed-mode-prerequisites/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-default-input-format/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-default-input-format/index.html b/docs/drill-default-input-format/index.html
index 59cd590..3fa1d99 100644
--- a/docs/drill-default-input-format/index.html
+++ b/docs/drill-default-input-format/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-explorer-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-explorer-introduction/index.html b/docs/drill-explorer-introduction/index.html
index e8a69a6..aa5650e 100644
--- a/docs/drill-explorer-introduction/index.html
+++ b/docs/drill-explorer-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-in-10-minutes/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-in-10-minutes/index.html b/docs/drill-in-10-minutes/index.html
index 2f762fe..7f9c288 100644
--- a/docs/drill-in-10-minutes/index.html
+++ b/docs/drill-in-10-minutes/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-introduction/index.html b/docs/drill-introduction/index.html
index 91985a7..6c9a4f0 100644
--- a/docs/drill-introduction/index.html
+++ b/docs/drill-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-patch-review-tool/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-patch-review-tool/index.html b/docs/drill-patch-review-tool/index.html
index bc20403..23f438d 100644
--- a/docs/drill-patch-review-tool/index.html
+++ b/docs/drill-patch-review-tool/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-plan-syntax/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-plan-syntax/index.html b/docs/drill-plan-syntax/index.html
index 28fda98..3c2a177 100644
--- a/docs/drill-plan-syntax/index.html
+++ b/docs/drill-plan-syntax/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drill-query-execution/index.html
----------------------------------------------------------------------
diff --git a/docs/drill-query-execution/index.html b/docs/drill-query-execution/index.html
index a407a9c..c36d461 100644
--- a/docs/drill-query-execution/index.html
+++ b/docs/drill-query-execution/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/drop-view/index.html
----------------------------------------------------------------------
diff --git a/docs/drop-view/index.html b/docs/drop-view/index.html
index 68ae42b..49271ed 100644
--- a/docs/drop-view/index.html
+++ b/docs/drop-view/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/embedded-mode-prerequisites/index.html
----------------------------------------------------------------------
diff --git a/docs/embedded-mode-prerequisites/index.html b/docs/embedded-mode-prerequisites/index.html
index dc07d9f..80ca128 100644
--- a/docs/embedded-mode-prerequisites/index.html
+++ b/docs/embedded-mode-prerequisites/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/enabling-query-queuing/index.html
----------------------------------------------------------------------
diff --git a/docs/enabling-query-queuing/index.html b/docs/enabling-query-queuing/index.html
index 24d3a02..4be837a 100644
--- a/docs/enabling-query-queuing/index.html
+++ b/docs/enabling-query-queuing/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/enron-emails/index.html
----------------------------------------------------------------------
diff --git a/docs/enron-emails/index.html b/docs/enron-emails/index.html
index ff9b10a..75af6b8 100644
--- a/docs/enron-emails/index.html
+++ b/docs/enron-emails/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/error-messages/index.html
----------------------------------------------------------------------
diff --git a/docs/error-messages/index.html b/docs/error-messages/index.html
index 800f780..d99020f 100644
--- a/docs/error-messages/index.html
+++ b/docs/error-messages/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/explain/index.html
----------------------------------------------------------------------
diff --git a/docs/explain/index.html b/docs/explain/index.html
index 0e861ab..f0a44b1 100644
--- a/docs/explain/index.html
+++ b/docs/explain/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/file-system-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/file-system-storage-plugin/index.html b/docs/file-system-storage-plugin/index.html
index 1806d84..64fc1c4 100644
--- a/docs/file-system-storage-plugin/index.html
+++ b/docs/file-system-storage-plugin/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/flatten/index.html
----------------------------------------------------------------------
diff --git a/docs/flatten/index.html b/docs/flatten/index.html
index 874aaa6..1db57a4 100644
--- a/docs/flatten/index.html
+++ b/docs/flatten/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/from-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/from-clause/index.html b/docs/from-clause/index.html
index 8c441cb..44b45b5 100644
--- a/docs/from-clause/index.html
+++ b/docs/from-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1023,7 +1027,7 @@ A table defined by a subquery in the WITH clause.</p>
 Name of a table or view. In Drill, you can also refer to a file system directory or a specific file.</li>
 </ul></li>
 <li><p><em>alias</em><br>
-A temporary alternative name for a table or view that provides a convenient shortcut for identifying tables in other parts of a query, such as the WHERE clause. You must supply an alias for a table derived from a subquery. In other table references, aliases are optional. The AS keyword is always optional. Drill does not support the GROUP BY alias.</p></li>
+A temporary alternative name for a table or view that provides a convenient shortcut for identifying tables in other parts of a query, such as the WHERE clause. You must supply an alias for a table derived from a subquery. Aliases might be required for <a href="/docs/json-data-model/#analyzing-json">querying nested JSON</a>. Aliases are definitely required to resolve ambiguous references, such as using the name &quot;user&quot; to query the Drill profiles. Drill treats &quot;user&quot; as a function in this case, and the returns unexpected results. If you use a table alias, Drill treats &quot;user&quot; as a column identifier, and the query returns expected results. The AS keyword is always optional. Drill does not support the GROUP BY alias.</p></li>
 <li><p><em>column_alias</em><br>
 A temporary alternative name for a column in a table or view. You can use named column aliases in the SELECT list to provide meaningful names for regular columns and computed columns, such as the results of aggregate functions. You cannot reference column aliases in the following clauses:<br>
    WHERE<br>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/functions-for-handling-nulls/index.html
----------------------------------------------------------------------
diff --git a/docs/functions-for-handling-nulls/index.html b/docs/functions-for-handling-nulls/index.html
index 6dc7acd..805ef3b 100644
--- a/docs/functions-for-handling-nulls/index.html
+++ b/docs/functions-for-handling-nulls/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/getting-started/index.html
----------------------------------------------------------------------
diff --git a/docs/getting-started/index.html b/docs/getting-started/index.html
index 0fe3383..55f991f 100644
--- a/docs/getting-started/index.html
+++ b/docs/getting-started/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/getting-to-know-the-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/getting-to-know-the-drill-sandbox/index.html b/docs/getting-to-know-the-drill-sandbox/index.html
index 01a1a32..2e4f502 100644
--- a/docs/getting-to-know-the-drill-sandbox/index.html
+++ b/docs/getting-to-know-the-drill-sandbox/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/group-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/group-by-clause/index.html b/docs/group-by-clause/index.html
index 056a665..a409ab1 100644
--- a/docs/group-by-clause/index.html
+++ b/docs/group-by-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/guidelines-for-optimizing-aggregation/index.html
----------------------------------------------------------------------
diff --git a/docs/guidelines-for-optimizing-aggregation/index.html b/docs/guidelines-for-optimizing-aggregation/index.html
index 5fe6b65..5b14269 100644
--- a/docs/guidelines-for-optimizing-aggregation/index.html
+++ b/docs/guidelines-for-optimizing-aggregation/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/handling-different-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/handling-different-data-types/index.html b/docs/handling-different-data-types/index.html
index 820c61d..a018537 100644
--- a/docs/handling-different-data-types/index.html
+++ b/docs/handling-different-data-types/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/having-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/having-clause/index.html b/docs/having-clause/index.html
index 8acfc48..9e1f3fd 100644
--- a/docs/having-clause/index.html
+++ b/docs/having-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/hbase-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/hbase-storage-plugin/index.html b/docs/hbase-storage-plugin/index.html
index 1880f00..2b7272e 100644
--- a/docs/hbase-storage-plugin/index.html
+++ b/docs/hbase-storage-plugin/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/hive-storage-plugin/index.html
----------------------------------------------------------------------
diff --git a/docs/hive-storage-plugin/index.html b/docs/hive-storage-plugin/index.html
index d8d5bb0..2e7df78 100644
--- a/docs/hive-storage-plugin/index.html
+++ b/docs/hive-storage-plugin/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/hive-to-drill-data-type-mapping/index.html
----------------------------------------------------------------------
diff --git a/docs/hive-to-drill-data-type-mapping/index.html b/docs/hive-to-drill-data-type-mapping/index.html
index 81aee45..ed0ebb5 100644
--- a/docs/hive-to-drill-data-type-mapping/index.html
+++ b/docs/hive-to-drill-data-type-mapping/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/how-to-run-the-drill-demo/index.html
----------------------------------------------------------------------
diff --git a/docs/how-to-run-the-drill-demo/index.html b/docs/how-to-run-the-drill-demo/index.html
index 7346488..77a23ec 100644
--- a/docs/how-to-run-the-drill-demo/index.html
+++ b/docs/how-to-run-the-drill-demo/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/identifying-performance-issues/index.html
----------------------------------------------------------------------
diff --git a/docs/identifying-performance-issues/index.html b/docs/identifying-performance-issues/index.html
index 56b4498..c73ec45 100644
--- a/docs/identifying-performance-issues/index.html
+++ b/docs/identifying-performance-issues/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/index.html
----------------------------------------------------------------------
diff --git a/docs/index.html b/docs/index.html
index 0e13259..25f60d3 100644
--- a/docs/index.html
+++ b/docs/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/install-drill-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/install-drill-introduction/index.html b/docs/install-drill-introduction/index.html
index d8c2905..073852b 100644
--- a/docs/install-drill-introduction/index.html
+++ b/docs/install-drill-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/install-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/install-drill/index.html b/docs/install-drill/index.html
index a4ca01e..b3795bf 100644
--- a/docs/install-drill/index.html
+++ b/docs/install-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-drill-in-distributed-mode/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-drill-in-distributed-mode/index.html b/docs/installing-drill-in-distributed-mode/index.html
index 5b02b5f..e7b9984 100644
--- a/docs/installing-drill-in-distributed-mode/index.html
+++ b/docs/installing-drill-in-distributed-mode/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-drill-in-embedded-mode/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-drill-in-embedded-mode/index.html b/docs/installing-drill-in-embedded-mode/index.html
index eeb3b31..9eceb8c 100644
--- a/docs/installing-drill-in-embedded-mode/index.html
+++ b/docs/installing-drill-in-embedded-mode/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-drill-on-linux-and-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-drill-on-linux-and-mac-os-x/index.html b/docs/installing-drill-on-linux-and-mac-os-x/index.html
index 8ba061c..0a13480 100644
--- a/docs/installing-drill-on-linux-and-mac-os-x/index.html
+++ b/docs/installing-drill-on-linux-and-mac-os-x/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-drill-on-the-cluster/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-drill-on-the-cluster/index.html b/docs/installing-drill-on-the-cluster/index.html
index a5830db..37e0eac 100644
--- a/docs/installing-drill-on-the-cluster/index.html
+++ b/docs/installing-drill-on-the-cluster/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-drill-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-drill-on-windows/index.html b/docs/installing-drill-on-windows/index.html
index bd22e4a..8f45739 100644
--- a/docs/installing-drill-on-windows/index.html
+++ b/docs/installing-drill-on-windows/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-the-apache-drill-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-apache-drill-sandbox/index.html b/docs/installing-the-apache-drill-sandbox/index.html
index 41c9ed3..6ad9ff3 100644
--- a/docs/installing-the-apache-drill-sandbox/index.html
+++ b/docs/installing-the-apache-drill-sandbox/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-the-driver-on-linux/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-linux/index.html b/docs/installing-the-driver-on-linux/index.html
index 48f96cc..a2b875f 100644
--- a/docs/installing-the-driver-on-linux/index.html
+++ b/docs/installing-the-driver-on-linux/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-the-driver-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-mac-os-x/index.html b/docs/installing-the-driver-on-mac-os-x/index.html
index 1643ef4..b375892 100644
--- a/docs/installing-the-driver-on-mac-os-x/index.html
+++ b/docs/installing-the-driver-on-mac-os-x/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-the-driver-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-windows/index.html b/docs/installing-the-driver-on-windows/index.html
index 92e25e2..2053250 100644
--- a/docs/installing-the-driver-on-windows/index.html
+++ b/docs/installing-the-driver-on-windows/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-the-odbc-driver/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-odbc-driver/index.html b/docs/installing-the-odbc-driver/index.html
index 69ed9c1..dde607d 100644
--- a/docs/installing-the-odbc-driver/index.html
+++ b/docs/installing-the-odbc-driver/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/installing-the-tdc-file-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-tdc-file-on-windows/index.html b/docs/installing-the-tdc-file-on-windows/index.html
index 861a734..b435b7a 100644
--- a/docs/installing-the-tdc-file-on-windows/index.html
+++ b/docs/installing-the-tdc-file-on-windows/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/interfaces-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/interfaces-introduction/index.html b/docs/interfaces-introduction/index.html
index b89349c..ad823e0 100644
--- a/docs/interfaces-introduction/index.html
+++ b/docs/interfaces-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/join-planning-guidelines/index.html
----------------------------------------------------------------------
diff --git a/docs/join-planning-guidelines/index.html b/docs/join-planning-guidelines/index.html
index 22bf6b7..b6d954e 100644
--- a/docs/join-planning-guidelines/index.html
+++ b/docs/join-planning-guidelines/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/json-data-model/index.html
----------------------------------------------------------------------
diff --git a/docs/json-data-model/index.html b/docs/json-data-model/index.html
index 1aa8c1c..84392d9 100644
--- a/docs/json-data-model/index.html
+++ b/docs/json-data-model/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/kvgen/index.html
----------------------------------------------------------------------
diff --git a/docs/kvgen/index.html b/docs/kvgen/index.html
index da0d93d..b4dfc34 100644
--- a/docs/kvgen/index.html
+++ b/docs/kvgen/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/learn-drill-with-the-mapr-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/learn-drill-with-the-mapr-sandbox/index.html b/docs/learn-drill-with-the-mapr-sandbox/index.html
index 777f71e..d13256b 100644
--- a/docs/learn-drill-with-the-mapr-sandbox/index.html
+++ b/docs/learn-drill-with-the-mapr-sandbox/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/lesson-1-learn-about-the-data-set/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-1-learn-about-the-data-set/index.html b/docs/lesson-1-learn-about-the-data-set/index.html
index 50b425c..99d9844 100644
--- a/docs/lesson-1-learn-about-the-data-set/index.html
+++ b/docs/lesson-1-learn-about-the-data-set/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/lesson-2-run-queries-with-ansi-sql/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-2-run-queries-with-ansi-sql/index.html b/docs/lesson-2-run-queries-with-ansi-sql/index.html
index 8c3d79a..8b130be 100644
--- a/docs/lesson-2-run-queries-with-ansi-sql/index.html
+++ b/docs/lesson-2-run-queries-with-ansi-sql/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/lesson-3-run-queries-on-complex-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/lesson-3-run-queries-on-complex-data-types/index.html b/docs/lesson-3-run-queries-on-complex-data-types/index.html
index fc640ad..208b5b2 100644
--- a/docs/lesson-3-run-queries-on-complex-data-types/index.html
+++ b/docs/lesson-3-run-queries-on-complex-data-types/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/lexical-structure/index.html
----------------------------------------------------------------------
diff --git a/docs/lexical-structure/index.html b/docs/lexical-structure/index.html
index 913c7c4..63caaa4 100644
--- a/docs/lexical-structure/index.html
+++ b/docs/lexical-structure/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/limit-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/limit-clause/index.html b/docs/limit-clause/index.html
index 86a30bf..3b6b64e 100644
--- a/docs/limit-clause/index.html
+++ b/docs/limit-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/log-and-debug-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/log-and-debug-introduction/index.html b/docs/log-and-debug-introduction/index.html
index 50f5bd4..e24fda6 100644
--- a/docs/log-and-debug-introduction/index.html
+++ b/docs/log-and-debug-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/log-and-debug/index.html
----------------------------------------------------------------------
diff --git a/docs/log-and-debug/index.html b/docs/log-and-debug/index.html
index 8e0b817..b773d05 100644
--- a/docs/log-and-debug/index.html
+++ b/docs/log-and-debug/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/mapr-db-format/index.html
----------------------------------------------------------------------
diff --git a/docs/mapr-db-format/index.html b/docs/mapr-db-format/index.html
index e97afa2..b4908e8 100644
--- a/docs/mapr-db-format/index.html
+++ b/docs/mapr-db-format/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/math-and-trig/index.html
----------------------------------------------------------------------
diff --git a/docs/math-and-trig/index.html b/docs/math-and-trig/index.html
index 7446c25..9411e44 100644
--- a/docs/math-and-trig/index.html
+++ b/docs/math-and-trig/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/modify-logback-xml/index.html
----------------------------------------------------------------------
diff --git a/docs/modify-logback-xml/index.html b/docs/modify-logback-xml/index.html
index 1bb7d1d..e5e0308 100644
--- a/docs/modify-logback-xml/index.html
+++ b/docs/modify-logback-xml/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/modifying-query-planning-options/index.html
----------------------------------------------------------------------
diff --git a/docs/modifying-query-planning-options/index.html b/docs/modifying-query-planning-options/index.html
index c788bc2..9c21f6b 100644
--- a/docs/modifying-query-planning-options/index.html
+++ b/docs/modifying-query-planning-options/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/mongodb-plugin-for-apache-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/mongodb-plugin-for-apache-drill/index.html b/docs/mongodb-plugin-for-apache-drill/index.html
index ffc42d1..5785261 100644
--- a/docs/mongodb-plugin-for-apache-drill/index.html
+++ b/docs/mongodb-plugin-for-apache-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
----------------------------------------------------------------------
diff --git a/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html b/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
index 184bdf1..8b97166 100644
--- a/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
+++ b/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/nested-data-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/nested-data-functions/index.html b/docs/nested-data-functions/index.html
index f986c40..467eab7 100644
--- a/docs/nested-data-functions/index.html
+++ b/docs/nested-data-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/nested-data-limitations/index.html
----------------------------------------------------------------------
diff --git a/docs/nested-data-limitations/index.html b/docs/nested-data-limitations/index.html
index 15d421c..6938a2b 100644
--- a/docs/nested-data-limitations/index.html
+++ b/docs/nested-data-limitations/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/odbc-configuration-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-configuration-reference/index.html b/docs/odbc-configuration-reference/index.html
index 7aa69af..1edf2a8 100644
--- a/docs/odbc-configuration-reference/index.html
+++ b/docs/odbc-configuration-reference/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/odbc-jdbc-interfaces/index.html
----------------------------------------------------------------------
diff --git a/docs/odbc-jdbc-interfaces/index.html b/docs/odbc-jdbc-interfaces/index.html
index e99ed77..2c2635f 100644
--- a/docs/odbc-jdbc-interfaces/index.html
+++ b/docs/odbc-jdbc-interfaces/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/offset-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/offset-clause/index.html b/docs/offset-clause/index.html
index 2b45d90..04ffaae 100644
--- a/docs/offset-clause/index.html
+++ b/docs/offset-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/operators/index.html
----------------------------------------------------------------------
diff --git a/docs/operators/index.html b/docs/operators/index.html
index 1dcfe18..0490eae 100644
--- a/docs/operators/index.html
+++ b/docs/operators/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/order-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/order-by-clause/index.html b/docs/order-by-clause/index.html
index a181789..b0d556c 100644
--- a/docs/order-by-clause/index.html
+++ b/docs/order-by-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/parquet-format/index.html
----------------------------------------------------------------------
diff --git a/docs/parquet-format/index.html b/docs/parquet-format/index.html
index 2425677..671e1f2 100644
--- a/docs/parquet-format/index.html
+++ b/docs/parquet-format/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/partition-by-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/partition-by-clause/index.html b/docs/partition-by-clause/index.html
index 428c268..96acf62 100644
--- a/docs/partition-by-clause/index.html
+++ b/docs/partition-by-clause/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           
@@ -1007,7 +1011,7 @@
 <p>When the base table in the SELECT statement is schema-less, include columns in the PARTITION BY clause in the table&#39;s column list, or use a select all (SELECT *) statement:  </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE dest_name [ (column, . . .) ]
 [ PARTITION_BY (column, . . .) ] 
-AS SELECT &lt;column_list&gt; FROM &lt;source_name&gt;;
+AS SELECT column_list FROM &lt;source_name&gt;;
 </code></pre></div>
 <p>When columns in the source table have ambiguous names, such as COLUMNS[0], define one or more column aliases in the SELECT statement. Use the alias name or names in the CREATE TABLE list. List aliases in the same order as the corresponding columns in the SELECT statement. Matching order is important because Drill performs an overwrite operation.  </p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE dest_name (alias1, alias2, . . .) 
@@ -1017,7 +1021,7 @@ AS SELECT column1 alias1, column2 alias2, . . .;
 <p>For example:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE by_yr (yr, ngram, occurrances) PARTITION BY (yr) AS SELECT columns[1] yr, columns[0] ngram, columns[2] occurrances FROM `googlebooks-eng-all-5gram-20120701-zo.tsv`;
 </code></pre></div>
-<p>When the partition column is resolved to * column in a schema-less query, the * column cannot be a result of join operation. </p>
+<p>When the partition column is resolved to * column (due to a SELECT * query) in a schema-less query, the * column cannot be a result of join operation. </p>
 
 <p>The output of CTAS using a PARTITION BY clause creates separate files. Each file contains one partition value, and Drill can create multiple files for the same partition value.</p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/partition-pruning/index.html
----------------------------------------------------------------------
diff --git a/docs/partition-pruning/index.html b/docs/partition-pruning/index.html
index a0bc862..fdd36cb 100644
--- a/docs/partition-pruning/index.html
+++ b/docs/partition-pruning/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/performance-tuning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning-introduction/index.html b/docs/performance-tuning-introduction/index.html
index 71dfe7a..aa0fa62 100644
--- a/docs/performance-tuning-introduction/index.html
+++ b/docs/performance-tuning-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/performance-tuning-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning-reference/index.html b/docs/performance-tuning-reference/index.html
index 67dc1d0..8a5a0a6 100644
--- a/docs/performance-tuning-reference/index.html
+++ b/docs/performance-tuning-reference/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/performance-tuning/index.html
----------------------------------------------------------------------
diff --git a/docs/performance-tuning/index.html b/docs/performance-tuning/index.html
index 926c3a4..f1970c0 100644
--- a/docs/performance-tuning/index.html
+++ b/docs/performance-tuning/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/performance/index.html
----------------------------------------------------------------------
diff --git a/docs/performance/index.html b/docs/performance/index.html
index 431b375..e9373ae 100644
--- a/docs/performance/index.html
+++ b/docs/performance/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/persistent-configuration-storage/index.html
----------------------------------------------------------------------
diff --git a/docs/persistent-configuration-storage/index.html b/docs/persistent-configuration-storage/index.html
index 11f366c..4b1bc63 100644
--- a/docs/persistent-configuration-storage/index.html
+++ b/docs/persistent-configuration-storage/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/physical-operators/index.html
----------------------------------------------------------------------
diff --git a/docs/physical-operators/index.html b/docs/physical-operators/index.html
index 9346b5d..8feb99b 100644
--- a/docs/physical-operators/index.html
+++ b/docs/physical-operators/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/planning-and-execution-options/index.html
----------------------------------------------------------------------
diff --git a/docs/planning-and-execution-options/index.html b/docs/planning-and-execution-options/index.html
index d225208..884f513 100644
--- a/docs/planning-and-execution-options/index.html
+++ b/docs/planning-and-execution-options/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/plugin-configuration-basics/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-basics/index.html b/docs/plugin-configuration-basics/index.html
index 93d716a..ba4c54a 100644
--- a/docs/plugin-configuration-basics/index.html
+++ b/docs/plugin-configuration-basics/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/ports-used-by-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/ports-used-by-drill/index.html b/docs/ports-used-by-drill/index.html
index 1a1087e..d802ddb 100644
--- a/docs/ports-used-by-drill/index.html
+++ b/docs/ports-used-by-drill/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/progress-reports/index.html
----------------------------------------------------------------------
diff --git a/docs/progress-reports/index.html b/docs/progress-reports/index.html
index 9595a3c..3f524f4 100644
--- a/docs/progress-reports/index.html
+++ b/docs/progress-reports/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/project-bylaws/index.html
----------------------------------------------------------------------
diff --git a/docs/project-bylaws/index.html b/docs/project-bylaws/index.html
index c29d08c..d89814d 100644
--- a/docs/project-bylaws/index.html
+++ b/docs/project-bylaws/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-audit-logging/index.html
----------------------------------------------------------------------
diff --git a/docs/query-audit-logging/index.html b/docs/query-audit-logging/index.html
index d19e764..001b77d 100644
--- a/docs/query-audit-logging/index.html
+++ b/docs/query-audit-logging/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-data-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/query-data-introduction/index.html b/docs/query-data-introduction/index.html
index 49ffaf6..ab27398 100644
--- a/docs/query-data-introduction/index.html
+++ b/docs/query-data-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-data/index.html
----------------------------------------------------------------------
diff --git a/docs/query-data/index.html b/docs/query-data/index.html
index d70c549..afa6c02 100644
--- a/docs/query-data/index.html
+++ b/docs/query-data/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-directory-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/query-directory-functions/index.html b/docs/query-directory-functions/index.html
index 4c519ff..f6a976a 100644
--- a/docs/query-directory-functions/index.html
+++ b/docs/query-directory-functions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-plans-and-tuning-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans-and-tuning-introduction/index.html b/docs/query-plans-and-tuning-introduction/index.html
index 9d79db1..793a5db 100644
--- a/docs/query-plans-and-tuning-introduction/index.html
+++ b/docs/query-plans-and-tuning-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-plans-and-tuning/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans-and-tuning/index.html b/docs/query-plans-and-tuning/index.html
index 7c7357b..3fec0c0 100644
--- a/docs/query-plans-and-tuning/index.html
+++ b/docs/query-plans-and-tuning/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-plans/index.html
----------------------------------------------------------------------
diff --git a/docs/query-plans/index.html b/docs/query-plans/index.html
index c927bf2..b1be792 100644
--- a/docs/query-plans/index.html
+++ b/docs/query-plans/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-profile-column-descriptions/index.html
----------------------------------------------------------------------
diff --git a/docs/query-profile-column-descriptions/index.html b/docs/query-profile-column-descriptions/index.html
index 733d632..aa6a4f3 100644
--- a/docs/query-profile-column-descriptions/index.html
+++ b/docs/query-profile-column-descriptions/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-profiles/index.html
----------------------------------------------------------------------
diff --git a/docs/query-profiles/index.html b/docs/query-profiles/index.html
index b00b58d..f0aea24 100644
--- a/docs/query-profiles/index.html
+++ b/docs/query-profiles/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/query-stages/index.html
----------------------------------------------------------------------
diff --git a/docs/query-stages/index.html b/docs/query-stages/index.html
index 98120e9..d8ecf5c 100644
--- a/docs/query-stages/index.html
+++ b/docs/query-stages/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-a-file-system-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-a-file-system-introduction/index.html b/docs/querying-a-file-system-introduction/index.html
index 55b2cd5..5ff8dd9 100644
--- a/docs/querying-a-file-system-introduction/index.html
+++ b/docs/querying-a-file-system-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-a-file-system/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-a-file-system/index.html b/docs/querying-a-file-system/index.html
index 168355f..a522e25 100644
--- a/docs/querying-a-file-system/index.html
+++ b/docs/querying-a-file-system/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
             
           

http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-complex-data-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-complex-data-introduction/index.html b/docs/querying-complex-data-introduction/index.html
index f0b94ed..f47b268 100644
--- a/docs/querying-complex-data-introduction/index.html
+++ b/docs/querying-complex-data-introduction/index.html
@@ -906,6 +906,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>