drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject svn commit: r1651949 [3/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/apache-drill-in-10-minutes/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html (added)
+++ drill/site/trunk/content/drill/docs/apache-drill-in-10-minutes/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,478 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Apache Drill in 10 Minutes - 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>Apache Drill in 10 Minutes</h1>
+
+</div>
+
+<div class="int_text" align="left"><ul>
+<li>Objective</li>
+<li>A Few Bits About Apache Drill</li>
+<li>Process Overview</li>
+<li>Install Drill
+
+<ul>
+<li>Installing Drill on Linux</li>
+<li>Installing Drill on Mac OS X</li>
+<li>Installing Drill on Windows </li>
+</ul></li>
+<li>Start Drill </li>
+<li>Query Sample Data </li>
+<li>Summary </li>
+<li>Next Steps</li>
+<li>More Information</li>
+</ul>
+
+<h1 id="objective">Objective</h1>
+
+<p>Use Apache Drill to query sample data in 10 minutes. For simplicity, you’ll
+run Drill in <em>embedded</em> mode rather than <em>distributed</em> mode to try out Drill
+without having to perform any setup tasks.</p>
+
+<h1 id="a-few-bits-about-apache-drill">A Few Bits About Apache Drill</h1>
+
+<p>Drill is a clustered, powerful MPP (Massively Parallel Processing) query
+engine for Hadoop that can process petabytes of data, fast. Drill is useful
+for short, interactive ad-hoc queries on large-scale data sets. Drill is
+capable of querying nested data in formats like JSON and Parquet and
+performing dynamic schema discovery. Drill does not require a centralized
+metadata repository.</p>
+
+<h3 id="_dynamic-schema-discovery-_"><strong>_Dynamic schema discovery _</strong></h3>
+
+<p>Drill does not require schema or type specification for data in order to start
+the query execution process. Drill starts data processing in record-batches
+and discovers the schema during processing. Self-describing data formats such
+as Parquet, JSON, AVRO, and NoSQL databases have schema specified as part of
+the data itself, which Drill leverages dynamically at query time. Because
+schema can change over the course of a Drill query, all Drill operators are
+designed to reconfigure themselves when schemas change.</p>
+
+<h3 id="flexible-data-model"><strong><em>Flexible data model</em></strong></h3>
+
+<p>Drill allows access to nested data attributes, just like SQL columns, and
+provides intuitive extensions to easily operate on them. From an architectural
+point of view, Drill provides a flexible hierarchical columnar data model that
+can represent complex, highly dynamic and evolving data models. Drill allows
+for efficient processing of these models without the need to flatten or
+materialize them at design time or at execution time. Relational data in Drill
+is treated as a special or simplified case of complex/multi-structured data.</p>
+
+<h3 id="de-centralized-metadata"><strong><em>De-centralized metadata</em></strong></h3>
+
+<p>Drill does not have a centralized metadata requirement. You do not need to
+create and manage tables and views in a metadata repository, or rely on a
+database administrator group for such a function. Drill metadata is derived
+from the storage plugins that correspond to data sources. Storage plugins
+provide a spectrum of metadata ranging from full metadata (Hive), partial
+metadata (HBase), or no central metadata (files). De-centralized metadata
+means that Drill is NOT tied to a single Hive repository. You can query
+multiple Hive repositories at once and then combine the data with information
+from HBase tables or with a file in a distributed file system. You can also
+use SQL DDL syntax to create metadata within Drill, which gets organized just
+like a traditional database. Drill metadata is accessible through the ANSI
+standard INFORMATION_SCHEMA database.</p>
+
+<h3 id="extensibility"><strong><em>Extensibility</em></strong></h3>
+
+<p>Drill provides an extensible architecture at all layers, including the storage
+plugin, query, query optimization/execution, and client API layers. You can
+customize any layer for the specific needs of an organization or you can
+extend the layer to a broader array of use cases. Drill provides a built in
+classpath scanning and plugin concept to add additional storage plugins,
+functions, and operators with minimal configuration.</p>
+
+<h1 id="process-overview">Process Overview</h1>
+
+<p>Download the Apache Drill archive and extract the contents to a directory on
+your machine. The Apache Drill archive contains sample JSON and Parquet files
+that you can query immediately.</p>
+
+<p>Query the sample JSON and parquet files using SQLLine. SQLLine is a pure-Java
+console-based utility for connecting to relational databases and executing SQL
+commands. SQLLine is used as the shell for Drill. Drill follows the ANSI SQL:
+2011 standard with a few extensions for nested data formats.</p>
+
+<h3 id="prerequisite">Prerequisite</h3>
+
+<p>You must have the following software installed on your machine to run Drill:</p>
+
+<div class="table-wrap"><table class="confluenceTable"><tbody><tr><td class="confluenceTd"><p><strong>Software</strong></p></td><td class="confluenceTd"><p><strong>Description</strong></p></td></tr><tr><td class="confluenceTd"><p><a href="http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html" class="external-link" rel="nofollow">Oracle JDK version 7</a></p></td><td class="confluenceTd"><p>A set of programming tools for developing Java applications.</p></td></tr></tbody></table></div>
+
+<h3 id="prerequisite-validation">Prerequisite Validation</h3>
+
+<p>Run the following command to verify that the system meets the software
+prerequisite:
+<table class="confluenceTable"><tbody><tr><td class="confluenceTd"><p><strong>Command </strong></p></td><td class="confluenceTd"><p><strong>Example Output</strong></p></td></tr><tr><td class="confluenceTd"><p><code>java –version</code></p></td><td class="confluenceTd"><p><code>java version &quot;1.7.0_65&quot;</code><br /><code>Java(TM) SE Runtime Environment (build 1.7.0_65-b19)</code><br /><code>Java HotSpot(TM) 64-Bit Server VM (build 24.65-b04, mixed mode)</code></p></td></tr></tbody></table></p>
+
+<h1 id="install-drill">Install Drill</h1>
+
+<p>You can install Drill on a machine running Linux, Mac OS X, or Windows.  </p>
+
+<h2 id="installing-drill-on-linux">Installing Drill on Linux</h2>
+
+<p>Complete the following steps to install Drill:</p>
+
+<ol>
+<li><p>Issue the following command to download the latest, stable version of Apache Drill to a directory on your machine:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">wget 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 new directory to which you can extract the contents of the Drill <code>tar.gz</code> file:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">sudo mkdir -p /opt/drill
+</code></pre></div></li>
+<li><p>Navigate to the directory where you downloaded the Drill <code>tar.gz</code> file.  </p></li>
+<li><p>Issue the following command to extract the contents of the Drill <code>tar.gz</code> file:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">sudo tar -xvzf apache-drill-&lt;version&gt;.tar.gz -C /opt/drill
+</code></pre></div></li>
+<li><p>Issue the following command to navigate to the Drill installation directory:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">cd /opt/drill/apache-drill-&lt;version&gt;
+</code></pre></div></li>
+</ol>
+
+<p>At this point, you can <a href="https://cwiki.apache.org/confluence/displ%0Aay/DRILL/Apache+Drill+in+10+Minutes#ApacheDrillin10Minutes-StartDrill">start Drill</a>.</p>
+
+<h2 id="installing-drill-on-mac-os-x">Installing Drill on Mac OS X</h2>
+
+<p>Complete the following steps to install Drill:</p>
+
+<ol>
+<li><p>Open a Terminal window, and create a <code>drill</code> directory inside your home directory (or in some other location if you prefer).</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">$ pwd
+/Users/max
+$ mkdir drill
+$ cd drill
+$ pwd
+/Users/max/drill
+</code></pre></div></li>
+<li><p>Click the following link to download the latest, stable version of Apache Drill:</p>
+
+<p><a href="http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0/apache-drill-0.7.0.tar.gz">http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0/apache-drill-0.7.0.tar.gz</a></p></li>
+<li><p>Open the downloaded <code>TAR</code> file with the Mac Archive utility or a similar tool for unzipping files.</p></li>
+<li><p>Move the resulting <code>apache-drill-&lt;version&gt;</code> folder into the <code>drill</code> directory that you created.</p></li>
+<li><p>Issue the following command to navigate to the <code>apache-drill-&lt;version&gt;</code> directory:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">cd /Users/max/drill/apache-drill-&lt;version&gt;
+</code></pre></div></li>
+</ol>
+
+<p>At this point, you can <a href="https://cwiki.apache.org/confluence/displ%0Aay/DRILL/Apache+Drill+in+10+Minutes#ApacheDrillin10Minutes-StartDrill">start Drill</a>.</p>
+
+<h2 id="installing-drill-on-windows">Installing Drill on Windows</h2>
+
+<p>You can install Drill on Windows 7 or 8. To install Drill on Windows, you must
+have JDK 7, and you must set the <code>JAVA_HOME</code> path in the Windows Environment
+Variables. You must also have a utility, such as
+<a href="http://www.7-zip.org/">7-zip</a>, installed on your machine. These instructions
+assume that the <a href="http://www.7-zip.org/">7-zip</a> decompression utility is
+installed to extract a Drill archive file that you download.</p>
+
+<h4 id="setting-java_home">Setting JAVA_HOME</h4>
+
+<p>Complete the following steps to set <code>JAVA_HOME</code>:</p>
+
+<ol>
+<li>Navigate to <code>Control Panel\All Control Panel Items\System</code>, and select <strong>Advanced System Settings</strong>. The System Properties window appears.</li>
+<li>On the Advanced tab, click <strong>Environment Variables</strong>. The Environment Variables window appears.</li>
+<li><p>Add/Edit <code>JAVA_HOME</code> to point to the location where the JDK software is located.</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">C:\Program Files\Java\jdk1.7.0_65
+</code></pre></div></li>
+<li><p>Click <strong>OK</strong> to exit the windows.</p></li>
+</ol>
+
+<h4 id="installing-drill">Installing Drill</h4>
+
+<p>Complete the following steps to install Drill:</p>
+
+<ol>
+<li><p>Create a <code>drill</code> directory on your <code>C:\</code> drive, (or in some other location if you prefer).</p>
+
+<p><strong>Example</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text"> C:\drill
+</code></pre></div>
+<p>Do not include spaces in your directory path. If you include spaces in the
+directory path, Drill fails to run.</p></li>
+<li><p>Click the following link to download the latest, stable version of Apache Drill:</p>
+
+<p><a href="http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0/apache-drill-0.7.0.tar.gz">http://www.apache.org/dyn/closer.cgi/drill/drill-0.7.0/apache-drill-0.7.0.tar.gz</a></p></li>
+<li><p>Move the <code>apache-drill-&lt;version&gt;.tar.gz</code> file to the <code>drill</code> directory that you created on your <code>C:\</code> drive.</p></li>
+<li><p>Unzip the <code>TAR.GZ</code> file and the resulting <code>TAR</code> file.  </p>
+
+<ol>
+<li>Right-click <code>apache-drill-&lt;version&gt;.tar.gz,</code> and select<code>7-Zip&gt;Extract Here</code>. The utility extracts the <code>apache-drill-&lt;version&gt;.tar</code> file.</li>
+<li>Right-click <code>apache-drill-&lt;version&gt;.tar,</code>and select`<code>7-Zip&gt;Extract Here</code>. <code>The utility extracts the</code> apache-drill-<version> `folder.</li>
+</ol></li>
+<li><p>Open the <code>apache-drill-&lt;version&gt;</code>folder.</p></li>
+<li><p>Open the <code>bin</code> folder, and double-click on the <code>sqlline.bat</code> file. The Windows command prompt opens.</p></li>
+<li><p>At the <code>sqlline&gt;</code> prompt, type <code>!connect jdbc:drill:zk=local</code> and then press <code>Enter</code>.</p></li>
+<li><p>Enter the username and password.
+a. When prompted, enter the user name <code>admin</code> and then press Enter. 
+b. When prompted, enter the password <code>admin</code> and then press Enter. The cursor blinks for a few seconds and then <code>0: jdbc:drill:zk=local&gt;</code>displays in the prompt.</p></li>
+</ol>
+
+<p>At this point, you can submit queries to Drill. Refer to the <a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minute%0As#ApacheDrillin10Minutes-QuerySampleData">Query Sample Dat
+a</a> section of this document.</p>
+
+<h1 id="start-drill">Start Drill</h1>
+
+<p>Launch SQLLine, the Drill shell, to start and run Drill in embedded mode.
+Launching SQLLine automatically starts a new Drillbit within the shell. In a
+production environment, Drillbits are the daemon processes that run on each
+node in a Drill cluster.</p>
+
+<p>Complete the following steps to launch SQLLine and start Drill:</p>
+
+<ol>
+<li><p>Verify that you are in the Drill installation directory.<br>
+Example: <code>~/apache-drill-&lt;version&gt;</code></p></li>
+<li><p>Issue the following command to launch SQLLine:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">bin/sqlline -u jdbc:drill:zk=local
+</code></pre></div>
+<p><code>-u</code> is a JDBC connection string that directs SQLLine to connect to Drill. It
+also starts a local Drillbit. If you are connecting to an Apache Drill
+cluster, the value of <code>zk=</code> would be a list of Zookeeper quorum nodes. For
+more information about how to run Drill in clustered mode, go to <a href="/confluence/display/DRILL/Deploying+A%0Apache+Drill+in+a+Clustered+Environment">Deploying
+Apache Drill in a Clustered Environment</a>.</p></li>
+</ol>
+
+<p>When SQLLine starts, the system displays the following prompt:<br>
+<code>0: jdbc:drill:zk=local&gt;</code></p>
+
+<p>Issue the following command when you want to exit SQLLine:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">!quit
+</code></pre></div>
+<h1 id="query-sample-data">Query Sample Data</h1>
+
+<p>Your Drill installation includes a <code>sample-date</code> directory with JSON and
+Parquet files that you can query. The local file system on your machine is
+configured as the <code>dfs</code> storage plugin instance by default when you install
+Drill in embedded mode. For more information about storage plugin
+configuration, refer to <a href="https://cwiki.apache.org%0A/confluence/display/DRILL/Connecting+to+Data+Sources#ConnectingtoDataSources-%0AStoragePluginRegistration">Storage Plugin Registration</a>.</p>
+
+<p>Use SQL syntax to query the sample <code>JSON</code> and <code>Parquet</code> files in the <code>sample-
+data</code> directory on your local file system.</p>
+
+<h3 id="querying-a-json-file">Querying a JSON File</h3>
+
+<p>A sample JSON file, <code>employee.json</code>, contains fictitious employee data.</p>
+
+<p>To view the data in the <code>employee.json</code> file, submit the following SQL query
+to Drill:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; SELECT * FROM cp.`employee.json`;
+</code></pre></div>
+<p>The query returns the following results:</p>
+
+<p><strong>Example of partial output</strong></p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">+-------------+------------+------------+------------+-------------+-----------+
+| employee_id | full_name  | first_name | last_name  | position_id | position_ |
++-------------+------------+------------+------------+-------------+-----------+
+| 1101        | Steve Eurich | Steve      | Eurich         | 16          | Store T |
+| 1102        | Mary Pierson | Mary       | Pierson    | 16          | Store T |
+| 1103        | Leo Jones  | Leo        | Jones      | 16          | Store Tem |
+| 1104        | Nancy Beatty | Nancy      | Beatty     | 16          | Store T |
+| 1105        | Clara McNight | Clara      | McNight    | 16          | Store  |
+| 1106        | Marcella Isaacs | Marcella   | Isaacs     | 17          | Stor |
+| 1107        | Charlotte Yonce | Charlotte  | Yonce      | 17          | Stor |
+| 1108        | Benjamin Foster | Benjamin   | Foster     | 17          | Stor |
+| 1109        | John Reed  | John       | Reed       | 17          | Store Per |
+| 1110        | Lynn Kwiatkowski | Lynn       | Kwiatkowski | 17          | St |
+| 1111        | Donald Vann | Donald     | Vann       | 17          | Store Pe |
+| 1112        | William Smith | William    | Smith      | 17          | Store  |
+| 1113        | Amy Hensley | Amy        | Hensley    | 17          | Store Pe |
+| 1114        | Judy Owens | Judy       | Owens      | 17          | Store Per |
+| 1115        | Frederick Castillo | Frederick  | Castillo   | 17          | S |
+| 1116        | Phil Munoz | Phil       | Munoz      | 17          | Store Per |
+| 1117        | Lori Lightfoot | Lori       | Lightfoot  | 17          | Store |
++-------------+------------+------------+------------+-------------+-----------+
+1,155 rows selected (0.762 seconds)
+0: jdbc:drill:zk=local&gt;
+</code></pre></div>
+<h3 id="querying-a-parquet-file">Querying a Parquet File</h3>
+
+<p>Query the <code>region.parquet</code> and <code>nation.parquet</code> files in the <code>sample-data</code>
+directory on your local file system.</p>
+
+<h4 id="region-file">Region File</h4>
+
+<p>If you followed the Apache Drill in 10 Minutes instructions to install Drill
+in embedded mode, the path to the parquet file varies between operating
+systems.</p>
+
+<p><strong>Note:</strong> When you enter the query, include the version of Drill that you are currently running. </p>
+
+<p>To view the data in the <code>region.parquet</code> file, issue the query appropriate for
+your operating system:</p>
+
+<ul>
+<li>Linux<br>
+<code>SELECT * FROM dfs.</code>/opt/drill/apache-drill-<version>/sample-
+data/region.parquet<code>;</code></li>
+<li>Mac OS X<br>
+<code>SELECT * FROM dfs.</code>/Users/max/drill/apache-drill-<version>/sample-
+data/region.parquet<code>;</code></li>
+<li>Windows<br>
+<code>SELECT * FROM dfs.</code>C:\drill\apache-drill-<version>\sample-
+data\region.parquet<code>;</code></li>
+</ul>
+
+<p>The query returns the following results:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+
+|   EXPR$0   |   EXPR$1   |
++------------+------------+
+| AFRICA     | lar deposits. blithely final packages cajole. regular waters ar |
+| AMERICA    | hs use ironic, even requests. s |
+| ASIA       | ges. thinly even pinto beans ca |
+| EUROPE     | ly final courts cajole furiously final excuse |
+| MIDDLE EAST | uickly special accounts cajole carefully blithely close reques |
++------------+------------+
+5 rows selected (0.165 seconds)
+</code></pre></div>
+<p>0: jdbc:drill:zk=local&gt;</p>
+
+<h4 id="nation-file">Nation File</h4>
+
+<p>If you followed the Apache Drill in 10 Minutes instructions to install Drill
+in embedded mode, the path to the parquet file varies between operating
+systems.</p>
+
+<p><strong>Note:</strong> When you enter the query, include the version of Drill that you are currently running. </p>
+
+<p>To view the data in the <code>nation.parquet</code> file, issue the query appropriate for
+your operating system:</p>
+
+<ul>
+<li>Linux<br></li>
+</ul>
+
+<p><code>SELECT * FROM dfs.`/opt/drill/apache-drill-&lt;version&gt;/sample-
+data/nation.parquet`;</code>
+* Mac OS X</p>
+
+<p><code>SELECT * FROM dfs.`/Users/max/drill/apache-drill-&lt;version&gt;/sample-
+data/nation.parquet`;</code></p>
+
+<ul>
+<li>Windows </li>
+</ul>
+
+<p><code>SELECT * FROM dfs.`C:\drill\apache-drill-&lt;version&gt;\sample-
+data\nation.parquet`;</code></p>
+
+<p>The query returns the following results:</p>
+
+<h1 id="summary">Summary</h1>
+
+<p>Now you know a bit about Apache Drill. To summarize, you have completed the
+following tasks:</p>
+
+<ul>
+<li>Learned that Apache Drill supports nested data, schema-less execution, and decentralized metadata.</li>
+<li>Downloaded and installed Apache Drill.</li>
+<li>Invoked SQLLine with Drill in embedded mode.</li>
+<li>Queried the sample JSON file, <code>employee.json</code>, to view its data.</li>
+<li>Queried the sample <code>region.parquet</code> file to view its data.</li>
+<li>Queried the sample <code>nation.parquet</code> file to view its data.</li>
+</ul>
+
+<h1 id="next-steps">Next Steps</h1>
+
+<p>Now that you have an idea about what Drill can do, you might want to:</p>
+
+<ul>
+<li><a href="https://cwiki.apache.org/confluence/display/DRILL/Deploying+Apache+Drill+in+a+Clustered+Environment">Deploy Drill in a clustered environment.</a></li>
+<li><a href="https://cwiki.apache.org/confluence/display/DRILL/Connecting+to+Data+Sources">Configure storage plugins to connect Drill to your data sources</a>.</li>
+<li>Query <a href="https://cwiki.apache.org/confluence/display/DRILL/Connecting+to+Data+Sources#ConnectingtoDataSources-QueryingHiveTables">Hive</a> and <a href="https://cwiki.apache.org/confluence/display/DRILL/Connecting+to+Data+Sources#ConnectingtoDataSources-QueryingHiveTables">HBase</a> data.</li>
+<li><p><a href="https://cwiki.apache.org/confluence/display/DRILL/Querying+Complex+Data">Query Complex Data</a></p></li>
+<li><p><a href="https://cwiki.apache.org/confluence/display/DRILL/Querying+Plain+Text+Files">Query Plain Text Files</a></p></li>
+</ul>
+
+<h1 id="more-information">More Information</h1>
+
+<p>For more information about Apache Drill, go to <a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+Wiki">Apache Drill
+Wiki</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/apache-drill-m1-release-notes-apache-drill-alpha/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html (added)
+++ drill/site/trunk/content/drill/docs/apache-drill-m1-release-notes-apache-drill-alpha/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,133 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Apache Drill M1 Release Notes (Apache Drill Alpha) - 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>Apache Drill M1 Release Notes (Apache Drill Alpha)</h1>
+
+</div>
+
+<div class="int_text" align="left"><h3 id="milestone-1-goals">Milestone 1 Goals</h3>
+
+<p>The first release of Apache Drill is designed as a technology preview for
+people to better understand the architecture and vision. It is a functional
+release tying to piece together the key components of a next generation MPP
+query engine. It is designed to allow milestone 2 (M2) to focus on
+architectural analysis and performance optimization.</p>
+
+<ul>
+<li>Provide a new optimistic DAG execution engine for data analysis</li>
+<li>Build a new columnar shredded in-memory format and execution model that minimizes data serialization/deserialization costs and operator complexity</li>
+<li>Provide a model for runtime generated functions and relational operators that minimizes complexity and maximizes performance</li>
+<li>Support queries against columnar on disk format (Parquet) and JSON</li>
+<li>Support the most common set of standard SQL read-only phrases using ANSI standards. Includes: SELECT, FROM, WHERE, HAVING, ORDER, GROUP BY, IN, DISTINCT, LEFT JOIN, RIGHT JOIN, INNER JOIN</li>
+<li>Support schema-on-read querying and execution</li>
+<li>Build a set of columnar operation primitives including Merge Join, Sort, Streaming Aggregate, Filter, Selection Vector removal.</li>
+<li>Support unlimited level of subqueries and correlated subqueries</li>
+<li>Provided an extensible query-language agnostic JSON-base logical data flow syntax.</li>
+<li>Support complex data type manipulation via logical plan operations</li>
+</ul>
+
+<h3 id="known-issues">Known Issues</h3>
+
+<p>SQL Parsing<br>
+Because Apache Drill is built to support late-bound changing schemas while SQL
+is statically typed, there are couple of special requirements that are
+required writing SQL queries. These are limited to the current release and
+will be correct in a future milestone release.</p>
+
+<ul>
+<li>All tables are exposed as a single map field that contains</li>
+<li>Drill Alpha doesn&#39;t support implicit or explicit casts outside those required above.</li>
+<li>Drill Alpha does not include, there are currently a couple of differences for how to write a query in In order to query against</li>
+</ul>
+
+<p>UDFs</p>
+
+<ul>
+<li>Drill currently supports simple and aggregate functions using scalar, repeated and</li>
+<li>Nested data support incomplete. Drill Alpha supports nested data structures as well repeated fields. However,</li>
+<li>asd</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/apache-drill-tutorial/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html (added)
+++ drill/site/trunk/content/drill/docs/apache-drill-tutorial/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,142 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Apache Drill Tutorial - 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>Apache Drill Tutorial</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>This tutorial uses the MapR Sandbox, which is a Hadoop environment pre-
+configured with Apache Drill.</p>
+
+<p>To complete the tutorial on the MapR Sandbox with Apache Drill, work through
+the following pages in order:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Installing+the+Apache+Drill+Sandbox">Installing the Apache Drill Sandbox</a></li>
+<li><a href="/confluence/display/DRILL/Getting+to+Know+the+Drill+Setup">Getting to Know the Drill Setup</a></li>
+<li><a href="/confluence/display/DRILL/Lesson+1%3A+Learn+About+the+Data+Set">Lesson 1: Learn About the Data Set</a></li>
+<li><a href="/confluence/display/DRILL/Lesson+2%3A+Run+Queries+with+ANSI+SQL">Lesson 2: Run Queries with ANSI SQL</a></li>
+<li><a href="/confluence/display/DRILL/Lesson+3%3A+Run+Queries+on+Complex+Data+Types">Lesson 3: Run Queries on Complex Data Types</a></li>
+<li><a href="/confluence/display/DRILL/Summary">Summary</a></li>
+</ul>
+
+<h1 id="about-apache-drill">About Apache Drill</h1>
+
+<p>Drill is an Apache open-source SQL query engine for Big Data exploration.
+Drill is designed from the ground up to support high-performance analysis on
+the semi-structured and rapidly evolving data coming from modern Big Data
+applications, while still providing the familiarity and ecosystem of ANSI SQL,
+the industry-standard query language. Drill provides plug-and-play integration
+with existing Apache Hive and Apache HBase deployments.Apache Drill 0.5 offers
+the following key features:</p>
+
+<ul>
+<li><p>Low-latency SQL queries</p></li>
+<li><p>Dynamic queries on self-describing data in files (such as JSON, Parquet, text) and MapR-DB/HBase tables, without requiring metadata definitions in the Hive metastore.</p></li>
+<li><p>ANSI SQL</p></li>
+<li><p>Nested data support</p></li>
+<li><p>Integration with Apache Hive (queries on Hive tables and views, support for all Hive file formats and Hive UDFs)</p></li>
+<li><p>BI/SQL tool integration using standard JDBC/ODBC drivers</p></li>
+</ul>
+
+<h1 id="mapr-sandbox-with-apache-drill">MapR Sandbox with Apache Drill</h1>
+
+<p>MapR includes Apache Drill as part of the Hadoop distribution. The MapR
+Sandbox with Apache Drill is a fully functional single-node cluster that can
+be used to get an overview on Apache Drill in a Hadoop environment. Business
+and technical analysts, product managers, and developers can use the sandbox
+environment to get a feel for the power and capabilities of Apache Drill by
+performing various types of queries. Once you get a flavor for the technology,
+refer to the <a href="http://incubator.apache.org/drill/">Apache Drill web site</a> and
+<a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+Wiki">Apache Drill documentation
+</a>for more
+details.</p>
+
+<p>Note that Hadoop is not a prerequisite for Drill and users can start ramping
+up with Drill by running SQL queries directly on the local file system. Refer
+to <a href="https://cwiki.apache.org/confluence/display/DR%0AILL/Apache+Drill+in+10+Minutes">Apache Drill in 10 minutes</a> for an introduction to using Drill in local
+(embedded) mode.</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/architectural-highlights/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/architectural-highlights/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/architectural-highlights/index.html (added)
+++ drill/site/trunk/content/drill/docs/architectural-highlights/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,104 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Architectural Highlights - 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>Architectural Highlights</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The goal for Drill is to bring the <strong>SQL Ecosystem</strong> and <strong>Performance</strong> of
+the relational systems to <strong>Hadoop scale</strong> data <strong>WITHOUT</strong> compromising on
+the <strong>Flexibility</strong> of Hadoop/NoSQL systems. There are several core
+architectural elements in Apache Drill that make it a highly flexible and
+efficient query engine.</p>
+
+<p>Click on either of the following links to read more about Drill&#39;s performance
+and flexibility:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Flexibility">Flexibility</a></li>
+<li><a href="/confluence/display/DRILL/Performance">Performance</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/architectural-overview/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/architectural-overview/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/architectural-overview/index.html (added)
+++ drill/site/trunk/content/drill/docs/architectural-overview/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,150 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Architectural Overview - 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>Architectural Overview</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Apache Drill is a low latency distributed query engine for large-scale
+datasets, including structured and semi-structured/nested data. Inspired by
+Google’s Dremel, Drill is designed to scale to several thousands of nodes and
+query petabytes of data at interactive speeds that BI/Analytics environments
+require.</p>
+
+<h3 id="high-level-architecture">High-Level Architecture</h3>
+
+<p>Drill includes a distributed execution environment, purpose built for large-
+scale data processing. At the core of Apache Drill is the ‘Drillbit’ service,
+which is responsible for accepting requests from the client, processing the
+queries, and returning results to the client.</p>
+
+<p>A Drillbit service can be installed and run on all of the required nodes in a
+Hadoop cluster to form a distributed cluster environment. When a Drillbit runs
+on each data node in the cluster, Drill can maximize data locality during
+query execution without moving data over the network or between nodes. Drill
+uses ZooKeeper to maintain cluster membership and health-check information.</p>
+
+<p>Though Drill works in a Hadoop cluster environment, Drill is not tied to
+Hadoop and can run in any distributed cluster environment. The only pre-
+requisite for Drill is Zookeeper.</p>
+
+<h3 id="query-flow-in-drill">Query Flow in Drill</h3>
+
+<p>The following image represents the flow of a Drill query:</p>
+
+<p><img src="../img/queryFlow.PNG?version=1&amp;modifica%0AtionDate=1400017845000&amp;api=v2" alt="">  </p>
+
+<p>The flow of a Drill query typically involves the following steps:</p>
+
+<ol>
+<li>The Drill client issues a query. Any Drillbit in the cluster can accept queries from clients. There is no master-slave concept.</li>
+<li>The Drillbit then parses the query, optimizes it, and generates an optimized distributed query plan for fast and efficient execution.</li>
+<li>The Drillbit that accepts the query becomes the driving Drillbit node for the request. It gets a list of available Drillbit nodes in the cluster from ZooKeeper. The driving Drillbit determines the appropriate nodes to execute various query plan fragments to maximize data locality.</li>
+<li>The Drillbit schedules the execution of query fragments on individual nodes according to the execution plan.</li>
+<li>The individual nodes finish their execution and return data to the driving Drillbit.</li>
+<li>The driving Drillbit returns results back to the client.</li>
+</ol>
+
+<h3 id="drill-clients">Drill Clients</h3>
+
+<p>You can access Drill through the following interfaces:</p>
+
+<ul>
+<li>Drill shell (SQLLine)</li>
+<li>Drill Web UI</li>
+<li>ODBC </li>
+<li>JDBC</li>
+<li>C++ API</li>
+</ul>
+
+<p>Click on either of the following links to continue reading about Drill&#39;s
+architecture:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Core+Modules+within+a+Drillbit">Core Modules within a Drillbit</a></li>
+<li><a href="/confluence/display/DRILL/Architectural+Highlights">Architectural Highlights</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/archived-pages/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/archived-pages/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/archived-pages/index.html (added)
+++ drill/site/trunk/content/drill/docs/archived-pages/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,97 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Archived Pages - 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>Archived Pages</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The following pages have been archived:</p>
+
+<ul>
+<li>How to Run Drill with Sample Data</li>
+<li>Meet Apache Drill</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/compiling-drill-from-source/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/compiling-drill-from-source/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/compiling-drill-from-source/index.html (added)
+++ drill/site/trunk/content/drill/docs/compiling-drill-from-source/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,257 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Compiling Drill From source - 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>Compiling Drill From source</h1>
+
+</div>
+
+<div class="int_text" align="left"><ul>
+<li>Drill JIRA and Reviewboard script
+
+<ul>
+<li>1. Setup</li>
+<li>2. Usage</li>
+<li>3. Upload patch</li>
+<li>4. Update patch</li>
+</ul></li>
+<li>JIRA command line tool
+
+<ul>
+<li>1. Download the JIRA command line package</li>
+<li>2. Configure JIRA username and password</li>
+</ul></li>
+<li>Reviewboard
+
+<ul>
+<li>1. Install the post-review tool</li>
+<li>2. Configure Stuff</li>
+</ul></li>
+<li>FAQ
+
+<ul>
+<li>When I run the script, it throws the following error and exits</li>
+<li>When I run the script, it throws the following error and exits</li>
+</ul></li>
+</ul>
+
+<h3 id="drill-jira-and-reviewboard-script">Drill JIRA and Reviewboard script</h3>
+
+<h4 id="1.-setup">1. Setup</h4>
+
+<ol>
+<li>Follow instructions <a href="https://cwiki.apache.org/confluence/display/DRILL/Drill+Patch+Review+Tool#Drillpatchreviewtool-JIRAcommandlinetool">here</a> to setup the jira-python package</li>
+<li>Follow instructions <a href="https://cwiki.apache.org/confluence/display/DRILL/Drill+Patch+Review+Tool#Drillpatchreviewtool-Reviewboard">here</a> to setup the reviewboard python tools</li>
+<li><p>Install the argparse module </p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">On Linux -&gt; sudo yum install python-argparse
+On Mac -&gt; sudo easy_install argparse
+</code></pre></div></li>
+</ol>
+
+<h4 id="2.-usage">2. Usage</h4>
+<div class="highlight"><pre><code class="language-text" data-lang="text">nnarkhed-mn: nnarkhed$ python drill-patch-review.py --help
+usage: drill-patch-review.py [-h] -b BRANCH -j JIRA [-s SUMMARY]
+                             [-d DESCRIPTION] [-r REVIEWBOARD] [-t TESTING]
+                             [-v VERSION] [-db] -rbu REVIEWBOARDUSER -rbp REVIEWBOARDPASSWORD
+
+Drill patch review tool
+
+optional arguments:
+  -h, --help            show this help message and exit
+  -b BRANCH, --branch BRANCH
+                        Tracking branch to create diff against
+  -j JIRA, --jira JIRA  JIRA corresponding to the reviewboard
+  -s SUMMARY, --summary SUMMARY
+                        Summary for the reviewboard
+  -d DESCRIPTION, --description DESCRIPTION
+                        Description for reviewboard
+  -r REVIEWBOARD, --rb REVIEWBOARD
+                        Review board that needs to be updated
+  -t TESTING, --testing-done TESTING
+                        Text for the Testing Done section of the reviewboard
+  -v VERSION, --version VERSION
+                        Version of the patch
+  -db, --debug          Enable debug mode
+  -rbu, --reviewboard-user Reviewboard user name
+  -rbp, --reviewboard-password Reviewboard password
+</code></pre></div>
+<h4 id="3.-upload-patch">3. Upload patch</h4>
+
+<ol>
+<li>Specify the branch against which the patch should be created (-b)</li>
+<li>Specify the corresponding JIRA (-j)</li>
+<li>Specify an <strong>optional</strong> summary (-s) and description (-d) for the reviewboard</li>
+</ol>
+
+<p>Example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">python drill-patch-review.py -b origin/master -j DRILL-241 -rbu tnachen -rbp password
+</code></pre></div>
+<h4 id="4.-update-patch">4. Update patch</h4>
+
+<ol>
+<li>Specify the branch against which the patch should be created (-b)</li>
+<li>Specify the corresponding JIRA (--jira)</li>
+<li>Specify the rb to be updated (-r)</li>
+<li>Specify an <strong>optional</strong> summary (-s) and description (-d) for the reviewboard, if you want to update it</li>
+<li>Specify an <strong>optional</strong> version of the patch. This will be appended to the jira to create a file named JIRA-<version>.patch. The purpose is to be able to upload multiple patches to the JIRA. This has no bearing on the reviewboard update.</li>
+</ol>
+
+<p>Example:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">python drill-patch-review.py -b origin/master -j DRILL-241 -r 14081 rbp tnachen -rbp password
+</code></pre></div>
+<h3 id="jira-command-line-tool">JIRA command line tool</h3>
+
+<h4 id="1.-download-the-jira-command-line-package">1. Download the JIRA command line package</h4>
+
+<p>Install the jira-python package.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">sudo easy_install jira-python
+</code></pre></div>
+<h4 id="2.-configure-jira-username-and-password">2. Configure JIRA username and password</h4>
+
+<p>Include a jira.ini file in your $HOME directory that contains your Apache JIRA
+username and password.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">nnarkhed-mn:~ nnarkhed$ cat ~/jira.ini
+user=nehanarkhede
+password=***********
+</code></pre></div>
+<h3 id="reviewboard">Reviewboard</h3>
+
+<p>This is a quick tutorial on using <a href="https://reviews.apache.org">Review Board</a>
+with Drill.</p>
+
+<h4 id="1.-install-the-post-review-tool">1. Install the post-review tool</h4>
+
+<p>If you are on RHEL, Fedora or CentOS, follow these steps:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">sudo yum install python-setuptools
+sudo easy_install -U RBTools
+</code></pre></div>
+<p>If you are on Mac, follow these steps:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">sudo easy_install -U setuptools
+sudo easy_install -U RBTools
+</code></pre></div>
+<p>For other platforms, follow the <a href="http://www.reviewboard.org/docs/manual/dev/users/tools/post-review/">instructions</a> to
+setup the post-review tool.</p>
+
+<h4 id="2.-configure-stuff">2. Configure Stuff</h4>
+
+<p>Then you need to configure a few things to make it work.</p>
+
+<p>First set the review board url to use. You can do this from in git:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">git config reviewboard.url https://reviews.apache.org
+</code></pre></div>
+<p>If you checked out using the git wip http url that confusingly won&#39;t work with
+review board. So you need to configure an override to use the non-http url.
+You can do this by adding a config file like this:</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">jkreps$ cat ~/.reviewboardrc
+REPOSITORY = &#39;git://git.apache.org/incubator-drill.git&#39;
+TARGET_GROUPS = &#39;drill-git&#39;
+</code></pre></div>
+<p>GUESS_FIELDS = True</p>
+
+<h3 id="faq">FAQ</h3>
+
+<h4 id="when-i-run-the-script,-it-throws-the-following-error-and-exits">When I run the script, it throws the following error and exits</h4>
+<div class="highlight"><pre><code class="language-text" data-lang="text">nnarkhed$python drill-patch-review.py -b trunk -j DRILL-241
+There don&#39;t seem to be any diffs
+</code></pre></div>
+<p>There are two reasons for this:</p>
+
+<ul>
+<li>The code is not checked into your local branch</li>
+<li>The -b branch is not pointing to the remote branch. In the example above, &quot;trunk&quot; is specified as the branch, which is the local branch. The correct value for the -b (--branch) option is the remote branch. &quot;git branch -r&quot; gives the list of the remote branch names.</li>
+</ul>
+
+<h4 id="when-i-run-the-script,-it-throws-the-following-error-and-exits">When I run the script, it throws the following error and exits</h4>
+
+<p>Error uploading diff</p>
+
+<p>Your review request still exists, but the diff is not attached.</p>
+
+<p>One of the most common root causes of this error are that the git remote
+branches are not up-to-date. Since the script already does that, it is
+probably due to some other problem. You can run the script with the --debug
+option that will make post-review run in the debug mode and list the root
+cause of the issue.</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/configuration-options/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/configuration-options/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/configuration-options/index.html (added)
+++ drill/site/trunk/content/drill/docs/configuration-options/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,107 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Configuration Options - 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>Configuration Options</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Drill provides several configuration options that you can enable, disable, or
+modify. Modifying certain configuration options can impact Drill’s
+performance. Many of Drill&#39;s configuration options reside in the <code>drill-
+env.sh</code> and <code>drill-override.conf</code> files. Drill stores these files in the
+<code>/conf</code> directory. Drill sources<code>/etc/drill/conf</code> if it exists. Otherwise,
+Drill sources the local <code>&lt;drill_installation_directory&gt;/conf</code> directory.</p>
+
+<p>Refer to the following documentation for information about configuration
+options that you can modify:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Memory+Allocation">Memory Allocation</a></li>
+<li><a href="/confluence/display/DRILL/Start-Up+Options">Start-Up Options</a></li>
+<li><a href="/confluence/display/DRILL/Planning+and+Execution+Options">Planning and Execution Options</a></li>
+<li><a href="/confluence/display/DRILL/Persistent+Configuration+Storage">Persistent Configuration Storage</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/connect-to-data-sources/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/connect-to-data-sources/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/connect-to-data-sources/index.html (added)
+++ drill/site/trunk/content/drill/docs/connect-to-data-sources/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,142 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Connect to Data Sources - 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>Connect to Data Sources</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>Apache Drill serves as a query layer that connects to data sources through
+storage plugins. Drill uses the storage plugins to interact with data sources.
+You can think of a storage plugin as a connection between Drill and a data
+source.</p>
+
+<p>The following image represents the storage plugin layer between Drill and a
+data source:</p>
+
+<p><img src="../img/storageplugin.png" alt=""></p>
+
+<p>Storage plugins provide the following information to Drill:</p>
+
+<ul>
+<li>Metadata available in the underlying data source</li>
+<li>Location of data</li>
+<li>Interfaces that Drill can use to read from and write to data sources</li>
+<li>A set of storage plugin optimization rules that assist with efficient and faster execution of Drill queries, such as pushdowns, statistics, and partition awareness</li>
+</ul>
+
+<p>Storage plugins perform scanner and writer functions, and inform the metadata
+repository of any known metadata, such as:</p>
+
+<ul>
+<li>Schema</li>
+<li>File size</li>
+<li>Data ordering</li>
+<li>Secondary indices</li>
+<li>Number of blocks</li>
+</ul>
+
+<p>Storage plugins inform the execution engine of any native capabilities, such
+as predicate pushdown, joins, and SQL.</p>
+
+<p>Drill provides storage plugins for files and HBase/M7. Drill also integrates
+with Hive through a storage plugin. Hive provides a metadata abstraction layer
+on top of files and HBase/M7.</p>
+
+<p>When you run Drill to query files in HBase/M7, Drill can perform direct
+queries on the data or go through Hive, if you have metadata defined there.
+Drill integrates with the Hive metastore for metadata and also uses a Hive
+SerDe for the deserialization of records. Drill does not invoke the Hive
+execution engine for any requests.</p>
+
+<p>For information about how to connect Drill to your data sources, refer to
+storage plugin registration:</p>
+
+<ul>
+<li><a href="/confluence/display/DRILL/Storage+Plugin+Registration">Storage Plugin Registration</a></li>
+<li><a href="/confluence/display/DRILL/MongoDB+Plugin+for+Apache+Drill">MongoDB Plugin for Apache Drill</a></li>
+<li><a href="/confluence/display/DRILL/MapR-DB+Plugin+for+Apache+Drill">MapR-DB Plugin for Apache Drill</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/contribute-to-drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/contribute-to-drill/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/contribute-to-drill/index.html (added)
+++ drill/site/trunk/content/drill/docs/contribute-to-drill/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,96 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Contribute to 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>Contribute to Drill</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The Apache Drill community welcomes your support. Please read <a href="https://cwiki.apache.org/confluence/display/DRILL/Apa%0Ache+Drill+Contribution+Guidelines">Apache Drill
+Contribution Guidelines</a> for information about how to contribute to
+the project. If you would like to contribute to the project and need some
+ideas for what to do, please read <a href="/confluence/display/DRILL/Apache+Drill+Contribution+Ideas">Apache Drill Contribution
+Ideas</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/core-modules-within-a-drillbit/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html?rev=1651949&view=auto
==============================================================================
--- drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html (added)
+++ drill/site/trunk/content/drill/docs/core-modules-within-a-drillbit/index.html Thu Jan 15 05:11:44 2015
@@ -0,0 +1,122 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Core Modules within a Drillbit - 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>Core Modules within a Drillbit</h1>
+
+</div>
+
+<div class="int_text" align="left"><p>The following image represents components within each Drillbit:</p>
+
+<p><img src="../../img/DrillbitModules.PNG?version=1&amp;mo%0AdificationDate=1400017845000&amp;api=v2" alt=""></p>
+
+<p>The following list describes the key components of a Drillbit:</p>
+
+<ul>
+<li><p><strong>RPC end point</strong>: Drill exposes a low overhead protobuf-based RPC protocol to communicate with the clients. Additionally, a C++ and Java API layers are also available for the client applications to interact with Drill. Clients can communicate to a specific Drillbit directly or go through a ZooKeeper quorum to discover the available Drillbits before submitting queries. It is recommended that the clients always go through ZooKeeper to shield clients from the intricacies of cluster management, such as the addition or removal of nodes. </p></li>
+<li><p><strong>SQL parser</strong>: Drill uses Optiq, the open source framework, to parse incoming queries. The output of the parser component is a language agnostic, computer-friendly logical plan that represents the query. </p></li>
+<li><p><strong>Storage plugin interfaces</strong>: Drill serves as a query layer on top of several data sources. Storage plugins in Drill represent the abstractions that Drill uses to interact with the data sources. Storage plugins provide Drill with the following information:</p>
+
+<ul>
+<li>Metadata available in the source</li>
+<li>Interfaces for Drill to read from and write to data sources</li>
+<li>Location of data and a set of optimization rules to help with efficient and faster execution of Drill queries on a specific data source </li>
+</ul></li>
+</ul>
+
+<p>In the context of Hadoop, Drill provides storage plugins for files and
+HBase/M7. Drill also integrates with Hive as a storage plugin since Hive
+provides a metadata abstraction layer on top of files, HBase/M7, and provides
+libraries to read data and operate on these sources (Serdes and UDFs).</p>
+
+<p>When users query files and HBase/M7 with Drill, they can do it directly or go
+through Hive if they have metadata defined there. Drill integration with Hive
+is only for metadata. Drill does not invoke the Hive execution engine for any
+requests.</p>
+
+<ul>
+<li>**Distributed cache: **Drill uses a distributed cache to manage metadata (not the data) and configuration information across various nodes. Sample metadata information that is stored in the cache includes query plan fragments, intermediate state of the query execution, and statistics. Drill uses Infinispan as its cache technology.</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