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/09/16 01:36:11 UTC

[17/17] drill-site git commit: Bridget/Kris Drill 1.2 Doc Updates

Bridget/Kris Drill 1.2 Doc Updates


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

Branch: refs/heads/asf-site
Commit: b0ce85e7149cac4f30946bead8e681a03f94b6d4
Parents: 3e2e1d4
Author: Bridget Bevens <bb...@maprtech.com>
Authored: Tue Sep 15 16:35:23 2015 -0700
Committer: Bridget Bevens <bb...@maprtech.com>
Committed: Tue Sep 15 16:35:23 2015 -0700

----------------------------------------------------------------------
 architecture/index.html                         |    4 -
 blog/2014/11/19/sql-on-mongodb/index.html       |    4 -
 .../12/02/drill-top-level-project/index.html    |    4 -
 .../running-sql-queries-on-amazon-s3/index.html |    4 -
 .../index.html                                  |    4 -
 blog/2014/12/16/whats-coming-in-2015/index.html |    4 -
 blog/2014/12/23/drill-0.7-released/index.html   |    4 -
 .../index.html                                  |    4 -
 .../index.html                                  |    4 -
 blog/2015/03/31/drill-0.8-released/index.html   |    4 -
 .../index.html                                  |    4 -
 blog/2015/05/04/drill-0.9-released/index.html   |    4 -
 blog/2015/05/19/drill-1.0-released/index.html   |    4 -
 .../index.html                                  |    4 -
 blog/2015/07/05/drill-1.1-released/index.html   |    4 -
 .../drill-tutorial-at-nosql-now-2015/index.html |    4 -
 blog/index.html                                 |    4 -
 community-resources/index.html                  |    4 -
 data/index.html                                 |   66 +-
 docs/about-sql-function-examples/index.html     |   46 +-
 docs/about-the-mapr-sandbox/index.html          |   46 +-
 .../adding-custom-functions-to-drill/index.html |   46 +-
 .../index.html                                  |   61 +-
 docs/aggregate-window-functions/index.html      |   46 +-
 docs/alter-session/index.html                   |   46 +-
 docs/alter-system/index.html                    |   46 +-
 .../index.html                                  |   46 +-
 docs/analyzing-social-media/index.html          |   46 +-
 .../index.html                                  |   48 +-
 docs/aol-search/index.html                      |   46 +-
 .../apache-drill-0-4-0-release-notes/index.html |   46 +-
 .../apache-drill-0-5-0-release-notes/index.html |   46 +-
 .../apache-drill-0-6-0-release-notes/index.html |   46 +-
 .../apache-drill-0-7-0-release-notes/index.html |   46 +-
 .../apache-drill-0-8-0-release-notes/index.html |   46 +-
 .../apache-drill-0-9-0-release-notes/index.html |   46 +-
 .../apache-drill-1-0-0-release-notes/index.html |   46 +-
 .../apache-drill-1-1-0-release-notes/index.html |   46 +-
 .../index.html                                  |   48 +-
 docs/apache-drill-contribution-ideas/index.html |   46 +-
 .../index.html                                  |   46 +-
 docs/architecture-introduction/index.html       |   46 +-
 docs/architecture/index.html                    |   46 +-
 .../browsing-data-and-defining-views/index.html |   46 +-
 docs/case/index.html                            |   50 +-
 docs/choosing-a-storage-format/index.html       |   46 +-
 docs/compiling-drill-from-source/index.html     |   46 +-
 .../index.html                                  |   46 +-
 docs/configuration-options/index.html           |   48 +-
 docs/configure-drill-introduction/index.html    |   46 +-
 docs/configure-drill/index.html                 |   51 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 docs/configuring-drill-memory/index.html        |   46 +-
 docs/configuring-jreport-with-drill/index.html  |   46 +-
 .../index.html                                  |   46 +-
 docs/configuring-odbc-on-linux/index.html       |   46 +-
 docs/configuring-odbc-on-mac-os-x/index.html    |   46 +-
 docs/configuring-odbc-on-windows/index.html     |   46 +-
 docs/configuring-odbc/index.html                |   46 +-
 .../index.html                                  |   46 +-
 docs/configuring-the-drill-shell/index.html     |   46 +-
 .../index.html                                  |   46 +-
 docs/configuring-user-authentication/index.html |   46 +-
 .../index.html                                  |   48 +-
 docs/configuring-user-impersonation/index.html  |   46 +-
 .../index.html                                  | 1346 ++++++++++++++++++
 .../index.html                                  |   46 +-
 docs/connect-a-data-source/index.html           |   46 +-
 .../index.html                                  |   46 +-
 docs/contribute-to-drill/index.html             |   46 +-
 .../index.html                                  |   46 +-
 docs/core-modules/index.html                    |   46 +-
 docs/create-table-as-ctas/index.html            |   46 +-
 docs/create-view/index.html                     |   48 +-
 docs/custom-function-interfaces/index.html      |   46 +-
 .../index.html                                  |   46 +-
 docs/data-sources-and-file-formats/index.html   |   46 +-
 docs/data-type-conversion/index.html            |   55 +-
 docs/data-types/index.html                      |   46 +-
 docs/date-time-and-timestamp/index.html         |   46 +-
 .../index.html                                  |   95 +-
 docs/deploying-and-using-a-hive-udf/index.html  |   46 +-
 docs/describe/index.html                        |   50 +-
 docs/design-docs/index.html                     |   46 +-
 .../index.html                                  |   46 +-
 docs/develop-custom-functions/index.html        |   46 +-
 docs/develop-drill/index.html                   |   46 +-
 docs/developer-information/index.html           |   46 +-
 docs/developing-a-simple-function/index.html    |   46 +-
 .../developing-an-aggregate-function/index.html |   46 +-
 docs/distributed-mode-prerequisites/index.html  |   69 +-
 docs/drill-default-input-format/index.html      |   46 +-
 docs/drill-explorer-introduction/index.html     |   46 +-
 docs/drill-in-10-minutes/index.html             |  114 +-
 docs/drill-introduction/index.html              |   46 +-
 docs/drill-patch-review-tool/index.html         |   46 +-
 docs/drill-plan-syntax/index.html               |   46 +-
 docs/drill-query-execution/index.html           |   46 +-
 docs/drop-table/index.html                      | 1289 +++++++++++++++++
 docs/drop-view/index.html                       |   50 +-
 docs/embedded-mode-prerequisites/index.html     |   46 +-
 docs/enabling-query-queuing/index.html          |   46 +-
 docs/enron-emails/index.html                    |   46 +-
 docs/error-messages/index.html                  |   46 +-
 docs/explain/index.html                         |   48 +-
 docs/file-system-storage-plugin/index.html      |   46 +-
 docs/flatten/index.html                         |   46 +-
 docs/from-clause/index.html                     |   46 +-
 docs/functions-for-handling-nulls/index.html    |   46 +-
 docs/getting-started/index.html                 |   46 +-
 .../index.html                                  |   46 +-
 docs/group-by-clause/index.html                 |   46 +-
 .../index.html                                  |   46 +-
 docs/handling-different-data-types/index.html   |   46 +-
 docs/having-clause/index.html                   |   46 +-
 docs/hbase-storage-plugin/index.html            |   46 +-
 docs/hive-storage-plugin/index.html             |   46 +-
 docs/hive-to-drill-data-type-mapping/index.html |   46 +-
 docs/identifying-performance-issues/index.html  |   46 +-
 docs/img/plugin-default.png                     |  Bin 56412 -> 70859 bytes
 docs/img/web-ui-admin-view.png                  |  Bin 0 -> 45701 bytes
 docs/img/web-ui-login.png                       |  Bin 0 -> 45535 bytes
 docs/img/web-ui-user-view.png                   |  Bin 0 -> 47799 bytes
 docs/img/web-ui.png                             |  Bin 0 -> 43194 bytes
 docs/index.html                                 |   46 +-
 docs/install-drill-introduction/index.html      |   46 +-
 docs/install-drill/index.html                   |   49 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   56 +-
 docs/installing-drill-on-the-cluster/index.html |   69 +-
 docs/installing-drill-on-windows/index.html     |   51 +-
 .../index.html                                  |   46 +-
 docs/installing-the-driver-on-linux/index.html  |   46 +-
 .../index.html                                  |   46 +-
 .../installing-the-driver-on-windows/index.html |   46 +-
 docs/installing-the-odbc-driver/index.html      |   46 +-
 .../index.html                                  |   46 +-
 docs/interfaces-introduction/index.html         |   46 +-
 docs/join-planning-guidelines/index.html        |   46 +-
 docs/json-data-model/index.html                 |   46 +-
 docs/kvgen/index.html                           |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 docs/lexical-structure/index.html               |   46 +-
 docs/limit-clause/index.html                    |   46 +-
 docs/log-and-debug-introduction/index.html      |   46 +-
 docs/log-and-debug/index.html                   |   46 +-
 docs/mapr-db-format/index.html                  |   46 +-
 docs/math-and-trig/index.html                   |   46 +-
 docs/modify-logback-xml/index.html              |   46 +-
 .../modifying-query-planning-options/index.html |   46 +-
 docs/mongodb-plugin-for-apache-drill/index.html |   46 +-
 .../index.html                                  |   48 +-
 docs/nested-data-functions/index.html           |   46 +-
 docs/nested-data-limitations/index.html         |   46 +-
 docs/odbc-configuration-reference/index.html    |   46 +-
 docs/odbc-jdbc-interfaces/index.html            |   46 +-
 docs/offset-clause/index.html                   |   46 +-
 docs/operators/index.html                       |   51 +-
 docs/order-by-clause/index.html                 |   46 +-
 docs/parquet-format/index.html                  |   68 +-
 docs/partition-by-clause/index.html             |   46 +-
 docs/partition-pruning/index.html               |   46 +-
 docs/performance-tuning-introduction/index.html |   46 +-
 docs/performance-tuning-reference/index.html    |   46 +-
 docs/performance-tuning/index.html              |   46 +-
 docs/performance/index.html                     |   46 +-
 .../persistent-configuration-storage/index.html |   46 +-
 docs/physical-operators/index.html              |   46 +-
 docs/planning-and-execution-options/index.html  |   46 +-
 docs/plugin-configuration-basics/index.html     |   52 +-
 docs/ports-used-by-drill/index.html             |   46 +-
 docs/project-bylaws/index.html                  |   48 +-
 docs/query-audit-logging/index.html             |   46 +-
 docs/query-data-introduction/index.html         |   46 +-
 docs/query-data/index.html                      |   46 +-
 docs/query-directory-functions/index.html       |   46 +-
 .../index.html                                  |   46 +-
 docs/query-plans-and-tuning/index.html          |   46 +-
 docs/query-plans/index.html                     |   46 +-
 .../index.html                                  |   46 +-
 docs/query-profiles/index.html                  |   46 +-
 docs/query-stages/index.html                    |   46 +-
 .../index.html                                  |   46 +-
 docs/querying-a-file-system/index.html          |   46 +-
 .../index.html                                  |   46 +-
 docs/querying-complex-data/index.html           |   46 +-
 docs/querying-directories/index.html            |   46 +-
 docs/querying-hbase/index.html                  |   48 +-
 docs/querying-hive/index.html                   |   46 +-
 docs/querying-json-files/index.html             |   73 +-
 docs/querying-parquet-files/index.html          |   74 +-
 docs/querying-plain-text-files/index.html       |   46 +-
 docs/querying-system-tables/index.html          |   46 +-
 docs/querying-the-information-schema/index.html |   46 +-
 docs/ranking-window-functions/index.html        |   93 +-
 docs/release-notes/index.html                   |   46 +-
 docs/repeated-contains/index.html               |   46 +-
 docs/repeated-count/index.html                  |   46 +-
 docs/reserved-keywords/index.html               |   46 +-
 docs/review-the-java-stack-trace/index.html     |   46 +-
 docs/rpc-overview/index.html                    |   46 +-
 docs/sample-data-donuts/index.html              |   46 +-
 docs/sample-datasets/index.html                 |   46 +-
 docs/select-list/index.html                     |   46 +-
 docs/select/index.html                          |   46 +-
 docs/selecting-flat-data/index.html             |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 docs/show-databases-and-show-schemas/index.html |   46 +-
 docs/show-files/index.html                      |   46 +-
 docs/show-tables/index.html                     |   46 +-
 .../index.html                                  |   46 +-
 docs/sql-commands/index.html                    |   53 +-
 docs/sql-conditional-expressions/index.html     |   46 +-
 docs/sql-extensions/index.html                  |   46 +-
 docs/sql-functions/index.html                   |   46 +-
 docs/sql-reference-introduction/index.html      |   46 +-
 docs/sql-reference/index.html                   |   54 +-
 docs/sql-window-functions-examples/index.html   |   48 +-
 .../index.html                                  |   48 +-
 docs/sql-window-functions/index.html            |   49 +-
 docs/start-up-options/index.html                |   46 +-
 .../index.html                                  |  166 +--
 .../index.html                                  |   94 +-
 docs/starting-drill-on-windows/index.html       |   65 +-
 docs/starting-the-web-ui/index.html             | 1040 ++++++++++++++
 docs/storage-plugin-configuration/index.html    |   46 +-
 docs/storage-plugin-registration/index.html     |   62 +-
 docs/string-manipulation/index.html             |   46 +-
 docs/summary/index.html                         |   46 +-
 docs/supported-data-types/index.html            |   46 +-
 docs/supported-sql-commands/index.html          |   46 +-
 docs/tableau-examples/index.html                |   46 +-
 docs/testing-the-odbc-connection/index.html     |   46 +-
 docs/text-files-csv-tsv-psv/index.html          |   46 +-
 docs/troubleshooting/index.html                 |   46 +-
 .../index.html                                  |   52 +-
 docs/tutorials-introduction/index.html          |   46 +-
 docs/tutorials/index.html                       |   46 +-
 docs/union-set-operator/index.html              |   46 +-
 docs/use/index.html                             |   46 +-
 docs/useful-research/index.html                 |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   48 +-
 docs/using-drill-explorer/index.html            |   46 +-
 .../index.html                                  |   46 +-
 docs/using-drill-with-bi-tools/index.html       |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 .../index.html                                  |   46 +-
 docs/using-the-jdbc-driver/index.html           |  184 ++-
 .../index.html                                  |   46 +-
 docs/value-vectors/index.html                   |   46 +-
 docs/value-window-functions/index.html          | 1175 +++++++++++++++
 docs/where-clause/index.html                    |   46 +-
 docs/why-drill/index.html                       |   46 +-
 docs/wikipedia-edit-history/index.html          |   48 +-
 docs/with-clause/index.html                     |   46 +-
 docs/workspaces/index.html                      |   46 +-
 download/index.html                             |    4 -
 faq/index.html                                  |    4 -
 feed.xml                                        |    4 +-
 index.html                                      |    4 -
 mailinglists/index.html                         |    4 -
 overview/index.html                             |    4 -
 search/index.html                               |    4 -
 team/index.html                                 |    4 -
 toc/index.html                                  | 1345 ++---------------
 why/index.html                                  |    4 -
 275 files changed, 8730 insertions(+), 9289 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/architecture/index.html
----------------------------------------------------------------------
diff --git a/architecture/index.html b/architecture/index.html
index ccd143a..5131f9c 100644
--- a/architecture/index.html
+++ b/architecture/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2014/11/19/sql-on-mongodb/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/11/19/sql-on-mongodb/index.html b/blog/2014/11/19/sql-on-mongodb/index.html
index 6f3c9e3..00411d7 100644
--- a/blog/2014/11/19/sql-on-mongodb/index.html
+++ b/blog/2014/11/19/sql-on-mongodb/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2014/12/02/drill-top-level-project/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/12/02/drill-top-level-project/index.html b/blog/2014/12/02/drill-top-level-project/index.html
index 3daa854..f28e620 100644
--- a/blog/2014/12/02/drill-top-level-project/index.html
+++ b/blog/2014/12/02/drill-top-level-project/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2014/12/09/running-sql-queries-on-amazon-s3/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/12/09/running-sql-queries-on-amazon-s3/index.html b/blog/2014/12/09/running-sql-queries-on-amazon-s3/index.html
index fc2801c..e1fb271 100644
--- a/blog/2014/12/09/running-sql-queries-on-amazon-s3/index.html
+++ b/blog/2014/12/09/running-sql-queries-on-amazon-s3/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
index 16fd570..548a456 100644
--- a/blog/2014/12/11/apache-drill-qa-panelist-spotlight/index.html
+++ b/blog/2014/12/11/apache-drill-qa-panelist-spotlight/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2014/12/16/whats-coming-in-2015/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/12/16/whats-coming-in-2015/index.html b/blog/2014/12/16/whats-coming-in-2015/index.html
index 36ffc53..21094d3 100644
--- a/blog/2014/12/16/whats-coming-in-2015/index.html
+++ b/blog/2014/12/16/whats-coming-in-2015/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2014/12/23/drill-0.7-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2014/12/23/drill-0.7-released/index.html b/blog/2014/12/23/drill-0.7-released/index.html
index b95a686..3d46f44 100644
--- a/blog/2014/12/23/drill-0.7-released/index.html
+++ b/blog/2014/12/23/drill-0.7-released/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/01/27/schema-free-json-data-infrastructure/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/01/27/schema-free-json-data-infrastructure/index.html b/blog/2015/01/27/schema-free-json-data-infrastructure/index.html
index 0f1e308..aecbcf5 100644
--- a/blog/2015/01/27/schema-free-json-data-infrastructure/index.html
+++ b/blog/2015/01/27/schema-free-json-data-infrastructure/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/03/23/microstrategy-announces-drill-support/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/03/23/microstrategy-announces-drill-support/index.html b/blog/2015/03/23/microstrategy-announces-drill-support/index.html
index e4e3211..e101bc5 100644
--- a/blog/2015/03/23/microstrategy-announces-drill-support/index.html
+++ b/blog/2015/03/23/microstrategy-announces-drill-support/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/03/31/drill-0.8-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/03/31/drill-0.8-released/index.html b/blog/2015/03/31/drill-0.8-released/index.html
index 63df6bb..e4b3d6f 100644
--- a/blog/2015/03/31/drill-0.8-released/index.html
+++ b/blog/2015/03/31/drill-0.8-released/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/index.html b/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/index.html
index 94b640c..064f1eb 100644
--- a/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/index.html
+++ b/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/05/04/drill-0.9-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/05/04/drill-0.9-released/index.html b/blog/2015/05/04/drill-0.9-released/index.html
index ba48f8a..c579903 100644
--- a/blog/2015/05/04/drill-0.9-released/index.html
+++ b/blog/2015/05/04/drill-0.9-released/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/05/19/drill-1.0-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/05/19/drill-1.0-released/index.html b/blog/2015/05/19/drill-1.0-released/index.html
index ddb8327..a11e4b6 100644
--- a/blog/2015/05/19/drill-1.0-released/index.html
+++ b/blog/2015/05/19/drill-1.0-released/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html b/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html
index 3aba825..dda5fcc 100644
--- a/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/index.html
+++ b/blog/2015/05/19/the-apache-software-foundation-announces-apache-drill-1.0/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/07/05/drill-1.1-released/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/07/05/drill-1.1-released/index.html b/blog/2015/07/05/drill-1.1-released/index.html
index 8181f1a..01fb1d0 100644
--- a/blog/2015/07/05/drill-1.1-released/index.html
+++ b/blog/2015/07/05/drill-1.1-released/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
----------------------------------------------------------------------
diff --git a/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html b/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
index ea5704b..22fb027 100644
--- a/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/index.html
+++ b/blog/2015/07/23/drill-tutorial-at-nosql-now-2015/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/blog/index.html
----------------------------------------------------------------------
diff --git a/blog/index.html b/blog/index.html
index 5107dd4..2ea127b 100644
--- a/blog/index.html
+++ b/blog/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/community-resources/index.html
----------------------------------------------------------------------
diff --git a/community-resources/index.html b/community-resources/index.html
index 12c3eb6..1016722 100644
--- a/community-resources/index.html
+++ b/community-resources/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>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/data/index.html
----------------------------------------------------------------------
diff --git a/data/index.html b/data/index.html
index 73cdfb7..9ae7ea7 100644
--- a/data/index.html
+++ b/data/index.html
@@ -102,18 +102,6 @@
     "relative_path": "_docs/140-sample-datasets.md"
 },
 {
-    "url": "/docs/archived-pages/",
-    "title": "Archived Pages",
-    "parent": "",
-    "relative_path": "_docs/150-archived-pages.md"
-},
-{
-    "url": "/docs/progress-reports/",
-    "title": "Progress Reports",
-    "parent": "",
-    "relative_path": "_docs/160-progress-reports.md"
-},
-{
     "url": "/docs/project-bylaws/",
     "title": "Project Bylaws",
     "parent": "",
@@ -144,18 +132,6 @@
     "relative_path": "_docs/architecture/030-performance.md"
 },
 {
-    "url": "/docs/how-to-run-the-drill-demo/",
-    "title": "How to Run the Drill Demo",
-    "parent": "Archived Pages",
-    "relative_path": "_docs/archived-pages/010-how-to-run-the-drill-demo.md"
-},
-{
-    "url": "/docs/what-is-apache-drill/",
-    "title": "What is Apache Drill",
-    "parent": "Archived Pages",
-    "relative_path": "_docs/archived-pages/020-what-is-apache-drill.md"
-},
-{
     "url": "/docs/configure-drill-introduction/",
     "title": "Configure Drill Introduction",
     "parent": "Configure Drill",
@@ -210,6 +186,12 @@
     "relative_path": "_docs/configure-drill/076-configuring-user-impersonation-with-hive-authorization.md"
 },
 {
+    "url": "/docs/configuring-web-ui-and-rest-api-security/",
+    "title": "Configuring Web UI and REST API Security",
+    "parent": "Configure Drill",
+    "relative_path": "_docs/configure-drill/078-configuring-web-ui-and-rest-api-security.md"
+},
+{
     "url": "/docs/configuration-options/",
     "title": "Configuration Options",
     "parent": "Configure Drill",
@@ -516,6 +498,12 @@
     "relative_path": "_docs/install/050-starting-drill-in-distributed-mode.md"
 },
 {
+    "url": "/docs/starting-the-web-ui/",
+    "title": "Starting the Web UI",
+    "parent": "Install Drill",
+    "relative_path": "_docs/install/060-starting-the-web-ui.md"
+},
+{
     "url": "/docs/embedded-mode-prerequisites/",
     "title": "Embedded Mode Prerequisites",
     "parent": "Installing Drill in Embedded Mode",
@@ -840,12 +828,6 @@
     "relative_path": "_docs/performance-tuning/query-plans-and-tuning/070-controlling-parallelization-to-balance-performance-with-multi-tenancy.md"
 },
 {
-    "url": "/docs/2014-q1-drill-report/",
-    "title": "2014 Q1 Drill Report",
-    "parent": "Progress Reports",
-    "relative_path": "_docs/progress-reports/001-2014-q1.md"
-},
-{
     "url": "/docs/query-data-introduction/",
     "title": "Query Data Introduction",
     "parent": "Query Data",
@@ -1194,16 +1176,22 @@
     "relative_path": "_docs/sql-reference/sql-commands/050-create-view.md"
 },
 {
-    "url": "/docs/drop-view/",
-    "title": "DROP VIEW",
+    "url": "/docs/describe/",
+    "title": "DESCRIBE",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/055-drop-view.md"
+    "relative_path": "_docs/sql-reference/sql-commands/053-describe.md"
 },
 {
-    "url": "/docs/describe/",
-    "title": "DESCRIBE",
+    "url": "/docs/drop-table/",
+    "title": "DROP TABLE",
     "parent": "SQL Commands",
-    "relative_path": "_docs/sql-reference/sql-commands/060-describe.md"
+    "relative_path": "_docs/sql-reference/sql-commands/055-drop-table.md"
+},
+{
+    "url": "/docs/drop-view/",
+    "title": "DROP VIEW",
+    "parent": "SQL Commands",
+    "relative_path": "_docs/sql-reference/sql-commands/056-drop-view.md"
 },
 {
     "url": "/docs/explain/",
@@ -1368,6 +1356,12 @@
     "relative_path": "_docs/sql-reference/sql-window-functions/030-ranking-window-functions.md"
 },
 {
+    "url": "/docs/value-window-functions/",
+    "title": "Value Window Functions",
+    "parent": "SQL Window Functions",
+    "relative_path": "_docs/sql-reference/sql-window-functions/035-value-window-functions.md"
+},
+{
     "url": "/docs/sql-window-functions-examples/",
     "title": "SQL Window Functions Examples",
     "parent": "SQL Window Functions",

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 fbae1ae..0421b09 100644
--- a/docs/about-sql-function-examples/index.html
+++ b/docs/about-sql-function-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"><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/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 64a8aa7..7b3cd08 100644
--- a/docs/about-the-mapr-sandbox/index.html
+++ b/docs/about-the-mapr-sandbox/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/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 5c032f3..8b1de41 100644
--- a/docs/adding-custom-functions-to-drill/index.html
+++ b/docs/adding-custom-functions-to-drill/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/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 08c0766..7e7bdf9 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/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>
         
       
@@ -1021,7 +1003,7 @@ Drill queries:</p>
 </thead><tbody>
 <tr>
 <td>AVG(expression)</td>
-<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVALYEAR or INTERVALDAY</td>
+<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
 <td>DECIMAL for any integer-type argument, DOUBLE for a floating-point argument, otherwise the same as the argument data type</td>
 </tr>
 <tr>
@@ -1046,7 +1028,7 @@ Drill queries:</p>
 </tr>
 <tr>
 <td>SUM(expression)</td>
-<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVALDAY, or INTERVALYEAR</td>
+<td>SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL</td>
 <td>BIGINT for SMALLINT or INTEGER arguments, DECIMAL for BIGINT arguments, DOUBLE for floating-point arguments, otherwise the same as the argument data type</td>
 </tr>
 </tbody></table>
@@ -1055,7 +1037,7 @@ Drill queries:</p>
 
 <p>AVG, COUNT, MIN, MAX, and SUM accept ALL and DISTINCT keywords. The default is ALL.</p>
 
-<p>These examples of aggregate functions use the <code>cp</code> storage plugin to access a JSON file installed with Drill. By default, JSON reads numbers as double-precision floating point numbers. These examples assume that you are using the default option <a href="/docs/json-data-model/#handling-type-differences">all_text_mode</a> set to false.</p>
+<p>These examples of aggregate functions use the <code>cp</code> storage plugin to access a the <a href="/docs/querying-json-files/"><code>employee.json</code></a> file installed with Drill. By default, JSON reads numbers as double-precision floating point numbers. These examples assume that you are using the default option <a href="/docs/json-data-model/#handling-type-differences">all_text_mode</a> set to false.</p>
 
 <h2 id="avg">AVG</h2>
 
@@ -1133,9 +1115,10 @@ SELECT AVG(DISTINCT salary) FROM cp.`employee.json`;
 <p>Returns the number of rows that match the given criteria.</p>
 
 <h3 id="count-syntax">COUNT Syntax</h3>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT COUNT([DISTINCT | ALL] column) FROM . . .
-SELECT COUNT(*) FROM . . .
-</code></pre></div>
+
+<p><code>SELECT COUNT([DISTINCT | ALL] column) FROM . . .</code><br>
+<code>SELECT COUNT(*) FROM . . .</code>  </p>
+
 <ul>
 <li>column<br>
 Returns the number of values of the specified column.<br></li>
@@ -1222,7 +1205,7 @@ SELECT MAX(salary) FROM cp.`employee.json`;
 
 <h3 id="sum-syntax">SUM syntax</h3>
 
-<p>SUM(column)</p>
+<p><code>SUM(column)</code></p>
 
 <h3 id="examples">Examples</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">SELECT SUM(ALL salary) FROM cp.`employee.json`;

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/aggregate-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/aggregate-window-functions/index.html b/docs/aggregate-window-functions/index.html
index 3b98b72..af905fa 100644
--- a/docs/aggregate-window-functions/index.html
+++ b/docs/aggregate-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>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/alter-session/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-session/index.html b/docs/alter-session/index.html
index d45972a..2fa43c7 100644
--- a/docs/alter-session/index.html
+++ b/docs/alter-session/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/alter-system/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-system/index.html b/docs/alter-system/index.html
index df01d49..ed8bde5 100644
--- a/docs/alter-system/index.html
+++ b/docs/alter-system/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/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 f572080..dae920c 100644
--- a/docs/analyzing-highly-dynamic-datasets/index.html
+++ b/docs/analyzing-highly-dynamic-datasets/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/analyzing-social-media/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-social-media/index.html b/docs/analyzing-social-media/index.html
index 2264bc8..0ffa58b 100644
--- a/docs/analyzing-social-media/index.html
+++ b/docs/analyzing-social-media/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/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 267963f..8b47332 100644
--- a/docs/analyzing-the-yelp-academic-dataset/index.html
+++ b/docs/analyzing-the-yelp-academic-dataset/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>
         
       
@@ -1023,7 +1005,7 @@ example is downloadable from <a href="http://www.yelp.com/dataset_challenge">Yel
 
 <h2 id="installing-and-starting-drill">Installing and Starting Drill</h2>
 
-<h3 id="step-1:-download-apache-drill-onto-your-local-machine">Step 1: Download Apache Drill onto your local machine</h3>
+<h3 id="download-apache-drill-onto-your-local-machine">Download Apache Drill onto your local machine</h3>
 
 <p>To experiment with Drill locally, follow the installation instructions in <a href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a>.</p>
 

http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/aol-search/index.html
----------------------------------------------------------------------
diff --git a/docs/aol-search/index.html b/docs/aol-search/index.html
index 4831249..89074d7 100644
--- a/docs/aol-search/index.html
+++ b/docs/aol-search/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/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 b423f6d..328d45a 100644
--- a/docs/apache-drill-0-4-0-release-notes/index.html
+++ b/docs/apache-drill-0-4-0-release-notes/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>