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:35:57 UTC
[03/17] drill-site git commit: Bridget/Kris Drill 1.2 Doc Updates
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/text-files-csv-tsv-psv/index.html
----------------------------------------------------------------------
diff --git a/docs/text-files-csv-tsv-psv/index.html b/docs/text-files-csv-tsv-psv/index.html
index aa95581..36ce340 100644
--- a/docs/text-files-csv-tsv-psv/index.html
+++ b/docs/text-files-csv-tsv-psv/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/troubleshooting/index.html
----------------------------------------------------------------------
diff --git a/docs/troubleshooting/index.html b/docs/troubleshooting/index.html
index 3313fc7..6ceed46 100644
--- a/docs/troubleshooting/index.html
+++ b/docs/troubleshooting/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/tutorial-develop-a-simple-function/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorial-develop-a-simple-function/index.html b/docs/tutorial-develop-a-simple-function/index.html
index e5d7aa8..985bca8 100644
--- a/docs/tutorial-develop-a-simple-function/index.html
+++ b/docs/tutorial-develop-a-simple-function/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>
@@ -1166,8 +1148,8 @@ Basic Coding Rules</h2>
<p>To leverage Java’s just-in-time (JIT) compiler for maximum speed, you need to adhere to some basic rules.</p>
<ul>
-<li>Do not use imports. Instead, use the fully qualified class name as required by the Google Guava API packaged in Apache Drill and as shown in <a href="/docs/tutorial-develop-a-simple-function/#step-3-declare-input-parameters">"Step 3: Declare input parameters"</a>.<br></li>
-<li>Manipulate the ValueHolders classes, for example VarCharHolder and IntHolder, as structs by calling helper methods, such as getStringFromVarCharHolder and toStringFromUTF8 as shown in <a href="/docs/tutorial-develop-a-simple-function/#step-5-implement-the-eval-function">"Step 5: Implement the eval() function"</a>.<br></li>
+<li>Do not use imports. Instead, use the fully qualified class name as required by the Google Guava API packaged in Apache Drill and as shown in <a href="/docs/tutorial-develop-a-simple-function/#step-3:-declare-input-parameters">"Step 3: Declare input parameters"</a>.<br></li>
+<li>Manipulate the ValueHolders classes, for example VarCharHolder and IntHolder, as structs by calling helper methods, such as getStringFromVarCharHolder and toStringFromUTF8 as shown in <a href="/docs/tutorial-develop-a-simple-function/#step-5:-implement-the-eval()-method">"Step 5: Implement the eval() function"</a>.<br></li>
<li>Do not call methods such as toString because this causes serious problems.</li>
</ul>
@@ -1218,7 +1200,7 @@ Basic Coding Rules</h2>
<h2 id="test-the-new-function">Test the New Function</h2>
-<p>Restart drill and run the following query:</p>
+<p>Restart drill and run the following query on the <a href="/docs/querying-json-files/"><code>employee.json</code></a> file installed with Drill:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT MASK(first_name, '*' , 3) FIRST , MASK(last_name, '#', 7) LAST FROM cp.`employee.json` LIMIT 5;
+----------+------------+
| FIRST | LAST |
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/tutorials-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorials-introduction/index.html b/docs/tutorials-introduction/index.html
index 7352ee6..51b67d5 100644
--- a/docs/tutorials-introduction/index.html
+++ b/docs/tutorials-introduction/index.html
@@ -77,10 +77,6 @@
<li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
- <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-
- <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
</ul>
@@ -249,6 +245,10 @@
</ul>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+
+
</ul>
@@ -290,6 +290,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+
+
+
<li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
<ul style="display: none">
@@ -660,6 +664,8 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+
<li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
</ul>
@@ -702,10 +708,12 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-
<li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+
<li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
<li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
- <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-
-
- </ul>
-
-
-
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/tutorials/index.html
----------------------------------------------------------------------
diff --git a/docs/tutorials/index.html b/docs/tutorials/index.html
index c566b0c..3374c0b 100644
--- a/docs/tutorials/index.html
+++ b/docs/tutorials/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/union-set-operator/index.html
----------------------------------------------------------------------
diff --git a/docs/union-set-operator/index.html b/docs/union-set-operator/index.html
index 9dbb910..7b3af2f 100644
--- a/docs/union-set-operator/index.html
+++ b/docs/union-set-operator/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/use/index.html
----------------------------------------------------------------------
diff --git a/docs/use/index.html b/docs/use/index.html
index 1342394..7951b19 100644
--- a/docs/use/index.html
+++ b/docs/use/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/useful-research/index.html
----------------------------------------------------------------------
diff --git a/docs/useful-research/index.html b/docs/useful-research/index.html
index aa71c18..0fbd041 100644
--- a/docs/useful-research/index.html
+++ b/docs/useful-research/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/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 95da240..d0319c4 100644
--- a/docs/using-apache-drill-with-tableau-9-desktop/index.html
+++ b/docs/using-apache-drill-with-tableau-9-desktop/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/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 89b8ad8..b2b3d2a 100644
--- a/docs/using-apache-drill-with-tableau-9-server/index.html
+++ b/docs/using-apache-drill-with-tableau-9-server/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/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 d8d30b7..325e7a0 100644
--- a/docs/using-custom-functions-in-queries/index.html
+++ b/docs/using-custom-functions-in-queries/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>
@@ -1011,7 +993,7 @@ locates the function for the request, Drill processes the query and applies
the function during processing.</p>
<p>Your Drill installation includes sample files in the Drill classpath. One
-sample file, <code>employee.json</code>, contains some fictitious employee data that you
+sample file, <a href="/docs/querying-json-files/"><code>employee.json</code></a>, contains some fictitious employee data that you
can query with a custom function.</p>
<h2 id="simple-function-example">Simple Function Example</h2>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/using-drill-explorer/index.html
----------------------------------------------------------------------
diff --git a/docs/using-drill-explorer/index.html b/docs/using-drill-explorer/index.html
index b8efb11..19eb9ec 100644
--- a/docs/using-drill-explorer/index.html
+++ b/docs/using-drill-explorer/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/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 1ceb0f1..b74bbd6 100644
--- a/docs/using-drill-with-bi-tools-introduction/index.html
+++ b/docs/using-drill-with-bi-tools-introduction/index.html
@@ -77,10 +77,6 @@
<li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
- <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-
- <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
</ul>
@@ -249,6 +245,10 @@
</ul>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+
+
</ul>
@@ -290,6 +290,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+
+
+
<li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
<ul style="display: none">
@@ -660,6 +664,8 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+
<li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
</ul>
@@ -702,10 +708,12 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-
<li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+
<li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
<li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
- <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-
-
- </ul>
-
-
-
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/docs/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 6b85e05..6f8a7d3 100644
--- a/docs/using-drill-with-bi-tools/index.html
+++ b/docs/using-drill-with-bi-tools/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/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 50b2307..9757266 100644
--- a/docs/using-jdbc-with-squirrel-on-windows/index.html
+++ b/docs/using-jdbc-with-squirrel-on-windows/index.html
@@ -77,10 +77,6 @@
<li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
- <li><a href="/docs/archived-pages/">Archived Pages</a></li>
-
- <li><a href="/docs/progress-reports/">Progress Reports</a></li>
-
<li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
</ul>
@@ -249,6 +245,10 @@
</ul>
+
+ <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li>
+
+
</ul>
@@ -290,6 +290,10 @@
+ <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li>
+
+
+
<li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li>
<ul style="display: none">
@@ -660,6 +664,8 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li>
+
<li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li>
</ul>
@@ -702,10 +708,12 @@
<li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
- <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
-
<li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li>
+
+ <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+
<li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
<li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
@@ -944,32 +952,6 @@
- <li class="toctree-l1"><a href="javascript: void(0);">Archived Pages</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
-
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
-
-
- </ul>
-
-
-
- <li class="toctree-l1"><a href="javascript: void(0);">Progress Reports</a></li>
- <ul style="display: none">
-
-
- <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-
-
- </ul>
-
-
-
<li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
http://git-wip-us.apache.org/repos/asf/drill-site/blob/b0ce85e7/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 70dc5f3..628e358 100644
--- a/docs/using-microstrategy-analytics-with-apache-drill/index.html
+++ b/docs/using-microstrategy-analytics-with-apache-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/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 803d795..4c8cc4c 100644
--- a/docs/using-sql-functions-clauses-and-joins/index.html
+++ b/docs/using-sql-functions-clauses-and-joins/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/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 b065b0d..c893ad6 100644
--- a/docs/using-the-jdbc-driver/index.html
+++ b/docs/using-the-jdbc-driver/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>
@@ -1005,81 +987,66 @@
<div class="int_text" align="left">
- <p>This section explains how to install and use the JDBC driver for Apache Drill. For specific examples of client tool connections to Drill via JDBC, see <a href="/docs/using-jdbc-with-squirrel-on-windows">Using JDBC with SQuirreL</a> and <a href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Spotfire Server</a>.</p>
-
-<h3 id="prerequisites">Prerequisites</h3>
-
-<ul>
-<li>JRE 7 or JDK 7</li>
-<li>Drill installed either in embedded mode or in distributed mode on one or more nodes in a cluster. Refer to the <a href="/docs/install-drill/">Install Drill</a> documentation for more information.</li>
-<li><p>The client must be able to resolve the actual hostname of the Drill node(s) with the IP(s). Verify that a DNS entry was created on the client machine for the Drill node(s). If a DNS entry does not exist, create the entry for the Drill node(s).</p>
-
-<ul>
-<li>For Windows, create the entry in the %WINDIR%\system32\drivers\etc\hosts file.</li>
-<li>For Linux and Mac OSX, create the entry in /etc/hosts.<br>
-<drill-machine-IP> <drill-machine-hostname>
-For example: <code>127.0.1.1 maprdemo</code></li>
-</ul></li>
-</ul>
-
-<hr>
-
-<h3 id="getting-the-drill-jdbc-driver">Getting the Drill JDBC Driver</h3>
-
-<p>The Drill JDBC Driver <code>JAR</code> file must exist in a directory on a client machine so you can configure the driver for the application or third-party tool that you intend to use. You can obtain the driver in two different ways:</p>
+ <p>This section explains how to install and use the JDBC driver for Apache Drill. To use the JDBC driver, you have to:</p>
<ol>
-<li><p>Copy the <code>drill-jdbc-all</code> JAR file from the following Drill installation directory on a node where Drill is installed to a directory on your client machine:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text"><drill_installation_directory>/jars/jdbc-driver/drill-jdbc-all-<version>.jar
-</code></pre></div>
-<p>For example, on a MapR cluster: <code>/opt/mapr/drill/drill-1.0.0/jars/jdbc-driver/drill-jdbc-all-1.0.0-mapr-r1.jar</code></p></li>
-<li><p>Download the following tar file to a location on your client machine: <a href="http://apache.osuosl.org/drill/drill-1.0.0/apache-drill-1.0.0-src.tar.gz">apache-
-drill-1.0.0.tar.gz</a> and extract the file. You may need to use a decompression utility, such as <a href="http://www.7-zip.org/">7-zip</a>. The driver is extracted to the following directory:</p>
-
-<p><drill-home>\apache-drill-<version>\jars\jdbc-driver\drill-jdbc-all-<version>.jar</p></li>
+<li><a href="/docs/using-the-jdbc-driver/#prerequisites">Meet prerequisites</a>.</li>
+<li><a href="/docs/using-the-jdbc-driver/#getting-the-drill-jdbc-driver">Get the Drill JDBC Driver</a>.</li>
+<li>Put the Drill JDBC jar file on the classpath.</li>
+<li>Use a <a href="/docs/using-the-jdbc-driver/#using-the-jdbc-url-for-a-random-drillbit-connection">valid URL</a> in the JDBC connection string when you write application code or configure BI tools.</li>
+<li>Use the <a href="/docs/using-the-jdbc-driver/#using-the-drill-driver-class-name">name of the Drill driver class</a> in application code or in the configuration of client tools.</li>
</ol>
-<hr>
-
-<h3 id="configuring-a-driver-application-or-client">Configuring a Driver Application or Client</h3>
-
-<p>To configure a JDBC application, users have to:</p>
+<p>Most client tools provide a UI where you can enter all of the required connection information, including the driver location, connection URL, and driver class name. For specific examples of client tool connections to Drill through JDBC, see <a href="/docs/using-jdbc-with-squirrel-on-windows">Using JDBC with SQuirreL</a> and <a href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Spotfire Server</a>.</p>
-<ol>
-<li>Put the Drill JDBC jar file on the class path.</li>
-<li>Use a valid Drill JDBC URL.</li>
-<li>Configure tools or application code with the name of the Drill driver class.</li>
-</ol>
+<h2 id="prerequisites">Prerequisites</h2>
-<p>Most client tools provide a UI where you can enter all of the required connection information, including the Driver location, connection URL, and driver class name.</p>
-
-<h3 id="jdbc-driver-urls">JDBC Driver URLs</h3>
+<ul>
+<li>JRE 7 or JDK 7<br></li>
+<li><a href="/docs/install-drill/">A Drill installation</a><br></li>
+<li>Capability to resolve the actual host name of the Drill node(s) with the IP(s), as described in step 4 of <a href="/docs/configuring-jreport-with-drill/#step-1:-install-the-drill-jdbc-driver-with-jreport">Install the Drill JDBC Driver with JReport</a>. </li>
+</ul>
-<p>The driver URLs that you use to create JDBC connection strings must be formed as follows:</p>
+<h2 id="getting-the-drill-jdbc-driver">Getting the Drill JDBC Driver</h2>
-<p><code>jdbc:drill:zk=<zookeeper_quorum>:<port>/<drill_directory_in_zookeeper>/<cluster_ID>;schema=<schema_to_use_as_default></code></p>
+<p>The Drill JDBC Driver <code>JAR</code> file must exist on a client machine so you can configure the driver for the application or third-party tool that you intend to use. Obtain the driver in one of the following ways:</p>
-<p>Any Drill JDBC URL must start with: <code>jdbc:drill</code>.</p>
+<ul>
+<li>Copy the <code>drill-jdbc-all</code> JAR file from the following Drill installation directory on a node where Drill is installed to a directory on your client machine:<br>
+<code><drill_installation_directory>/jars/jdbc-driver/drill-jdbc-all-<version>.jar</code><br></li>
+</ul>
-<p><strong>ZooKeeper Quorum</strong></p>
+<p>Or</p>
-<p>To connect to a cluster, specify the ZooKeeper quorum as a list of hostnames or IP addresses. </p>
+<ul>
+<li>Download the following TAR file to a location on your client machine: <a href="http://apache.osuosl.org/drill/drill-1.0.0/apache-drill-1.0.0-src.tar.gz">apache-
+drill-1.0.0.tar.gz</a>. Extract the file. On Windows, you may need to use a decompression utility, such as <a href="http://www.7-zip.org/">7-zip</a>. The driver is extracted to the following directory:<br>
+<code><drill-installation_directory>/jars/jdbc-driver/drill-jdbc-all-<version>.jar</code></li>
+</ul>
-<p><strong>ZooKeeper Port Number</strong></p>
+<h2 id="using-the-jdbc-url-for-a-random-drillbit-connection">Using the JDBC URL for a Random Drillbit Connection</h2>
-<p>The default ZooKeeper port is 2181. On a MapR cluster, the ZooKeeper port is 5181.</p>
+<p>The format of the JDBC URL differs slightly, depending on the way you want to connect to the Drillbit: random, local, or direct. This section covers using the URL for a random or local connection. Using a URL to <a href="/docs/using-the-jdbc-driver/#using-the-jdbc-url-format-for-a-direct-drillbit-connection">directly connect to a Drillbit</a> is covered later. If you want ZooKeeper to randomly choose a Drillbit in the cluster, or if you want to connect to the local Drillbit, the format of the driver URL is:</p>
-<p><strong>Drill Directory in ZooKeeper</strong></p>
+<p><code>jdbc:drill:[schema=<storage plugin>;]zk=<zk name>[:<port>][,<zk name2>[:<port>]...</code><br>
+ <code>]<directory>/<cluster ID></code></p>
-<p>The name of the Drill directory stored in ZooKeeper is <code>/drill</code>.</p>
+<p>where</p>
-<p><strong>Cluster ID</strong></p>
+<ul>
+<li><code>jdbc</code> is the connection type. Required.<br></li>
+<li><code>schema</code> is the name of a <a href="/docs/storage-plugin-registration">storage plugin</a> configuration to use as the default for queries. For example,<code>schema=hive</code>. Optional.<br></li>
+<li><code>zk name</code> specifies one or more ZooKeeper host names, or IP addresses. Use <code>local</code> instead of a host name or IP address to connect to the local Drillbit. Required. </li>
+<li><code>port</code> is the ZooKeeper port number. Port 2181 is the default. On a MapR cluster, the default is 5181. Optional. </li>
+<li><code>directory</code> is the Drill directory in ZooKeeper, which by default is <code>/Drill</code>. Optional. </li>
+<li><code>cluster ID</code> is <code>drillbits1</code> by default. If the default has changed, <a href="/docs/using-the-jdbc-driver/#determining-the-cluster-id">determine the cluster ID</a> and use it. Optional.</li>
+</ul>
-<p>The Drill default cluster ID is <code>drillbits1</code>.</p>
+<h3 id="determining-the-cluster-id">Determining the Cluster ID</h3>
-<p>On a MapR cluster, check the following file for the cluster ID:</p>
+<p>To determine the cluster ID, check the following file:</p>
-<p><code>/opt/mapr/drill/drill-1.0.0/conf/drill-override.conf</code></p>
+<p><code><drill-installation>/conf/drill-override.conf</code></p>
<p>For example:</p>
@@ -1090,34 +1057,49 @@ drill.exec: {
}
...</code></p>
-<p><strong>Schema</strong></p>
-
-<p>Optionally, include the default schema for the JDBC connection. For example:</p>
-
-<p><code>schema=hive</code></p>
-
<h3 id="url-examples">URL Examples</h3>
<p><strong>Single-Node Installation</strong></p>
<p><code>jdbc:drill:zk=maprdemo:5181</code></p>
-<p><code>jdbc:drill:zk=centos23.lab:5181/drill/docs41cluster-drillbits</code></p>
+<p><code>jdbc:drill:zk=centos23.lab:2181/drill/docs41cluster-drillbits</code></p>
-<p><code>jdbc:drill:zk=10.10.100.56:5181/drill/drillbits1;schema=hive</code></p>
+<p><code>jdbc:drill:zk=10.10.100.56:2181/drill/drillbits1;schema=hive</code></p>
<p><strong>Cluster Installation</strong></p>
-<p><code>jdbc:drill:zk=10.10.100.30:5181,10.10.100.31:5181,10.10.100.32:5181/drill/drillbits1;schema=hive</code></p>
+<p><code>jdbc:drill:zk=10.10.100.30:5181,10.10.100.31:5181,10.10.100.32:2181/drill/drillbits1;schema=hive</code></p>
+
+<h2 id="using-the-jdbc-url-format-for-a-direct-drillbit-connection">Using the JDBC URL Format for a Direct Drillbit Connection</h2>
+
+<p>If you want to connect directly to a Drillbit instead of using ZooKeeper to choose the Drillbit, replace <code>zk=<zk name></code> with <code>drillbit=<node></code> as shown in the following URL.</p>
+
+<p><code>jdbc:drill:[schema=<storage plugin>;]drillbit=<node name>[:<port>][,<node name2>[:<port>]...</code><br>
+ <code>]<directory>/<cluster ID></code></p>
-<hr>
+<p>where</p>
-<h3 id="driver-class-name">Driver Class Name</h3>
+<p><code>drillbit=<node name></code> specifies one or more host names or IP addresses of cluster nodes running Drill. </p>
-<p>The class name for the JDBC driver is <code>org.apache.drill.jdbc.Driver</code></p>
+<p>For definitions of other URL components, see <a href="/docs/using-the-jdbc-driver/#using-the-jdbc-url-for-a-random-drillbit-connection">Using the JDBC URL for a Random Drillbit Connection</a>.</p>
-<hr>
+<h2 id="using-the-drill-driver-class-name">Using the Drill Driver Class Name</h2>
+<p>The class name for the JDBC driver is <code>org.apache.drill.jdbc.Driver</code>. </p>
+
+<h2 id="example-of-connecting-to-drill-programmatically">Example of Connecting to Drill Programmatically</h2>
+
+<p>The following sample code shows using the class name in a snippet that connects to Drill using the Drill-Jdbc-all driver:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">Class.forName("org.apache.drill.jdbc.Driver");
+Connection connection =DriverManager.getConnection("jdbc:drill:zk=
+node3.mynode.com:2181/drill/my_cluster_com-drillbits");
+Statement st = connection.createStatement();
+ResultSet rs = st.executeQuery("SELECT * from cp.`employee`");
+while(rs.next()){
+System.out.println(rs.getString(1));
+}
+</code></pre></div>
<div class="doc-nav">