drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject svn commit: r1651949 [4/13] - in /drill/site/trunk/content/drill: ./ blog/2014/11/19/sql-on-mongodb/ blog/2014/12/02/drill-top-level-project/ blog/2014/12/09/running-sql-queries-on-amazon-s3/ blog/2014/12/11/apache-drill-qa-panelist-spotlight/ blog/201...
Date Thu, 15 Jan 2015 05:11:48 GMT
Added: drill/site/trunk/content/drill/docs/create-table-as-ctas-command/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/create-table-as-ctas-command/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/create-table-as-ctas-command/index.html (added)
+++ drill/site/trunk/content/drill/docs/create-table-as-ctas-command/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,212 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>CREATE TABLE AS (CTAS) command - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>CREATE TABLE AS (CTAS) command</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>You can create tables in Drill by using the CTAS command:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">CREATE TABLE new_table_name AS &lt;query&gt;;
+</code></pre></div>
+<p>where query is any valid Drill query. Each table you create must have a unique
+name. You can include an optional column list for the new table. For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">create table logtable(transid, prodid) as select transaction_id, product_id from ...
+</code></pre></div>
+<p>You can store table data in one of three formats:</p>
+
+<ul>
+<li>csv</li>
+<li>parquet</li>
+<li>json</li>
+</ul>
+
+<p>The parquet and json formats can be used to store complex data.</p>
+
+<p>To set the output format for a Drill table, set the <code>store.format</code> option with
+the ALTER SYSTEM or ALTER SESSION command. For example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">alter session set `store.format`=&#39;json&#39;;
+</code></pre></div>
+<p>Table data is stored in the location specified by the workspace that is in use
+when you run the CTAS statement. By default, a directory is created, using the
+exact table name specified in the CTAS statement. A .json, .csv, or .parquet
+file inside that directory contains the data.</p>
+
+<p>You can only create new tables in workspaces. You cannot create tables in
+other storage plugins such as Hive and HBase.</p>
+
+<p>You must use a writable (mutable) workspace when creating Drill tables. For
+example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">&quot;tmp&quot;: {
+      &quot;location&quot;: &quot;/tmp&quot;,
+      &quot;writable&quot;: true,
+       }
+</code></pre></div>
+<h2 id="example">Example</h2>
+
+<p>The following query returns one row from a JSON file:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select id, type, name, ppu
+from dfs.`/Users/brumsby/drill/donuts.json`;
++------------+------------+------------+------------+
+|     id     |    type    |    name    |    ppu     |
++------------+------------+------------+------------+
+| 0001       | donut      | Cake       | 0.55       |
++------------+------------+------------+------------+
+1 row selected (0.248 seconds)
+</code></pre></div>
+<p>To create and verify the contents of a table that contains this row:</p>
+
+<ol>
+<li>Set the workspace to a writable workspace.</li>
+<li>Set the <code>store.format</code> option appropriately.</li>
+<li>Run a CTAS statement that contains the query.</li>
+<li>Go to the directory where the table is stored and check the contents of the file.</li>
+<li>Run a query against the new table.</li>
+</ol>
+
+<p>The following sqlline output captures this sequence of steps.</p>
+
+<h3 id="workspace-definition">Workspace Definition</h3>
+<div class="highlight"><pre><code class="language-text" data-lang="text">&quot;tmp&quot;: {
+      &quot;location&quot;: &quot;/tmp&quot;,
+      &quot;writable&quot;: true,
+       }
+</code></pre></div>
+<h3 id="alter-session-command">ALTER SESSION Command</h3>
+<div class="highlight"><pre><code class="language-text" data-lang="text">alter session set `store.format`=&#39;json&#39;;
+</code></pre></div>
+<h3 id="use-command">USE Command</h3>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; use dfs.tmp;
++------------+------------+
+|     ok     |  summary   |
++------------+------------+
+| true       | Default schema changed to &#39;dfs.tmp&#39; |
++------------+------------+
+1 row selected (0.03 seconds)
+</code></pre></div>
+<h3 id="ctas-command">CTAS Command</h3>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; create table donuts_json as
+select id, type, name, ppu from dfs.`/Users/brumsby/drill/donuts.json`;
++------------+---------------------------+
+|  Fragment  | Number of records written |
++------------+---------------------------+
+| 0_0        | 1                         |
++------------+---------------------------+
+1 row selected (0.107 seconds)
+</code></pre></div>
+<h3 id="file-contents">File Contents</h3>
+<div class="highlight"><pre><code class="language-text" data-lang="text">administorsmbp7:tmp brumsby$ pwd
+/tmp
+administorsmbp7:tmp brumsby$ cd donuts_json
+administorsmbp7:donuts_json brumsby$ more 0_0_0.json
+{
+ &quot;id&quot; : &quot;0001&quot;,
+  &quot;type&quot; : &quot;donut&quot;,
+  &quot;name&quot; : &quot;Cake&quot;,
+  &quot;ppu&quot; : 0.55
+}
+</code></pre></div>
+<h3 id="query-against-new-table">Query Against New Table</h3>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select * from donuts_json;
++------------+------------+------------+------------+
+|     id     |    type    |    name    |    ppu     |
++------------+------------+------------+------------+
+| 0001       | donut      | Cake       | 0.55       |
++------------+------------+------------+------------+
+1 row selected (0.053 seconds)
+</code></pre></div>
+<h3 id="use-a-different-output-format">Use a Different Output Format</h3>
+
+<p>You can run the same sequence again with a different storage format set for
+the system or session (csv or parquet). For example, if the format is set to
+csv, and you name the table donuts_csv, the resulting file would look like
+this:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">administorsmbp7:tmp brumsby$ cd donuts_csv
+administorsmbp7:donuts_csv brumsby$ ls
+0_0_0.csv
+administorsmbp7:donuts_csv brumsby$ more 0_0_0.csv
+id,type,name,ppu
+0001,donut,Cake,0.55
+</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>

Added: drill/site/trunk/content/drill/docs/custom-function-interfaces/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/custom-function-interfaces/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/custom-function-interfaces/index.html (added)
+++ drill/site/trunk/content/drill/docs/custom-function-interfaces/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,103 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Custom Function Interfaces - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Custom Function Interfaces</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Implement the Drill interface appropriate for the type of function that you
+want to develop. Each interface provides a set of required holders where you
+input data types that your function uses and required methods that Drill calls
+to perform your function’s operations.</p>
+
+<p>Click on either of the links for more information about custom function
+interfaces for Drill:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Simple+Function+Interface">Simple Function Interface</a></li>
+<li><a href="/confluence/display/DRILL/Aggregate+Function+Interface">Aggregate Function Interface</a></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>

Added: drill/site/trunk/content/drill/docs/data-types/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/data-types/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/data-types/index.html (added)
+++ drill/site/trunk/content/drill/docs/data-types/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,193 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Data Types - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Data Types</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>You can use the following SQL data types in your Drill queries:</p>
+
+<h4 id="binary-types">Binary Types</h4>
+
+<ul>
+<li>BYTEA</li>
+<li>VARBINARY</li>
+</ul>
+
+<h4 id="character-types">Character Types</h4>
+
+<ul>
+<li>CHAR</li>
+<li>VARCHAR </li>
+<li>TEXT</li>
+</ul>
+
+<h4 id="date/time-data-types">Date/Time Data Types</h4>
+
+<ul>
+<li>DATE</li>
+<li><p>INTERVAL</p>
+
+<ul>
+<li>Interval Year (stores year and month)</li>
+<li>Interval Day (stores day, hour, minute, seconds, and milliseconds)</li>
+</ul></li>
+<li><p>TIME</p></li>
+<li><p>TIMESTAMP</p></li>
+</ul>
+
+<p>Refer to <a href="https://cwiki.apache.org/conf%0Aluence/pages/viewpage.action?pageId=44304039">Supported Date/Time Data Type formats</a>.</p>
+
+<h4 id="integer">Integer</h4>
+
+<ul>
+<li><p>BIGINT</p></li>
+<li><p>INT</p></li>
+<li><p>SMALLINT</p></li>
+<li><p>TINYINT</p></li>
+</ul>
+
+<h4 id="numeric-types">Numeric Types</h4>
+
+<ul>
+<li>DECIMAL</li>
+<li>FLOAT </li>
+<li>DOUBLE PRECISION (FLOAT 8)</li>
+<li>REAL (FLOAT 4) </li>
+</ul>
+
+<h4 id="boolean-types">Boolean Types</h4>
+
+<ul>
+<li>FALSE</li>
+<li>NULL</li>
+<li>TRUE</li>
+</ul>
+
+<h1 id="complex-data-types">Complex Data Types</h1>
+
+<p>Drill provides map and array data types to work with complex and nested data
+structures. For analysis of complex data, a more modern JSON-style approach to
+writing queries is more effective than using standard SQL functions.</p>
+
+<p>The following table provides descriptions and examples of the complex data
+types:</p>
+
+<table><tbody>
+  <tr><th>Data Type</th>
+  <th>Description</th>
+  <th>Example</th></tr>
+    <tr>
+      <td valign="top">Map</td>
+      <td valign="top">A map is a set of name/value pairs. </br>
+      A value in an map can be a scalar type, </br>
+      such as string or int, or a map can be a </br>
+      complex type, such as an array or another map.</td>
+      <td valign="top">Map with scalar type values:</br><code>&nbsp;&nbsp;&quot;phoneNumber&quot;: { &quot;areaCode&quot;: &quot;622&quot;, &quot;number&quot;: &quot;1567845&quot;}</code></br>Map with complex type value:<code></br>&nbsp;&nbsp;{ &quot;citiesLived&quot; : [ { &quot;place&quot; : &quot;Los Angeles&quot;,</br>        
+      &nbsp;&nbsp;&nbsp;&nbsp;&quot;yearsLived&quot; : [ &quot;1989&quot;,</br>
+      &nbsp;&nbsp;&nbsp;&nbsp;            &quot;1993&quot;,</br>            
+      &nbsp;&nbsp;&nbsp;&nbsp;&quot;1998&quot;,</br>            
+      &nbsp;&nbsp;&nbsp;&nbsp;&quot;2002&quot;</br>
+      &nbsp;&nbsp;&nbsp;&nbsp;          ]</br>      
+      &nbsp;&nbsp;
+      &nbsp;} ] }</code></td>
+    </tr>
+    <tr>
+      <td valign="top">Array</td>
+      <td valign="top">An array is a repeated list of values. </br>
+      A value in an array can be a scalar type, </br>
+      such as string or int, or an array can be a</br> 
+      complex type, such as a map or another array.</td>
+      <td valign="top">Array with scalar values:</br><code>&nbsp;&nbsp;&quot;yearsLived&quot;: [&quot;1990&quot;, &quot;1993&quot;, &quot;1998&quot;, &quot;2008&quot;]</code></br>Array with complex type values:</br><code>&nbsp;&nbsp;&quot;children&quot;:</br>&nbsp;&nbsp;[ { &quot;age&quot; : &quot;10&quot;, </br>   &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;gender&quot; : &quot;Male&quot;,</br>    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;name&quot; : &quot;Earl&quot;</br> &nbsp;&nbsp;&nbsp;&nbsp; }, </br> &nbsp;&nbsp;&nbsp;&nbsp;{ &quot;age&quot; : &quot;6&quot;,</br>    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;gender&quot; : &quot;Male&quot;,</br>    &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&quot;name&quot; : &quot;Sam&quot;</br>  &nbsp;&nbsp;&nbsp;&nbsp;},</br>  &nbsp;&nbsp;&nbsp;&nbsp;{ &quot;age&quot; : &quot;8&quot;,</br>    &nbsp;&nbsp;&nbsp;&nbsp;&quot;gender&quot; : &quot;Male&quot;,  </br>  &nbsp;&nbsp;&nbsp;&nbsp;&quot;name&quot; : &quot;Kit&quot; </br> &nbsp;&nbsp;&nbsp;&nbsp
 ;}</br>&nbsp;&nbsp;]</code></td>
+    </tr>
+  </tbody></table>
+
+<!--| Data Type | Description | Example |  
+| --------- | ----------- | --------| 
+| Map       | A map is a set of name/value pairs. A value in an map can be a scalar type, such as string or int, or a map can be a complex type, such as an array or another map.| Map with scalar type values: "phoneNumber": { "areaCode": "622", "number": "1567845"} Map with complex type value :{ "citiesLived" : [ { "place" : "Los Angeles", "yearsLived" : [ "1989", "1993", "1998", "2002"] } ] } |
+|Array| An array is a repeated list of values. A value in an array can be a scalar type, such as string or int, or an array can be a complex type, such as a map or another array.| Array with scalar type values: "yearsLived": ["1990"", "1993", "1998", "2008"] Array with complex type value :"children" : [ { "age" : "10", "gender" : "Male", "name": "Earl" }, {"age" : "6", "gender": "Male", "name": "Sam"}, { "age" : "8", "gender" : "Male", "name" : "Kit" }] |
+-->
+</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/deploying-apache-drill-in-a-clustered-environment/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/index.html (added)
+++ drill/site/trunk/content/drill/docs/deploying-apache-drill-in-a-clustered-environment/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,186 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Deploying Apache Drill in a Clustered Environment - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Deploying Apache Drill in a Clustered Environment</h1>
+
+</div>
+
+<div class="int_text" align="left"><h1 id="overview">Overview</h1>
+
+<p>To run Drill in a clustered environment, complete the following steps:</p>
+
+<ol>
+<li>Install Drill on each designated node in the cluster.</li>
+<li>Configure a cluster ID and add Zookeeper information.</li>
+<li>Connect Drill to your data sources. </li>
+<li>Start Drill.</li>
+</ol>
+
+<h3 id="prerequisites">Prerequisites</h3>
+
+<p>Before you install Apache Drill on nodes in your cluster, you must have the
+following software and services installed:</p>
+
+<ul>
+<li><a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html">Oracle JDK version 7</a></li>
+<li>Configured and running ZooKeeper quorum</li>
+<li>Configured and running Hadoop cluster (Recommended)</li>
+<li>DNS (Recommended)</li>
+</ul>
+
+<p>Installing Drill</p>
+
+<p>Complete the following steps to install Drill on designated nodes:</p>
+
+<ol>
+<li><p>Download the Drill tarball.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">curl http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0/apache-drill-0.7.0.tar.gz
+</code></pre></div></li>
+<li><p>Issue the following command to create a Drill installation directory and then explode the tarball to the directory:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">mkdir /opt/drill
+tar xzf apache-drill-&lt;version&gt;.tar.gz --strip=1 -C /opt/drill
+</code></pre></div></li>
+<li><p>If you are using external JAR files, edit <code>drill-env.sh,</code>located in <code>/opt/drill/conf/</code>, and define <code>HADOOP_HOME:</code></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">export HADOOP_HOME=&quot;~/hadoop/hadoop-0.20.2/&quot;
+</code></pre></div></li>
+<li><p>In <code>drill-override.conf,</code>create a unique Drill <code>cluster ID</code>, and provide Zookeeper host names and port numbers to configure a connection to your Zookeeper quorum.</p>
+
+<p>a. Edit <code>drill-override.conf</code>located in <code>~/drill/drill-&lt;version&gt;/conf/</code>.</p>
+
+<p>b. Provide a unique <code>cluster-id</code> and the Zookeeper host names and port numbers in <code>zk.connect</code>. If you install Drill on multiple nodes, assign the same <code>cluster ID</code> to each Drill node so that all Drill nodes share the same ID. The default Zookeeper port is 2181.</p></li>
+</ol>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">drill.exec: {
+  cluster-id: &quot;&lt;mydrillcluster&gt;&quot;,
+  zk.connect: &quot;&lt;zkhostname1&gt;:&lt;port&gt;,&lt;zkhostname2&gt;:&lt;port&gt;,&lt;zkhostname3&gt;:&lt;port&gt;&quot;,
+  debug.error_on_leak: false,
+  buffer.size: 6,
+  functions: [&quot;org.apache.drill.expr.fn.impl&quot;, &quot;org.apache.drill.udfs&quot;]
+}
+</code></pre></div>
+<p>Connecting Drill to Data Sources</p>
+
+<p>You can connect Drill to various types of data sources. Refer to <a href="https://cwiki.apache.org/confluence/display/DRIL%0AL/Connecting+to+Data+Sources">Connect
+Apache Drill to Data Sources</a> to get configuration instructions for the
+particular type of data source that you want to connect to Drill.</p>
+
+<h2 id="starting-drill">Starting Drill</h2>
+
+<p>Complete the following steps to start Drill:</p>
+
+<ol>
+<li><p>Navigate to the Drill installation directory, and issue the following command to start a Drillbit:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">bin/drillbit.sh restart
+</code></pre></div></li>
+<li><p>Issue the following command to invoke SQLLine and start Drill:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline -u jdbc:drill:
+</code></pre></div>
+<p>When connected, the Drill prompt appears.<br>
+ Example:</p>
+
+<p><code>0: jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt;&gt;</code></p>
+
+<p>If you cannot connect to Drill, invoke SQLLine with the ZooKeeper quorum:</p>
+
+<p><code>bin/sqlline -u jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt;,&lt;zk2host&gt;:&lt;port&gt;,&lt;zk3host&gt;:&lt;port&gt;</code> </p></li>
+<li><p>Issue the following query to Drill to verify that all Drillbits have joined the cluster:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=&lt;zk1host&gt;:&lt;port&gt;&gt; select * from sys.drillbits;
+</code></pre></div></li>
+</ol>
+
+<p>Drill provides a list of Drillbits that have joined.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+--------------+--------------------+
+|    host        | user_port    | control_port | data_port    |
++------------+------------+--------------+--------------------+
+| &lt;host address&gt; | &lt;port number&gt;| &lt;port number&gt;| &lt;port number&gt;|
++------------+------------+--------------+--------------------+
+</code></pre></div>
+<p><strong>Example</strong></p>
+
+<p>Now you can query data with Drill. The Drill installation includes sample data
+that you can query. Refer to <a href="https://cwiki.apache.org/conf%0Aluence/display/DRILL/Apache+Drill+in+10+Minutes#ApacheDrillin10Minutes-%0AQuerySampleData">Query Sample Data</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>

Added: drill/site/trunk/content/drill/docs/design-docs/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/design-docs/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/design-docs/index.html (added)
+++ drill/site/trunk/content/drill/docs/design-docs/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,102 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Design Docs - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Design Docs</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Review the Apache Drill design docs for early descriptions of Apache Drill
+functionality, terms, and goals, and reference the research articles to learn
+about Apache Drill&#39;s history:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Drill+Plan+Syntax">Drill Plan Syntax</a></li>
+<li><a href="/confluence/display/DRILL/RPC+Overview">RPC Overview</a></li>
+<li><a href="/confluence/display/DRILL/Query+Stages">Query Stages</a></li>
+<li><a href="/confluence/display/DRILL/Useful+Research">Useful Research</a></li>
+<li><a href="/confluence/display/DRILL/Value+Vectors">Value Vectors</a></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>

Added: drill/site/trunk/content/drill/docs/develop-a-simple-function/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/develop-a-simple-function/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/develop-a-simple-function/index.html (added)
+++ drill/site/trunk/content/drill/docs/develop-a-simple-function/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,135 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Develop a Simple Function - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Develop a Simple Function</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Create a class within a Java package that implements Drill’s simple interface
+into the program, and include the required information for the function type.
+Your function must include data types that Drill supports, such as int or
+BigInt. For a list of supported data types, refer to the Apache Drill SQL
+Reference.</p>
+
+<p>Complete the following steps to develop a simple function using Drill’s simple
+function interface:</p>
+
+<ol>
+<li><p>Create a Maven project and add the following dependency:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">&lt;dependency&gt;
+&lt;groupId&gt;org.apache.drill.exec&lt;/groupId&gt;
+&lt;artifactId&gt;drill-java-exec&lt;/artifactId&gt;
+&lt;version&gt;1.0.0-m2-incubating-SNAPSHOT&lt;/version&gt;
+&lt;/dependency&gt;
+</code></pre></div></li>
+<li><p>Create a class that implements the <code>DrillSimpleFunc</code> interface and identify the scope as <code>FunctionScope.SIMPLE</code>.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">@FunctionTemplate(name = &quot;myaddints&quot;, scope = FunctionScope.SIMPLE, nulls = NullHandling.NULL_IF_NULL)
+  public static class IntIntAdd implements DrillSimpleFunc {
+</code></pre></div></li>
+<li><p>Provide the variables used in the code in the <code>Param</code> and <code>Output</code> bit holders.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">@Param IntHolder in1;
+@Param IntHolder in2;
+@Output IntHolder out;
+</code></pre></div></li>
+<li><p>Add the code that performs operations for the function in the <code>eval()</code> method.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">public void setup(RecordBatch b) {
+}
+public void eval() {
+ out.value = (int) (in1.value + in2.value);
+}
+</code></pre></div></li>
+<li><p>Use the maven-source-plugin to compile the sources and classes JAR files. Verify that an empty <code>drill-module.conf</code> is included in the resources folder of the JARs.<br>
+Drill searches this module during classpath scanning. If the file is not
+included in the resources folder, you can add it to the JAR file or add it to
+<code>etc/drill/conf</code>.</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>

Added: drill/site/trunk/content/drill/docs/develop-custom-functions/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/develop-custom-functions/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/develop-custom-functions/index.html (added)
+++ drill/site/trunk/content/drill/docs/develop-custom-functions/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,137 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Develop Custom Functions - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Develop Custom Functions</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Drill provides a high performance Java API with interfaces that you can
+implement to develop simple and aggregate custom functions. Custom functions
+are reusable SQL functions that you develop in Java to encapsulate code that
+processes column values during a query. Custom functions can perform
+calculations and transformations that built-in SQL operators and functions do
+not provide. Custom functions are called from within a SQL statement, like a
+regular function, and return a single value.</p>
+
+<h3 id="simple-function">Simple Function</h3>
+
+<p>A simple function operates on a single row and produces a single row as the
+output. When you include a simple function in a query, the function is called
+once for each row in the result set. Mathematical and string functions are
+examples of simple functions.</p>
+
+<h3 id="aggregate-function">Aggregate Function</h3>
+
+<p>Aggregate functions differ from simple functions in the number of rows that
+they accept as input. An aggregate function operates on multiple input rows
+and produces a single row as output. The COUNT(), MAX(), SUM(), and AVG()
+functions are examples of aggregate functions. You can use an aggregate
+function in a query with a GROUP BY clause to produce a result set with a
+separate aggregate value for each combination of values from the GROUP BY
+clause.</p>
+
+<h3 id="process">Process</h3>
+
+<p>To develop custom functions that you can use in your Drill queries, you must
+complete the following tasks:</p>
+
+<ol>
+<li>Create a Java program that implements Drill’s simple or aggregate interface, and compile a sources and a classes JAR file.</li>
+<li>Add the sources and classes JAR files to Drill’s classpath.</li>
+<li>Add the name of the package that contains the classes to Drill’s main configuration file, drill-override.conf. </li>
+</ol>
+
+<p>Click on one of the following links to learn how to create custom functions
+for Drill:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Developing+a+Simple+Function">Developing a Simple Function</a></li>
+<li><a href="/confluence/display/DRILL/Developing+an+Aggregate+Function">Developing an Aggregate Function</a></li>
+<li><a href="/confluence/display/DRILL/Adding+Custom+Functions+to+Drill">Adding Custom Functions to Drill</a></li>
+<li><a href="/confluence/display/DRILL/Using+Custom+Functions+in+Queries">Using Custom Functions in Queries</a></li>
+<li><a href="/confluence/display/DRILL/Custom+Function+Interfaces">Custom Function Interfaces</a></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>

Added: drill/site/trunk/content/drill/docs/develop-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/develop-drill/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/develop-drill/index.html (added)
+++ drill/site/trunk/content/drill/docs/develop-drill/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,104 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Develop 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Develop Drill</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>To develop Drill, you compile Drill from source code and then set up a project
+in Eclipse for use as your development environment. To review or contribute to
+Drill code, you must complete the steps required to install and use the Drill
+patch review tool.</p>
+
+<p>For information about contributing to the Apache Drill project, you can refer
+to the following pages:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Compiling+Drill+from+Source">Compiling Drill from Source</a></li>
+<li><a href="/confluence/display/DRILL/Setting+Up+Your+Development+Environment">Setting Up Your Development Environment</a></li>
+<li><a href="/confluence/display/DRILL/Drill+Patch+Review+Tool">Drill Patch Review Tool</a></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>

Added: drill/site/trunk/content/drill/docs/developing-an-aggregate-function/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/developing-an-aggregate-function/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/developing-an-aggregate-function/index.html (added)
+++ drill/site/trunk/content/drill/docs/developing-an-aggregate-function/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,144 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Developing an Aggregate Function - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Developing an Aggregate Function</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Create a class within a Java package that implements Drill’s aggregate
+interface into the program. Include the required information for the function.
+Your function must include data types that Drill supports, such as int or
+BigInt. For a list of supported data types, refer to the Drill SQL Reference.</p>
+
+<p>Complete the following steps to create an aggregate function:</p>
+
+<ol>
+<li><p>Create a Maven project and add the following dependency:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">&lt;dependency&gt;
+&lt;groupId&gt;org.apache.drill.exec&lt;/groupId&gt;
+&lt;artifactId&gt;drill-java-exec&lt;/artifactId&gt;
+&lt;version&gt;1.0.0-m2-incubating-SNAPSHOT&lt;/version&gt;
+&lt;/dependency&gt;
+</code></pre></div></li>
+<li><p>Create a class that implements the <code>DrillAggFunc</code> interface and identify the scope as <code>FunctionTemplate.FunctionScope.POINT_AGGREGATE</code>.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">@FunctionTemplate(name = &quot;count&quot;, scope = FunctionTemplate.FunctionScope.POINT_AGGREGATE)
+public static class BitCount implements DrillAggFunc{
+</code></pre></div></li>
+<li><p>Provide the variables used in the code in the <code>Param, Workspace,</code>and <code>Output</code> bit holders.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">@Param BitHolder in;
+@Workspace BitHolder value;
+@Output BitHolder out;
+</code></pre></div></li>
+<li><p>Include the <code>setup(), add(), output(),</code> and <code>reset()</code> methods.</p>
+
+<p><strong>Example</strong>
+    public void setup(RecordBatch b) {
+      value = new BitHolder(); 
+        value.value = 0;
+    }</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">@Override
+public void add() {
+      value.value++;
+}
+@Override
+public void output() {
+  out.value = value.value;
+}
+@Override
+public void reset() {
+
+    value.value = 0;
+</code></pre></div></li>
+<li><p>Use the maven-source-plugin to compile the sources and classes JAR files. Verify that an empty <code>drill-module.conf</code> is included in the resources folder of the JARs.<br>
+Drill searches this module during classpath scanning. If the file is not
+included in the resources folder, you can add it to the JAR file or add it to
+<code>etc/drill/conf</code>.</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>

Added: drill/site/trunk/content/drill/docs/drill-default-input-format/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/drill-default-input-format/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/drill-default-input-format/index.html (added)
+++ drill/site/trunk/content/drill/docs/drill-default-input-format/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,152 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Drill Default Input Format - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Drill Default Input Format</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>You can define a default input format to tell Drill what file type exists in a
+workspace within a file system. Drill determines the file type based on file
+extensions and magic numbers when searching a workspace.</p>
+
+<p>Magic numbers are file signatures that Drill uses to identify Parquet files.
+If Drill cannot identify the file type based on file extensions or magic
+numbers, the query fails. Defining a default input format can prevent queries
+from failing in situations where Drill cannot determine the file type.</p>
+
+<p>If you incorrectly define the file type in a workspace and Drill cannot
+determine the file type, the query fails. For example, if the directory for
+which you have defined a workspace contains JSON files and you defined the
+default input format as CSV, the query fails against the workspace.</p>
+
+<p>You can define one default input format per workspace. If you do not define a
+default input format, and Drill cannot detect the file format, the query
+fails. You can define a default input format for any of the file types that
+Drill supports. Currently, Drill supports the following types:</p>
+
+<ul>
+<li>CSV</li>
+<li>TSV</li>
+<li>PSV</li>
+<li>Parquet</li>
+<li>JSON</li>
+</ul>
+
+<h2 id="defining-a-default-input-format">Defining a Default Input Format</h2>
+
+<p>You define the default input format for a file system workspace through the
+Drill Web UI. You must have a defined workspace before you can define a
+default input format. For information about how to define a workspace, refer
+to <a href="https://cwiki.apache.org/confluence/display/DRILL/Workspaces">Workspaces</a>.</p>
+
+<p>To define a default input format for a workspace, complete the following
+steps:</p>
+
+<ol>
+<li>Navigate to the Drill Web UI at <code>&lt;drill_node_ip_address&gt;:8047</code>. The Drillbit process must be running on the node before you connect to the Drill Web UI.</li>
+<li>Select <strong>Storage</strong> in the toolbar.</li>
+<li>Click <strong>Update</strong> next to the file system for which you want to define a default input format for a workspace.</li>
+<li><p>In the Configuration area, locate the workspace for which you would like to define the default input format, and change the <code>defaultInputFormat</code> attribute to any of the supported file types.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">{
+  &quot;type&quot;: &quot;file&quot;,
+  &quot;enabled&quot;: true,
+  &quot;connection&quot;: &quot;hdfs:///&quot;,
+  &quot;workspaces&quot;: {
+    &quot;root&quot;: {
+      &quot;location&quot;: &quot;/drill/testdata&quot;,
+      &quot;writable&quot;: false,
+      &quot;defaultInputFormat&quot;: csv
+  },
+  &quot;local&quot; : {
+    &quot;location&quot; : &quot;/max/proddata&quot;,
+    &quot;writable&quot; : true,
+    &quot;defaultInputFormat&quot; : &quot;json&quot;
+}
+</code></pre></div></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/drill-interfaces/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/drill-interfaces/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/drill-interfaces/index.html (added)
+++ drill/site/trunk/content/drill/docs/drill-interfaces/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,107 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Drill Interfaces - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Drill Interfaces</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>You can connect to Apache Drill through the following interfaces:</p>
+
+<ul>
+<li>Drill shell (SQLLine)</li>
+<li>Drill Web UI</li>
+<li>ODBC*</li>
+<li><a href="/confluence/display/DRILL/Using+JDBC+to+Access+Apache+Drill+from+SQuirreL">JDBC</a></li>
+<li>C++ API</li>
+</ul>
+
+<p>*Apache Drill does not have an open source ODBC driver. However, MapR provides an ODBC driver that you can use to connect to Apache Drill from BI tools. For more information, refer to the following documents:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Using+JDBC+to+Access+Apache+Drill+from+SQuirreL">Using JDBC to Access Apache Drill from SQuirreL</a></li>
+<li><a href="/confluence/display/DRILL/Using+ODBC+to+Access+Apache+Drill+from+BI+Tools">Using ODBC to Access Apache Drill from BI Tools</a></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>

Added: drill/site/trunk/content/drill/docs/drill-plan-syntax/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/drill-plan-syntax/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/drill-plan-syntax/index.html (added)
+++ drill/site/trunk/content/drill/docs/drill-plan-syntax/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,111 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Drill Plan Syntax - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Drill Plan Syntax</h1>
+
+</div>
+
+<div class="int_text" align="left"><h3 id="whats-the-plan?">Whats the plan?</h3>
+
+<p>This section is about the end-to-end plan flow for Drill. The incoming query
+to Drill can be a SQL 2003 query/DrQL or MongoQL. The query is converted to a
+<em>Logical Plan</em> that is a Drill&#39;s internal representation of the query
+(language-agnostic). Drill then uses its optimization rules over the Logical
+Plan to optimize it for best performance and crafts out a <em>Physical Plan</em>. The
+Physical Plan is the actual plan the Drill then executes for the final data
+processing. Below is a diagram to illustrate the flow:</p>
+
+<p><img src="../../img/slide-15-638.png" alt=""></p>
+
+<p><strong>The Logical Plan</strong> describes the abstract data flow of a language independent query i.e. it would be a representation of the input query which would not be dependent on the actual input query language. It generally tries to work with primitive operations without focus on optimization. This makes it more verbose than traditional query languages. This is to allow a substantial level of flexibility in defining higher-level query language features. It would be forwarded to the optimizer to get a physical plan.</p>
+
+<p><strong>The Physical Plan</strong> is often called the execution plan, since it is the input to the execution engine. Its a description of the physical operations the execution engine will undertake to get the desired result. It is the output of the query planner and is a transformation of the logical plan after applying the optimization rules.</p>
+
+<p>Typically, the physical and execution plans will be represented using the same
+JSON format as the logical plan.</p>
+
+<p><strong>Detailed document</strong>: Here is a document that explains the Drill logical &amp; physical plans in full detail. <a href="https://docs.google.com/document/d/1QTL8warUYS2KjldQrGUse7zp8eA72VKtLOHwfXy6c7I/edit">Drill detailed plan syntax document</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>

Added: drill/site/trunk/content/drill/docs/enron-emails/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/enron-emails/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/enron-emails/index.html (added)
+++ drill/site/trunk/content/drill/docs/enron-emails/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,110 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Enron Emails - 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&nbsp;&nbsp;&nbsp;&nbsp;</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? &nbsp;&nbsp;&nbsp;&nbsp;</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>&nbsp;</span></li>
+  <li class="d"><a href="/download/">Download</a></li>
+</ul>
+</div>
+
+<div class="int_title">
+<h1>Enron Emails</h1>
+
+</div>
+
+<div class="int_text" align="left"><h2 id="quick-stats">Quick Stats</h2>
+
+<p>The <a href="http://www.cs.cmu.edu/%7Eenron/">Enron Email dataset</a> contains data from
+about 150 users, mostly senior management of Enron.</p>
+
+<h2 id="the-data-source">The Data Source</h2>
+
+<p>Totalling some 500,000 messages, the <a href="http://www.cs.cmu.edu/%7Eenron/enron_mail_20110402.tgz">raw
+data</a> (2009 version of
+the dataset; ~423MB) is available for download as well as a <a href="ftp://ftp.isi.edu/sims/philpot/data/enron-mysqldump.sql.gz">MySQL
+dump</a> (~177MB).</p>
+
+<h2 id="the-queries">The Queries</h2>
+
+<p>Interesting queries, for example</p>
+
+<ul>
+<li>Via <a href="https://dbappserv.cis.upenn.edu/spell/">Query Dataset for Email Search</a></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>



Mime
View raw message