Website update

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

Branch: refs/heads/asf-site
Commit: e6841a7481e6106df189644c6aa1ece7c9a1d3ce
Parents: 7c09fc9
Author: Tomer Shiran <[email protected]>
Authored: Tue May 5 15:24:00 2015 -0700
Committer: Tomer Shiran <[email protected]>
Committed: Tue May 5 15:24:00 2015 -0700

----------------------------------------------------------------------
 data/index.html                                 |  18 +
 docs/2014-q1-drill-report/index.html            |  12 +
 docs/about-sql-function-examples/index.html     |  12 +
 docs/about-the-mapr-sandbox/index.html          |  12 +
 .../adding-custom-functions-to-drill/index.html |  12 +
 docs/advanced-properties/index.html             |  46 +-
 .../index.html                                  |  12 +
 docs/alter-session-command/index.html           |  12 +
 docs/alter-system-command/index.html            |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 docs/aol-search/index.html                      |  12 +
 .../apache-drill-0-4-0-release-notes/index.html |  12 +
 .../apache-drill-0-5-0-release-notes/index.html |  12 +
 .../apache-drill-0-6-0-release-notes/index.html |  12 +
 .../apache-drill-0-7-0-release-notes/index.html |  12 +
 .../apache-drill-0-8-0-release-notes/index.html |  14 +-
 .../apache-drill-0-9-0-release-notes/index.html | 882 ++++++++++++++++++
 .../index.html                                  |  12 +
 docs/apache-drill-contribution-ideas/index.html |  12 +
 .../index.html                                  |  12 +
 docs/architectural-highlights/index.html        |  12 +
 docs/architecture-introduction/index.html       |  12 +
 docs/architecture/index.html                    |  12 +
 docs/archived-pages/index.html                  |  12 +
 docs/case/index.html                            |  12 +
 docs/compiling-drill-from-source/index.html     |  12 +
 .../index.html                                  |  12 +
 docs/configuration-options/index.html           |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 docs/connect-a-data-source/index.html           |  12 +
 docs/connecting-to-odbc-data-sources/index.html |  29 +-
 docs/contribute-to-drill/index.html             |  12 +
 docs/core-modules/index.html                    |  12 +
 docs/create-table-as-ctas-command/index.html    |  12 +
 docs/create-view-command/index.html             |  12 +
 docs/custom-function-interfaces/index.html      |  59 +-
 .../index.html                                  |  12 +
 docs/data-sources-and-file-formats/index.html   |  12 +
 docs/data-type-conversion/index.html            | 416 +++++----
 docs/data-types/index.html                      |  12 +
 docs/date-time-and-timestamp/index.html         |  12 +
 .../index.html                                  |  42 +-
 docs/deploying-and-using-a-hive-udf/index.html  |  12 +
 docs/describe-command/index.html                |  12 +
 docs/design-docs/index.html                     |  12 +
 docs/develop-a-simple-function/index.html       |  12 +
 .../index.html                                  |  12 +
 docs/develop-custom-functions/index.html        |  12 +
 docs/develop-drill/index.html                   |  12 +
 docs/developer-information/index.html           |  12 +
 .../developing-an-aggregate-function/index.html |  12 +
 docs/distributed-mode-prerequisites/index.html  |  12 +
 docs/drill-default-input-format/index.html      |  12 +
 docs/drill-in-10-minutes/index.html             |  12 +
 docs/drill-introduction/index.html              |  43 +-
 docs/drill-patch-review-tool/index.html         |  12 +
 docs/drill-plan-syntax/index.html               |  12 +
 docs/driver-configuration-options/index.html    |  56 +-
 docs/embedded-mode-prerequisites/index.html     |  12 +
 docs/enron-emails/index.html                    |  12 +
 docs/explain-commands/index.html                |  12 +
 docs/file-system-storage-plugin/index.html      |  12 +
 docs/flatten/index.html                         |  12 +
 docs/flexibility/index.html                     |  12 +
 docs/functions-for-handling-nulls/index.html    |  12 +
 docs/getting-started/index.html                 |  12 +
 .../index.html                                  |  12 +
 docs/handling-different-data-types/index.html   |  12 +
 docs/hbase-storage-plugin/index.html            |  12 +
 docs/hive-storage-plugin/index.html             |  12 +
 docs/hive-to-drill-data-type-mapping/index.html | 188 ++--
 docs/how-to-run-the-drill-demo/index.html       |  12 +
 docs/img/spotfire_1.png                         | Bin 0 -> 63223 bytes
 docs/img/spotfire_2.png                         | Bin 0 -> 120724 bytes
 docs/img/spotfire_3.png                         | Bin 0 -> 23075 bytes
 docs/img/spotfire_4.png                         | Bin 0 -> 23999 bytes
 docs/img/spotfire_5.png                         | Bin 0 -> 45511 bytes
 docs/img/spotfire_6.png                         | Bin 0 -> 48674 bytes
 docs/index.html                                 |  18 +-
 docs/install-drill-introduction/index.html      |  12 +
 docs/install-drill/index.html                   |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 docs/installing-drill-on-the-cluster/index.html |  14 +-
 docs/installing-drill-on-windows/index.html     |  12 +
 .../index.html                                  |  12 +
 docs/installing-the-driver-on-linux/index.html  |  18 +-
 .../index.html                                  |  14 +-
 .../installing-the-driver-on-windows/index.html |  16 +-
 docs/interfaces-introduction/index.html         |  12 +
 docs/json-data-model/index.html                 |  67 +-
 docs/kvgen/index.html                           |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 docs/lexical-structure/index.html               |  12 +
 docs/manage-drill-introduction/index.html       |  12 +
 docs/manage-drill/index.html                    |  12 +
 docs/mapr-db-format/index.html                  |  12 +
 docs/math-and-trig/index.html                   | 277 +++---
 docs/mongodb-plugin-for-apache-drill/index.html |  12 +
 .../index.html                                  |  12 +
 docs/nested-data-functions/index.html           |  12 +
 docs/nested-data-limitations/index.html         |  12 +
 docs/odbc-jdbc-interfaces/index.html            |  18 +
 .../index.html                                  |  12 +
 docs/operators/index.html                       |  12 +
 docs/parquet-format/index.html                  | 282 +++---
 docs/partition-pruning/index.html               |  12 +
 docs/performance/index.html                     |  12 +
 .../persistent-configuration-storage/index.html |  28 +-
 docs/planning-and-execution-options/index.html  |  12 +
 .../index.html                                  |  12 +
 docs/ports-used-by-drill/index.html             |  46 +-
 docs/progress-reports/index.html                |  12 +
 docs/project-bylaws/index.html                  |  12 +
 docs/query-data-introduction/index.html         |  12 +
 docs/query-data/index.html                      |  14 +-
 docs/query-directory-functions/index.html       |  12 +
 docs/query-stages/index.html                    |  12 +
 .../index.html                                  |  12 +
 docs/querying-a-file-system/index.html          |  12 +
 .../index.html                                  |  12 +
 docs/querying-complex-data/index.html           |  12 +
 docs/querying-directories/index.html            |  12 +
 docs/querying-hbase/index.html                  |  12 +
 docs/querying-hive/index.html                   |  12 +
 docs/querying-json-files/index.html             |  12 +
 docs/querying-parquet-files/index.html          |  12 +
 docs/querying-plain-text-files/index.html       |  12 +
 docs/querying-system-tables/index.html          |  12 +
 docs/querying-the-information-schema/index.html |  12 +
 docs/release-notes/index.html                   |  15 +
 docs/repeated-contains/index.html               |  12 +
 docs/repeated-count/index.html                  |  12 +
 docs/reserved-keywords/index.html               |  12 +
 docs/rpc-overview/index.html                    |  12 +
 docs/sample-data-donuts/index.html              |  12 +
 docs/sample-datasets/index.html                 |  14 +-
 docs/select-statements/index.html               |  12 +
 docs/selecting-flat-data/index.html             |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 docs/show-files-command/index.html              |  12 +
 docs/show-tables-command/index.html             |  12 +
 docs/sql-commands/index.html                    |  12 +
 docs/sql-conditional-expressions/index.html     |  12 +
 docs/sql-extensions/index.html                  |  67 +-
 docs/sql-functions/index.html                   |  12 +
 docs/sql-reference-introduction/index.html      |  12 +
 docs/sql-reference/index.html                   |  12 +
 docs/start-up-options/index.html                |  12 +
 .../index.html                                  |  12 +
 .../index.html                                  |  12 +
 docs/starting-drill-on-windows/index.html       |  12 +
 docs/starting-stopping-drill/index.html         |  12 +
 docs/storage-plugin-configuration/index.html    |  12 +
 docs/storage-plugin-registration/index.html     |  12 +
 docs/string-manipulation/index.html             |  12 +
 docs/summary/index.html                         |  12 +
 docs/supported-data-types/index.html            | 825 ++++++++---------
 docs/supported-sql-commands/index.html          |  12 +
 docs/tableau-examples/index.html                |  12 +
 docs/testing-the-odbc-connection/index.html     |  12 +
 docs/tutorials-introduction/index.html          |  12 +
 docs/tutorials/index.html                       |  12 +
 docs/use-command/index.html                     |  12 +
 docs/useful-research/index.html                 |  12 +
 docs/using-a-connection-string/index.html       |  12 +
 .../index.html                                  | 911 +++++++++++++++++++
 .../index.html                                  |  12 +
 docs/using-drill-explorer-on-windows/index.html |  12 +
 docs/using-jdbc/index.html                      |  48 +-
 .../index.html                                  |  24 +-
 .../using-odbc-on-linux-and-mac-os-x/index.html |  12 +
 docs/using-odbc-on-windows/index.html           |  12 +
 .../index.html                                  |  12 +
 docs/value-vectors/index.html                   |  12 +
 docs/what-is-apache-drill/index.html            |  12 +
 docs/why-drill/index.html                       |  12 +
 docs/wikipedia-edit-history/index.html          |  12 +
 docs/workspaces/index.html                      |  12 +
 feed.xml                                        |   4 +-
 toc/index.html                                  | 231 +++++
 195 files changed, 5542 insertions(+), 1086 deletions(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/data/index.html
----------------------------------------------------------------------
diff --git a/data/index.html b/data/index.html
index 667eb2d..bcc2873 100644
--- a/data/index.html
+++ b/data/index.html
@@ -546,6 +546,18 @@
     "relative_path": 
"_docs/odbc-jdbc-interfaces/050-using-microstrategy-analytics-with-drill.md"
 },
 {
+    "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/",
+    "title": "Using Apache Drill with Tibco Spotfire Desktop",
+    "parent": "ODBC/JDBC Interfaces",
+    "relative_path": 
"_docs/odbc-jdbc-interfaces/060-using-apache-drill-with-tibco-spotfire-desktop.md"
+},
+{
+    "url": "/docs/using-apache-drill-with-tibco-spotfire-desktop/",
+    "title": "Using Apache Drill with Tibco Spotfire Desktop",
+    "parent": "ODBC/JDBC Interfaces",
+    "relative_path": "_docs/odbc-jdbc-interfaces/060-using-spotfire.md"
+},
+{
     "url": "/docs/odbc-on-linux-and-mac-introduction/",
     "title": "ODBC on Linux and Mac Introduction",
     "parent": "Using ODBC on Linux and Mac OS X",
@@ -780,6 +792,12 @@
     "relative_path": "_docs/rn/060-0.8.0-rn.md"
 },
 {
+    "url": "/docs/apache-drill-0-9-0-release-notes/",
+    "title": "Apache Drill 0.9.0 Release Notes",
+    "parent": "Release Notes",
+    "relative_path": "_docs/rn/070-0.9.0-rn.md"
+},
+{
     "url": "/docs/aol-search/",
     "title": "AOL Search",
     "parent": "Sample Datasets",

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/2014-q1-drill-report/index.html
----------------------------------------------------------------------
diff --git a/docs/2014-q1-drill-report/index.html 
b/docs/2014-q1-drill-report/index.html
index f7386eb..1193c7c 100644
--- a/docs/2014-q1-drill-report/index.html
+++ b/docs/2014-q1-drill-report/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/about-sql-function-examples/index.html
----------------------------------------------------------------------
diff --git a/docs/about-sql-function-examples/index.html 
b/docs/about-sql-function-examples/index.html
index 45c7f30..3bef31c 100644
--- a/docs/about-sql-function-examples/index.html
+++ b/docs/about-sql-function-examples/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/about-the-mapr-sandbox/index.html
----------------------------------------------------------------------
diff --git a/docs/about-the-mapr-sandbox/index.html 
b/docs/about-the-mapr-sandbox/index.html
index 3a2bb08..a96b0c9 100644
--- a/docs/about-the-mapr-sandbox/index.html
+++ b/docs/about-the-mapr-sandbox/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/adding-custom-functions-to-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/adding-custom-functions-to-drill/index.html 
b/docs/adding-custom-functions-to-drill/index.html
index 2d5d4b4..8d12e21 100644
--- a/docs/adding-custom-functions-to-drill/index.html
+++ b/docs/adding-custom-functions-to-drill/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/advanced-properties/index.html
----------------------------------------------------------------------
diff --git a/docs/advanced-properties/index.html 
b/docs/advanced-properties/index.html
index 4e451c4..b007994 100644
--- a/docs/advanced-properties/index.html
+++ b/docs/advanced-properties/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       
@@ -827,7 +839,39 @@ 
TimestampTZDisplayTimezone=utc;ExcludedSchemas=test,abc</code></p>
 <p>The following table lists and describes the advanced properties that you can
 set when using the MapR Drill ODBC Driver on Linux and Mac OS X.</p>
 
-<table ><tbody><tr><td valign="top"><strong>Property Name</strong></td><td 
valign="top"><strong>Default Value</strong></td><td 
valign="top"><strong>Description</strong></td></tr><tr><td 
valign="top">HandshakeTimeout</td><td valign="top">5</td><td valign="top">An 
integer value representing the number of seconds that the driver waits before 
aborting an attempt to connect to a data source. When set to a value of 0, the 
driver does not abort connection attempts.</td></tr><tr><td 
valign="top">QueryTimeout</td><td valign="top">180</td><td valign="top">An 
integer value representing the number of seconds for the driver to wait before 
automatically stopping a query. When set to a value of 0, the driver does not 
stop queries automatically.</td></tr><tr><td 
valign="top">TimestampTZDisplayTimezone</td><td valign="top">local</td><td 
valign="top">Two values are possible:local—Timestamps are dependent on the 
time zone of the user.utc—Timestamps appear in Coordinated Universal Time 
(UTC).</td><
 /tr><tr><td valign="top">ExcludedSchemas</td><td valign="top">sys, 
INFORMATION_SCHEMA</td><td valign="top">The value of ExcludedSchemas is a list 
of schemas that do not appear in client applications such as Drill Explorer, 
Tableau, and Excel. Separate schemas in the list using a comma 
(,).</td></tr><tr><td colspan="1" valign="top"><span style="color: 
rgb(0,0,0);">CastAnyToVarchar</span></td><td colspan="1" 
valign="top">true</td><td colspan="1" valign="top"><span style="color: 
rgb(0,0,0);">Casts the “ANY” and “(VARCHAR(1), ANY) MAP” data types 
returned from SQL column calls into type 
“VARCHAR”.</span></td></tr></tbody></table>
+<table><thead>
+<tr>
+<th>Property Name</th>
+<th>Default Value</th>
+<th>Description</th>
+</tr>
+</thead><tbody>
+<tr>
+<td>HandshakeTimeout</td>
+<td>5</td>
+<td>An integer value representing the number of seconds that the driver waits 
before aborting an attempt to connect to a data source. When set to a value of 
0, the driver does not abort connection attempts.</td>
+</tr>
+<tr>
+<td>QueryTimeout</td>
+<td>180</td>
+<td>An integer value representing the number of seconds for the driver to wait 
before automatically stopping a query. When set to a value of 0, the driver 
does not stop queries automatically.</td>
+</tr>
+<tr>
+<td>TimestampTZDisplayTimezone</td>
+<td>local</td>
+<td>Two values are possible:local—Timestamps are dependent on the time zone 
of the user.utc—Timestamps appear in Coordinated Universal Time (UTC).</td>
+</tr>
+<tr>
+<td>ExcludedSchemas</td>
+<td>sys, INFORMATION_SCHEMA</td>
+<td>The value of ExcludedSchemas is a list of schemas that do not appear in 
client applications such as Drill Explorer, Tableau, and Excel. Separate 
schemas in the list using a comma (,).</td>
+</tr>
+<tr>
+<td>CastAnyToVarchar</td>
+<td>true</td>
+<td>Casts the “ANY” and “(VARCHAR(1), ANY) MAP” data types returned 
from SQL column calls into type “VARCHAR”.</td>
+</tr>
+</tbody></table>
 
       
         

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/aggregate-and-aggregate-statistical/index.html
----------------------------------------------------------------------
diff --git a/docs/aggregate-and-aggregate-statistical/index.html 
b/docs/aggregate-and-aggregate-statistical/index.html
index 858d477..4729eed 100644
--- a/docs/aggregate-and-aggregate-statistical/index.html
+++ b/docs/aggregate-and-aggregate-statistical/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/alter-session-command/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-session-command/index.html 
b/docs/alter-session-command/index.html
index bf215aa..558f36a 100644
--- a/docs/alter-session-command/index.html
+++ b/docs/alter-session-command/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/alter-system-command/index.html
----------------------------------------------------------------------
diff --git a/docs/alter-system-command/index.html 
b/docs/alter-system-command/index.html
index e407f96..6c0318f 100644
--- a/docs/alter-system-command/index.html
+++ b/docs/alter-system-command/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/analyzing-highly-dynamic-datasets/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-highly-dynamic-datasets/index.html 
b/docs/analyzing-highly-dynamic-datasets/index.html
index cff7d0c..cf2eb40 100644
--- a/docs/analyzing-highly-dynamic-datasets/index.html
+++ b/docs/analyzing-highly-dynamic-datasets/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/analyzing-the-yelp-academic-dataset/index.html
----------------------------------------------------------------------
diff --git a/docs/analyzing-the-yelp-academic-dataset/index.html 
b/docs/analyzing-the-yelp-academic-dataset/index.html
index aecbd1e..d4f40cc 100644
--- a/docs/analyzing-the-yelp-academic-dataset/index.html
+++ b/docs/analyzing-the-yelp-academic-dataset/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/aol-search/index.html
----------------------------------------------------------------------
diff --git a/docs/aol-search/index.html b/docs/aol-search/index.html
index a7235a9..f43ecb8 100644
--- a/docs/aol-search/index.html
+++ b/docs/aol-search/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-0-4-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-4-0-release-notes/index.html 
b/docs/apache-drill-0-4-0-release-notes/index.html
index 40a40ab..79496e8 100644
--- a/docs/apache-drill-0-4-0-release-notes/index.html
+++ b/docs/apache-drill-0-4-0-release-notes/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-0-5-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-5-0-release-notes/index.html 
b/docs/apache-drill-0-5-0-release-notes/index.html
index 95fddd6..069a650 100644
--- a/docs/apache-drill-0-5-0-release-notes/index.html
+++ b/docs/apache-drill-0-5-0-release-notes/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-0-6-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-6-0-release-notes/index.html 
b/docs/apache-drill-0-6-0-release-notes/index.html
index 4bcffb9..b896418 100644
--- a/docs/apache-drill-0-6-0-release-notes/index.html
+++ b/docs/apache-drill-0-6-0-release-notes/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-0-7-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-7-0-release-notes/index.html 
b/docs/apache-drill-0-7-0-release-notes/index.html
index 14dd482..ecb5c1a 100644
--- a/docs/apache-drill-0-7-0-release-notes/index.html
+++ b/docs/apache-drill-0-7-0-release-notes/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-0-8-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-8-0-release-notes/index.html 
b/docs/apache-drill-0-8-0-release-notes/index.html
index 6c0dd37..23759dc 100644
--- a/docs/apache-drill-0-8-0-release-notes/index.html
+++ b/docs/apache-drill-0-8-0-release-notes/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2 current"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       
@@ -840,7 +852,7 @@ run Drill against your preferred distribution</p>
         
           <div class="doc-nav">
   
-  <span class="previous-toc"><a 
href="/docs/apache-drill-0-7-0-release-notes/">← Apache Drill 0.7.0 Release 
Notes</a></span><span class="next-toc"><a href="/docs/sample-datasets/">Sample 
Datasets →</a></span>
+  <span class="previous-toc"><a 
href="/docs/apache-drill-0-7-0-release-notes/">← Apache Drill 0.7.0 Release 
Notes</a></span><span class="next-toc"><a 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes 
→</a></span>
 </div>
 
       

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-0-9-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-0-9-0-release-notes/index.html 
b/docs/apache-drill-0-9-0-release-notes/index.html
new file mode 100644
index 0000000..18d3992
--- /dev/null
+++ b/docs/apache-drill-0-9-0-release-notes/index.html
@@ -0,0 +1,882 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>Apache Drill 0.9.0 Release Notes - Apache Drill</title>
+
+<link href="/css/syntax.css" rel="stylesheet" type="text/css">
+<link href="/css/style.css" rel="stylesheet" type="text/css">
+<link href="/css/arrows.css" rel="stylesheet" type="text/css">
+<link href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
+<link rel="stylesheet" 
href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
+<link href="/css/responsive.css" rel="stylesheet" type="text/css">
+
+<link rel="shortcut icon" href="/favicon.ico" type="image/x-icon">
+<link rel="icon" href="/favicon.ico" type="image/x-icon">
+
+<script language="javascript" type="text/javascript" 
src="/js/lib/jquery-1.11.1.min.js"></script>
+<script language="javascript" type="text/javascript" 
src="/js/lib/jquery.easing.1.3.js"></script>
+<script language="javascript" type="text/javascript" 
src="/js/modernizr.custom.js"></script>
+<script language="javascript" type="text/javascript" 
src="/js/script.js"></script>
+<script language="javascript" type="text/javascript" 
src="/js/drill.js"></script>
+
+
+</head>
+
+<body onResize="resized();">
+  <div class="page-wrap">
+    <div class="bui"></div>
+
+<div id="menu" class="mw">
+<ul>
+  <li class='toc-categories'>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa 
fa-bars"></i></a>
+  </li>
+  <li class="logo"><a href="/"></a></li>
+  <li class='expand-menu'>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span 
class='expand-icon'><i class="fa fa-bars"></i></span></a>
+  </li>
+  <li class='clear-float'></li>
+  <li class="documentation-menu">
+    <a href="/docs/">Documentation</a>
+    <ul>
+      
+        <li><a href="/docs/getting-started/">Getting Started</a></li>
+      
+        <li><a href="/docs/architecture/">Architecture</a></li>
+      
+        <li><a href="/docs/tutorials/">Tutorials</a></li>
+      
+        <li><a href="/docs/install-drill/">Install Drill</a></li>
+      
+        <li><a href="/docs/connect-a-data-source/">Connect a Data 
Source</a></li>
+      
+        <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+      
+        <li><a href="/docs/query-data/">Query Data</a></li>
+      
+        <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+      
+        <li><a href="/docs/data-sources-and-file-formats/">Data Sources and 
File Formats</a></li>
+      
+        <li><a href="/docs/develop-custom-functions/">Develop Custom 
Functions</a></li>
+      
+        <li><a href="/docs/manage-drill/">Manage Drill</a></li>
+      
+        <li><a href="/docs/developer-information/">Developer 
Information</a></li>
+      
+        <li><a href="/docs/release-notes/">Release Notes</a></li>
+      
+        <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>
+  </li>
+  <li class='nav'>
+    <a href="/community-resources/">Community</a>
+    <ul>
+      <li><a href="/team/">Team</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/community-resources/">Community Resources</a></li>
+    </ul>
+  </li>
+  <li class='nav'><a href="/faq/">FAQ</a></li>
+  <li class='nav'><a href="/blog/">Blog</a></li>
+  <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill"; 
title="apachedrill on twitter" target="_blank"><img 
src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> 
</li>
+  <li class='search-bar'>
+    <form id="drill-search-form">
+      <input type="text" placeholder="Search Apache Drill" 
id="drill-search-term" />
+      <button type="submit">
+        <i class="fa fa-search"></i>
+      </button>
+    </form>
+  </li>
+  <li class="d">
+    <a href="/download/">
+      <i class="fa fa-cloud-download"></i> Download
+    </a>
+  </li>
+</ul>
+</div>
+
+      
+      
+
+
+
+
+<aside class="sidebar">
+  <div class="docsidebar">
+    <div class="docsidebarwrapper">
+      <ul style="display: block;">
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Getting 
Started</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-introduction/">Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/why-drill/">Why Drill</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: 
void(0);">Architecture</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/architecture-introduction/">Architecture Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/core-modules/">Core Modules</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Architectural Highlights</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/flexibility/">Flexibility</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/performance/">Performance</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: 
void(0);">Tutorials</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/tutorials-introduction/">Tutorials Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-the-yelp-academic-dataset/">Analyzing the Yelp Academic 
Dataset</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Learn 
Drill with the MapR Sandbox</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill 
Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/getting-to-know-the-drill-sandbox/">Getting to Know the Drill 
Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lession-1-learn-about-the-data-set/">Lession 1: Learn about the 
Data Set</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lession-2-run-queries-with-ansi-sql/">Lession 2: Run Queries with 
ANSI SQL</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lession-3-run-queries-on-complex-data-types/">Lession 3: Run 
Queries on Complex Data Types</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/summary/">Summary</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic 
Datasets</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Install 
Drill</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/install-drill-introduction/">Install Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
Drill in Embedded Mode</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/embedded-mode-prerequisites/">Embedded Mode Prerequisites</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-linux-and-mac-os-x/">Installing Drill on Linux 
and Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-on-linux-and-mac-os-x/">Starting Drill on Linux and 
Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-windows/">Installing Drill on Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-on-windows/">Starting Drill on Windows</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
Drill in Distributed Mode</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/distributed-mode-prerequisites/">Distributed Mode 
Prerequisites</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-the-cluster/">Installing Drill on the 
Cluster</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-in-distributed-mode/">Starting Drill in Distributed 
Mode</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Connect a Data 
Source</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/connect-a-data-source-introduction/">Connect a Data Source 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Storage 
Plugin Configuration</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/plugin-configuration-introduction/">Plugin Configuration 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/workspaces/">Workspaces</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/hive-storage-plugin/">Hive Storage Plugin</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-default-input-format/">Drill Default Input Format</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/mongodb-plugin-for-apache-drill/">MongoDB Plugin for Apache 
Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/mapr-db-format/">MapR-DB Format</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">ODBC/JDBC 
Interfaces</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/interfaces-introduction/">Interfaces Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-jdbc/">Using JDBC</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Using ODBC 
on Linux and Mac OS X</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/odbc-on-linux-and-mac-introduction/">ODBC on Linux and Mac 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-linux/">Installing the Driver on 
Linux</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS 
X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-connections-on-linux-and-mac-os-x/">Configuring 
Connections on Linux and Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/driver-configuration-options/">Driver Configuration Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-a-connection-string/">Using a Connection String</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/advanced-properties/">Advanced Properties</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Using ODBC 
on Windows</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-windows/">Installing the Driver on 
Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-connections-on-windows/">Configuring Connections on 
Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/connecting-to-odbc-data-sources/">Connecting to ODBC Data 
Sources</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/tableau-examples/">Tableau Examples</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-drill-explorer-on-windows/">Using Drill Explorer on 
Windows</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query 
Data</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-data-introduction/">Query Data Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Querying a 
File System</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-a-file-system-introduction/">Querying a File System 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-json-files/">Querying JSON Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-parquet-files/">Querying Parquet Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-directories/">Querying Directories</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-hbase/">Querying HBase</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Querying 
Complex Data</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-complex-data-introduction/">Querying Complex Data 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-flat-data/">Selecting Flat Data</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, 
Clauses, and Joins</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a 
Column</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple 
Columns Within Nested Data</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-hive/">Querying Hive</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-the-information-schema/">Querying the INFORMATION 
SCHEMA</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-system-tables/">Querying System Tables</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">SQL 
Reference</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Data 
Types</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/supported-data-types/">Supported Data Types</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/handling-different-data-types/">Handling Different Data 
Types</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/lexical-structure/">Lexical Structure</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/operators/">Operators</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/math-and-trig/">Math and Trig</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/data-type-conversion/">Data Type Conversion</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/date-time-functions-and-arithmetic/">Date/Time Functions and 
Arithmetic</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/string-manipulation/">String Manipulation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/aggregate-and-aggregate-statistical/">Aggregate and Aggregate 
Statistical</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/functions-for-handling-nulls/">Functions for Handling Nulls</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Nested 
Data Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/nested-data-limitations/">Nested Data Limitations</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/flatten/">FLATTEN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/kvgen/">KVGEN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/repeated-count/">REPEATED_COUNT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-directory-functions/">Query Directory Functions</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Commands</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) 
command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/create-view-command/">CREATE VIEW command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/describe-command/">DESCRIBE Command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/explain-commands/">EXPLAIN commands</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/select-statements/">SELECT Statements</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES AND SHOW 
SCHEMAS Command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/show-files-command/">SHOW FILES Command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/use-command/">USE Command</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Conditional Expressions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/case/">CASE</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/reserved-keywords/">Reserved Keywords</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sql-extensions/">SQL Extensions</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Data Sources 
and File Formats</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File 
Formats Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type 
Mapping</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive 
UDF</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/parquet-format/">Parquet Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/json-data-model/">JSON Data Model</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Develop Custom 
Functions</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/develop-custom-functions-introduction/">Develop Custom Functions 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/develop-a-simple-function/">Develop a Simple Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/developing-an-aggregate-function/">Developing an Aggregate 
Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/adding-custom-functions-to-drill/">Adding Custom Functions to 
Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-custom-functions-in-queries/">Using Custom Functions in 
Queries</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/custom-function-interfaces/">Custom Function Interfaces</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Manage 
Drill</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/manage-drill-introduction/">Manage Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-drill-in-a-dedicated-cluster/">Configuring Drill in a 
Dedicated Cluster</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuring a Multitenant Cluster</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-a-multitenant-cluster-introduction/">Configuring a 
Multitenant Cluster Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-multitenant-resources/">Configuring Multitenant 
Resources</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-resources-for-a-shared-drillbit/">Configuring Resources 
for a Shared Drillbit</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuration Options</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuration-options-introduction/">Configuration Options 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/start-up-options/">Start-Up Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/planning-and-execution-options/">Planning and Execution 
Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/persistent-configuration-storage/">Persistent Configuration 
Storage</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/starting-stopping-drill/">Starting/Stopping Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/ports-used-by-drill/">Ports Used by Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/partition-pruning/">Partition Pruning</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/">Monitoring 
and Canceling Queries in the Drill Web UI</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Developer 
Information</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Develop 
Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-patch-review-tool/">Drill Patch Review Tool</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Contribute 
to Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution 
Guidelines</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution 
Ideas</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Design 
Docs</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/rpc-overview/">RPC Overview</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-stages/">Query Stages</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/useful-research/">Useful Research</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/value-vectors/">Value Vectors</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1 current_section "><a href="javascript: 
void(0);">Release Notes</a></li>
+          <ul class="current_section">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 
Release Notes (Apache Drill Alpha)</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 
Release Notes (Apache Drill Alpha)</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-6-0-release-notes/">Apache Drill 0.6.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-7-0-release-notes/">Apache Drill 0.7.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2 current"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Sample 
Datasets</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/aol-search/">AOL Search</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/enron-emails/">Enron Emails</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <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>
+        
+      
+      </ul>
+
+    </div>
+  </div>
+</aside>
+
+
+  <nav class="breadcrumbs">
+  <li><a href="/docs/">Docs</a></li>
+ 
+  
+    <li><a href="/docs/release-notes/">Release Notes</a></li>
+  
+  <li>Apache Drill 0.9.0 Release Notes</li>
+</nav>
+
+  <div class="main-content-wrapper">
+    <div class="main-content">
+
+      
+        <a class="edit-link" 
href="https://github.com/apache/drill/blob/gh-pages/_docs/rn/070-0.9.0-rn.md"; 
target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+      
+
+      <div class="int_title">
+        <h1>Apache Drill 0.9.0 Release Notes</h1>
+
+      </div>
+
+      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+
+      <div class="int_text" align="left">
+        
+          <p>It has been about a month since the release of Drill 0.8, which 
included <a href="/blog/drill-0.8-released/">more than 240 improvements</a>. 
Today we&#39;re happy to announce the availability of Drill 0.9, providing 
additional enhancements and bug fixes. In fact, this release includes <a 
href="https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&amp;version=12328813";>200
 resolved JIRAs</a>. Some of the noteworthy features in Drill 0.9 are:</p>
+
+<ul>
+<li><strong>Authentication</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-2674";>DRILL-2674</a>). Drill 
now supports username/password authentication through the Java and C++ clients, 
as well as JDBC and ODBC. On the server-side, Drill leverages Linux PAM to 
securely validate the credentials. Users can choose to use an external user 
directory such as Active Directory or LDAP. To enable authentication, set the 
<code>security.user.auth</code> option in <code>drill-override.conf</code>.</li>
+<li><strong>Impersonation</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-2363";>DRILL-2363</a>). 
Queries now execute and access resources using the identity of the user who 
submitted the query. Previously, all queries would run as the same user (eg, 
<code>drill</code>). With the new impersonation capability, the query will fail 
if the submitting user does not have permission to read the requested file(s) 
in the distributed file system. To enable impersonation, set the 
<code>drill.exec.impersonation</code> option in 
<code>drill-override.conf</code>.</li>
+<li><strong>Ownership chaining</strong>. Drill now allows views with different 
owners to be chained. This represents a very flexible access control solution. 
For example, an administrator with access to raw, sensitive data could create a 
view called <code>masked</code> which would expose only a subset of the data to 
other users. The administrator would enable users to read the 
<code>masked</code> view but not the raw data. Note that Drill provides an 
option <code>max_chained_user_hops</code> that specifies how many ownership 
changed are allowed in a chain, thereby providing administrators (or data 
stewards) more control over sharing of data.</li>
+<li><strong>MongoDB authentication</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-1502";>DRILL-1502</a>). Drill 
can now connect to a MongoDB cluster that requires authentication.</li>
+<li><strong>Extended JSON datatypes</strong>. Our friends at MongoDB invented 
<a 
href="http://docs.mongodb.org/manual/reference/mongodb-extended-json/";>extended 
JSON</a> - a set of extensions to the JSON format for supporting additional 
data types. We decided to embrace extended JSON in Drill. For example, standard 
JSON doesn&#39;t have a time type, so a time could be represented as either a 
string or a number: <code>{&quot;foo&quot;: &quot;19:20:30.450Z&quot;}</code> 
is just a string. With extended JSON, the <code>$time</code> qualifier can be 
used to specify that <code>foo</code> is a time <code>{&quot;foo&quot;: 
{&quot;$time&quot;: &quot;19:20:30.450Z&quot;}}</code>.
+We now support a number of qualifiers including <code>$bin</code>, 
<code>$date</code>, <code>$time</code>, <code>$interval</code>, 
<code>$numberLong</code> and <code>$dateDay</code> (see <a 
href="https://github.com/apache/drill/blob/master/exec/java-exec/src/test/resources/vector/complex/extended.json";>the
 example</a>). We&#39;re in the process of adding some additional qualifiers to 
make sure that all of MongoDB&#39;s extended types are supported (this is 
particularly important when querying data in MongoDB).</li>
+<li><strong>Avro support</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-1512";>DRILL-1512</a>). Drill 
can now read Avro files. This patch was contributed by Andrew Selden at 
Elastic.co (formerly known as Elasticsearch).</li>
+<li><strong>Improved error messages</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-2675";>DRILL-2675</a> and 
more). It can be challenging for a complex distributed system like Drill to 
translate low-level internal conditions into actionable messages to the user. 
This release includes several enhancements that enable Drill to accomplish just 
that in a variety of cases.</li>
+<li><strong>Parquet and Calcite enhancements</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-1410";>DRILL-1410</a> and <a 
href="https://issues.apache.org/jira/browse/DRILL-1384";>DRILL-1384</a>). Drill 
isn&#39;t a traditional query engine - it&#39;s the first analytical query 
engine with a JSON data model. This has required us to enhance Parquet (our 
columnar format) and Calcite (our SQL parser). These enhancements have now been 
contributed back to those projects, and Drill is using the latest versions 
which include these enhancements.</li>
+<li><p><strong>New sys tables for memory and thread information</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-2275";>DRILL-2275</a>). Drill 
includes two new <code>sys</code> tables that provide real-time metrics about 
memory utilization and threads on each of the nodes in the cluster. You can run 
a simple <code>SELECT *</code> to see what information is available:</p>
+<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span 
class="k">SELECT</span> <span class="o">*</span> <span class="k">FROM</span> 
<span class="n">sys</span><span class="p">.</span><span 
class="n">drillmemory</span><span class="p">;</span>
+<span class="k">SELECT</span> <span class="o">*</span> <span 
class="k">FROM</span> <span class="n">sys</span><span class="p">.</span><span 
class="n">drillbitthreads</span><span class="p">;</span>
+</code></pre></div></li>
+<li><p><strong>Support for very wide tables</strong> (<a 
href="https://issues.apache.org/jira/browse/DRILL-2739";>DRILL-2739</a>). Drill 
previously had some issues with tables that had more than 4095 colums. This 
limitation has been addressed.</p></li>
+</ul>
+
+<p>You can now <a href="/download/">download Drill 0.9</a>. As always, you can 
check out the official <a href="/docs/release-notes/">release notes</a> for 
more details.</p>
+
+<p>We&#39;re gearing up for Drill&#39;s 1.0 release later this month. Stay 
tuned!</p>
+
+      
+        
+          <div class="doc-nav">
+  
+  <span class="previous-toc"><a 
href="/docs/apache-drill-0-8-0-release-notes/">← Apache Drill 0.8.0 Release 
Notes</a></span><span class="next-toc"><a href="/docs/sample-datasets/">Sample 
Datasets →</a></span>
+</div>
+
+      
+      </div>
+    </div>
+  </div>
+
+  </div>
+  <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2014 The Apache Software Foundation, licensed under the 
Apache License, Version 2.0.<br>
+Apache and the Apache feather logo are trademarks of The Apache Software 
Foundation. Other names appearing on the site may be trademarks of their 
respective owners.<br/><br/>
+</div>
+</div>
+
+  <script>
+(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ga('create', 'UA-53379651-1', 'auto');
+ga('send', 'pageview');
+</script>
+
+</body>
+</html>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/e6841a74/docs/apache-drill-contribution-guidelines/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-contribution-guidelines/index.html 
b/docs/apache-drill-contribution-guidelines/index.html
index 0f93221..63372de 100644
--- a/docs/apache-drill-contribution-guidelines/index.html
+++ b/docs/apache-drill-contribution-guidelines/index.html
@@ -345,6 +345,14 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-drill/">Using MicroStrategy 
Analytics with Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-apache-drill-with-tibco-spotfire-desktop/">Using Apache Drill 
with Tibco Spotfire Desktop</a></li>
+            
+          
           </ul>
         
       
@@ -728,6 +736,10 @@
               <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
           </ul>
         
       

Reply via email to