You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by br...@apache.org on 2015/07/02 01:53:45 UTC
[2/4] drill-site git commit: Edits to Drill 1.1 Docs
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-complex-data/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-complex-data/index.html b/docs/querying-complex-data/index.html
index 1d1f041..124e067 100644
--- a/docs/querying-complex-data/index.html
+++ b/docs/querying-complex-data/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-directories/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-directories/index.html b/docs/querying-directories/index.html
index 8c0b39d..670b19d 100644
--- a/docs/querying-directories/index.html
+++ b/docs/querying-directories/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-hbase/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-hbase/index.html b/docs/querying-hbase/index.html
index bbcf4cd..21568ba 100644
--- a/docs/querying-hbase/index.html
+++ b/docs/querying-hbase/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-hive/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-hive/index.html b/docs/querying-hive/index.html
index 9e179f1..63849d4 100644
--- a/docs/querying-hive/index.html
+++ b/docs/querying-hive/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-json-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-json-files/index.html b/docs/querying-json-files/index.html
index 3289477..697c091 100644
--- a/docs/querying-json-files/index.html
+++ b/docs/querying-json-files/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-parquet-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-parquet-files/index.html b/docs/querying-parquet-files/index.html
index cb5468c..b579555 100644
--- a/docs/querying-parquet-files/index.html
+++ b/docs/querying-parquet-files/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-plain-text-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-plain-text-files/index.html b/docs/querying-plain-text-files/index.html
index 7a89118..29ac5e4 100644
--- a/docs/querying-plain-text-files/index.html
+++ b/docs/querying-plain-text-files/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-system-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-system-tables/index.html b/docs/querying-system-tables/index.html
index aa32aa1..4b626da 100644
--- a/docs/querying-system-tables/index.html
+++ b/docs/querying-system-tables/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/querying-the-information-schema/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-the-information-schema/index.html b/docs/querying-the-information-schema/index.html
index ac3f560..8b47539 100644
--- a/docs/querying-the-information-schema/index.html
+++ b/docs/querying-the-information-schema/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/ranking-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/ranking-window-functions/index.html b/docs/ranking-window-functions/index.html
index 32913d3..a1dbc9b 100644
--- a/docs/ranking-window-functions/index.html
+++ b/docs/ranking-window-functions/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -995,11 +999,9 @@
<div class="int_text" align="left">
- <h2 id="ranking-window-functions">Ranking Window Functions</h2>
-
-<p>Window functions operate on a set of rows and return a single value for each row from the underlying query. See SQL Window Functions. The OVER() clause differentiates window functions from other analytical and reporting functions. </p>
+ <p>Window functions operate on a set of rows and return a single value for each row from the underlying query. The OVER() clause differentiates window functions from other analytical and reporting functions. See <a href="/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a>. You can use ranking functions in Drill to return a ranking value for each row in a partition. </p>
-<p>The following table lists the ranking window functions in Drill with return data types and descriptions of each function: </p>
+<p>The following table lists the ranking window functions with supported data types and descriptions: </p>
<table><thead>
<tr>
@@ -1048,11 +1050,11 @@ CUME_DIST(), DENSE_RANK(), PERCENT_RANK(), RANK(), ROW_NUMBER() </p>
The functions do not take arguments, however the empty parentheses are required. </p>
<p>OVER clause<br>
-The window clauses for the function. The OVER clause cannot contain an explicit frame specification, but must include an ORDER BY clause. See Window Function Syntax for OVER clause syntax.</p>
+The window clauses for the function. The OVER clause cannot contain an explicit frame specification, but must include an ORDER BY clause. See <a href="/docs/sql-window-functions-introduction/#syntax">Window Function Syntax</a> for OVER clause syntax.</p>
<h2 id="examples">Examples</h2>
-<p>The following examples show queries that use each of the ranking window functions in Drill. See Window Function Examples for information about the data and setup for these examples.</p>
+<p>The following examples show queries that use each of the ranking window functions in Drill. See <a href="/docs/sql-window-functions-examples/">Window Functions Examples</a> for information about the data and setup for these examples.</p>
<h3 id="cume_dist()">CUME_DIST()</h3>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/release-notes/index.html b/docs/release-notes/index.html
index 6210245..5dc6162 100644
--- a/docs/release-notes/index.html
+++ b/docs/release-notes/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -1017,6 +1021,9 @@
<li><a href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+ <li><a href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
<li><a href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/repeated-contains/index.html
----------------------------------------------------------------------
diff --git a/docs/repeated-contains/index.html b/docs/repeated-contains/index.html
index f3e0585..242bfef 100644
--- a/docs/repeated-contains/index.html
+++ b/docs/repeated-contains/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/repeated-count/index.html
----------------------------------------------------------------------
diff --git a/docs/repeated-count/index.html b/docs/repeated-count/index.html
index c64d6e5..bce65cd 100644
--- a/docs/repeated-count/index.html
+++ b/docs/repeated-count/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/reserved-keywords/index.html
----------------------------------------------------------------------
diff --git a/docs/reserved-keywords/index.html b/docs/reserved-keywords/index.html
index 09bfc77..b4bac3f 100644
--- a/docs/reserved-keywords/index.html
+++ b/docs/reserved-keywords/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/review-the-java-stack-trace/index.html
----------------------------------------------------------------------
diff --git a/docs/review-the-java-stack-trace/index.html b/docs/review-the-java-stack-trace/index.html
index 3d7010e..59bdb66 100644
--- a/docs/review-the-java-stack-trace/index.html
+++ b/docs/review-the-java-stack-trace/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/rpc-overview/index.html
----------------------------------------------------------------------
diff --git a/docs/rpc-overview/index.html b/docs/rpc-overview/index.html
index 0a101b0..5398bee 100644
--- a/docs/rpc-overview/index.html
+++ b/docs/rpc-overview/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sample-data-donuts/index.html
----------------------------------------------------------------------
diff --git a/docs/sample-data-donuts/index.html b/docs/sample-data-donuts/index.html
index 1091968..05d68c1 100644
--- a/docs/sample-data-donuts/index.html
+++ b/docs/sample-data-donuts/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sample-datasets/index.html
----------------------------------------------------------------------
diff --git a/docs/sample-datasets/index.html b/docs/sample-datasets/index.html
index 4b85b57..e4c4842 100644
--- a/docs/sample-datasets/index.html
+++ b/docs/sample-datasets/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/select-list/index.html
----------------------------------------------------------------------
diff --git a/docs/select-list/index.html b/docs/select-list/index.html
index 6aa91b3..229fdb2 100644
--- a/docs/select-list/index.html
+++ b/docs/select-list/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/select/index.html
----------------------------------------------------------------------
diff --git a/docs/select/index.html b/docs/select/index.html
index 22827a4..e38d542 100644
--- a/docs/select/index.html
+++ b/docs/select/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/selecting-flat-data/index.html
----------------------------------------------------------------------
diff --git a/docs/selecting-flat-data/index.html b/docs/selecting-flat-data/index.html
index 4bc283b..2895e33 100644
--- a/docs/selecting-flat-data/index.html
+++ b/docs/selecting-flat-data/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/selecting-multiple-columns-within-nested-data/index.html
----------------------------------------------------------------------
diff --git a/docs/selecting-multiple-columns-within-nested-data/index.html b/docs/selecting-multiple-columns-within-nested-data/index.html
index 9f78b7a..bd0a036 100644
--- a/docs/selecting-multiple-columns-within-nested-data/index.html
+++ b/docs/selecting-multiple-columns-within-nested-data/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/selecting-nested-data-for-a-column/index.html
----------------------------------------------------------------------
diff --git a/docs/selecting-nested-data-for-a-column/index.html b/docs/selecting-nested-data-for-a-column/index.html
index e70a6d7..6da3066 100644
--- a/docs/selecting-nested-data-for-a-column/index.html
+++ b/docs/selecting-nested-data-for-a-column/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/show-databases-and-show-schemas/index.html
----------------------------------------------------------------------
diff --git a/docs/show-databases-and-show-schemas/index.html b/docs/show-databases-and-show-schemas/index.html
index a07e607..044b4e4 100644
--- a/docs/show-databases-and-show-schemas/index.html
+++ b/docs/show-databases-and-show-schemas/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/show-files/index.html
----------------------------------------------------------------------
diff --git a/docs/show-files/index.html b/docs/show-files/index.html
index e3cad21..95e1878 100644
--- a/docs/show-files/index.html
+++ b/docs/show-files/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/show-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/show-tables/index.html b/docs/show-tables/index.html
index f0b8c0a..5cf27f6 100644
--- a/docs/show-tables/index.html
+++ b/docs/show-tables/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
----------------------------------------------------------------------
diff --git a/docs/sort-based-and-hash-based-memory-constrained-operators/index.html b/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
index 418b8a5..7c97b7e 100644
--- a/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
+++ b/docs/sort-based-and-hash-based-memory-constrained-operators/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-commands/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-commands/index.html b/docs/sql-commands/index.html
index 30e8284..a274db8 100644
--- a/docs/sql-commands/index.html
+++ b/docs/sql-commands/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-conditional-expressions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-conditional-expressions/index.html b/docs/sql-conditional-expressions/index.html
index 1876c65..e5c3a44 100644
--- a/docs/sql-conditional-expressions/index.html
+++ b/docs/sql-conditional-expressions/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-extensions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-extensions/index.html b/docs/sql-extensions/index.html
index cf41f73..b4dc6a9 100644
--- a/docs/sql-extensions/index.html
+++ b/docs/sql-extensions/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-functions/index.html b/docs/sql-functions/index.html
index 7f1a546..e1482c9 100644
--- a/docs/sql-functions/index.html
+++ b/docs/sql-functions/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-reference-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-reference-introduction/index.html b/docs/sql-reference-introduction/index.html
index d3e2804..f6e35fe 100644
--- a/docs/sql-reference-introduction/index.html
+++ b/docs/sql-reference-introduction/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-reference/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-reference/index.html b/docs/sql-reference/index.html
index 74c2049..d83f8ea 100644
--- a/docs/sql-reference/index.html
+++ b/docs/sql-reference/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-window-functions-examples/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions-examples/index.html b/docs/sql-window-functions-examples/index.html
index b8166e3..1072b11 100644
--- a/docs/sql-window-functions-examples/index.html
+++ b/docs/sql-window-functions-examples/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -995,7 +999,7 @@
<div class="int_text" align="left">
- <p>The window function examples use a view named q1_sales that was created from a CSV file named emp_sales and stored in a directory on the local file system:</p>
+ <p>The window function examples use a view named q1_sales that was created from a CSV file named emp_sales and stored in a directory on the local file system.</p>
<p>The emp_sales.csv file contains the following information: </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> +-----------------+-----------------+------------+--------+
@@ -1041,7 +1045,7 @@
| true | Default schema changed to [dfs.emp] |
+-------+--------------------------------------+
</code></pre></div>
-<p>To create the q1_sales view used in the examples, issue the following query with the CREATE VIEW command to Drill.</p>
+<p>To create the q1_sales view used in the examples, issue the following query with the CREATE VIEW command.</p>
<p>Note: You must use column numbers when querying CSV files. Also, CAST the columns to a specific data type to avoid incorrect implicit casting by Drill. This can affect the accuracy of window function results. In Drill, the column array starts with 0 as the first column.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> 0: jdbc:drill:zk=local> create view q1_sales as select cast(columns[0] as varchar(30)) as emp_name, cast(columns[1] as varchar(30)) as emp_mgr, cast(columns[2] as int) as dealer_id, cast(columns[3] as int) as sales from `q1_sales.csv`;
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-window-functions-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions-introduction/index.html b/docs/sql-window-functions-introduction/index.html
index 30f6598..3536468 100644
--- a/docs/sql-window-functions-introduction/index.html
+++ b/docs/sql-window-functions-introduction/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -1041,7 +1045,7 @@ To compare, you can run a query using the AVG() function as a standard set funct
<p>Window functions are applied to the rows within each partition and sorted according to the order specification. </p>
<p>The following query uses the AVG() window function with the PARTITION BY clause to determine the average car sales for each dealer in Q1: </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> select emp_name, dealer_id, sales, avg(sales) over (PARTITION BY dealer_id) as avgsales from q1_sales;
+<div class="highlight"><pre><code class="language-text" data-lang="text"> select emp_name, dealer_id, sales, avg(sales) over (partition by dealer_id) as avgsales from q1_sales;
+-----------------+------------+--------+-----------+
| emp_name | dealer_id | sales | avgsales |
+-----------------+------------+--------+-----------+
@@ -1062,7 +1066,7 @@ To compare, you can run a query using the AVG() function as a standard set funct
<p>Currently, Drill supports the following aggregate and ranking window functions: </p>
-<p>Aggregation </p>
+<p>Aggregate </p>
<ul>
<li>AVG()</li>
@@ -1082,15 +1086,14 @@ To compare, you can run a query using the AVG() function as a standard set funct
<li>ROW_NUMBER()</li>
</ul>
-<p>All of the ranking functions listed depend on the sort ordering specified by the ORDER BY clause of the associated window definition. Rows that are not distinct in the ordering are called peers. The ranking functions are defined so that they give the same answer for any two peer rows. </p>
+<p>All of the ranking functions depend on the sort ordering specified by the ORDER BY clause of the associated window definition. Rows that are not distinct in the ordering are called peers. The ranking functions are defined so that they give the same answer for any two peer rows. </p>
<h2 id="syntax">Syntax</h2>
-<div class="highlight"><pre><code class="language-text" data-lang="text"> window_function (expression)
- OVER (
+<div class="highlight"><pre><code class="language-text" data-lang="text"> window_function (expression) OVER (
[ PARTITION BY expr_list ]
[ ORDER BY order_list ][ frame_clause ] )
</code></pre></div>
-<p>where function is one of the functions described, such as AVG() and <em>expr_list</em> is: </p>
+<p>where function is one of the functions described, such as AVG(), and <em>expr_list</em> is: </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> expression | column_name [, expr_list ]
</code></pre></div>
<p>and <em>order_list</em> is: </p>
@@ -1127,13 +1130,13 @@ OVER() is a mandatory clause that defines a window within a query result set. OV
PARTITION BY is an optional clause that subdivides the data into partitions. Including the partition clause divides the query result set into partitions, and the window function is applied to each partition separately. Computation restarts for each partition. If you do not include a partition clause, the function calculates on the entire table or file. </p>
<p>ORDER BY <em>order_list</em><br>
-The ORDER BY clause defines the logical order of the rows within each partition of the result set. If no PARTITION BY is specified, ORDER BY uses the entire table. ORDER BY is optional for the aggregation window functions, but required for the ranking functions. This ORDER BY clause does not relate to the ORDER BY clause that you use outside of the OVER clause. </p>
+The ORDER BY clause defines the logical order of the rows within each partition of the result set. If no PARTITION BY is specified, ORDER BY uses the entire table. ORDER BY is optional for the aggregate window functions and required for the ranking functions. This ORDER BY clause does not relate to the ORDER BY clause used outside of the OVER clause. </p>
<p>The window function is applied to the rows within each partition sorted according to the order specification. </p>
<p>Column identifiers or expressions that evaluate to column identifiers are required in the order list. You can also use constants as substitutes for column names. </p>
-<p>NULLS are treated as their own group, sorted and ranked last in ASC, and sorted and ranked first in DESC. ASC is the default sort order. </p>
+<p>NULLS are treated as their own group, sorted and ranked last in ASC and sorted and ranked first in DESC. ASC is the default sort order. </p>
<p><em>column_name</em><br>
The name of a column to be partitioned by or ordered by. </p>
@@ -1148,7 +1151,7 @@ The frame_clause specifies the group of rows that create the window frame. Curre
<div class="highlight"><pre><code class="language-text" data-lang="text"> RANGE UNBOUNDED PRECEDING
RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW
</code></pre></div>
-<p>When OVER clause does not contain an ORDER BY clause, the following frames are equivalent to the default frame: </p>
+<p>When the OVER clause does not contain an ORDER BY clause, the following frames are equivalent to the default frame: </p>
<div class="highlight"><pre><code class="language-text" data-lang="text"> RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
ROWS BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING
</code></pre></div>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/sql-window-functions/index.html
----------------------------------------------------------------------
diff --git a/docs/sql-window-functions/index.html b/docs/sql-window-functions/index.html
index 1ba445d..2b51e9e 100644
--- a/docs/sql-window-functions/index.html
+++ b/docs/sql-window-functions/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/start-up-options/index.html
----------------------------------------------------------------------
diff --git a/docs/start-up-options/index.html b/docs/start-up-options/index.html
index b74ca9f..d7bc987 100644
--- a/docs/start-up-options/index.html
+++ b/docs/start-up-options/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -1037,24 +1041,12 @@ override.conf</code> file located in Drill’s<code>/conf</code> directory.</p>
<p>The summary of start-up options, also known as boot options, lists default values. The following descriptions provide more detail on key options that are frequently reconfigured:</p>
<ul>
-<li>drill.exec.sys.store.provider.class<br></li>
-</ul>
-
-<p>Defines the persistent storage (PStore) provider. The <a href="/docs/persistent-configuration-storage">PStore</a> holds configuration and profile data. </p>
-
-<ul>
-<li>drill.exec.buffer.size</li>
-</ul>
-
-<p>Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option increases the speed at which Drill completes a query.</p>
-
-<ul>
-<li>drill.exec.sort.external.spill.directories</li>
-</ul>
-
-<p>Tells Drill which directory to use when spooling. Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the /tmp directory. Spooling performance (both writing and reading back from it) is constrained by the file system. For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Volumes improve performance and stripe data across as many disks as possible.</p>
-
-<ul>
+<li>drill.exec.sys.store.provider.class<br>
+Defines the persistent storage (PStore) provider. The <a href="/docs/persistent-configuration-storage">PStore</a> holds configuration and profile data.<br></li>
+<li>drill.exec.buffer.size<br>
+Defines the amount of memory available, in terms of record batches, to hold data on the downstream side of an operation. Drill pushes data downstream as quickly as possible to make data immediately available. This requires Drill to use memory to hold the data pending operations. When data on a downstream operation is required, that data is immediately available so Drill does not have to go over the network to process it. Providing more memory to this option increases the speed at which Drill completes a query.<br></li>
+<li>drill.exec.sort.external.spill.directories<br>
+Tells Drill which directory to use when spooling. Drill uses a spool and sort operation for beyond memory operations. The sorting operation is designed to spool to a Hadoop file system. The default Hadoop file system is a local file system in the <code>/tmp</code> directory. Spooling performance (both writing and reading back from it) is constrained by the file system. For MapR clusters, use MapReduce volumes or set up local volumes to use for spooling purposes. Volumes improve performance and stripe data across as many disks as possible.<br></li>
<li>drill.exec.zk.connect<br>
Provides Drill with the ZooKeeper quorum to use to connect to data sources. Change this setting to point to the ZooKeeper quorum that you want Drill to use. You must configure this option on each Drillbit node.</li>
</ul>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/starting-drill-in-distributed-mode/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-drill-in-distributed-mode/index.html b/docs/starting-drill-in-distributed-mode/index.html
index e90cd08..9ceee11 100644
--- a/docs/starting-drill-in-distributed-mode/index.html
+++ b/docs/starting-drill-in-distributed-mode/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/starting-drill-on-linux-and-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-drill-on-linux-and-mac-os-x/index.html b/docs/starting-drill-on-linux-and-mac-os-x/index.html
index 9e38c11..07c384a 100644
--- a/docs/starting-drill-on-linux-and-mac-os-x/index.html
+++ b/docs/starting-drill-on-linux-and-mac-os-x/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/starting-drill-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/starting-drill-on-windows/index.html b/docs/starting-drill-on-windows/index.html
index 7ab2aae..b562d75 100644
--- a/docs/starting-drill-on-windows/index.html
+++ b/docs/starting-drill-on-windows/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/storage-plugin-configuration/index.html
----------------------------------------------------------------------
diff --git a/docs/storage-plugin-configuration/index.html b/docs/storage-plugin-configuration/index.html
index 2816fe7..7c92b16 100644
--- a/docs/storage-plugin-configuration/index.html
+++ b/docs/storage-plugin-configuration/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/storage-plugin-registration/index.html
----------------------------------------------------------------------
diff --git a/docs/storage-plugin-registration/index.html b/docs/storage-plugin-registration/index.html
index 9c0079e..c4a72d3 100644
--- a/docs/storage-plugin-registration/index.html
+++ b/docs/storage-plugin-registration/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/string-manipulation/index.html
----------------------------------------------------------------------
diff --git a/docs/string-manipulation/index.html b/docs/string-manipulation/index.html
index f7435b3..154d630 100644
--- a/docs/string-manipulation/index.html
+++ b/docs/string-manipulation/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/summary/index.html
----------------------------------------------------------------------
diff --git a/docs/summary/index.html b/docs/summary/index.html
index 3b0126a..eba4112 100644
--- a/docs/summary/index.html
+++ b/docs/summary/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/supported-data-types/index.html
----------------------------------------------------------------------
diff --git a/docs/supported-data-types/index.html b/docs/supported-data-types/index.html
index 3dbe977..eafe3d6 100644
--- a/docs/supported-data-types/index.html
+++ b/docs/supported-data-types/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/supported-sql-commands/index.html
----------------------------------------------------------------------
diff --git a/docs/supported-sql-commands/index.html b/docs/supported-sql-commands/index.html
index 6dc6c2f..7e3415d 100644
--- a/docs/supported-sql-commands/index.html
+++ b/docs/supported-sql-commands/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -998,8 +1002,84 @@
<p>The following table provides a list of the SQL commands that Drill supports,
with their descriptions and example syntax:</p>
-<table style='table-layout:fixed;width:100%'>
- <tr><th >Command</th><th >Description</th><th >Syntax</th></tr><tr><td valign="top" width="15%"><a href="/docs/alter-session">ALTER SESSION</a></td><td valign="top" width="60%">Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to <a href="/docs/planning-and-execution-options">Planning and Execution Options</a>.</td><td valign="top"><pre>ALTER SESSION SET `<option_name>`=<value>;</pre></td></tr><tr><td valign="top" ><a href="/docs/alter-system">ALTER SYSTEM</a></td><td valign="top" >Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to <a href="/docs/planning-and-execution-options">Planning and Execution Options</a>.</td><td valign="top" ><pre>ALTER SYSTEM SET `<option_name>`=<value>;</pre></td></tr><tr><td valign="top" ><p><a href="/docs/create-table-as--cta
s">CREATE TABLE AS<br />(CTAS)</a></p></td><td valign="top" >Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO. When you issue the CTAS command, you create a directory that contains parquet or CSV files. Each workspace in a file system has a default file type.<br />You can specify which writer you want Drill to use when creating a table: parquet, CSV, or JSON (as specified with the <code>store.format</code> option).</td><td valign="top" ><pre class="programlisting">CREATE TABLE new_table_name AS <query>;</pre></td></tr><tr><td - valign="top" ><a href="/docs/create-view">CREATE VIEW </a></td><td - valign="top" >Creates a virtual structure for the result set of a stored query.-</td><td -valign="top" ><pre>CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS <query>;</pre></td></tr><tr><td valign="top" ><a href="/docs/describe">DESCRIBE</a></td><td
valign="top" >Returns information about columns in a table or view.</td><td valign="top" ><pre>DESCRIBE [workspace.]table_name|view_name</pre></td></tr><tr><td valign="top" ><a href="/docs/drop-view">DROP VIEW</a></td><td valign="top" >Removes a view.</td><td valign="top" ><pre>DROP VIEW [workspace.]view_name ;</pre></td></tr><tr><td valign="top" ><a href="/docs/explain">EXPLAIN PLAN FOR</a></td><td valign="top" >Returns the physical plan for a particular query.</td><td valign="top" ><pre>EXPLAIN PLAN FOR <query>;</pre></td></tr><tr><td valign="top" ><a href="/docs/explain">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td><td valign="top" >Returns the logical plan for a particular query.</td><td valign="top" ><pre>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR <query>;</pre></td></tr><tr><td colspan="1" valign="top" ><a href="/docs/select" rel="nofollow">SELECT</a></td><td valign="top" >Retrieves data from tables and files.</td><td valign="top" ><pre>[WITH subquery]<br />SEL
ECT column_list FROM table_name <br />[WHERE clause]<br />[GROUP BY clause]<br />[HAVING clause]<br />[ORDER BY clause];</pre></td></tr><tr><td valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW DATABASES </a></td><td valign="top" >Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td><td valign="top" ><pre>SHOW DATABASES;</pre></td></tr><tr><td valign="top" ><a href="/docs/show-files" >SHOW FILES</a></td><td valign="top" >Returns a list of files in a file system schema.</td><td valign="top" ><pre>SHOW FILES IN filesystem.`schema_name`;<br />SHOW FILES FROM filesystem.`schema_name`;</pre></td></tr><tr><td valign="top" ><a href="/docs/show-databases-and-show-schemas">SHOW SCHEMAS</a></td><td - valign="top" >Returns a list of available schemas. Equivalent to SHOW DATABASES.</td><td valign="top" ><pre>SHOW SCHEMAS;</pre></td></tr><tr><td valign="top" ><a href="/docs/show-tables">SHOW TABLES</a></td><td valign="top" >Returns a list of tables and views.</t
d><td valign="top" ><pre>SHOW TABLES;</pre></td></tr><tr><td valign="top" ><a href="/docs/use">USE</a></td><td valign="top" >Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td><td valign="top" ><pre>USE schema_name;</pre></td></tr></table>
+<table><thead>
+<tr>
+<th>Command</th>
+<th>Description</th>
+<th>Syntax</th>
+</tr>
+</thead><tbody>
+<tr>
+<td><a href="/docs/alter-session">ALTER SESSION</a></td>
+<td>Changes a system setting for the duration of a session. A session ends when you quit the Drill shell. For a list of Drill options and their descriptions, refer to Planning and Execution Options.</td>
+<td>ALTER SESSION SET `option_name` = value;</td>
+</tr>
+<tr>
+<td><a href="/docs/alter-system">ALTER SYSTEM</a></td>
+<td>Permanently changes a system setting. The new settings persist across all sessions. For a list of Drill options and their descriptions, refer to Planning and Execution Options.</td>
+<td>ALTER SYSTEM SET `option_name`=value;</td>
+</tr>
+<tr>
+<td><a href="/docs/create-table-as--ctas">CREATE TABLE AS(CTAS) </a></td>
+<td>Creates a new table and populates the new table with rows returned from a SELECT query. Use the CREATE TABLE AS (CTAS) statement in place of INSERT INTO.</td>
+<td>CREATE TABLE name AS query;</td>
+</tr>
+<tr>
+<td><a href="/docs/create-view">CREATE VIEW</a></td>
+<td>Creates a virtual structure for the result set of a stored query.-</td>
+<td>CREATE [OR REPLACE] VIEW [workspace.]view_name [ (column_name [, ...]) ] AS query;</td>
+</tr>
+<tr>
+<td><a href="/docs/describe">DESCRIBE </a></td>
+<td>Returns information about columns in a table or view.</td>
+<td>DESCRIBE [workspace.]table_name</td>
+</tr>
+<tr>
+<td><a href="/docs/drop-view">DROP VIEW</a></td>
+<td>Removes a view.</td>
+<td>DROP VIEW [workspace.]view_name ;</td>
+</tr>
+<tr>
+<td><a href="/docs/explain">EXPLAIN PLAN FOR</a></td>
+<td>Returns the physical plan for a particular query.</td>
+<td>EXPLAIN PLAN FOR query;</td>
+</tr>
+<tr>
+<td><a href="/docs/explain">EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR</a></td>
+<td>Returns the logical plan for a particular query.</td>
+<td>EXPLAIN PLAN WITHOUT IMPLEMENTATION FOR query;</td>
+</tr>
+<tr>
+<td><a href="/docs/select">SELECT</a></td>
+<td>Retrieves data from tables and files.</td>
+<td>[WITH subquery]SELECT column_list FROM table_name[WHERE clause] [GROUP BY clause][HAVING clause][ORDER BY clause];</td>
+</tr>
+<tr>
+<td><a href="/docs/show-databases-and-show-schemas">SHOW DATABASES</a></td>
+<td>Returns a list of available schemas. Equivalent to SHOW SCHEMAS.</td>
+<td>SHOW DATABASES;</td>
+</tr>
+<tr>
+<td><a href="/docs/show-files">SHOW FILES</a></td>
+<td>Returns a list of files in a file system schema.</td>
+<td>SHOW FILES IN|FROM filesystem.`schema_name`;</td>
+</tr>
+<tr>
+<td><a href="/docs/show-databases-and-show-schemas">SHOW SCHEMAS</a></td>
+<td>Returns a list of available schemas. Equivalent to SHOW DATABASES.</td>
+<td>SHOW SCHEMAS;</td>
+</tr>
+<tr>
+<td><a href="/docs/show-tables">SHOW TABLES</a></td>
+<td>Returns a list of tables and views.</td>
+<td>SHOW TABLES;</td>
+</tr>
+<tr>
+<td><a href="/docs/use">USE</a></td>
+<td>Change to a particular schema. When you opt to use a particular schema, Drill issues queries on that schema only.</td>
+<td>USE schema_name;</td>
+</tr>
+</tbody></table>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/tableau-examples/index.html
----------------------------------------------------------------------
diff --git a/docs/tableau-examples/index.html b/docs/tableau-examples/index.html
index 50127ed..6b6ccf0 100644
--- a/docs/tableau-examples/index.html
+++ b/docs/tableau-examples/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/testing-the-odbc-connection/index.html
----------------------------------------------------------------------
diff --git a/docs/testing-the-odbc-connection/index.html b/docs/testing-the-odbc-connection/index.html
index 3e404b1..cd1908e 100644
--- a/docs/testing-the-odbc-connection/index.html
+++ b/docs/testing-the-odbc-connection/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/troubleshooting/index.html
----------------------------------------------------------------------
diff --git a/docs/troubleshooting/index.html b/docs/troubleshooting/index.html
index f0747a3..b225341 100644
--- a/docs/troubleshooting/index.html
+++ b/docs/troubleshooting/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -1027,26 +1031,26 @@
<li><a href="/docs/troubleshooting/#query-parsing-errors">Query Parsing Errors</a></li>
<li><a href="/docs/troubleshooting/#query-parsing-errors-caused-by-reserved-words">Query Parsing Errors Caused by Reserved Words</a></li>
<li><a href="/docs/troubleshooting/#table-not-found">Table Not Found</a></li>
-<li><a href="/docs/troubleshooting/#access-nested-fields-without-table-name/alias">Access Nested Fields without Table Name/Alias</a></li>
+<li><a href="/docs/troubleshooting/#access-nested-fields-without-table-name-alias">Access Nested Fields without Table Name/Alias</a></li>
<li><a href="/docs/troubleshooting/#unexpected-null-values-for-columns-in-results">Unexpected Null Values for Columns in Results</a></li>
<li><a href="/docs/troubleshooting/#using-functions-with-incorrect-data-types">Using Functions with Incorrect Data Types</a></li>
<li><a href="/docs/troubleshooting/#query-takes-a-long-time-to-return">Query Takes a Long Time to Return</a></li>
<li><a href="/docs/troubleshooting/#schema-changes">Schema Changes</a></li>
<li><a href="/docs/troubleshooting/#timestamps-and-timezones-other-than-utc">Timestamps and Timezones Other Than UTC</a></li>
<li><a href="/docs/troubleshooting/#unexpected-odbc-issues">Unexpected ODBC Issues</a></li>
-<li><a href="/docs/troubleshooting/#jdbc/odbc-connection-issues-with-zookeeper">JDBC/ODBC Connection Issues with ZooKeeper</a></li>
+<li><a href="/docs/troubleshooting/#jdbc-odbc-connection-issues-with-zookeeper">JDBC/ODBC Connection Issues with ZooKeeper</a></li>
<li><a href="/docs/troubleshooting/#metadata-queries-take-a-long-time-to-return">Metadata Queries Take a Long Time to Return</a></li>
<li><a href="/docs/troubleshooting/#unexpected-results-due-to-implicit-casting">Unexpected Results Due to Implicit Casting</a></li>
<li><a href="/docs/troubleshooting/#column-alias-causes-an-error">Column Alias Causes an Error</a></li>
-<li><a href="/docs/troubleshooting/#list-(array)-contains-null">List (Array) Contains Null</a></li>
-<li><a href="/docs/troubleshooting/#select-count-(*)-takes-a-long-time-to-run">SELECT COUNT (*) Takes a Long Time to Run</a></li>
+<li><a href="/docs/troubleshooting/#list-array-contains-null">List (Array) Contains Null</a></li>
+<li><a href="/docs/troubleshooting/#select-count-takes-a-long-time-to-run">SELECT COUNT (*) Takes a Long Time to Run</a></li>
<li><a href="/docs/troubleshooting/#tableau-issues">Tableau Issues</a></li>
<li><a href="/docs/troubleshooting/#group-by-using-alias">GROUP BY Using Alias</a></li>
<li><a href="/docs/troubleshooting/#casting-a-varchar-string-to-an-integer-causes-an-error">Casting a VARCHAR String to an INTEGER Causes an Error</a></li>
<li><a href="/docs/troubleshooting/#unexpected-exception-during-fragment-initialization">Unexpected Exception during Fragment Initialization</a></li>
<li><a href="/docs/troubleshooting/#queries-running-out-of-memory">Queries Running Out of Memory</a></li>
<li><a href="/docs/troubleshooting/#unclear-error-message">Unclear Error Message</a></li>
-<li><a href="/docs/troubleshooting/#sqlline-error-starting-drill-in-embedded-mode">SQLLine Error Starting Drill in Embedded Mode</a></li>
+<li><a href="/docs/troubleshooting/#error-starting-drill-in-embedded-mode">Error Starting Drill in Embedded Mode</a></li>
</ul>
<h3 id="memory-issues">Memory Issues</h3>
@@ -1270,7 +1274,7 @@ Turn on ODBC driver debug logging to better understand failure. </p>
<p>Determine your currently connected drillbit using `SELECT * FROM sys.drillbits. Then review logs Drill logs from that drillbit.</p>
-<h3 id="sqlline-error-starting-drill-in-embedded-mode">SQLLine Error Starting Drill in Embedded Mode</h3>
+<h3 id="error-starting-drill-in-embedded-mode">Error Starting Drill in Embedded Mode</h3>
<p>Symptom: </p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/tutorials-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorials-introduction/index.html b/docs/tutorials-introduction/index.html
index 030552d..5bd8acf 100644
--- a/docs/tutorials-introduction/index.html
+++ b/docs/tutorials-introduction/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/tutorials/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorials/index.html b/docs/tutorials/index.html
index b0951f2..c6f92a2 100644
--- a/docs/tutorials/index.html
+++ b/docs/tutorials/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/union-set-operator/index.html
----------------------------------------------------------------------
diff --git a/docs/union-set-operator/index.html b/docs/union-set-operator/index.html
index 21b705f..7c5d486 100644
--- a/docs/union-set-operator/index.html
+++ b/docs/union-set-operator/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/use/index.html
----------------------------------------------------------------------
diff --git a/docs/use/index.html b/docs/use/index.html
index 50fcf53..40a6538 100644
--- a/docs/use/index.html
+++ b/docs/use/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/useful-research/index.html
----------------------------------------------------------------------
diff --git a/docs/useful-research/index.html b/docs/useful-research/index.html
index 2005888..47ace20 100644
--- a/docs/useful-research/index.html
+++ b/docs/useful-research/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-apache-drill-with-tableau-9-desktop/index.html
----------------------------------------------------------------------
diff --git a/docs/using-apache-drill-with-tableau-9-desktop/index.html b/docs/using-apache-drill-with-tableau-9-desktop/index.html
index 8b92d43..dbf3f58 100644
--- a/docs/using-apache-drill-with-tableau-9-desktop/index.html
+++ b/docs/using-apache-drill-with-tableau-9-desktop/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-apache-drill-with-tableau-9-server/index.html
----------------------------------------------------------------------
diff --git a/docs/using-apache-drill-with-tableau-9-server/index.html b/docs/using-apache-drill-with-tableau-9-server/index.html
index bc46d0b..9ddb543 100644
--- a/docs/using-apache-drill-with-tableau-9-server/index.html
+++ b/docs/using-apache-drill-with-tableau-9-server/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-custom-functions-in-queries/index.html
----------------------------------------------------------------------
diff --git a/docs/using-custom-functions-in-queries/index.html b/docs/using-custom-functions-in-queries/index.html
index 8606220..b18be1b 100644
--- a/docs/using-custom-functions-in-queries/index.html
+++ b/docs/using-custom-functions-in-queries/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-drill-explorer/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-explorer/index.html b/docs/using-drill-explorer/index.html
index bf75cc4..13ce0db 100644
--- a/docs/using-drill-explorer/index.html
+++ b/docs/using-drill-explorer/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-drill-with-bi-tools-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-with-bi-tools-introduction/index.html b/docs/using-drill-with-bi-tools-introduction/index.html
index b2254a5..26693b3 100644
--- a/docs/using-drill-with-bi-tools-introduction/index.html
+++ b/docs/using-drill-with-bi-tools-introduction/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-drill-with-bi-tools/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-with-bi-tools/index.html b/docs/using-drill-with-bi-tools/index.html
index 70e9f16..7be7cf4 100644
--- a/docs/using-drill-with-bi-tools/index.html
+++ b/docs/using-drill-with-bi-tools/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-jdbc-with-squirrel-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/using-jdbc-with-squirrel-on-windows/index.html b/docs/using-jdbc-with-squirrel-on-windows/index.html
index 6ae49e6..19ad440 100644
--- a/docs/using-jdbc-with-squirrel-on-windows/index.html
+++ b/docs/using-jdbc-with-squirrel-on-windows/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-microstrategy-analytics-with-apache-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/using-microstrategy-analytics-with-apache-drill/index.html b/docs/using-microstrategy-analytics-with-apache-drill/index.html
index e95cb65..eb95759 100644
--- a/docs/using-microstrategy-analytics-with-apache-drill/index.html
+++ b/docs/using-microstrategy-analytics-with-apache-drill/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-sql-functions-clauses-and-joins/index.html
----------------------------------------------------------------------
diff --git a/docs/using-sql-functions-clauses-and-joins/index.html b/docs/using-sql-functions-clauses-and-joins/index.html
index acb85ef..76ccc44 100644
--- a/docs/using-sql-functions-clauses-and-joins/index.html
+++ b/docs/using-sql-functions-clauses-and-joins/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-the-jdbc-driver/index.html
----------------------------------------------------------------------
diff --git a/docs/using-the-jdbc-driver/index.html b/docs/using-the-jdbc-driver/index.html
index 2778e00..95f9608 100644
--- a/docs/using-the-jdbc-driver/index.html
+++ b/docs/using-the-jdbc-driver/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/using-tibco-spotfire-desktop-with-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/using-tibco-spotfire-desktop-with-drill/index.html b/docs/using-tibco-spotfire-desktop-with-drill/index.html
index abf853b..a270cf9 100644
--- a/docs/using-tibco-spotfire-desktop-with-drill/index.html
+++ b/docs/using-tibco-spotfire-desktop-with-drill/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/value-vectors/index.html
----------------------------------------------------------------------
diff --git a/docs/value-vectors/index.html b/docs/value-vectors/index.html
index 48ec396..a2ce775 100644
--- a/docs/value-vectors/index.html
+++ b/docs/value-vectors/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/what-is-apache-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/what-is-apache-drill/index.html b/docs/what-is-apache-drill/index.html
index 838eae1..835ad7e 100644
--- a/docs/what-is-apache-drill/index.html
+++ b/docs/what-is-apache-drill/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/where-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/where-clause/index.html b/docs/where-clause/index.html
index 8d23379..b0c1e64 100644
--- a/docs/where-clause/index.html
+++ b/docs/where-clause/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/why-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/why-drill/index.html b/docs/why-drill/index.html
index cb3ff2b..e3e1ca0 100644
--- a/docs/why-drill/index.html
+++ b/docs/why-drill/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/wikipedia-edit-history/index.html
----------------------------------------------------------------------
diff --git a/docs/wikipedia-edit-history/index.html b/docs/wikipedia-edit-history/index.html
index 5038fc2..4f7f87c 100644
--- a/docs/wikipedia-edit-history/index.html
+++ b/docs/wikipedia-edit-history/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/with-clause/index.html
----------------------------------------------------------------------
diff --git a/docs/with-clause/index.html b/docs/with-clause/index.html
index fe5a4cc..b10c6b6 100644
--- a/docs/with-clause/index.html
+++ b/docs/with-clause/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
@@ -1004,8 +1008,9 @@ name, an optional list of column names, and a SELECT statement.</p>
<p>The WITH clause supports the following syntax:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">WITH with_subquery [, ...]
-where with_subquery is:
-with_subquery_table_name [ ( column_name [, ...] ) ] AS ( query )
+</code></pre></div>
+<p>where with_subquery is:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">with_subquery_table_name [ ( column_name [, ...] ) ] AS ( query )
</code></pre></div>
<h2 id="parameters">Parameters</h2>
@@ -1019,7 +1024,7 @@ An optional list of output column names for the WITH clause subquery,
separated by commas. The number of column names specified must be equal to or
less than the number of columns defined by the subquery.</p>
-<p>query<br>
+<p><em>query</em><br>
Any SELECT query that Drill supports. See
<a href="/docs/SELECT+Statements">SELECT</a>.</p>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/docs/workspaces/index.html
----------------------------------------------------------------------
diff --git a/docs/workspaces/index.html b/docs/workspaces/index.html
index 0449fdd..ecabf88 100644
--- a/docs/workspaces/index.html
+++ b/docs/workspaces/index.html
@@ -906,6 +906,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li>
+
+
+
<li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/47760316/feed.xml
----------------------------------------------------------------------
diff --git a/feed.xml b/feed.xml
index f60ea97..0e1f791 100644
--- a/feed.xml
+++ b/feed.xml
@@ -6,8 +6,8 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Tue, 30 Jun 2015 18:35:04 -0700</pubDate>
- <lastBuildDate>Tue, 30 Jun 2015 18:35:04 -0700</lastBuildDate>
+ <pubDate>Wed, 01 Jul 2015 16:49:25 -0700</pubDate>
+ <lastBuildDate>Wed, 01 Jul 2015 16:49:25 -0700</lastBuildDate>
<generator>Jekyll v2.5.2</generator>
<item>