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/03/31 03:20:44 UTC
svn commit: r1670235 [3/4] - in /drill/site/trunk/content/drill: ./
blog/2014/12/11/apache-drill-qa-panelist-spotlight/ docs/
docs/advanced-properties/ docs/analyzing-yelp-json-data-with-apache-drill/
docs/apache-drill-in-10-minutes/ docs/apache-drill-...
Modified: drill/site/trunk/content/drill/docs/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/index.html (original)
+++ drill/site/trunk/content/drill/docs/index.html Tue Mar 31 01:20:42 2015
@@ -112,10 +112,6 @@
-
-
-
-
<li><a href="/docs/core-modules-within-a-drillbit/">Core Modules within a Drillbit</a></li>
@@ -168,15 +164,19 @@
+ <li><a href="/docs/flexibility/">Flexibility</a></li>
+
+ <li><a href="/docs/performance/">Performance</a></li>
+
- <li><a href="/docs/flexibility/">Flexibility</a></li>
+
- <li><a href="/docs/performance/">Performance</a></li>
+
@@ -679,6 +679,14 @@
+
+
+
+
+
+
+
+
</ul>
@@ -967,6 +975,10 @@
+
+
+
+
<li><a href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill Sandbox</a></li>
@@ -1262,6 +1274,10 @@
+
+
+
+
<li><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/">Installing the MapR Sandbox with Apache Drill on VMware Player/VMware Fusion</a></li>
@@ -1761,6 +1777,10 @@
+
+
+
+
</ul>
@@ -1944,6 +1964,10 @@
+
+
+
+
</ul>
@@ -2002,10 +2026,6 @@
-
-
-
-
<li><a href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li>
@@ -2070,10 +2090,6 @@
-
-
-
-
<li><a href="/docs/workspaces/">Workspaces</a></li>
@@ -2321,6 +2337,14 @@
+
+
+
+
+
+
+
+
</ul>
@@ -2573,6 +2597,14 @@
+
+
+
+
+
+
+
+
</ul>
@@ -2857,6 +2889,8 @@
+
+
<li><a href="/docs/installing-the-mapr-drill-odbc-driver-on-linux/">Installing the MapR Drill ODBC Driver on Linux</a></li>
@@ -3030,6 +3064,8 @@
+
+
</ul>
@@ -3188,6 +3224,8 @@
+
+
<li><a href="/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows/">Step 1. Install the MapR Drill ODBC Driver on Windows</a></li>
@@ -3343,11 +3381,22 @@
+
+
</ul>
+ <li><a href="/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li>
+
+
+
+
+
+
+
+
@@ -3695,6 +3744,8 @@
+
+
<li><a href="/docs/getting-started-tutorial/">Getting Started Tutorial</a></li>
@@ -3892,6 +3943,8 @@
+
+
<li><a href="/docs/lesson-1-connect-to-data-sources/">Lesson 1: Connect to Data Sources</a></li>
@@ -3999,6 +4052,8 @@
+
+
</ul>
@@ -4217,6 +4272,8 @@
+
+
<li><a href="/docs/querying-json-files/">Querying JSON Files</a></li>
@@ -4310,6 +4367,8 @@
+
+
</ul>
@@ -4525,6 +4584,8 @@
+
+
<li><a href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
@@ -4630,6 +4691,8 @@
+
+
</ul>
@@ -4757,6 +4820,8 @@
+
+
</ul>
@@ -4993,6 +5058,8 @@
+
+
<li><a href="/docs/data-types/">Data Types</a></li>
@@ -5262,6 +5329,8 @@
+
+
<li><a href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
@@ -5295,6 +5364,8 @@
+
+
</ul>
@@ -5587,10 +5658,16 @@
+
+
<li><a href="/docs/math-and-trig/">Math and Trig</a></li>
+ <li><a href="/docs/casting-converting-data-types/">Casting/Converting Data Types</a></li>
+
+
+
@@ -5894,19 +5971,23 @@
- <li><a href="/docs/flatten-function/">FLATTEN Function</a></li>
+
+
+
+
+ <li><a href="/docs/flatten/">FLATTEN</a></li>
- <li><a href="/docs/kvgen-function/">KVGEN Function</a></li>
+ <li><a href="/docs/kvgen/">KVGEN</a></li>
- <li><a href="/docs/repeated-count-function/">REPEATED_COUNT Function</a></li>
+ <li><a href="/docs/repeated-count/">REPEATED_COUNT</a></li>
- <li><a href="/docs/repeated-contains-function/">REPEATED_CONTAINS Function</a></li>
+ <li><a href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li>
@@ -6177,6 +6258,8 @@
+
+
<li><a href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
@@ -6250,6 +6333,8 @@
+
+
</ul>
@@ -6320,6 +6405,8 @@
+
+
</ul>
@@ -6396,14 +6483,6 @@
-
-
-
-
-
-
-
-
<li><a href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li>
@@ -6643,21 +6722,6 @@
- </ul>
-
-
-
-
- <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li>
-
-
-
- <ul>
-
-
-
-
-
@@ -6670,7 +6734,16 @@
-
+ </ul>
+
+
+
+
+ <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li>
+
+
+
+ <ul>
@@ -6971,6 +7044,28 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
</ul>
@@ -7139,6 +7234,8 @@
+
+
<li><a href="/docs/configuration-options/">Configuration Options</a></li>
@@ -7312,6 +7409,8 @@
+
+
<li><a href="/docs/memory-allocation/">Memory Allocation</a></li>
@@ -7445,6 +7544,8 @@
+
+
</ul>
@@ -7603,12 +7704,14 @@
+
+
</ul>
- <li><a href="/docs/develop-drill/">Develop Drill</a></li>
+ <li><a href="/docs/developer-information/">Developer Information</a></li>
@@ -7703,482 +7806,942 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li><a href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
-
-
-
-
-
-
- <li><a href="/docs/setting-up-your-development-environment/">Setting Up Your Development Environment</a></li>
-
-
-
-
-
-
- <li><a href="/docs/drill-patch-review-tool/">Drill Patch Review Tool</a></li>
+ <li><a href="/docs/develop-drill/">Develop Drill</a></li>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- </ul>
-
-
-
-
- <li><a href="/docs/release-notes/">Release Notes</a></li>
-
-
-
- <ul>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li><a href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release Notes</a></li>
-
-
-
-
-
-
- <li><a href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release Notes</a></li>
-
-
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
+
+
+
+ <li><a href="/docs/drill-patch-review-tool/">Drill Patch Review Tool</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </ul>
- <li><a href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 Release Notes (Apache Drill Alpha)</a></li>
-
+ <li><a href="/docs/contribute-to-drill/">Contribute to Drill</a></li>
-
-
-
- <li><a href="/docs/apache-drill-0-6-0-release-notes-apache-drill-alpha/">Apache Drill 0.6.0 Release Notes (Apache Drill Alpha)</a></li>
-
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution Guidelines</a></li>
+
+
+
+ <li><a href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution Ideas</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </ul>
- <li><a href="/docs/apache-drill-0-7-0-release-notes-apache-drill-alpha/">Apache Drill 0.7.0 Release Notes (Apache Drill Alpha)</a></li>
+ <li><a href="/docs/design-docs/">Design Docs</a></li>
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li><a href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
+
+
+
+ <li><a href="/docs/rpc-overview/">RPC Overview</a></li>
+
+
+
+ <li><a href="/docs/query-stages/">Query Stages</a></li>
+
+
+
+ <li><a href="/docs/useful-research/">Useful Research</a></li>
+
+
+
+ <li><a href="/docs/value-vectors/">Value Vectors</a></li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ </ul>
+
@@ -8249,37 +8812,6 @@
- </ul>
-
-
-
-
- <li><a href="/docs/contribute-to-drill/">Contribute to Drill</a></li>
-
-
-
- <ul>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -8329,18 +8861,8 @@
- <li><a href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution Guidelines</a></li>
-
-
-
-
- <li><a href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution Ideas</a></li>
-
-
-
-
@@ -8424,7 +8946,16 @@
-
+ </ul>
+
+
+
+
+ <li><a href="/docs/release-notes/">Release Notes</a></li>
+
+
+
+ <ul>
@@ -8562,17 +9093,6 @@
- </ul>
-
-
-
-
- <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
-
-
-
- <ul>
-
@@ -8654,160 +9174,38 @@
- <li><a href="/docs/aol-search/">AOL Search</a></li>
+ <li><a href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release Notes</a></li>
- <li><a href="/docs/enron-emails/">Enron Emails</a></li>
+ <li><a href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release Notes</a></li>
- <li><a href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
+ <li><a href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 Release Notes (Apache Drill Alpha)</a></li>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+ <li><a href="/docs/apache-drill-0-6-0-release-notes-apache-drill-alpha/">Apache Drill 0.6.0 Release Notes (Apache Drill Alpha)</a></li>
+
+
+
-
+ <li><a href="/docs/apache-drill-0-7-0-release-notes-apache-drill-alpha/">Apache Drill 0.7.0 Release Notes (Apache Drill Alpha)</a></li>
+
+
+
@@ -8885,7 +9283,7 @@
- <li><a href="/docs/design-docs/">Design Docs</a></li>
+ <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
@@ -8964,52 +9362,46 @@
-
+ <li><a href="/docs/aol-search/">AOL Search</a></li>
+
+
+
-
+ <li><a href="/docs/enron-emails/">Enron Emails</a></li>
+
+
+
-
+ <li><a href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
+
+
+
- <li><a href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
-
-
-
+
- <li><a href="/docs/rpc-overview/">RPC Overview</a></li>
-
-
-
+
- <li><a href="/docs/query-stages/">Query Stages</a></li>
-
-
-
+
- <li><a href="/docs/useful-research/">Useful Research</a></li>
-
-
-
+
- <li><a href="/docs/value-vectors/">Value Vectors</a></li>
-
-
-
+
@@ -9262,10 +9654,6 @@
-
-
-
-
<li><a href="/docs/how-to-run-the-drill-demo/">How to Run the Drill Demo</a></li>
@@ -9521,6 +9909,14 @@
+
+
+
+
+
+
+
+
</ul>
@@ -9707,6 +10103,8 @@
+
+
<li><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
@@ -9829,6 +10227,8 @@
+
+
</ul>
@@ -9841,6 +10241,14 @@
+
+
+
+
+
+
+
+
Modified: drill/site/trunk/content/drill/docs/install-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/install-drill/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/install-drill/index.html (original)
+++ drill/site/trunk/content/drill/docs/install-drill/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/analyzing-yelp-json-data-with-apache-drill">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/apache-drill-in-10-minutes">Next</a></p>
-
-<p>You can install Drill in embedded mode or in distributed mode. Installing
+<div class="int_text" align="left"><p>You can install Drill in embedded mode or in distributed mode. Installing
Drill in embedded mode does not require any configuration, which means that
you can quickly get started with Drill. If you want to use Drill in a
clustered Hadoop environment, you can install Drill in distributed mode.
Modified: drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-drill-in-distributed-mode/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-drill-on-windows">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/connect-to-a-data-source">Next</a></p>
-
-<p>You can install Apache Drill in distributed mode on one or multiple nodes to
+<div class="int_text" align="left"><p>You can install Apache Drill in distributed mode on one or multiple nodes to
run it in a clustered environment.</p>
<p>To install Apache Drill in distributed mode, complete the following steps:</p>
Modified: drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-drill-in-embedded-mode/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/deploying-apache-drill-in-a-clustered-environment">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-on-linux">Next</a></p>
-
-<p>Installing Drill in embedded mode installs Drill locally on your machine.
+<div class="int_text" align="left"><p>Installing Drill in embedded mode installs Drill locally on your machine.
Embedded mode is a quick, easy way to install and try Drill without having to
perform any configuration tasks. When you install Drill in embedded mode, the
Drillbit service is installed locally and starts automatically when you invoke
Modified: drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-drill-on-linux/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-drill-in-embedded-mode">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-on-mac-os-x">Next</a></p>
-
-<p>Complete the following steps to install Apache Drill on a machine running
+<div class="int_text" align="left"><p>Complete the following steps to install Apache Drill on a machine running
Linux:</p>
<ol>
Modified: drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-drill-on-mac-os-x/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-drill-on-linux">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-on-windows">Next</a></p>
-
-<p>Complete the following steps to install Apache Drill on a machine running Mac
+<div class="int_text" align="left"><p>Complete the following steps to install Apache Drill on a machine running Mac
OS X:</p>
<ol>
Modified: drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-drill-on-windows/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-drill-on-mac-os-x">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-drill-in-distributed-mode">Next</a></p>
-
-<p>You can install Drill on Windows 7 or 8. To install Drill on Windows, you must
+<div class="int_text" align="left"><p>You can install Drill on Windows 7 or 8. To install Drill on Windows, you must
have JDK 7, and you must set the <code>JAVA_HOME</code> path in the Windows Environment
Variables. You must also have a utility, such as
<a href="http://www.7-zip.org/">7-zip</a>, installed on your machine. These instructions
Modified: drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-apache-drill-sandbox/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/apache-drill-tutorial">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion">Next</a></p>
-
-<h2 id="prerequisites">Prerequisites</h2>
+<div class="int_text" align="left"><h2 id="prerequisites">Prerequisites</h2>
<p>The MapR Sandbox with Apache Drill runs on VMware Player and VirtualBox, free
desktop applications that you can use to run a virtual machine on a Windows,
Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-linux/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x">Next</a></p>
-
-<p>Install the MapR Drill ODBC Driver on the machine from which you connect to
+<div class="int_text" align="left"><p>Install the MapR Drill ODBC Driver on the machine from which you connect to
the Drill service. You can install the 32- or 64-bit driver on Linux. Install
the version of the driver that matches the architecture of the client
application that you use to access Drill. The 64-bit editions of Linux support
Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-mapr-drill-odbc-driver-on-mac-os-x/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-the-mapr-drill-odbc-driver-on-linux">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/configuring-odbc-connections-for-linux-and-mac-os-x">Next</a></p>
-
-<p>Install the MapR Drill ODBC Driver on the machine from which you connect to
+<div class="int_text" align="left"><p>Install the MapR Drill ODBC Driver on the machine from which you connect to
the Drill service.</p>
<p>To install the MapR Drill ODBC Driver, complete the following steps:</p>
Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/getting-to-know-the-drill-sandbox">Next</a></p>
-
-<p>The MapR Sandbox for Apache Drill on VirtualBox comes with NAT port forwarding
+<div class="int_text" align="left"><p>The MapR Sandbox for Apache Drill on VirtualBox comes with NAT port forwarding
enabled, which allows you to access the sandbox using localhost as hostname.</p>
<p>Complete the following steps to install the MapR Sandbox with Apache Drill on
Modified: drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html (original)
+++ drill/site/trunk/content/drill/docs/installing-the-mapr-sandbox-with-apache-drill-on-vmware-player-vmware-fusion/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/installing-the-apache-drill-sandbox">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/installing-the-mapr-sandbox-with-apache-drill-on-virtualbox">Next</a></p>
-
-<p>Complete the following steps to install the MapR Sandbox with Apache Drill on
+<div class="int_text" align="left"><p>Complete the following steps to install the MapR Sandbox with Apache Drill on
VMware Player or VMware Fusion:</p>
<ol>
Modified: drill/site/trunk/content/drill/docs/json-data-model/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/json-data-model/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/json-data-model/index.html (original)
+++ drill/site/trunk/content/drill/docs/json-data-model/index.html Tue Mar 31 01:20:42 2015
@@ -538,8 +538,10 @@ FROM dfs.`/Users/mypath/example.json` t;
<p>Workaround: Separate lengthy objects into objects delimited by curly braces using the following functions:</p>
-<p><a href="/docs/json-data-model#flatten-json-data">flatten</a> separates a set of nested JSON objects into individual rows in a DRILL table.
-<a href="/docs/json-data-model#generate-key-value-pairs">kvgen</a> separates objects having more elements than optimal for querying.</p>
+<ul>
+<li><p><a href="/docs/json-data-model#flatten-json-data">flatten</a> separates a set of nested JSON objects into individual rows in a DRILL table.</p></li>
+<li><p><a href="/docs/json-data-model#generate-key-value-pairs">kvgen</a> separates objects having more elements than optimal for querying.</p></li>
+</ul>
<h3 id="nested-column-names">Nested Column Names</h3>
Added: drill/site/trunk/content/drill/docs/kvgen/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/kvgen/index.html?rev=1670235&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/kvgen/index.html (added)
+++ drill/site/trunk/content/drill/docs/kvgen/index.html Tue Mar 31 01:20:42 2015
@@ -0,0 +1,285 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>KVGEN - 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/button.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>
+
+</head>
+
+<body onResize="resized();">
+
+<div class="bui"></div>
+
+<div id="search">
+<input type="text" placeholder="Enter search term here">
+</div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class="logo"><a href="/"></a></li>
+ <li>
+ <a href="/overview/">Documentation</a>
+ <ul>
+ <li><a href="/overview/">Overview </a></li>
+ <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes" target="_blank">Drill in 10 Minutes</a></li>
+ <li><a href="/why/">Why Drill? </a></li>
+ <li><a href="/architecture/">Architecture</a></li>
+ </ul>
+ </li>
+ <li>
+ <a href="/community/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/community/#events">Events and Meetups</a></li>
+ <li><a href="/community/#mailinglists">Mailing Lists</a></li>
+ <li><a href="/community/#getinvolved">Get Involved</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
+ <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+ </ul>
+ </li>
+ <li><a href="/faq/">FAQ</a></li>
+ <li><a href="/blog/">Blog</a></li>
+ <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li>
+ <li class="l"><span> </span></li>
+ <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>KVGEN</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Returns a list of the keys that exist in the map.</p>
+
+<h2 id="syntax">Syntax</h2>
+<div class="highlight"><pre><code class="language-text" data-lang="text">KVGEN(column)
+</code></pre></div>
+<p><em>column</em> is the name of a column.</p>
+
+<h2 id="usage-notes">Usage Notes</h2>
+
+<p>You use KVGEN (Key-Value Generation) to query maps that have keys instead of a schema to
+represent data. For example, you store statistics
+about the number of interactions between the users on a social network
+in a JSON document store. User records appear as follows:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ user_id : 12345,
+ user_interactions : {
+ "12633" : 10,
+ "25678" : 25,
+ "11111" : 5
+ }
+}
+</code></pre></div>
+<p>This record summarizes the interaction of one user with others. The record contains the user_id and a map between other
+users' ids and the number of interactions recorded between them. A complete dataset stores the summary of user interactions and includes 12345 listed under user_interactions for user records 12633 and 25678. For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ user_id: 12633,
+ user_interactions : {
+ "12345" : 10,
+ "27569" : 104,
+ "93033" : 52
+ }
+}
+{ user_id: 25678,
+ user_interactions : {
+ "12345" : 25,
+ "37886" : 14,
+ "87394" : 5
+ }
+}
+</code></pre></div>
+<p>To list the users that interact most, you need to use a subquery; otherwise, Drill operates on the data before the flattening and key generation occurs:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT t.flat_interactions.key, t.flat_interactions.`value` from (select flatten(kvgen(user_interactions)) as flat_interactions from dfs.`/Users/khahn/Documents/test_files_source/user_table.json`) as t order by t.flat_interactions.`value` DESC;
+
++------------+------------+
+| EXPR$0 | EXPR$1 |
++------------+------------+
+| 27569 | 104 |
+| 93033 | 52 |
+| 25678 | 25 |
+| 12345 | 25 |
+| 37886 | 14 |
+| 12633 | 10 |
+| 12345 | 10 |
+| 11111 | 5 |
+| 87394 | 5 |
++------------+------------+
+9 rows selected (0.093 seconds)
+</code></pre></div>
+<p>KVGEN is useful when complex
+data files contain arbitrary maps that consist of relatively "unknown" column
+names. Instead of having to specify columns in the map to access the data, you
+can use KVGEN to return a list of the keys that exist in the map. KVGEN turns
+a map with a wide set of columns into an array of key-value pairs.</p>
+
+<p>In turn, you can write analytic queries that return a subset of the generated
+keys or constrain the keys in some way. For example, you can use the
+<a href="/docs/flatten-function">FLATTEN</a> function to break the
+array down into multiple distinct rows and further query those rows.</p>
+
+<p>For example, assume that a JSON file contains this data: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{"a": "valA", "b": "valB"}
+{"c": "valC", "d": "valD"}
+</code></pre></div>
+<p>KVGEN would operate on this data to generate:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">[{"key": "a", "value": "valA"}, {"key": "b", "value": "valB"}]
+[{"key": "c", "value": "valC"}, {"key": "d", "value": "valD"}]
+</code></pre></div>
+<p>Applying the <a href="/docs/flatten-function">FLATTEN</a> function to
+this data would return:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{"key": "a", "value": "valA"}
+{"key": "b", "value": "valB"}
+{"key": "c", "value": "valC"}
+{"key": "d", "value": "valD"}
+</code></pre></div>
+<h2 id="example:-different-data-type-values">Example: Different Data Type Values</h2>
+
+<p>Assume that a JSON file called <code>kvgendata.json</code> includes multiple records that
+look like this one:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+ "rownum": 1,
+ "bigintegercol": {
+ "int_1": 1,
+ "int_2": 2,
+ "int_3": 3
+ },
+ "varcharcol": {
+ "varchar_1": "abc",
+ "varchar_2": "def",
+ "varchar_3": "xyz"
+ },
+ "boolcol": {
+ "boolean_1": true,
+ "boolean_2": false,
+ "boolean_3": true
+ },
+ "float8col": {
+ "f8_1": 1.1,
+ "f8_2": 2.2
+ },
+ "complex": [
+ {
+ "col1": 3
+ },
+ {
+ "col2": 2,
+ "col3": 1
+ },
+ {
+ "col1": 7
+ }
+ ]
+}
+
+{
+ "rownum": 3,
+ "bigintegercol": {
+ "int_1": 1,
+ "int_3": 3
+ },
+ "varcharcol": {
+ "varchar_1": "abcde",
+ "varchar_2": null,
+ "varchar_3": "xyz",
+ "varchar_4": "xyz2"
+ },
+ "boolcol": {
+ "boolean_1": true,
+ "boolean_2": false
+ },
+ "float8col": {
+ "f8_1": 1.1,
+ "f8_3": 6.6
+ },
+ "complex": [
+ {
+ "col1": 2,
+ "col3": 1
+ }
+ ]
+}
+...
+</code></pre></div>
+<p>A SELECT * query against this specific record returns the following row:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select * from dfs.`kvgendata.json` where rownum=1;
+
++------------+---------------+------------+------------+------------+------------+
+| rownum | bigintegercol | varcharcol | boolcol | float8col | complex |
++------------+---------------+------------+------------+------------+------------+
+| 1 | {"int_1":1,"int_2":2,"int_3":3} | {"varchar_1":"abc","varchar_2":"def","varchar_3":"xyz"} | {"boolean_1":true,"boolean_2":false,"boolean_3":true} | {"f8_1":1.1,"f8_2":2.2} | [{"col1":3},{"col2":2,"col3":1},{"col1":7}] |
++------------+---------------+------------+------------+------------+------------+
+1 row selected (0.122 seconds)
+</code></pre></div>
+<p>You can use the KVGEN function to turn the maps in this data into key-value
+pairs. For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select kvgen(varcharcol) from dfs.yelp.`kvgendata.json`;
++------------+
+| EXPR$0 |
++------------+
+| [{"key":"varchar_1","value":"abc"},{"key":"varchar_2","value":"def"},{"key":"varchar_3","value":"xyz"}] |
+| [{"key":"varchar_1","value":"abcd"}] |
+| [{"key":"varchar_1","value":"abcde"},{"key":"varchar_3","value":"xyz"},{"key":"varchar_4","value":"xyz2"}] |
+| [{"key":"varchar_1","value":"abc"},{"key":"varchar_2","value":"def"}] |
++------------+
+4 rows selected (0.091 seconds)
+</code></pre></div>
+<p>Now you can apply the FLATTEN function to break out the key-value pairs into
+distinct rows:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local> select flatten(kvgen(varcharcol)) from dfs.yelp.`kvgendata.json`;
++------------+
+| EXPR$0 |
++------------+
+| {"key":"varchar_1","value":"abc"} |
+| {"key":"varchar_2","value":"def"} |
+| {"key":"varchar_3","value":"xyz"} |
+| {"key":"varchar_1","value":"abcd"} |
+| {"key":"varchar_1","value":"abcde"} |
+| {"key":"varchar_3","value":"xyz"} |
+| {"key":"varchar_4","value":"xyz2"} |
+| {"key":"varchar_1","value":"abc"} |
+| {"key":"varchar_2","value":"def"} |
++------------+
+9 rows selected (0.151 seconds)
+</code></pre></div>
+<p>For more examples of KVGEN and FLATTEN, see the examples in the section, <a href="/docs/json-data-model">"JSON Data Model"</a>.</p>
+</div>
+
+
+<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>
Modified: drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html (original)
+++ drill/site/trunk/content/drill/docs/lession-1-learn-about-the-data-set/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/getting-to-know-the-drill-sandbox">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lession-2-run-queries-with-ansi-sql">Next</a></p>
-
-<h2 id="goal">Goal</h2>
+<div class="int_text" align="left"><h2 id="goal">Goal</h2>
<p>This lesson is simply about discovering what data is available, in what
format, using simple SQL SELECT statements. Drill is capable of analyzing data
Modified: drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html (original)
+++ drill/site/trunk/content/drill/docs/lession-2-run-queries-with-ansi-sql/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/lession-1-learn-about-the-data-set">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/lession-3-run-queries-on-complex-data-types">Next</a></p>
-
-<h2 id="goal">Goal</h2>
+<div class="int_text" align="left"><h2 id="goal">Goal</h2>
<p>This lesson shows how to do some standard SQL analysis in Apache Drill: for
example, summarizing data by using simple aggregate functions and connecting
Modified: drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html (original)
+++ drill/site/trunk/content/drill/docs/lession-3-run-queries-on-complex-data-types/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/lession-2-run-queries-with-ansi-sql">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/summary">Next</a></p>
-
-<h2 id="goal">Goal</h2>
+<div class="int_text" align="left"><h2 id="goal">Goal</h2>
<p>This lesson focuses on queries that exercise functions and operators on self-
describing data and complex data types. Drill offers intuitive SQL extensions
Modified: drill/site/trunk/content/drill/docs/mapr-db-format/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/mapr-db-format/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/mapr-db-format/index.html (original)
+++ drill/site/trunk/content/drill/docs/mapr-db-format/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/mongodb-plugin-for-apache-drill">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/odbc-jdbc-interfaces">Next</a></p>
-
-<p>Drill includes a <code>maprdb</code> format for reading MapR-DB data. The <code>dfs</code> storage plugin defines the format when you install Drill from the <code>mapr-drill</code> package on a MapR node. The <code>maprdb</code> format plugin improves the
+<div class="int_text" align="left"><p>Drill includes a <code>maprdb</code> format for reading MapR-DB data. The <code>dfs</code> storage plugin defines the format when you install Drill from the <code>mapr-drill</code> package on a MapR node. The <code>maprdb</code> format plugin improves the
estimated number of rows that Drill uses to plan a query. It also enables you
to query tables like you would query files in a file system because MapR-DB
and MapR-FS share the same namespace.</p>
Modified: drill/site/trunk/content/drill/docs/math-and-trig/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/math-and-trig/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/math-and-trig/index.html (original)
+++ drill/site/trunk/content/drill/docs/math-and-trig/index.html Tue Mar 31 01:20:42 2015
@@ -122,6 +122,11 @@
<td>Converts x radians to degrees.</td>
</tr>
<tr>
+ <td>E()</td>
+ <td>FLOAT8</td>
+ <td>Returns 2.718281828459045.</td>
+ </tr>
+ <tr>
<td>EXP(x)</td>
<td>FLOAT8</td>
<td>Returns e (Euler's number) to the power of x.</td>
@@ -134,7 +139,17 @@
<tr>
<td>LOG(x)</td>
<td>FLOAT8</td>
- <td>Returns the log value of x.</td>
+ <td>Returns the natural log (base e) of x.</td>
+ </tr>
+ <tr>
+ <td>LOG(x, y)</td>
+ <td>FLOAT8</td>
+ <td>Returns log base x to the y power.</td>
+ </tr>
+ <tr>
+ <td>LOG10(x)</td>
+ <td>FLOAT8</td>
+ <td>Returns the common log of x.</td>
</tr>
<tr>
<td>LSHIFT(x, y)</td>
@@ -142,11 +157,36 @@
<td>Shifts the binary x by y times to the left.</td>
</tr>
<tr>
+ <td>MOD(x, y)</td>
+ <td>FLOAT8</td>
+ <td>Returns the remainder of x divided by y. Requires a cast to DECIMAL for consistent results when x and y are FLOAT or DOUBLE.</td>
+ </tr>
+ <tr>
+ <td>NEGATIVE(x)</td>
+ <td>Same as input</td>
+ <td>Returns x as a negative number.</td>
+ </tr>
+ <tr>
+ <td>PI</td>
+ <td>FLOAT8</td>
+ <td>Returns pi.</td>
+ </tr>
+ <tr>
+ <td>POW(x, y)</td>
+ <td>FLOAT8</td>
+ <td>Returns the value of x to the y power.</td>
+ </tr>
+ <tr>
<td>RADIANS</td>
<td>FLOAT8</td>
<td>Converts x degress to radians.</td>
</tr>
<tr>
+ <td>RAND</td>
+ <td>FLOAT8</td>
+ <td>Returns a random number from 0-1.</td>
+ </tr>
+ <tr>
<td>ROUND(x)</td>
<td>Same as input</td>
<td>Rounds to the nearest integer.</td>
@@ -172,9 +212,9 @@
<td>Returns the square root of x.</td>
</tr>
<tr>
- <td>TRUNC(x)</td>
+ <td>TRUNC(x, y)</td>
<td>Same as input</td>
- <td>Truncates x toward zero.</td>
+ <td>Truncates x to y decimal places. Specifying y is optional. Default is 1.</td>
</tr>
<tr>
<td>TRUNC(x, y)</td>
@@ -194,7 +234,7 @@
<p>Download the <code>input2.json</code> file from the <a href="https://github.com/apache/drill/tree/master/exec/java-exec/src/test/resources/jsoninput">Drill source code</a> page. On the Mac, for example, right-click input2.json and choose Save Link As, and then click Save.</p>
-<p>Create the a dummy JSON file having the following contents:</p>
+<p>The following examples refer to a dummy JSON file in the FROM clause. The dummy JSON file has following contents.</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">{"dummy" : "data"}
</code></pre></div>
<h4 id="abs-example">ABS Example</h4>
@@ -281,7 +321,7 @@ SELECT ABS(`integer`) FROM dfs.`/Users/d
<ul>
<li>Rounded to the nearest integer.</li>
<li><p>Rounded to the fourth decimal place.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT ROUND(`float`) FROM dfs.`/Users/khahn/Documents/test_files_source/input2.json`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT ROUND(`float`) FROM dfs.`/Users/drill/input2.json`;
+------------+
| EXPR$0 |
Modified: drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html (original)
+++ drill/site/trunk/content/drill/docs/mongodb-plugin-for-apache-drill/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/drill-default-input-format">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/mapr-db-format/">Next</a></p>
-
-<h2 id="overview">Overview</h2>
+<div class="int_text" align="left"><h2 id="overview">Overview</h2>
<p>You can leverage the power of Apache Drill to query data without any upfront
schema definitions. Drill enables you to create an architecture that works
Modified: drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html (original)
+++ drill/site/trunk/content/drill/docs/odbc-jdbc-interfaces/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/mapr-db-format/">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/using-the-mapr-odbc-driver-on-windows">Next</a></p>
-
-<p>You can connect to Apache Drill through the following interfaces:</p>
+<div class="int_text" align="left"><p>You can connect to Apache Drill through the following interfaces:</p>
<ul>
<li>Drill shell (SQLLine)</li>
Modified: drill/site/trunk/content/drill/docs/performance/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/performance/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/performance/index.html (original)
+++ drill/site/trunk/content/drill/docs/performance/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/flexibility">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/apache-drill-tutorial">Next</a></p>
-
-<p>Drill is designed from the ground up for high performance on large datasets.
+<div class="int_text" align="left"><p>Drill is designed from the ground up for high performance on large datasets.
The following core elements of Drill processing are responsible for Drill's
performance:</p>
Modified: drill/site/trunk/content/drill/docs/query-data/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/query-data/index.html?rev=1670235&r1=1670234&r2=1670235&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/query-data/index.html (original)
+++ drill/site/trunk/content/drill/docs/query-data/index.html Tue Mar 31 01:20:42 2015
@@ -67,9 +67,7 @@
</div>
-<div class="int_text" align="left"><p><a href="/docs/using-drill-explorer-to-browse-data-and-create-views">Previous</a><code> </code><a href="/docs">Back to Table of Contents</a><code> </code><a href="/docs/getting-started-tutorial">Next</a></p>
-
-<p>You can query local and distributed file systems, Hive, and HBase data sources
+<div class="int_text" align="left"><p>You can query local and distributed file systems, Hive, and HBase data sources
registered with Drill. If you connected directly to a particular schema when
you invoked SQLLine, you can issue SQL queries against that schema. If you did
not indicate a schema when you invoked SQLLine, you can issue the <code>USE
@@ -108,6 +106,7 @@ Example: <code>SELECT * FROM dfs.default
</ul></li>
<li><p><code>CAST</code> data to <code>VARCHAR</code> if an expression in a query returns <code>VARBINARY</code> as the result type in order to view the <code>VARBINARY</code> types as readable data. If you do not use the <code>CAST</code> function, Drill returns the results as byte data.<br>
Example: <code>CAST (VARBINARY_expr as VARCHAR(50))</code></p></li>
+<li><p>When querying schema-less data using SELECT *, the order of the returned columns might differ from the stored order and vary from query to query.</p></li>
</ul>
</div>
Added: drill/site/trunk/content/drill/docs/repeated-contains/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/repeated-contains/index.html?rev=1670235&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/repeated-contains/index.html (added)
+++ drill/site/trunk/content/drill/docs/repeated-contains/index.html Tue Mar 31 01:20:42 2015
@@ -0,0 +1,164 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>REPEATED_CONTAINS - 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/button.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>
+
+</head>
+
+<body onResize="resized();">
+
+<div class="bui"></div>
+
+<div id="search">
+<input type="text" placeholder="Enter search term here">
+</div>
+
+<div id="menu" class="mw">
+<ul>
+ <li class="logo"><a href="/"></a></li>
+ <li>
+ <a href="/overview/">Documentation</a>
+ <ul>
+ <li><a href="/overview/">Overview </a></li>
+ <li><a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes" target="_blank">Drill in 10 Minutes</a></li>
+ <li><a href="/why/">Why Drill? </a></li>
+ <li><a href="/architecture/">Architecture</a></li>
+ </ul>
+ </li>
+ <li>
+ <a href="/community/">Community</a>
+ <ul>
+ <li><a href="/team/">Team</a></li>
+ <li><a href="/community/#events">Events and Meetups</a></li>
+ <li><a href="/community/#mailinglists">Mailing Lists</a></li>
+ <li><a href="/community/#getinvolved">Get Involved</a></li>
+ <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
+ <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+ </ul>
+ </li>
+ <li><a href="/faq/">FAQ</a></li>
+ <li><a href="/blog/">Blog</a></li>
+ <li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </li>
+ <li class="l"><span> </span></li>
+ <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>REPEATED_CONTAINS</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>REPEATED CONTAINS searches for a keyword in an array. </p>
+
+<h2 id="syntax">Syntax</h2>
+<div class="highlight"><pre><code class="language-text" data-lang="text">REPEATED_CONTAINS(array_name, keyword)
+</code></pre></div>
+<ul>
+<li><p>array_name is a simple array, such as topping:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+. . .
+ "topping":
+ [
+ "None",
+ "Glazed",
+ "Sugar",
+ "Powdered Sugar",
+ "Chocolate with Sprinkles",
+ "Chocolate",
+ "Maple"
+ ]
+}
+</code></pre></div></li>
+<li><p>keyword is a value in the array, such as 'Glazed'.</p></li>
+</ul>
+
+<h2 id="usage-notes">Usage Notes</h2>
+
+<p>REPEATED_CONTAINS returns true if Drill finds a match; otherwise, the function returns false. The function supports regular expression wildcards, such as *, ., and ?, but not at the beginning of the keyword. Enclose keyword string values in single quotation marks. Do not enclose numerical keyword values in single quotation marks.</p>
+
+<h2 id="examples">Examples</h2>
+
+<p>The examples in this section <code>testRepeatedWrite.json</code>. To download this file, go to <a href="https://github.com/apache/drill/tree/master/exec/java-exec/src/test/resources">Drill test resources</a> page, locate testRepeatedWrite.json.json in the list of files, and download it. For example, on the Mac right-click the five, select Save Link As, and then click Save.</p>
+
+<p>Which donuts having glazed or glaze toppings?</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT name, REPEATED_CONTAINS(topping, 'Glaze?') AS `Glazed?` FROM dfs.`/Users/drill/testRepeatedWrite.json` WHERE type='donut';
+
+ +------------+------------+
+ | name | Glazed? |
+ +------------+------------+
+ | Cake | true |
+ | Raised | true |
+ | Old Fashioned | true |
+ | Filled | true |
+ | Apple Fritter | true |
+ +------------+------------+
+ 5 rows selected (0.072 seconds)
+</code></pre></div>
+<p>Which objects have powered sugar toppings? Use the asterisk wildcard instead of typing the entire keyword pair.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT name, REPEATED_CONTAINS(topping, 'P*r') AS `Powdered Sugar?` FROM dfs.`/Users/khahn/Documents/test_files_source/testRepeatedWrite.json` WHERE type='donut';
+
++------------+-----------------+
+| name | Powdered Sugar? |
++------------+-----------------+
+| Cake | true |
+| Raised | true |
+| Old Fashioned | false |
+| Filled | true |
+| Apple Fritter | false |
++------------+-----------------+
+5 rows selected (0.089 seconds)
+</code></pre></div>
+<p>Which donuts have toppings beginning with the letters "Map" and ending in any two letters?</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT name, REPEATED_CONTAINS(topping, 'Map..') AS `Maple?` FROM dfs.`/Users/drill/testRepeatedWrite.json` WHERE type='donut';
+
++------------+------------+
+| name | Maple? |
++------------+------------+
+| Cake | true |
+| Raised | true |
+| Old Fashioned | true |
+| Filled | true |
+| Apple Fritter | false |
++------------+------------+
+5 rows selected (0.085 seconds)
+</code></pre></div></div>
+
+
+<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>