drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bridg...@apache.org
Subject [05/17] drill-site git commit: Bridget/Kris Drill 1.2 Doc Updates
Date Tue, 15 Sep 2015 23:35:59 GMT
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 4c63715..c5f3374 100644
--- a/docs/show-databases-and-show-schemas/index.html
+++ b/docs/show-databases-and-show-schemas/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/show-files/index.html
----------------------------------------------------------------------
diff --git a/docs/show-files/index.html b/docs/show-files/index.html
index 4a7267e..3e2627c 100644
--- a/docs/show-files/index.html
+++ b/docs/show-files/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/show-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/show-tables/index.html b/docs/show-tables/index.html
index 161985b..bec9722 100644
--- a/docs/show-tables/index.html
+++ b/docs/show-tables/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 f8d14d8..86afe6f 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
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-commands/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-commands/index.html b/docs/sql-commands/index.html
index c4a73cc..6711fc2 100644
--- a/docs/sql-commands/index.html
+++ b/docs/sql-commands/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1025,10 +1007,13 @@
           <li><a href="/docs/create-view/">CREATE VIEW</a></li>
         
       
-          <li><a href="/docs/drop-view/">DROP VIEW</a></li>
+          <li><a href="/docs/describe/">DESCRIBE</a></li>
         
       
-          <li><a href="/docs/describe/">DESCRIBE</a></li>
+          <li><a href="/docs/drop-table/">DROP TABLE</a></li>
+        
+      
+          <li><a href="/docs/drop-view/">DROP VIEW</a></li>
         
       
           <li><a href="/docs/explain/">EXPLAIN</a></li>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-conditional-expressions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-conditional-expressions/index.html b/docs/sql-conditional-expressions/index.html
index b584325..14153f8 100644
--- a/docs/sql-conditional-expressions/index.html
+++ b/docs/sql-conditional-expressions/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-extensions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-extensions/index.html b/docs/sql-extensions/index.html
index ba86e29..ebfe873 100644
--- a/docs/sql-extensions/index.html
+++ b/docs/sql-extensions/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-functions/index.html b/docs/sql-functions/index.html
index 90428a6..f2bbb37 100644
--- a/docs/sql-functions/index.html
+++ b/docs/sql-functions/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-reference-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-reference-introduction/index.html b/docs/sql-reference-introduction/index.html
index 7770e2f..fafeac7 100644
--- a/docs/sql-reference-introduction/index.html
+++ b/docs/sql-reference-introduction/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-reference/index.html b/docs/sql-reference/index.html
index 80cc95c..7ff9509 100644
--- a/docs/sql-reference/index.html
+++ b/docs/sql-reference/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1058,6 +1040,8 @@
         
             <li><a href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
         
+            <li><a href="/docs/value-window-functions/">Value Window Functions</a></li>
+        
             <li><a href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
         
         </ul>
@@ -1099,10 +1083,12 @@
         
             <li><a href="/docs/create-view/">CREATE VIEW</a></li>
         
-            <li><a href="/docs/drop-view/">DROP VIEW</a></li>
-        
             <li><a href="/docs/describe/">DESCRIBE</a></li>
         
+            <li><a href="/docs/drop-table/">DROP TABLE</a></li>
+        
+            <li><a href="/docs/drop-view/">DROP VIEW</a></li>
+        
             <li><a href="/docs/explain/">EXPLAIN</a></li>
         
             <li><a href="/docs/select/">SELECT</a></li>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 3378e68..353e91b 100644
--- a/docs/sql-window-functions-examples/index.html
+++ b/docs/sql-window-functions-examples/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3 current"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1088,7 +1070,7 @@
       
         <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/ranking-window-functions/">← Ranking Window Functions</a></span><span class="next-toc"><a href="/docs/nested-data-functions/">Nested Data Functions →</a></span>
+  <span class="previous-toc"><a href="/docs/value-window-functions/">← Value Window Functions</a></span><span class="next-toc"><a href="/docs/nested-data-functions/">Nested Data Functions →</a></span>
 </div>
 
     

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 c85c7a4..189d18d 100644
--- a/docs/sql-window-functions-introduction/index.html
+++ b/docs/sql-window-functions-introduction/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1089,6 +1071,7 @@ To compare, you can run a query using the AVG() function as a standard set funct
 <ul>
 <li>CUME_DIST()</li>
 <li>DENSE_RANK()</li>
+<li>NTILE()</li>
 <li>PERCENT_RANK()</li>
 <li>RANK()</li>
 <li>ROW_NUMBER()</li>
@@ -1126,6 +1109,7 @@ Any of the following functions used with the OVER clause to provide a window spe
 <li>MIN()</li>
 <li>SUM()</li>
 <li>DENSE_RANK()</li>
+<li>NTILE()</li>
 <li>PERCENT_RANK()</li>
 <li>RANK()</li>
 <li>ROW_NUMBER()</li>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/sql-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions/index.html b/docs/sql-window-functions/index.html
index 3699790..cac2ac9 100644
--- a/docs/sql-window-functions/index.html
+++ b/docs/sql-window-functions/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1016,6 +998,9 @@
           <li><a href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
         
       
+          <li><a href="/docs/value-window-functions/">Value Window Functions</a></li>
+        
+      
           <li><a href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/start-up-options/index.html
----------------------------------------------------------------------
diff --git a/docs/start-up-options/index.html b/docs/start-up-options/index.html
index ae228fa..cb3d270 100644
--- a/docs/start-up-options/index.html
+++ b/docs/start-up-options/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 d21da15..9a7f60d 100644
--- a/docs/starting-drill-in-distributed-mode/index.html
+++ b/docs/starting-drill-in-distributed-mode/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1007,92 +989,96 @@
 
     <div class="int_text" align="left">
       
-        <p>The Drillbit service accepts requests from the client, processing the queries, and returning results to the client. You install Drill as a service and run the Drillbit on all of the required nodes in a Hadoop cluster to form a distributed cluster environment. When a Drillbit runs on each data node in the cluster, Drill maximizes data locality during query execution. Movement of data over the network or between nodes is minimized or eliminated when possible.</p>
+        <p>You start Drill in distributed mode in one of the following ways:</p>
+
+<ul>
+<li>Using the <strong>drillbit.sh</strong> command</li>
+<li>Starting the Drill Shell</li>
+<li>Using an Ad-Hoc Connection to Drill</li>
+</ul>
+
+<h2 id="using-the-drillbit.sh-command">Using the drillbit.sh Command</h2>
+
+<p>To use Drill in distributed mode, you need to control a Drillbit. If you use Drill in embedded mode, you do not use the <strong>drillbit.sh</strong> command. </p>
+
+<p>Using the <strong>drillbit.sh</strong> command you can perform the following tasks:</p>
+
+<ul>
+<li>Check the status of the Drillbit</li>
+<li>Start, stop, or restart a Drillbit</li>
+<li>Configure a Drillbit to restart by default</li>
+</ul>
+
+<p>You can use a configuration file to start Drill. Using such a file is handy for controlling Drillbits on multiple nodes.</p>
 
-<p>To use Drill in distributed mode, you need to control a Drillbit. If you use Drill in embedded mode, you do not use the <strong>drillbit</strong> command. </p>
+<h3 id="drillbit.sh-command-syntax">drillbit.sh Command Syntax</h3>
 
-<p>Using the <strong>drillbit command</strong>, located in the <code>bin</code> directory, you check the status of the Drillbit, start, stop, and restart a DrillBit. You can use a configuration file to start Drill. Using such a file is handy for controlling Drillbits on multiple nodes.</p>
+<p><code>drillbit.sh [--config &lt;conf-dir&gt;] (start|stop|status|restart|autorestart)</code></p>
+
+<p>For example, to restart a Drillbit on a tarball installation, navigate to the Drill installation directory, and issue the following command from the installation directory:</p>
+
+<p><code>bin/drillbit.sh restart</code></p>
 
-<h3 id="drillbit-command-syntax">drillbit Command Syntax</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">drillbit.sh [--config &lt;conf-dir&gt;] (start|stop|status|restart|autorestart)
-</code></pre></div>
-<p>For example, to restart a Drillbit, navigate to the Drill installation directory, and issue the following command:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drillbit.sh restart
-</code></pre></div>
 <h2 id="starting-the-drill-shell">Starting the Drill Shell</h2>
 
-<p>Using the Drill shell, you can connect to relational databases and execute SQL commands. To start the Drill shell, run one of the following scripts, which are located in the bin directory of the Drill installation:</p>
+<p>Using the Drill shell, you can connect to data sources and execute SQL commands. To start the Drill shell, run one of the following scripts, which are located in the bin directory of the Drill installation:</p>
 
 <ul>
 <li><code>drill-conf</code><br>
-Opens the shell using the connection string to ZooKeeper nodes specified in <code>drill-override.conf</code> in <code>/opt/mapr/drill/drill-1.1.0/conf</code>.<br></li>
+Opens the Drill shell using the connection string to ZooKeeper nodes specified in <code>drill-override.conf</code> in <code>&lt;installation directory&gt;/conf</code>.<br></li>
 <li><code>drill-localhost</code><br>
 Opens the Drill shell using a connection to the ZooKeeper running on the local host.</li>
 </ul>
 
-<p>Complete the following steps to start the Drill shell on the local node:</p>
-
-<ol>
-<li><p>Navigate to the Drill installation directory, and issue the following command to start the Drillbit if necessary:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drillbit.sh restart
-</code></pre></div></li>
-<li><p>Issue the following command to start the Drill shell if ZooKeeper is running on the same node as the shell:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drill-localhost
-</code></pre></div>
-<p>Alternatively, issue the following command to start the Drill shell using the connection string in <code>drill-conf</code>:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> bin/drill-conf
-</code></pre></div></li>
-<li><p>Issue the following query to check the Drillbits running in the cluster:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt; select * from sys.drillbits;
-</code></pre></div></li>
-</ol>
-
-<p>Drill provides a list of Drillbits that are running.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">+----------------+---------------+---------------+---------------+-----------+
-|    hostname    | user_port     | control_port  |   data_port   |  current  |
-+----------------+---------------+---------------+---------------+-----------+
-| &lt;host address&gt; | &lt;port number&gt; | &lt;port number&gt; | &lt;port number&gt; | &lt;boolean&gt; |
-+----------------+---------------+---------------+---------------+-----------+
-</code></pre></div>
-<p>Now you can run queries. The Drill installation includes sample data
-that you can query. Refer to <a href="/docs/querying-parquet-files/">Querying Parquet Files</a>.</p>
-
-<h3 id="using-an-ad-hoc-connection-to-drill">Using an Ad-Hoc Connection to Drill</h3>
+<p>The <a href="/docs/starting-drill-on-linux-and-mac-os-x/#about-the-drill-prompt">Drill prompt</a> appears when you start the Drill shell.</p>
+
+<p>Issue the following query to check the Drillbits running in the cluster:
+<code>0: jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt; SELECT * FROM sys.drillbits;</code><br>
+Drill lists information about the Drillbits that are running, such as the host name and data port number.</p>
+
+<h2 id="using-an-ad-hoc-connection-to-drill">Using an Ad-Hoc Connection to Drill</h2>
 
 <p>To use a custom connection to Drill, but not alter the connection string in <code>drill-conf</code> that you normally use, start the Drill shell on an ad-hoc basis using <code>sqlline</code>. For example, to start the Drill shell using a particular storage plugin as a schema, use the following command syntax: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">sqlline –u jdbc:drill:[schema=&lt;storage plugin&gt;;]zk=&lt;zk name&gt;[:&lt;port&gt;][,&lt;zk name2&gt;[:&lt;port&gt;]... ]
-</code></pre></div>
-<h4 id="sqlline-arguments">sqlline Arguments</h4>
+
+<p><code>sqlline –u jdbc:drill:[schema=&lt;storage plugin&gt;;]zk=&lt;zk name&gt;[:&lt;port&gt;][,&lt;zk name2&gt;[:&lt;port&gt;]... ]</code></p>
+
+<h3 id="sqlline-arguments-and-connection-parameters">sqlline Arguments and Connection Parameters</h3>
 
 <ul>
 <li><code>-u</code> is the option that precedes a connection string. Required.<br></li>
-<li><code>jdbc</code> is the connection protocol. Required.<br></li>
-<li><code>schema</code> is the name of a <a href="/docs/storage-plugin-registration">storage plugin</a> to use for queries. Optional.<br></li>
-<li><code>Zk=zkname</code> is one or more ZooKeeper host names or IP addresses.<br></li>
-<li><code>port</code> is the ZooKeeper port number. Optional. Port 2181 is the default.<br></li>
+<li><code>jdbc</code> is the connection type. Required.<br></li>
+<li><code>schema</code> is the name of a <a href="/docs/storage-plugin-registration">storage plugin</a> configuration to use as the default for queries. Optional.<br></li>
+<li><code>zk name</code> specifies one or more ZooKeeper host names or IP addresses.<br></li>
+<li><code>port</code> is the ZooKeeper port number. Optional. Port 2181 is the default for the open source version of Apache Drill.<br></li>
 </ul>
 
-<p>For example, start the Drill shell using the <code>dfs</code> storage plugin. Specifying the storage plugin when you start up eliminates the need to specify the storage plugin in the query:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline –u jdbc:drill:schema=dfs;zk=centos26
-</code></pre></div>
-<p>This command starts the Drill shell in a cluster configured to run ZooKeeper on three nodes:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline –u jdbc:drill:zk=cento23,zk=centos24,zk=centos26:5181
-</code></pre></div>
+<p>For example, start the Drill shell with the default schema being the <code>dfs</code> storage plugin:</p>
+
+<p><code>bin/sqlline –u jdbc:drill:schema=dfs;zk=centos26</code></p>
+
+<p>Specifying the storage plugin configuration name when you start up eliminates the need to enter <code>USE &lt;schema name&gt;</code> or specify the it in the FROM clause.</p>
+
+<p>The following command starts the Drill shell in a cluster configured to run ZooKeeper on three nodes:</p>
+
+<p><code>bin/sqlline –u jdbc:drill:zk=cento23,zk=centos24,zk=centos26:5181</code></p>
+
 <h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2>
 
 <p>To exit the Drill shell, issue the following command:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">!quit
-</code></pre></div>
+
+<p><code>!quit</code></p>
+
 <h2 id="stopping-drill">Stopping Drill</h2>
 
-<p>In some cases, such as stopping while a query is in progress, the <code>!quit</code> command does not stop Drill running in embedded mode. In distributed mode, you stop the Drillbit service. Navigate to the Drill installation directory, and issue the following command to stop a Drillbit:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drillbit.sh stop
-</code></pre></div>
+<p>Navigate to the Drill installation directory, and issue the following command to stop a Drillbit:</p>
+
+<p><code>bin/drillbit.sh stop</code></p>
+
     
       
         <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/installing-drill-on-the-cluster/">← Installing Drill on the Cluster</a></span><span class="next-toc"><a href="/docs/configure-drill/">Configure Drill →</a></span>
+  <span class="previous-toc"><a href="/docs/installing-drill-on-the-cluster/">← Installing Drill on the Cluster</a></span><span class="next-toc"><a href="/docs/starting-the-web-ui/">Starting the Web UI →</a></span>
 </div>
 
     

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 dd07d58..e04c40a 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
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1007,44 +989,42 @@
 
     <div class="int_text" align="left">
       
-        <p>Start the Drill shell using the <code>drill-embedded</code> command. The command uses a jdbc connection string and identifies the local node as the ZooKeeper node. Complete the following steps to start the Drill shell:</p>
+        <p>To start the Drill shell in embedded mode, use the <code>drill-embedded</code> command. Internally, the command uses a jdbc connection string and identifies the local node as the ZooKeeper node. Complete the following steps to start the Drill shell:</p>
 
 <ol>
-<li><p>Navigate to the Drill installation directory. For example:  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">cd apache-drill-1.1.0  
-</code></pre></div></li>
+<li><p>Navigate to the Drill installation directory.</p></li>
 <li><p>Issue the following command to start the Drill shell:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drill-embedded  
-</code></pre></div></li>
+
+<p><code>bin/drill-embedded</code>  </p></li>
 </ol>
 
-<p>The <code>0: jdbc:drill:zk=local&gt;</code>  prompt appears.  </p>
+<p>The <code>0: jdbc:drill:zk=local&gt;</code>  prompt appears. </p>
 
 <p>At this point, you can <a href="/docs/query-data">run queries</a>.</p>
 
-<p>To start Drill, you can also use the <strong>sqlline</strong> command and a custom connection string, as described in detail in <a href="/docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill">&quot;Using an Ad-Hoc Connection to Drill&quot;</a>. For example, you can specify the storage plugin when you start the shell. Doing so eliminates the need to specify the storage plugin in the query. For example, this command specifies the <code>dfs</code> storage plugin:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline –u jdbc:drill:schema=dfs;zk=local
-</code></pre></div>
+<p>To start Drill, you can also use the <strong>sqlline</strong> command and a custom connection string, as described in detail in <a href="/docs/starting-drill-in-distributed-mode/#using-an-ad-hoc-connection-to-drill">&quot;Using an Ad-Hoc Connection to Drill&quot;</a>. For example, you can specify the default storage plugin configuration when you start the shell. Doing so eliminates the need to specify the storage plugin configuration in the query. For example, this command specifies the <code>dfs</code> storage plugin:</p>
+
+<p><code>bin/sqlline –u jdbc:drill:schema=dfs;zk=local</code></p>
+
 <p>If you start Drill on one network, and then want to use Drill on another network, such as your home network, restart Drill.</p>
 
-<h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2>
+<h2 id="about-the-drill-prompt">About the Drill Prompt</h2>
 
-<p>To exit the Drill shell, issue the following command:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">!quit
-</code></pre></div>
-<h2 id="stopping-drill">Stopping Drill</h2>
+<p>In embedded mode, the Drill prompt appears as follows:</p>
 
-<p>In some cases, such as stopping while a query is in progress, the <code>!quit</code> command does not stop Drill running in embedded mode. To stop the Drill process on Mac OS X and Linux, use the kill command. For example, on Mac OS X and Linux, follow these steps:</p>
+<p><code>0: jdbc:drill:zk=local&gt;</code></p>
 
-<ol>
-<li>Issue a CTRL Z to stop the query, then start Drill again. If the startup message indicates success, skip the rest of the steps. If not, proceed to step 2.</li>
-<li><p>Search for the Drill process IDs.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">$ ps auwx | grep drill
-</code></pre></div></li>
-<li><p>Kill each process using the process numbers in the grep output. For example:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">$ sudo kill -9 2674 
-</code></pre></div></li>
-</ol>
+<ul>
+<li>0 is the number of connections to Drill, which can be only one in embedded node. </li>
+<li>jdbc is the connection type.</li>
+<li>zk=local zk=local means the local node substitutes for the ZooKeeper node.</li>
+</ul>
+
+<h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2>
+
+<p>To exit the Drill shell and stop the Drill process on Mac OS X and Linux, issue the following command:</p>
+
+<p><code>!quit</code></p>
 
     
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 f6b98ed..7fa6fc3 100644
--- a/docs/starting-drill-on-windows/index.html
+++ b/docs/starting-drill-on-windows/index.html
@@ -77,10 +77,6 @@
       
         <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
       
-        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-      
-        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-      
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
     </ul>
@@ -249,6 +245,10 @@
             </ul>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+            
+          
           </ul>
         
       
@@ -290,6 +290,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+            
+          
+            
               <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
               <ul style="display: none">
               
@@ -660,6 +664,8 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
               
             </ul>
@@ -702,10 +708,12 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
         
       
         
-          <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
-          <ul style="display: none">
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-            
-          
-          </ul>
-        
-      
-        
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
@@ -1007,34 +989,31 @@
 
     <div class="int_text" align="left">
       
-        <p>Start the Drill shell using the <strong>sqlline command</strong>. The <code>zk=local</code> means the local node is the ZooKeeper node. Complete the following steps to launch the Drill shell:</p>
+        <p>Start the Drill shell using the <strong>sqlline command</strong>. Complete the following steps to launch the Drill shell:</p>
 
 <ol>
 <li>Open Command Prompt.<br></li>
-<li>Open the apache-drill-1.1.0 folder. For example:<br>
-<code>cd apache-drill-1.1.0</code></li>
-<li>Go to the bin directory. For example:<br>
+<li>Navigate to the Drill installation folder. </li>
+<li>Go to the <code>bin</code> directory. For example:<br>
 <code>cd bin</code></li>
 <li>Type the following command on the command line:
 <code>sqlline.bat -u &quot;jdbc:drill:zk=local&quot;</code>
 <img src="/docs/img/sqlline1.png" alt="drill install dir"></li>
 </ol>
 
-<p>At this point, you can <a href="/docs/drill-in-10-minutes#query-sample-data">submit queries</a> to Drill.</p>
+<p>The <a href="/docs/starting-drill-on-linux-and-mac-os-x/#about-the-drill-prompt">Drill prompt</a> appears. You can <a href="/docs/drill-in-10-minutes#query-sample-data">submit queries</a> to Drill.</p>
 
 <p>You can use the schema option in the <strong>sqlline</strong> command to specify a storage plugin. Specifying the storage plugin when you start up eliminates the need to specify the storage plugin in the query. For example, this command specifies the <code>dfs</code> storage plugin:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">C:\bin\sqlline sqlline.bat –u &quot;jdbc:drill:schema=dfs;zk=local&quot;
-</code></pre></div>
+
+<p><code>C:\bin\sqlline sqlline.bat –u &quot;jdbc:drill:schema=dfs;zk=local&quot;</code></p>
+
 <p>If you start Drill on one network, and then want to use Drill on another network, such as your home network, restart Drill.</p>
 
 <h2 id="exiting-the-drill-shell">Exiting the Drill Shell</h2>
 
 <p>To exit the Drill shell, issue the following command:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">!quit
-</code></pre></div>
-<h2 id="stopping-drill">Stopping Drill</h2>
 
-<p>In some cases, such as stopping while a query is in progress, the <code>!quit</code> command does not stop Drill running in embedded mode. To stop the Drill process use the <a href="https://www.microsoft.com/resources/documentation/windows/xp/all/proddocs/en-us/taskkill.mspx?mfr=true"><strong>TaskKill</strong></a> command.</p>
+<p><code>!quit</code></p>
 
     
       


Mime
View raw message