You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ad...@apache.org on 2015/02/26 02:16:45 UTC
svn commit: r1662344 [8/8] - in /drill/site/trunk/content/drill: ./
blog/2014/12/11/apache-drill-qa-panelist-spotlight/ docs/
docs/2014-q1-drill-report/ docs/advanced-properties/
docs/analyzing-yelp-json-data-with-apache-drill/ docs/apache-drill-0-6-0-...
Modified: drill/site/trunk/content/drill/docs/supported-date-time-data-type-formats/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/supported-date-time-data-type-formats/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/supported-date-time-data-type-formats/index.html (original)
+++ drill/site/trunk/content/drill/docs/supported-date-time-data-type-formats/index.html Thu Feb 26 01:16:43 2015
@@ -136,14 +136,14 @@ Apache Drill does not support <code>time
</tr>
</tbody>
</table>
-
+
## Time
Drill supports the `time` data type in the following format:
HH:mm:ss.SSS (hour:minute:sec.milliseconds)
-The following table provides some examples for the` time` data type:
+The following table provides some examples for the `time` data type:
<table><tbody><tr>
<th>Use</th>
@@ -162,7 +162,6 @@ The following table provides some exampl
<td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select cast(time_col as time) from dfs.`/tmp/input.json`;</span></code></td>
</tr></tbody>
</table>
-
<h2 id="interval">Interval</h2>
@@ -174,7 +173,7 @@ The following table provides some exampl
supports the <code>interval</code> data type in the following format:</p>
<div class="highlight"><pre><code class="language-text" data-lang="text">P [qty] Y [qty] M
</code></pre></div>
-<p>The following table provides examples for <code>interval year</code>data type:</p>
+<p>The following table provides examples for <code>interval year</code> data type:</p>
<table ><tbody><tr>
<th>Use</th>
@@ -190,7 +189,6 @@ supports the <code>interval</code> data
<td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select cast(col as interval year) from dfs.`/tmp/input.json`;</span></code></td>
</tr>
</tbody></table>
-
<h3 id="interval-day">Interval Day</h3>
@@ -201,15 +199,14 @@ supports the <code>interval day</code> d
</code></pre></div>
<p>The following table provides examples for <code>interval day</code> data type:</p>
-<div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Use</th><th class="confluenceTh">Example</th></tr><tr><td valign="top">Literal</td><td valign="top"><code><span style="color: rgb(0,0,0);">select interval '1 10:20:30.123' day to second from dfs.`/tmp/input.json`;<br /></span><span style="color: rgb(0,0,0);">select interval '1 10' day to hour from dfs.`/tmp/input.json`;<br /></span><span style="color: rgb(0,0,0);">select interval '10' day from dfs.`/tmp/input.json`;<br /></span><span style="color: rgb(0,0,0);">select interval '10' hour from dfs.`/tmp/input.json`;</span></code><code><span style="color: rgb(0,0,0);">select interval '10.999' second from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code>JSON</code> Input</td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">{"col" : "P1DT10H20M30S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "P1DT
10H20M30.123S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "P1D"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT10H"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT10.10S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT20S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT10H10S"}</span></code></td></tr><tr><td colspan="1" valign="top"><code>CAST</code> from <code>VARCHAR</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select cast(col as interval day) from dfs.`/tmp/input.json`;</span></code></td></tr></tbody></table></div>
-
+<table ><tbody><tr><th >Use</th><th >Example</th></tr><tr><td valign="top">Literal</td><td valign="top"><code><span style="color: rgb(0,0,0);">select interval '1 10:20:30.123' day to second from dfs.`/tmp/input.json`;<br /></span><span style="color: rgb(0,0,0);">select interval '1 10' day to hour from dfs.`/tmp/input.json`;<br /></span><span style="color: rgb(0,0,0);">select interval '10' day from dfs.`/tmp/input.json`;<br /></span><span style="color: rgb(0,0,0);">select interval '10' hour from dfs.`/tmp/input.json`;</span></code><code><span style="color: rgb(0,0,0);">select interval '10.999' second from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code>JSON</code> Input</td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">{"col" : "P1DT10H20M30S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "P1DT10H20M30.123S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : &q
uot;P1D"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT10H"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT10.10S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT20S"}<br /></span><span style="color: rgb(0,0,0);">{"col" : "PT10H10S"}</span></code></td></tr><tr><td colspan="1" valign="top"><code>CAST</code> from <code>VARCHAR</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select cast(col as interval day) from dfs.`/tmp/input.json`;</span></code></td></tr></tbody></table>
<h2 id="literal">Literal</h2>
-<p>The following table provides a list of<code>date/time</code> literals that Drill
+<p>The following table provides a list of <code>date/time</code> literals that Drill
supports with examples of each:</p>
-<div class="table-wrap"><table class="confluenceTable"><tbody><tr><th class="confluenceTh">Format</th><th colspan="1" class="confluenceTh">Interpretation</th><th class="confluenceTh">Example</th></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '1 10:20:30.123' day to second</span></code></td><td colspan="1" valign="top"><code>1 day, 10 hours, 20 minutes, 30 seconds, and 123 thousandths of a second</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '1 10:20:30.123' day to second from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '1 10' day to hour</span></code></td><td colspan="1" valign="top"><code>1 day 10 hours</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '1 10' day to hour from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span styl
e="color: rgb(0,0,0);">interval '10' day</span></code></td><td colspan="1" valign="top"><code>10 days</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '10' day from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '10' hour</span></code></td><td colspan="1" valign="top"><code>10 hours</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '10' hour from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '10.999' second</span></code></td><td colspan="1" valign="top"><code>10.999 seconds</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '10.999' second from dfs.`/tmp/input.json`; </span></code></td></tr></tbody></table></div>
+<table ><tbody><tr><th >Format</th><th colspan="1" >Interpretation</th><th >Example</th></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '1 10:20:30.123' day to second</span></code></td><td colspan="1" valign="top"><code>1 day, 10 hours, 20 minutes, 30 seconds, and 123 thousandths of a second</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '1 10:20:30.123' day to second from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '1 10' day to hour</span></code></td><td colspan="1" valign="top"><code>1 day 10 hours</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '1 10' day to hour from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '10' day</span></code></td><td colspan="1" valign="top"><code>10 days</code
></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '10' day from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '10' hour</span></code></td><td colspan="1" valign="top"><code>10 hours</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '10' hour from dfs.`/tmp/input.json`;</span></code></td></tr><tr><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">interval '10.999' second</span></code></td><td colspan="1" valign="top"><code>10.999 seconds</code></td><td colspan="1" valign="top"><code><span style="color: rgb(0,0,0);">select interval '10.999' second from dfs.`/tmp/input.json`; </span></code></td></tr></tbody></table>
</div>
Added: drill/site/trunk/content/drill/docs/tableau-examples/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/tableau-examples/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/tableau-examples/index.html (added)
+++ drill/site/trunk/content/drill/docs/tableau-examples/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,343 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Tableau Examples - 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>Tableau Examples</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>You can generate reports in Tableau using ODBC connections to Drill data
+sources. Each example in this section takes you through the steps to create a
+DSN to a Drill data source and then access the data in Tableau 8.1.</p>
+
+<p>This section includes the following examples:
+ * Connecting to a Hive table
+ * Using a view to connect to Hbase table data
+ * Using custom SQL to connect to data in a Parquet file
+The steps and results of these examples assume pre-configured schemas and
+source data. You configure schemas as storage plugin instances on the Storage
+tab of the <a href="/drill/docs/getting-to-know-the-drill-sandbox#storage-plugins-overview">Drill Web UI</a>.</p>
+
+<h2 id="example:-connect-to-a-hive-table-in-tableau">Example: Connect to a Hive Table in Tableau</h2>
+
+<p>To access Hive tables in Tableau 8.1, connect to the Hive schema using a DSN
+and then visualize the data in Tableau.<br>
+<strong>Note:</strong> This example assumes that there is a schema named hive.default which contains a table named student_hive. </p>
+
+<h2 id="step-1:-create-a-dsn-to-a-hive-table">Step 1: Create a DSN to a Hive Table</h2>
+
+<p>In this step, we will create a DSN that accesses a Hive table.</p>
+
+<ol>
+<li>To launch the ODBC Administrator, click <strong>Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator.</strong>
+ The _ODBC Data Source Administrator _window appears.</li>
+<li>On the <strong>System DSN</strong> tab, click <strong>Add</strong>.</li>
+<li>Select <strong>MapR Drill ODBC Driver</strong> and click <strong>Finish</strong>.<br>
+ The <em>MapR Drill ODBC Driver DSN Setup</em> window appears.</li>
+<li>Enter a name for the data source.</li>
+<li>Specify the connection type based on your requirements. The connection type provides the DSN access to Drill Data Sources. .<br>
+In this example, we are connecting to a Zookeeper Quorum.</li>
+<li>In the <strong>Schema</strong> field, select the Hive schema.
+ In this example, the Hive schema is named hive.default.
+ <img src="/docs/img/Hive_DSN.png" alt=""></li>
+<li>Click <strong>OK</strong> to create the DSN and return to the ODBC Data Source Administrator window.</li>
+<li>Click <strong>OK</strong> to close the ODBC Data Source Administrator.</li>
+</ol>
+
+<h2 id="step-2:-connect-to-hive-tables-in-tableau">Step 2: Connect to Hive Tables in Tableau</h2>
+
+<p>Now, we can connect to Hive tables.</p>
+
+<ol>
+<li>In Tableau, click <strong>Data > Connect to Data</strong>.</li>
+<li>In the <em>On a server</em> section, click <strong>Other Databases (ODBC</strong>).<br>
+ The <em>Generic ODBC Connection</em> dialog appears.</li>
+<li>In the <em>Connect Using</em> section, select the DSN that connects to the Hive table.<br>
+-or-<br>
+To create a connection without an existing DSN, select the Driver option,
+select the MapR Drill ODBC driver from the list and click <strong>Connect.</strong> Then,
+configure the connection to the Hive table and click <strong>OK</strong>.** **</li>
+<li>In the <strong>Schema</strong> field, select the Hive schema.<br>
+ In this example, the Hive schema is named hive.default.</li>
+<li>In the <em>Table</em> section, verify that <strong>Single Table</strong> is selected and then click the Search icon.<br>
+ A list of tables appears.</li>
+<li>Select the table from the list and click <strong>Select</strong>.<br>
+ In this example, the table name is student_hive.</li>
+<li>Click <strong>OK</strong> to complete the connection.<br>
+ <img src="/docs/img/ODBC_HiveConnection.png" alt=""></li>
+<li>In the <em>Data Connection</em> dialog, click <strong>Connect Live</strong>.</li>
+</ol>
+
+<h2 id="step-3.-visualize-the-data-in-tableau">Step 3. Visualize the Data in Tableau</h2>
+
+<p>Once you connect to the data, the columns appear in the Data window. To
+visualize the data, drag fields from the Data window to the workspace view.</p>
+
+<p>For example, you can visualize the data in this way:</p>
+
+<p><img src="/docs/img/student_hive.png" alt=""></p>
+
+<h1 id="example:-connect-to-self-describing-data-in-tableau">Example: Connect to Self-Describing Data in Tableau</h1>
+
+<p>You can connect to self-describing data in Tableau in the following ways:</p>
+
+<ol>
+<li>Use Drill Explorer to explore the self-describing data sources, create a Drill view, and then use ODBC to access the view in Tableau as if it were a table. </li>
+<li>Use Tableauâs Custom SQL to query the self-describing data directly. </li>
+</ol>
+
+<h2 id="option-1.-using-a-view-to-connect-to-self-describing-data">Option 1. Using a View to Connect to Self-Describing Data</h2>
+
+<p>The following example describes how to create a view of an HBase table and
+connect to that view in Tableau 8.1. You can also use these steps to access
+data for other sources such as Hive, Parquet, JSON, TSV, and CSV.</p>
+
+<p><strong>Note:</strong> This example assumes that there is a schema named hbase that contains a table named s_voters. It also assumes that there is a schema named dfs.default that points to a writable location.</p>
+
+<h3 id="step-1.-create-a-view-and-a-dsn">Step 1. Create a View and a DSN</h3>
+
+<p>In this step, we will use the ODBC Administrator to access the Drill Explorer
+where we can create a view of an HBase table. Then, we will use the ODBC
+Administrator to create a DSN that connects to the view.</p>
+
+<ol>
+<li>To launch the ODBC Administrator, click <strong>Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator</strong>.<br>
+ The <em>ODBC Data Source Administrator</em> window appears.</li>
+<li>On the System DSN tab, click <strong>Add</strong>.</li>
+<li>Select <strong>MapR Drill ODBC Driver</strong> and click <strong>Finish</strong>.
+ The <em>MapR Drill ODBC Driver DSN Setup</em> window appears.</li>
+<li>Specify the Connection Type based on your requirements.
+ The connection type provides the DSN access to a Drillbit. For more
+information, see <a href="http://doc.mapr.com/display/MapR/Step+2.+Co%0Anfigure+ODBC+Connections+to+Drill+Data+Sources#ConnectionType">Connection Type</a>.</li>
+<li>Click <strong>Drill Explorer</strong> to start exploring the data.
+ The Drill Explorer dialog appears. You can use the Browse tab to visually
+explore the metadata and data available from Drill data sources. Advanced
+users can use SQL tab to type in SQL manually to explore the data and save the
+SQL query as a view.</li>
+<li>Select the schema that you want to create a view for.
+ <img src="/docs/img/Hbase_Browse.png" alt=""><br>
+ Drill Explorer displays the metadata and column families for the selected
+HBase table.</li>
+<li>To create a view of the HBase table, click the <strong>SQL</strong> tab.<br>
+ By default, the View Definition SQL field contains: <code>SELECT * FROM
+<schema>.<table></code></li>
+<li><p>To create the view, enter SQL in the <em>View Definition SQL</em> section and then click <strong>Preview</strong> to verify that the results are as expected.<br>
+ <img src="/docs/img/ODBC_HbasePreview2.png" alt="">
+ In this example, the following SQL was entered:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT cast(row_key as integer) voter_id, convert_from(voter.onecf.name,
+'UTF8') name, cast(voter.twocf.age as integer) age,
+cast(voter.twocf.registration as varchar(20)) registration,
+cast(voter.threecf.contributions as decimal(6,2)) contributions,
+cast(voter.threecf.voterzone as integer)
+voterzone,cast(voter.fourcf.create_date as timestamp) create_time FROM
+hbase.voter
+</code></pre></div>
+<p>HBase does not contain type information, so you need to cast the data in Drill
+Explorer. For information about SQL query support, see the <a href="/drill/docs/sql-reference">SQL
+Reference</a>.</p></li>
+<li><p>To save the view, click <strong>Create As</strong>.</p></li>
+<li><p>Specify the schema where you want to save the view, enter a name for the view, and click <strong>Save</strong>. </p>
+
+<p><img src="/docs/img/HbaseViewCreation0.png" alt=""></p></li>
+<li><p>Close the Drill Explorer to return to the _MapR Drill ODBC Driver DSN Setup _window.<br>
+ Now that we have created the view, we can create a DSN that can access the
+view.</p></li>
+<li><p>Enter a data source name and select the schema where you saved the view.<br>
+ In this example, we saved the view to dfs.default.<br>
+ <img src="/docs/img/HbaseViewDSN.png" alt=""></p></li>
+<li><p>Click <strong>OK</strong> to create the DSN and return to the <em>ODBC Data Source Administrator</em> window.</p></li>
+<li><p>Click <strong>OK</strong> to close the ODBC Data Source Administrator.</p></li>
+</ol>
+
+<h3 id="step-2.-connect-to-the-view-from-tableau">Step 2. Connect to the View from Tableau</h3>
+
+<p>Now, we can connect to the view in Tableau.</p>
+
+<ol>
+<li>In Tableau, click <strong>Data > Connect to Data</strong>.</li>
+<li>In the <em>On a server</em> section, click **Other Databases (ODBC).<br>
+**The <em>Generic ODBC Connection</em> dialog appears.</li>
+<li>In the <em>Connect Using</em> section, select the DSN that connects to the schema that contains the view that you created.<br>
+ -or-<br>
+ To create a connection without an existing DSN, select the <strong>Driver</strong> option, select the <strong>MapR Drill ODBC Driver</strong> from the list and click <strong>Connect</strong>. Then, configure the connection using the steps in step 1 and click <strong>OK</strong>.In this example, we created SQLView-DrillDataSource to access the view.</li>
+<li>In the **Schema **field, select the schema that contains the views that you created in Drill Explorer.<br>
+ In this example, we saved the view to the dfs_default schema.</li>
+<li>In the _Table _section, verify that <strong>Single Table</strong> is selected and then click the Search icon.<br>
+ A list of views appears.</li>
+<li>Select the view from the list and click <strong>Select</strong>.<br>
+ In this example, we need to select hbase_s_voter.<br>
+ <img src="/docs/img/SelectHbaseView.png" alt=""></li>
+<li>Click <strong>OK</strong> to complete the connection.<br>
+ <img src="/docs/img/ODBC_HbaseView.png" alt=""></li>
+<li>In the <em>Data Connection dialog</em>, click <strong>Connect Live</strong>.</li>
+</ol>
+
+<h3 id="step-3.-visualize-the-data-in-tableau">Step 3. Visualize the Data in Tableau</h3>
+
+<p>Once you connect to the data in Tableau, the columns appear in the Data
+window. To visualize the data, drag fields from the Data window to the
+workspace view.</p>
+
+<p>For example, you can visualize the data in this way:</p>
+
+<p><img src="/docs/img/VoterContributions_hbaseview.png" alt=""></p>
+
+<h2 id="option-2.-using-custom-sql-to-access-self-describing-data">Option 2. Using Custom SQL to Access Self-Describing Data</h2>
+
+<p>The following example describes how to use custom SQL to connect to a Parquet
+file and then visualize the data in Tableau 8.1. You can use the same steps to
+access data from other sources such as Hive, HBase, JSON, TSV, and CSV.</p>
+
+<p><strong>Note:</strong> This example assumes that there is a schema named dfs.default which contains a parquet file named region.parquet. </p>
+
+<h3 id="step-1.-create-a-dsn-to-the-parquet-file-and-preview-the-data">Step 1. Create a DSN to the Parquet File and Preview the Data</h3>
+
+<p>In this step, we will create a DSN that accesses files on the DFS. We will
+also use Drill Explorer to preview the SQL that we want to use to connect to
+the data in Tableau.</p>
+
+<ol>
+<li>To launch the ODBC Administrator, click *<em>Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator.<br>
+ *</em>The _ODBC Data Source Administrator _window appears.</li>
+<li>On the <strong>System DSN</strong> tab, click <strong>Add</strong>.</li>
+<li>Select <strong>MapR Drill ODBC Driver</strong> and click <strong>Finish</strong>.<br>
+ The <em>MapR Drill ODBC Driver DSN Setup</em> window appears.</li>
+<li>Enter a data source name.</li>
+<li>Specify the connection type based on your requirements. See Connection Type for more information.<br>
+ The connection type provides the DSN access to a Drillbit.<br>
+ In this example, we will connect to a Zookeeper Quorum.</li>
+<li>In the <em>Schema</em> section, select the schema associated with the data source that contains the Parquet file that you want to access. Then, click <strong>OK</strong>.<br>
+ In this example, the Parquet file is available in the dfs.default schema.<br>
+ <img src="/docs/img/Parquet_DSN.png" alt=""><br>
+ You can use this DSN to access multiple files from the same schema.<br>
+ In this example, we plan to use the Custom SQL option to connect to data in Tableau. You can use Drill Explorer to preview the results of custom SQL before you enter the SQL in Tableau.</li>
+<li>If you want to preview the results of a query, click <strong>Drill Explorer</strong>.
+
+<ol>
+<li>On the <strong>Browse</strong> tab, navigate to the file that you want. </li>
+<li>Click the <strong>SQL</strong> tab.<br>
+The SQL tab will include a default query to the file you selected on the Browse tab. You can use the SQL tab to preview the results of various queries until you achieve the expected result.</li>
+<li>Enter the query that you want to preview and then click <strong>Preview</strong>.<br>
+<img src="/docs/img/Parquet_Preview.png" alt=""><br>
+You can copy this query to file so that you can use it in Tableau.</li>
+<li>Close the Drill Explorer window. </li>
+</ol></li>
+<li>Click <strong>OK</strong> to create the DSN and return to the <em>ODBC Data Source Administrato</em>r window.</li>
+<li>Click <strong>OK</strong> to close the ODBC Data Source Administrator.</li>
+</ol>
+
+<h3 id="step-2.-connect-to-a-parquet-file-in-tableau-using-custom-sql">Step 2. Connect to a Parquet File in Tableau using Custom SQL</h3>
+
+<p>Now, we can create a connection to the Parquet file using the custom SQL.</p>
+
+<ol>
+<li>In Tableau, click <strong>Data > Connect to Data</strong>.</li>
+<li>In the <em>On a server</em> section, click **Other Databases (ODBC).<br>
+ **The <em>Generic ODBC Connection</em> dialog appears.</li>
+<li>In the <em>Connect Using</em> section, select the DSN that connects to the data source.<br>
+ In this example, Files-DrillDataSources was selected.</li>
+<li>In the <em>Schema</em> section, select the schema associated with the data source.<br>
+ In this example, dfs.default was selected.</li>
+<li>In the _Table _section, select <strong>Custom SQL</strong>.</li>
+<li><p>Enter the SQL query.<br>
+ In this example, the following SQL query was entered: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> SELECT CAST(R_NAME as varchar(20))Country,
+ CAST(R_COMMENT as varchar(200))Comments, R_RegionKey
+ FROM `dfs`.`default`.`./opt/mapr/drill/drill-1.0.0.BETA1/sample-data/region.parquet`
+</code></pre></div>
+<p>Note: The path to the file depends on its location in your file system.<code></code></p></li>
+<li><p>Click <strong>OK</strong> to complete the connection.<br>
+ <img src="/docs/img/ODBC_CustomSQL.png" alt=""></p></li>
+<li><p>In the <em>Data Connection dialog</em>, click <strong>Connect Live</strong>.</p></li>
+</ol>
+
+<h3 id="step-3.-visualize-the-data-in-tableau">Step 3. Visualize the Data in Tableau</h3>
+
+<p>Once you connect to the data, the fields appear in the Data window. To
+visualize the data, drag fields from the Data window to the workspace view.</p>
+
+<p>For example, you can visualize the data in this way:
+<img src="/docs/img/RegionParquet_table.png" alt=""></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>
Added: drill/site/trunk/content/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/index.html (added)
+++ drill/site/trunk/content/drill/docs/testing-the-odbc-connection-on-linux-and-mac-os-x/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,128 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Testing the ODBC Connection on Linux and Mac OS X - 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>Testing the ODBC Connection on Linux and Mac OS X</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>To test the connection, you can use an ODBC-enabled client application. For a
+basic connection test, you can also use the test utilities that are packaged
+with your driver manager installation.</p>
+
+<p>For example, the iODBC driver manager includes simple utilities called
+<code>iodbctest</code> and <code>iodbctestw</code>. You can use either one of these utilities to
+establish a test connection with your driver and your DSN. Use <code>iodbctest</code> to
+test how your driver works with an ANSI application. Use <code>iodbctestw</code> to test
+how your driver works with a Unicode application.</p>
+
+<p><strong>Note:</strong> There are 32-bit and 64-bit installations of the iODBC driver manager available. If you have only one or the other installed, then the appropriate version of iodbctest (or iodbctestw) is available. However, if you have both 32- and 64-bit versions installed, then you need to be careful that you are running the version from the correct installation directory.</p>
+
+<p>Visit <a href="http://www.iodbc.org/">http://www.iodbc.org</a> for further details on
+using the iODBC driver manager.</p>
+
+<h2 id="testing-the-odbc-connection">Testing the ODBC Connection</h2>
+
+<p>Complete the following steps to test your connection using the iODBC driver
+manager:</p>
+
+<ol>
+<li>Run <code>iodbctest</code> or <code>iodbctestw</code>. The program prompts you for an ODBC connection string.</li>
+<li>If you do not remember the DSN name, type a question mark (?) to see a list of DSNs.</li>
+<li><p>If you are connecting directly to a Drillbit, type an ODBC connection string using the following format:</p>
+
+<p><code>DRIVER=MapR Drill ODBC Driver;ConnectionType=Direct;Host=HostName;Port=PortNumber</code></p>
+
+<p>OR</p>
+
+<p>If you are connecting to a ZooKeeper cluster, type an ODBC connection string
+using the following format:</p>
+
+<p><code>DRIVER=MapR Drill ODBC Driver;ConnectionType=ZooKeeper;ZKQuorum=Server1:Port1
+,Server2:Port2;ZKClusterID=DrillbitName</code></p>
+
+<p>If the connection is successful, the <code>SQL></code> prompt appears.</p></li>
+</ol>
+</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/useful-research/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/useful-research/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/useful-research/index.html (original)
+++ drill/site/trunk/content/drill/docs/useful-research/index.html Thu Feb 26 01:16:43 2015
@@ -116,7 +116,7 @@
<li><a href="https://github.com/rgrzywinski/field-stripe/">https://github.com/rgrzywinski/field-stripe/</a></li>
</ul>
-<h2 id="code-generation-/-physical-plan-generation">Code generation / Physical plan generation</h2>
+Code generation / Physical plan generation</h2>
<ul>
<li><a href="http://www.vldb.org/pvldb/vol4/p539-neumann.pdf">http://www.vldb.org/pvldb/vol4/p539-neumann.pdf</a> (SLIDES: <a href="http://www.vldb.org/2011/files/slides/research9/rSession9-3.pdf">http://www.vldb.org/2011/files/slides/research9/rSession9-3.pdf</a>)</li>
Added: drill/site/trunk/content/drill/docs/using-drill-explorer-to-browse-data-and-create-views/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/using-drill-explorer-to-browse-data-and-create-views/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/using-drill-explorer-to-browse-data-and-create-views/index.html (added)
+++ drill/site/trunk/content/drill/docs/using-drill-explorer-to-browse-data-and-create-views/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,139 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Using Drill Explorer to Browse Data and Create Views - 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>Using Drill Explorer to Browse Data and Create Views</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Drill Explorer is a simple user interface that is embedded within the ODBC
+DSN. Drill Explorer enables users to understand the metadata and data before
+visualizing the data in a BI tool. Use Drill Explorer to browse Drill data
+sources, preview the results of a SQL query, and create a view that you can
+query.</p>
+
+<p>The Browse tab of Drill Explorer allows you to view metadata for each schema
+that you can access with Drill. The SQL tab allows you to preview the results
+of custom queries and save the results as a view.</p>
+
+<p><strong>To Browse Data:</strong></p>
+
+<ol>
+<li>To launch the ODBC Administrator, click <strong>Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator.</strong></li>
+<li>Click the <strong>User DSN</strong> tab or the <strong>System DSN</strong> tab and then select the DSN that corresponds to the Drill data source that you want to explore.</li>
+<li>Click <strong>Configure</strong>.<br>
+ The <em>MapR Drill ODBC Driver DSN Setup</em> dialog appears.</li>
+<li>Click <strong>Drill Explorer</strong>.</li>
+<li>In the <strong>Schemas</strong> section on the <strong>Browse</strong> tab, navigate to the the data source that you want to explore.</li>
+</ol>
+
+<p><strong>To Create a View</strong>:</p>
+
+<ol>
+<li>To launch the ODBC Administrator, click** Start > All Programs > MapR Drill ODBC Driver 1.0 (32|64-bit) > (32|64-bit) ODBC Administrator.**</li>
+<li>Click the <strong>User DSN</strong> tab or the <strong>System DSN</strong> tab and then select the DSN that corresponds to the Drill data source that you want to explore.</li>
+<li>Click <strong>Configure</strong>.<br>
+ The <em>MapR Drill ODBC Driver DSN Setup</em> dialog appears.</li>
+<li>Click <strong>Drill Explorer</strong>.</li>
+<li>In the <strong>Schemas</strong> section on the <strong>Browse</strong> tab, navigate to the the data source that you want to create a view for.<br>
+ After you select a data souce, the metadata and data displays on the Browse tab and the SQL that is used to access the data displays on the SQL tab.</li>
+<li>Click the <strong>SQL</strong> tab.</li>
+<li>In the <strong>View Definition SQL</strong> field, enter the SQL query that you want to create a view for.</li>
+<li>Click <strong>Preview</strong>.<br>
+ If the results are not as expected, you can edit the SQL query and click
+Preview again.</li>
+<li>Click <strong>Create As</strong>.<br>
+ The <em>Create As</em> dialog displays.</li>
+<li>In the <strong>Schema</strong> field, select the schema where you want to save the view.
+ As of 0.4.0, you can only save views to file-based schemas.</li>
+<li>In the <strong>View Name</strong> field, enter a descriptive name for the view.
+ As of 0.4.0, do not include spaces in the view name.</li>
+<li>Click <strong>Save</strong>.<br>
+ The status and any error message associated with the view creation displays in
+the Create As dialog. When a view saves successfully, the Save button changes
+to a Close button.</li>
+<li>Click <strong>Close</strong>.</li>
+</ol>
+</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>
Added: drill/site/trunk/content/drill/docs/using-the-jdbc-driver/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/using-the-jdbc-driver/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/using-the-jdbc-driver/index.html (added)
+++ drill/site/trunk/content/drill/docs/using-the-jdbc-driver/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,236 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Using the JDBC Driver - 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>Using the JDBC Driver</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>To use the JDBC Driver to access Drill through Squirrel, ensure that you meet the prerequisites and follow the steps in this section.</p>
+
+<h3 id="prerequisites">Prerequisites</h3>
+
+<ul>
+<li>SQuirreL requires JRE 7</li>
+<li>Drill installed in distributed mode on one or multiple nodes in a cluster. Refer to the <a href="/drill/docs/install-drill/">Install Drill</a> documentation for more information.</li>
+<li>The client must be able to resolve the actual hostname of the Drill node(s) with the IP(s). Verify that a DNS entry was created on the client machine for the Drill node(s).</li>
+</ul>
+
+<p>If a DNS entry does not exist, create the entry for the Drill node(s).</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">* For Windows, create the entry in the %WINDIR%\system32\drivers\etc\hosts file.
+* For Linux and Mac, create the entry in /etc/hosts.
+</code></pre></div>
+<p><drill-machine-IP> <drill-machine-hostname>
+ Example: <code>127.0.1.1 maprdemo</code></p>
+
+<h3 id="step-1:-getting-the-drill-jdbc-driver">Step 1: Getting the Drill JDBC Driver</h3>
+
+<p>The Drill JDBC Driver <code>JAR</code> file must exist in a directory on your Windows
+machine in order to configure the driver in the SQuirreL client.</p>
+
+<p>You can copy the Drill JDBC <code>JAR</code> file from the following Drill installation
+directory on the node with Drill installed, to a directory on your Windows
+machine:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"><drill_installation_directory>/jars/jdbc-driver/drill-jdbc-all-0.7.0-SNAPSHOT.jar
+</code></pre></div>
+<p>Or, you can download the <a href="http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0%0A/apache-drill-0.7.0.tar.gz">apache-
+drill-0.7.0.tar.gz</a> file to a location on your Windows machine, and
+extract the contents of the file. You may need to use a decompression utility,
+such as <a href="http://www.7-zip.org/">7-zip</a> to extract the archive. Once extracted,
+you can locate the driver in the following directory:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"><windows_directory>\apache-drill-<version>\jars\jdbc-driver\drill-jdbc-all-0.7.0-SNAPSHOT.jar
+</code></pre></div>
+<h3 id="step-2:-installing-and-starting-squirrel">Step 2: Installing and Starting SQuirreL</h3>
+
+<p>To install and start SQuirreL, complete the following steps:</p>
+
+<ol>
+<li>Download the SQuirreL JAR file for Windows from the following location:<br>
+<a href="http://www.squirrelsql.org/#installation">http://www.squirrelsql.org/#installation</a></li>
+<li>Double-click the SQuirreL <code>JAR</code> file. The SQuirreL installation wizard walks you through the installation process.</li>
+<li>When installation completes, navigate to the SQuirreL installation folder and then double-click <code>squirrel-sql.bat</code> to start SQuirreL.</li>
+</ol>
+
+<h3 id="step-3:-adding-the-drill-jdbc-driver-to-squirrel">Step 3: Adding the Drill JDBC Driver to SQuirreL</h3>
+
+<p>To add the Drill JDBC Driver to SQuirreL, define the driver and create a
+database alias. The alias is a specific instance of the driver configuration.
+SQuirreL uses the driver definition and alias to connect to Drill so you can
+access data sources that you have registered with Drill.</p>
+
+<h4 id="a.-define-the-driver">A. Define the Driver</h4>
+
+<p>To define the Drill JDBC Driver, complete the following steps:</p>
+
+<ol>
+<li><p>In the SQuirreL toolbar, select <strong>Drivers > New Driver</strong>. The Add Driver dialog box appears.</p>
+
+<p><img src="/docs/img/40.png" alt="drill query flow"></p></li>
+<li><p>Enter the following information:</p>
+
+<table style='table-layout:fixed;width:100%'><tbody><tr><td valign="top" width="13%"><strong>Option</strong></td><td valign="top" style='width: 460px;'><strong>Description</strong></td></tr><tr><td valign="top">Name</td><td valign="top">Name for the Drill JDBC Driver</td></tr><tr><td valign="top">Example URL</td><td valign="top"><code>jdbc:drill:zk=<<em>zookeeper_quorum</em>>[;schema=<<em>schema_to_use_as_default</em>>]</code><strong>Example:</strong><code> jdbc:drill:zk=maprdemo:5181</code><strong>Note:</strong> The default ZooKeeper port is 2181. In a MapR cluster, the ZooKeeper port is 5181.</td></tr><tr><td valign="top">Website URL</td><td valign="top"><code>jdbc:drill:zk=<<em>zookeeper_quorum</em>>[;schema=<<em>schema_to_use_as_default</em>>]</code><strong>Example:</strong><code><code> jdbc:drill:zk=maprdemo:5181</code></code><strong>Note:</strong><span> The default ZooKeeper port is 2181. In a MapR cluster, the ZooKeeper port is 5181.</span></td></tr><t
r><td valign="top">Extra Class Path</td><td valign="top">Click <strong>Add</strong> and navigate to the JDBC <code>JAR</code> file location in the Windows directory:<br /><code><windows_directory>/jars/jdbc-driver/<span style="color: rgb(34,34,34);">drill-jdbc-all-0.6.0-</span><span style="color: rgb(34,34,34);">incubating.jar</span></code>Select the <code>JAR</code> file, click <strong>Open</strong>, and then click <strong>List Drivers</strong>.</td></tr><tr><td valign="top">Class Name</td><td valign="top">Select <code>org.apache.drill.jdbc.Driver</code> from the drop-down menu.</td></tr></tbody></table> </li>
+<li><p>Click <strong>OK</strong>. The SQuirreL client displays a message stating that the driver registration is successful, and you can see the driver in the Drivers panel. </p></li>
+</ol>
+
+<p><img src="/docs/img/52.png" alt="drill query flow"></p>
+
+<h4 id="b.-create-an-alias">B. Create an Alias</h4>
+
+<p>To create an alias, complete the following steps:</p>
+
+<ol>
+<li>Select the <strong>Aliases</strong> tab.</li>
+<li><p>In the SQuirreL toolbar, select <strong>Aliases ></strong><strong>New Alias</strong>. The Add Alias dialog box appears.</p>
+
+<p><img src="/docs/img/19.png" alt="drill query flow"></p></li>
+<li><p>Enter the following information:</p>
+
+<p><table style='table-layout:fixed;width:100%'><tbody><tr>
+ <td valign="top" width="10%"><strong>Option</strong></td>
+ <td valign="top" style='width: 500px;'><strong>Description</strong></td>
+ </tr>
+ <tr>
+ <td valign="top">Alias Name</td>
+ <td valign="top">A unique name for the Drill JDBC Driver alias.</td>
+ </tr>
+ <tr>
+ <td valign="top">Driver</td>
+ <td valign="top">Select the Drill JDBC Driver.</td>
+ </tr>
+ <tr>
+ <td valign="top">URL</td>
+ <td valign="top">Enter the connection URL with the name of the Drill directory stored in ZooKeeper and the cluster ID:
+ <code>jdbc:drill:zk=<<em>zookeeper_quorum</em>>/<drill_directory_in_zookeeper>/<cluster_ID>;schema=<<em>schema_to_use_as_default</em>></code>
+ <em>The following examples show URLs for Drill installed on a single node:</em><br />
+ <span style="font-family: monospace;font-size: 14.0px;line-height: 1.4285715;background-color: transparent;">jdbc:drill:zk=10.10.100.56:5181/drill/demo_mapr_com-drillbits;schema=hive<br /></span>
+ <span style="font-family: monospace;font-size: 14.0px;line-height: 1.4285715;background-color: transparent;">jdbc:drill:zk=10.10.100.24:2181/drill/drillbits1;schema=hive<br /> </span>
+ <em>The following example shows a URL for Drill installed in distributed mode with a connection to a ZooKeeper quorum:</em>
+ <span style="font-family: monospace;font-size: 14.0px;line-height: 1.4285715;background-color: transparent;">jdbc:drill:zk=10.10.100.30:5181,10.10.100.31:5181,10.10.100.32:5181/drill/drillbits1;schema=hive</span>
+ <ul>
+ <li>Including a default schema is optional.</li>
+ <li>The ZooKeeper port is 2181. In a MapR cluster, the ZooKeeper port is 5181.</li>
+ <li>The Drill directory stored in ZooKeeper is <code>/drill</code>.</li>
+ <li>The Drill default cluster ID is<code> drillbits1</code>.</li>
+ </ul>
+ </td></tr><tr>
+ <td valign="top">User Name</td>
+ <td valign="top">admin</td>
+ </tr>
+ <tr>
+ <td valign="top">Password</td>
+ <td valign="top">admin</td>
+ </tr></tbody></table></p></li>
+<li><p>Click <strong>Ok</strong>. The Connect to: dialog box appears. </p>
+
+<p><img src="/docs/img/30.png" alt="drill query flow"></p></li>
+<li><p>Click <strong>Connect</strong>. SQuirreL displays a message stating that the connection is successful.</p>
+
+<p><img src="/docs/img/53.png" alt="drill query flow"></p></li>
+<li><p>Click <strong>OK</strong>. SQuirreL displays a series of tabs.</p></li>
+</ol>
+
+<h3 id="step-4:-running-a-drill-query-from-squirrel">Step 4: Running a Drill Query from SQuirreL</h3>
+
+<p>Once you have SQuirreL successfully connected to your cluster through the
+Drill JDBC Driver, you can issue queries from the SQuirreL client. You can run
+a test query on some sample data included in the Drill installation to try out
+SQuirreL with Drill.</p>
+
+<p>To query sample data with Squirrel, complete the following steps:</p>
+
+<ol>
+<li>Click the SQL tab.</li>
+<li><p>Enter the following query in the query box: </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM cp.`employee.json`;
+</code></pre></div>
+<p>Example:<br>
+ <img src="/docs/img/11.png" alt="drill query flow"></p></li>
+<li><p>Press <strong>Ctrl+Enter</strong> to run the query. The following query results display: </p>
+
+<p><img src="/docs/img/42.png" alt="drill query flow"> </p></li>
+</ol>
+
+<p>You have successfully run a Drill query from the SQuirreL client.</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>
Added: drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/index.html (added)
+++ drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-linux-and-mac-os-x/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,97 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Using the MapR ODBC Driver on Linux and Mac OS X - 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>Using the MapR ODBC Driver on Linux and Mac OS X</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The MapR Drill ODBC driver provides BI tools access to Drillâs flexible query
+capabilities so you can quickly explore various data sources. Once you install
+the MapR Drill ODBC Driver, you can configure ODBC connections to access Drill
+from BI tools through the connections. Drill can connect to data with well-
+defined schemas, such as Hive. Drill can also connect directly to data that is
+self-describing, such as HBase, Parquet, JSON, CSV, and TSV.</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>
Added: drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-windows/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-windows/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-windows/index.html (added)
+++ drill/site/trunk/content/drill/docs/using-the-mapr-odbc-driver-on-windows/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,126 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Using the MapR ODBC Driver on Windows - 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>Using the MapR ODBC Driver on Windows</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The MapR Drill ODBC driver provides BI tools access to Drillâs flexible query
+capabilities so that users can quickly explore various data sources. The MapR
+Drill ODBC driver includes Drill Explorer, which is a simple user interface
+that enables users to examine the content of data sources and create views
+before visualizing the data in a BI tool.</p>
+
+<p>Once you install the MapR Drill ODBC Driver, you can create ODBC DSNs to Drill
+data sources using the ODBC Administrator tool and then use the DSNs to access
+the data from BI tools that work with ODBC. Drill can connect to data with
+well-defined schemas, such as Hive. Drill can also connect directly to data
+that is self-describing, such as HBase, Parquet, JSON, CSV, and TSV.</p>
+
+<p>Complete the following steps to connect to a Drill data source from a BI tool
+using ODBC:</p>
+
+<ul>
+<li><a href="/drill/docs/step-1-install-the-mapr-drill-odbc-driver-on-windows">Step 1. Install the MapR Drill ODBC Driver</a></li>
+<li><a href="/drill/docs/step-2-configure-odbc-connections-to-drill-data-sources">Step 2. Configure ODBC Connections to Drill Data Sources</a></li>
+<li><a href="/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool">Step 3. Connect to Drill Data Sources from a BI Tool</a></li>
+</ul>
+
+<p>For examples of how you can use the MapR Drill ODBC Driver to connect to Drill
+Data Sources from BI tools, see <a href="/drill/docs/step-3-connect-to-drill-data-sources-from-a-bi-tool">Step 3. Connect to Drill Data Sources from a
+BI Tool</a>. While the documentation includes examples for Tableau, you can use
+this driver with any BI tool that works with ODBC, such as Excel,
+MicroStrategy, and Toad.</p>
+
+<p>The following figure shows how a BI tool on Windows uses an ODBC connection to
+access data from a Hive table:</p>
+
+<p><img src="/docs/img/BI_to_Drill_2.png" alt="BI to Drill Interface"></p>
+
+<p>The following components provide applications access to Drill data sources:</p>
+
+<p><table ><tbody><tr><th >Component</th><th >Role</th></tr><tr><td valign="top">Drillbit</td><td valign="top">Accepts queries from clients, executes queries against Drill data sources, and returns the query results. </td></tr><tr><td valign="top">ODBC Data Source Administrator</td><td valign="top">The ODBC Data Source Administrator enables the creation of DSNs to Apache Drill data sources.<br /> In the figure above, the ODBC Data Source Administrator was used to create <code>Hive-DrillDataSources</code>.</td></tr><tr><td valign="top">ODBC DSN</td><td valign="top"><p>Provides applications information about how to connect to the Drill Source.</p>In the figure above, the <code>Hive-DrillDataSources</code> is a DSN that provides connection information to the Hive tables.</td></tr><tr><td colspan="1" valign="top">BI Tool</td><td colspan="1" valign="top"><p>Accesses Drill data sources using the connection information from the ODBC DSN.</p>In the figure above, the BI tool uses <code>Hive-
DrillDataSources</code> to access the <code>hive_student</code> table.</td></tr></tbody></table></div></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/value-vectors/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/value-vectors/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/value-vectors/index.html (original)
+++ drill/site/trunk/content/drill/docs/value-vectors/index.html Thu Feb 26 01:16:43 2015
@@ -68,18 +68,18 @@
</div>
<div class="int_text" align="left"><p>This document defines the data structures required for passing sequences of
-columnar data between <a href="https://docs.google.com/a/maprtech.com/docum%0Aent/d/1zaxkcrK9mYyfpGwX1kAV80z0PCi8abefL45zOzb97dI/edit#bookmark=id.iip15ful18%0Amm">Operators</a>.</p>
+columnar data between <a href="https://docs.google.com/a/maprtech.com/document/d/1zaxkcrK9mYyfpGwX1kAV80z0PCi8abefL45zOzb97dI/edit#bookmark=id.iip15ful18mm">Operators</a>.</p>
-<h1 id="goals">Goals</h1>
+<h2 id="goals">Goals</h2>
-<h4 id="support-operators-written-in-multiple-language">Support Operators Written in Multiple Language</h4>
+<h3 id="support-operators-written-in-multiple-language">Support Operators Written in Multiple Language</h3>
<p>ValueVectors should support operators written in C/C++/Assembly. To support
this, the underlying ByteBuffer will not require modification when passed
through the JNI interface. The ValueVector will be considered immutable once
constructed. Endianness has not yet been considered.</p>
-<h4 id="access">Access</h4>
+<h3 id="access">Access</h3>
<p>Reading a random element from a ValueVector must be a constant time operation.
To accomodate, elements are identified by their offset from the start of the
@@ -87,7 +87,7 @@ buffer. Repeated, nullable and variable
additional fixed width value vector to index each element. Write access is not
supported once the ValueVector has been constructed by the RecordBatch.</p>
-<h4 id="efficient-subsets-of-value-vectors">Efficient Subsets of Value Vectors</h4>
+<h3 id="efficient-subsets-of-value-vectors">Efficient Subsets of Value Vectors</h3>
<p>When an operator returns a subset of values from a ValueVector, it should
reuse the original ValueVector. To accomplish this, a level of indirection is
@@ -96,18 +96,18 @@ indirection is a sequence of offsets whi
ValueVector and the count of subsequent values which are to be included in the
subset.</p>
-<h4 id="pooled-allocation">Pooled Allocation</h4>
+<h3 id="pooled-allocation">Pooled Allocation</h3>
<p>ValueVectors utilize one or more buffers under the covers. These buffers will
be drawn from a pool. Value vectors are themselves created and destroyed as a
schema changes during the course of record iteration.</p>
-<h4 id="homogenous-value-types">Homogenous Value Types</h4>
+<h3 id="homogenous-value-types">Homogenous Value Types</h3>
-<p>Each value in a Value Vector is of the same type. The <a href="https://d%0Aocs.google.com/a/maprtech.com/document/d/1zaxkcrK9mYyfpGwX1kAV80z0PCi8abefL45z%0AOzb97dI/edit#bookmark=kix.s2xuoqnr8obe">Record Batch</a> implementation is responsible for
+<p>Each value in a Value Vector is of the same type. The <a href="https://docs.google.com/a/maprtech.com/document/d/1zaxkcrK9mYyfpGwX1kAV80z0PCi8abefL45zOzb97dI/edit#bookmark=kix.s2xuoqnr8obe">Record Batch</a> implementation is responsible for
creating a new Value Vector any time there is a change in schema.</p>
-<h1 id="definitions">Definitions</h1>
+<h2 id="definitions">Definitions</h2>
<p>Data Types</p>
@@ -132,7 +132,7 @@ Value Vectors, in which case each batch
stores a sequence of values, and zero or more which store any metadata
associated with the ValueVector.</p>
-<h1 id="data-structure">Data Structure</h1>
+<h2 id="data-structure">Data Structure</h2>
<p>A ValueVector stores values in a ByteBuf, which is a contiguous region of
memory. Additional levels of indirection are used to support variable value
@@ -150,10 +150,7 @@ access is supported by accessing element
where Index is 0-based. The following illustrates the underlying buffer of
INT4 values [1 .. 6]:</p>
-<p><img src="../../img/value1.png" alt="image">
-<!--<a href="https://lh5.googleusercontent.com/iobQUgeF4dyrWFeqVfhIBZKbkjrLk5sBJqYhWdzm">https://lh5.googleusercontent.com/iobQUgeF4dyrWFeqVfhIBZKbkjrLk5sBJqYhWdzm</a>
-IyMmmcX1pzZaeQiKZ5OzYeafxcY5IZHXDKuG_JkPwJrjxeLJITpXBbn7r5ep1V07a3JBQC0cJg4qKf
-VhzPZ0PDeh--></p>
+<p><img src="/docs/img/value1.png" alt="drill query flow"></p>
<p>Nullable Values</p>
@@ -163,13 +160,9 @@ the value is NULL. Otherwise the value i
buffer. The following illustrates a NullableValueVector of INT4 values 2, 3
and 6:</p>
-<p><img src="../../img/value2.png" alt=""></p>
+<p><img src="/docs/img/value2.png" alt="drill query flow"></p>
-<!---->
-
-<h4 id="repeated-values">Repeated Values</h4>
+<h3 id="repeated-values">Repeated Values</h3>
<p>A repeated ValueVector is used for elements which can contain multiple values
(e.g. a JSON array). A table of offset and count pairs is used to represent
@@ -178,8 +171,7 @@ has no values (note the offset field is
illustrates three fields; one with two values, one with no values, and one
with a single value:</p>
-<p><img src="../../img/value3.png" alt="">
-<!--<img src="https://lh6.googleusercontent.com/nFIJjIOPAl9zXttVURgp-xkW8v6z6F7ikN7sMREm%0A58pdtfTlwdfjEUH4CHxknHexGdIeEhPHbMMzAgqMwnL99IZlR_YzAWvJaiStOO4QMtML8zLuwLvFDr%0AhJKLMNc0zg" alt="">--></p>
+<p><img src="/docs/img/value3.png" alt="drill query flow"></p>
<p>ValueVector Representation of the equivalent JSON:</p>
@@ -197,8 +189,7 @@ an entry is deduced by subtracting the o
of this, the offset table will always contain one more entry than total
elements, with the last entry pointing to the end of the buffer.</p>
-<p><img src="../../img/value4.png" alt="">
-<!--<img src="https://lh5.googleusercontent.com/ZxAfkmCVRJsKgLYO0pLbRM-%0AaEjR2yyNZWfYkFSmlsod8GnM3huKHQuc6Do-Bp4U1wK-%0AhF3e6vGHTiGPqhEc25YEHEuVTNqb1sBj0LdVrOlvGBzL8nywQbn8O1RlN-vrw" alt="">--></p>
+<p><img src="/docs/img/value4.png" alt="drill query flow"> </p>
<p>Repeated Map Vectors</p>
@@ -210,8 +201,7 @@ while the count indicates the maximum nu
following example illustrates a RepeatedMap with two records; one with two
objects, and one with a single object:</p>
-<p><img src="../../img/value5.png" alt="">
-<!--<img src="https://lh3.googleusercontent.com%0A/l8yo_z_MbBz9C3OoGQEy1bNOrmnNbo2e0XtCUDRbdRR4mbCYK8h-%0ALz7_VlhDtbTkPQziwwyNpw3ylfEKjMKtj-D0pUah4arohs1hcnHrzoFfE-QZRwUdQmEReMdpSgIT" alt="">--></p>
+<p><img src="/docs/img/value5.png" alt="drill query flow"></p>
<p>ValueVector representation of the equivalent JSON:</p>
@@ -229,13 +219,11 @@ or variable width ValueVector, the offse
table. The following illustrates a SelectionVector of INT4 (fixed width)
values 2, 3 and 5 from the original vector of [1 .. 6]:</p>
-<p><img src="../../img/value6.png" alt="">
-<!--<img src="https://lh5.googleusercontent.com/-hLlAaq9n-Q0_fZ_MKk3yFpXWZO7JOJLm-%0ANDh_a_x2Ir5BhZDrZX0t-6e_w3K7R4gfgQIsv-sPxryTUzrJRszNpA3pEEn5V5uRCAlMtHejTpcu-%0A_QFPfSTzzpdsf88OS" alt="">--></p>
+<p><img src="/docs/img/value6.png" alt="drill query flow"></p>
<p>The following illustrates the same ValueVector with nullable fields:</p>
-<p><img src="../../img/value7.png" alt="">
-<!--<img src="https://lh3.googleusercontent.com%0A/cJxo5H_nsWWlKFUFxjOHHC6YI4sPyG5Fjj1gbdAT2AEo-c6cdkZelso6rYeZV4leMWMfbei_-%0ArncjasvR9u4MUXgkpFpM22CUSnnkVX6ynpkcLW1Q-s5F2NgqCez1Fa_" alt="">--></p>
+<p><img src="/docs/img/value7.png" alt="drill query flow"></p>
</div>
Added: drill/site/trunk/content/drill/docs/what-is-apache-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/what-is-apache-drill/index.html?rev=1662344&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/what-is-apache-drill/index.html (added)
+++ drill/site/trunk/content/drill/docs/what-is-apache-drill/index.html Thu Feb 26 01:16:43 2015
@@ -0,0 +1,131 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>What is Apache Drill - 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>What is Apache Drill</h1>
+
+</div>
+
+<div class="int_text" align="left"><h2 id="what-is-apache-drill">What is Apache Drill</h2>
+
+<p>Apache Drill by Apache Foundation is the first open source implementation of
+the Google's Dremel paper for interactive query processing. Apache Drill
+provides low latency ad-hoc queries to many different data sources & nested
+data. Drill is designed to scale to 10,000 servers and query petabytes of data
+in seconds.</p>
+
+<p><img src="/docs/img/drill2.png" alt="drill query flow"></p>
+
+<p>In a nutshell, Few key points about Apache Drill are:</p>
+
+<ul>
+<li>Inspired by Google's Dremel</li>
+<li>Supports standard SQL 2003</li>
+<li>Supports plug-able data sources (HBase, Mongo, HDFS etc)</li>
+<li>Supports nested data (JSON, ProtoBufs, Parquet etc)</li>
+<li>Supports optional schema</li>
+<li>Community driven</li>
+</ul>
+
+<h2 id="where-apache-drill-fits-in">Where Apache Drill fits in</h2>
+
+<p>Apache Drill is designed as an answer to the Interactive queries problems that
+we face while dealing with huge data. A standard Drill Query might take 100ms
+- 3 minutes for its execution as compared to Apache Hadoop or HIVE/PIG. Below
+is a diagram to help you relate in terms of the execution times:</p>
+
+<p><img src="/docs/img/drill-runtime.png" alt="drill query flow"></p>
+
+<h2 id="drill-is-powerful">Drill is powerful</h2>
+
+<p>Below are few things that make Apache Drill really powerful:</p>
+
+<ul>
+<li><strong>Speed</strong>: Apache Drill uses an efficient columnar storage format, an optimistic execution engine and a cache-conscious memory layout. Coordination, query planning, optimization, scheduling, and execution are all distributed throughout nodes in a system to maximize parallelization. Apache Drill is blazing fast. Period.</li>
+<li><strong>Plug-able data sources</strong>: Apache drill brings in the support of pluggable data sources like HBase, Mongo, HDFS etc. It means that Drill will still work comfortably while your data is exploring new data stores.</li>
+<li><strong>Nested data</strong>: With the support for data sources like HBase, Cassandra, MongoDB etc, Drill allows interactive analysis on all of your data, including nested and schema-less forms. Drill also supports querying against nested data formats like JSON and Parquet.</li>
+<li><strong>Flexibility</strong>: Apache Dril strongly defined tiers and APIs for straightforward integration with a wide array of technologies.</li>
+</ul>
+</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/wikipedia-edit-history/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/wikipedia-edit-history/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/wikipedia-edit-history/index.html (original)
+++ drill/site/trunk/content/drill/docs/wikipedia-edit-history/index.html Thu Feb 26 01:16:43 2015
@@ -67,7 +67,7 @@
</div>
-<div class="int_text" align="left"><h1 id="quick-stats">Quick Stats</h1>
+<div class="int_text" align="left"><h2 id="quick-stats">Quick Stats</h2>
<p>The Wikipedia Edit History is a public dump of the website made available by
the wikipedia foundation. You can find details
@@ -75,7 +75,7 @@ the wikipedia foundation. You can find d
are made available as SQL or XML dumps. You can find the entire schema drawn
together in this great <a href="http://upload.wikimedia.org/wikipedia/commons%0A/thumb/4/42/MediaWiki_1.20_%2844edaa2%29_database_schema.svg/2193px-%0AMediaWiki_1.20_%2844edaa2%29_database_schema.svg.png">diagram</a>.</p>
-<h1 id="approach">Approach</h1>
+<h2 id="approach">Approach</h2>
<p>The <em>main</em> distribution files are:</p>
@@ -91,13 +91,13 @@ tool you generate a category specific XM
options. There are some limits like a maximum of 1000 revisions per export,
but otherwise this should work out just fine.</p>
-<p><img src="../../img/Overview.png" alt=""></p>
+<p><img src="/docs/img/Overview.png" alt="drill query flow"></p>
<p>The entities used in the query use cases.</p>
-<h1 id="use-cases">Use Cases</h1>
+<h2 id="use-cases">Use Cases</h2>
-<h2 id="select-change-volume-based-on-time">Select Change Volume Based on Time</h2>
+<h3 id="select-change-volume-based-on-time">Select Change Volume Based on Time</h3>
<p><strong>Query</strong></p>
<div class="highlight"><pre><code class="language-text" data-lang="text">select rev.::parent.title, rev.::parent.id, sum(rev.text.bytes)
@@ -128,7 +128,7 @@ explanatory.</p>
<li>I assume we would need some good indexing, but this should be achievable. We would need to translate the relative index <code>rev.timestamp</code> to an record absolute index <code>$.mediawiki.page.revision.timestamp</code> . Unclear to me now is whether the index would point to the record, or would it point to some kind of record substructure?</li>
</ul>
-<h2 id="select-change-volume-aggregated-on-time">Select Change Volume Aggregated on Time</h2>
+<h3 id="select-change-volume-aggregated-on-time">Select Change Volume Aggregated on Time</h3>
<p><strong>Query</strong></p>
<div class="highlight"><pre><code class="language-text" data-lang="text">select rev.::parent.title, rev.::parent.id, sum(rev.text.bytes), rev.timestamp.monthYear()
@@ -150,7 +150,7 @@ found page, now we are returning one res
<li>I would not provide implicit nodes into the records, i.e. if you want some attribute of a timestamp, call a function and not expect an automatically added element. So we want <code>rev.timestamp.monthYear()</code> and not <code>rev.timestamp.monthYear</code>. This may be quite confusing, especially if we have heterogenous record structures. We might even go ahead and support namespaces for custom, experimental features like <code>rev.timestamp.custom.maya:doomsDay()</code>.</li>
</ul>
-<h2 id="select-change-volume-based-on-contributor">Select Change Volume Based on Contributor</h2>
+<h3 id="select-change-volume-based-on-contributor">Select Change Volume Based on Contributor</h3>
<p><strong>Query</strong></p>
<div class="highlight"><pre><code class="language-text" data-lang="text">select ctrbr.username, ctbr.ip, ctbr.userid, sum(ctbr::parent.bytes) as bytesContributed
Modified: drill/site/trunk/content/drill/docs/workspaces/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/workspaces/index.html?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/docs/workspaces/index.html (original)
+++ drill/site/trunk/content/drill/docs/workspaces/index.html Thu Feb 26 01:16:43 2015
@@ -132,16 +132,6 @@ format to query a table in HBase:</p>
</code></pre></div>
<p>After you register a data source as a storage plugin instance with Drill, and
optionally configure workspaces, you can query the data source.</p>
-
-<p>Click any of the following links to learn how to register a data source as a
-storage plugin instance:</p>
-
-<ul>
-<li><a href="/confluence/display/DRILL/Registering+a+File+System">Registering a File System</a></li>
-<li><a href="/confluence/display/DRILL/Registering+HBase">Registering HBase</a></li>
-<li><a href="/confluence/display/DRILL/Registering+Hive">Registering Hive</a></li>
-<li><a href="/confluence/display/DRILL/Drill+Default+Input+Format">Drill Default Input Format</a></li>
-</ul>
</div>
Modified: drill/site/trunk/content/drill/feed.xml
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/feed.xml?rev=1662344&r1=1662343&r2=1662344&view=diff
==============================================================================
--- drill/site/trunk/content/drill/feed.xml (original)
+++ drill/site/trunk/content/drill/feed.xml Thu Feb 26 01:16:43 2015
@@ -6,9 +6,9 @@
</description>
<link>/</link>
<atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
- <pubDate>Tue, 27 Jan 2015 15:28:02 -0800</pubDate>
- <lastBuildDate>Tue, 27 Jan 2015 15:28:02 -0800</lastBuildDate>
- <generator>Jekyll v2.5.1</generator>
+ <pubDate>Wed, 25 Feb 2015 17:09:27 -0800</pubDate>
+ <lastBuildDate>Wed, 25 Feb 2015 17:09:27 -0800</lastBuildDate>
+ <generator>Jekyll v2.5.2</generator>
<item>
<title>Schema-free JSON Data Infrastructure</title>
@@ -242,9 +242,8 @@ Tomer Shiran</p>
<item>
<title>Apache Drill Q&A Panelist Spotlight</title>
- <description><script type="text/javascript" src="https://addthisevent.com/libs/1.5.8/ate.min.js"></script>
-
-<p><a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar" class="addthisevent">
+ <description><p><script type="text/javascript" src="https://addthisevent.com/libs/1.5.8/ate.min.js"></script>
+<a href="/blog/2014/12/11/apache-drill-qa-panelist-spotlight/" title="Add to Calendar" class="addthisevent">
Add to Calendar
<span class="_start">12-17-2014 11:30:00</span>
<span class="_end">12-17-2014 12:30:00</span>