drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject svn commit: r1641986 [1/2] - in /drill/site/trunk/content/drill: ./ architecture/ blog/ blog/2014/ blog/2014/11/ blog/2014/11/19/ blog/2014/11/19/sql-on-mongodb/ community/ css/ download/ faq/ overview/ static/ static/sql-on-mongodb/ team/ why/
Date Thu, 27 Nov 2014 01:28:56 GMT
Author: tshiran
Date: Thu Nov 27 01:28:55 2014
New Revision: 1641986

URL: http://svn.apache.org/r1641986
Log:
Website moved to drill.apache.org

Added:
    drill/site/trunk/content/drill/blog/
    drill/site/trunk/content/drill/blog/2014/
    drill/site/trunk/content/drill/blog/2014/11/
    drill/site/trunk/content/drill/blog/2014/11/19/
    drill/site/trunk/content/drill/blog/2014/11/19/sql-on-mongodb/
    drill/site/trunk/content/drill/blog/2014/11/19/sql-on-mongodb/index.html
    drill/site/trunk/content/drill/blog/index.html
    drill/site/trunk/content/drill/css/main.css
    drill/site/trunk/content/drill/feed.xml
    drill/site/trunk/content/drill/static/
    drill/site/trunk/content/drill/static/sql-on-mongodb/
    drill/site/trunk/content/drill/static/sql-on-mongodb/empinfo.json
    drill/site/trunk/content/drill/static/sql-on-mongodb/replicated.png   (with props)
    drill/site/trunk/content/drill/static/sql-on-mongodb/sharded.png   (with props)
    drill/site/trunk/content/drill/static/sql-on-mongodb/standalone.png   (with props)
Modified:
    drill/site/trunk/content/drill/architecture/index.html
    drill/site/trunk/content/drill/community/index.html
    drill/site/trunk/content/drill/css/style.css
    drill/site/trunk/content/drill/download/index.html
    drill/site/trunk/content/drill/faq/index.html
    drill/site/trunk/content/drill/index.html
    drill/site/trunk/content/drill/overview/index.html
    drill/site/trunk/content/drill/team/index.html
    drill/site/trunk/content/drill/why/index.html

Modified: drill/site/trunk/content/drill/architecture/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/architecture/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/architecture/index.html (original)
+++ drill/site/trunk/content/drill/architecture/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Architecture - Apache Drill</title>
 
-<link href="/drill/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/style.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/button.css" rel="stylesheet" type="text/css">
-
-<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon">
-<link rel="icon" href="/drill/favicon.ico" type="image/x-icon">
-
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery.easing.1.3.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/modernizr.custom.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script>
+<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>
 
@@ -33,32 +33,32 @@
 
 <div id="menu" class="mw">
 <ul>
-  <li class="logo"><a href="/drill/"></a></li>
+  <li class="logo"><a href="/"></a></li>
   <li>
-    <a href="/drill/overview/">Documentation</a>
+    <a href="/overview/">Documentation</a>
     <ul>
-      <li><a href="/drill/overview/">Overview&nbsp;&nbsp;&nbsp;&nbsp;</a></li>
+      <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="/drill/why/">Why Drill? &nbsp;&nbsp;&nbsp;&nbsp;</a></li>
-      <li><a href="/drill/architecture/">Architecture</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="/drill/community/">Community</a>
+    <a href="/community/">Community</a>
     <ul>
-      <li><a href="/drill/team/">Team</a></li>
-      <li><a href="/drill/community/#events">Events and Meetups</a></li>
-      <li><a href="/drill/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/drill/community/#getinvolved">Get Involved</a></li>
+      <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/incubator-drill" target="_blank">GitHub</a></li>
     </ul>
   </li>
-  <li><a href="/drill/faq/">FAQ</a></li>
-  <li><a href="http://drill-user.org" target="_blank">Blog</a></li>
-	<li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/drill/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </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="/drill/download/">Download</a></li>
+  <li class="d"><a href="/download/">Download</a></li>
 </ul>
 </div>
 
@@ -80,7 +80,7 @@
             <p>
 
             	The following image represents the flow of a Drill query:
-            	<img src="/drill/images/arc-1.jpg" alt="The flow of a Drill query" width="550">
+            	<img src="/images/arc-1.jpg" alt="The flow of a Drill query" width="550">
 
                 The flow of a Drill query typically involves the following steps:
 
@@ -97,7 +97,7 @@
             <h2>Core Modules within a Drillbit</h2>
             <p>The following image represents Drillbit components:</p>
 
-           	<img src="/drill/images/arc-2.jpg" alt="Drillbit components" width="525">
+           	<img src="/images/arc-2.jpg" alt="Drillbit components" width="525">
 
             <p>• RPC end point: 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>
             <p>• SQL parser: 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>
@@ -162,7 +162,7 @@ The following list provides a few exampl
 &nbsp;</p>
 <li><p><strong>Runtime compilation</strong>: 
 Runtime compilation is faster compared to the interpreted execution. Drill generates highly efficient custom code for every single query for every single operator.  Here is a quick overview of the Drill compilation/code generation process at a glance.
-<br><img src="/drill/images/drillcompiler.png" width="500">
+<br><img src="/images/drillcompiler.png" width="500">
 &nbsp;</p>
 <li><p><strong>Optimistic and pipelined query execution</strong>: Drill adopts an optimistic execution model to process queries. Drill assumes that failures are infrequent within the short span of a query and therefore does not spend time creating boundaries or checkpoints to minimize recovery time. Failures at node level are handled gracefully. In the instance of a single query failure, the query is rerun. Drill execution uses a pipeline model where all tasks are scheduled at once. The query execution happens in-memory as much as possible to move data through task pipelines, persisting to disk only if there is memory overflow. 
 &nbsp;</p>

Added: drill/site/trunk/content/drill/blog/2014/11/19/sql-on-mongodb/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/blog/2014/11/19/sql-on-mongodb/index.html?rev=1641986&view=auto
==============================================================================
--- drill/site/trunk/content/drill/blog/2014/11/19/sql-on-mongodb/index.html (added)
+++ drill/site/trunk/content/drill/blog/2014/11/19/sql-on-mongodb/index.html Thu Nov 27 01:28:55 2014
@@ -0,0 +1,263 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>SQL on MongoDB - 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/incubator-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="post int_text">
+
+  <header class="post-header">
+    <h1 class="post-title">SQL on MongoDB</h1>
+    <p class="post-meta"><strong>Date:</strong> Nov 19, 2014
+
+<br/><strong>Authors:</strong> Anil Kumar Batchu, SSE, Intuit India (IDC); Kamesh Bhallamudi, SSE, Intuit India (IDC)
+</p>
+  </header>
+
+  <article class="post-content">
+    <p>One of the many interesting and unique features about Drill is its ability to support multiple query languages, data formats, and data sources, as well as cross-platform querying (such as joining HBase tables with your Mongo collections) using ANSI SQL.</p>
+
+<p>As of now, Drill supports multiple storage plugins, including HDFS, HBase, Hive, and LocalFileSystem. Since Drill is optimized for nested data, we realized that a Mongo storage plugin would be a useful feature.</p>
+
+<p>So, recently Kamesh and I (we have an avid interest in all things Mongo) contributed the MongoDB storage plugin feature to the Apache Drill project. As part of this blog post, we would like to provide instructions on how to use this plugin, which has been included in the <a href="http://incubator.apache.org/drill/download/">Drill 0.6 release</a>.</p>
+
+<p>The instructions are divided into the following subtopics:</p>
+
+<ul>
+<li>Drill and Mongo setup (standalone/replicated/sharded)</li>
+<li>Running queries</li>
+<li>Securely accessing MongoDB</li>
+<li>Optimizations</li>
+</ul>
+
+<h2>Drill and MongoDB Setup (Standalone/Replicated/Sharded)</h2>
+
+<h3>Standalone</h3>
+
+<ul>
+<li>Start <code>mongod</code> process (<a href="http://docs.mongodb.org/manual/installation/">Install MongoDB</a>)</li>
+<li>Start Drill in embedded mode (<a href="https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Embedded+Mode">Installing Drill in Embedded Mode</a> &amp; <a href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=44994063">Starting/Stopping Drill</a>) </li>
+<li>Access the Web UI through the local drillbit: <a href="http://localhost:8047/">http://localhost:8047/</a></li>
+<li><p>Enable the Mongo storage plugin and update its configuration:</p>
+<div class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span>
+  <span class="nt">&quot;type&quot;</span><span class="p">:</span> <span class="s2">&quot;mongo&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;connection&quot;</span><span class="p">:</span> <span class="s2">&quot;mongodb://localhost:27017&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;enabled&quot;</span><span class="p">:</span> <span class="kc">true</span>
+<span class="p">}</span>
+</code></pre></div></li>
+</ul>
+
+<p>By default, <code>mongod</code> listens on port 27017.</p>
+
+<p><img src="/static/sql-on-mongodb/standalone.png" alt="Drill on MongoDB in standalone mode"></p>
+
+<h3>Replica Set</h3>
+
+<ul>
+<li>Start <code>mongod</code> processes in replication mode</li>
+<li>Start Drill in distributed mode (<a href="https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode">Installing Drill in Distributed Mode</a> &amp; <a href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=44994063">Starting/Stopping Drill</a>)</li>
+<li>Access the Web UI through any drillbit: <a href="http://drillbit2:8047">http://drillbit2:8047</a></li>
+<li><p>Enable the Mongo storage plugin and update its configuration:</p>
+<div class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span>
+  <span class="nt">&quot;type&quot;</span><span class="p">:</span> <span class="s2">&quot;mongo&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;connection&quot;</span><span class="p">:</span> <span class="s2">&quot;mongodb://&lt;host1&gt;:&lt;port1&gt;,&lt;host2&gt;:&lt;port2&gt;&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;enabled&quot;</span><span class="p">:</span> <span class="kc">true</span>
+<span class="p">}</span>
+</code></pre></div>
+<p>Where <code>host1</code> and <code>host2</code> are <code>mongod</code> hostnames in the replica set.</p></li>
+</ul>
+
+<p><img src="/static/sql-on-mongodb/replicated.png" alt="Drill on MongoDB in replicated mode"></p>
+
+<p>In replicated mode, whichever drillbit receives the query connects to the nearest <code>mongod</code> (local <code>mongod</code>) to read the data.</p>
+
+<h3>Sharded/Sharded with Replica Set</h3>
+
+<ul>
+<li>Start Mongo processes in sharded mode</li>
+<li>Start Drill in distributed mode (<a href="https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode">Installing Drill in Distributed Mode</a> &amp; <a href="https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=44994063">Starting/Stopping Drill</a>)</li>
+<li>Access the Web UI through any drillbit: <a href="http://drillbit3:8047">http://drillbit3:8047</a></li>
+<li><p>Enable the Mongo storage plugin and update its configuration:</p>
+<div class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span> 
+  <span class="nt">&quot;type&quot;</span><span class="p">:</span> <span class="s2">&quot;mongo&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;connection&quot;</span><span class="p">:</span> <span class="s2">&quot;mongodb://&lt;host1&gt;:&lt;port1&gt;,&lt;host2&gt;:&lt;port2&gt;&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;enabled&quot;</span><span class="p">:</span> <span class="kc">true</span>
+<span class="p">}</span>
+</code></pre></div>
+<p>Where <code>host1</code> and <code>host2</code> are the <code>mongos</code> hostnames.</p></li>
+</ul>
+
+<p><img src="/static/sql-on-mongodb/sharded.png" alt="Drill on MongoDB in sharded mode"></p>
+
+<p>In sharded mode, drillbit first connects to the <code>mongos</code> server to get the shard information.</p>
+
+<h2>Endpoint Assignments</h2>
+
+<p>Drill is designed to maximize data locality:</p>
+
+<ul>
+<li>When drillbits and shards run together on the same machines, each drillbit (endpoint) will read the chunks from the local shard. That is, all the chunks from a shard will be assigned to its local drillbit. This is known as data locality, and is the ideal scenario.</li>
+<li>When all drillbits and shards are running on different machines, chunks will be assigned to drillbits in a round-robin fashion. In this case there is no data locality.</li>
+<li>When some of drillbits and shards are colocated, and some of them are running on different machines, partial data locality is achieved.</li>
+</ul>
+
+<h2>Running Queries</h2>
+
+<p>Here is a simple exercise that provides steps for creating an <code>empinfo</code> collection in an <code>employee</code> database in Mongo that you can query using Drill:</p>
+
+<ol>
+<li>Download <a href="http://media.mongodb.org/zips.json">zips.json</a> and the <a href="/static/sql-on-mongodb/empinfo.json">empinfo.json</a> dataset referenced at the end of blog.</li>
+<li><p>Import the zips.json and empinfo.json files into Mongo using the following command:  </p>
+<div class="highlight"><pre><code class="language-bash" data-lang="bash">mongoimport --host localhost --db <span class="nb">test</span> --collection zips &lt; zips.json
+mongoimport --host localhost --db employee --collection empinfo &lt; empinfo.json
+</code></pre></div></li>
+<li><p>Issue the following queries either from sqlline (Drill’s shell) or from the Drill Web UI to get corresponding results from the Mongo collection. </p>
+
+<ul>
+<li>To issue queries from the web UI, open the Drill web UI and go to Query tab. </li>
+<li><p>To issue queries from sqlline, connect to sqlline using the following command: </p>
+<div class="highlight"><pre><code class="language-bash" data-lang="bash">&lt;DRILLHOME&gt;/bin/sqlline -u jdbc:drill:zk<span class="o">=</span>zkhost:2181 -n admin -p admin
+</code></pre></div></li>
+</ul></li>
+<li><p>Queries:</p>
+<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">SELECT</span> <span class="n">first_name</span><span class="p">,</span> <span class="n">last_name</span><span class="p">,</span> <span class="n">position_id</span>
+<span class="k">FROM</span> <span class="n">mongo</span><span class="p">.</span><span class="n">employee</span><span class="p">.</span><span class="o">`</span><span class="n">empinfo</span><span class="o">`</span>
+<span class="k">WHERE</span> <span class="n">employee_id</span> <span class="o">=</span> <span class="mi">1107</span> <span class="k">AND</span> <span class="n">position_id</span> <span class="o">=</span> <span class="mi">17</span> <span class="k">AND</span> <span class="n">last_name</span> <span class="o">=</span> <span class="s1">&#39;Yonce&#39;</span><span class="p">;</span>  
+
+<span class="k">SELECT</span> <span class="n">city</span><span class="p">,</span> <span class="k">sum</span><span class="p">(</span><span class="n">pop</span><span class="p">)</span>
+<span class="k">FROM</span> <span class="n">mongo</span><span class="p">.</span><span class="n">test</span><span class="p">.</span><span class="o">`</span><span class="n">zips</span><span class="o">`</span> <span class="n">zipcodes</span>
+<span class="k">WHERE</span> <span class="k">state</span> <span class="k">IS</span> <span class="k">NOT</span> <span class="k">NULL</span> <span class="k">GROUP</span> <span class="k">BY</span> <span class="n">city</span>
+<span class="k">ORDER</span> <span class="k">BY</span> <span class="k">sum</span><span class="p">(</span><span class="n">pop</span><span class="p">)</span> <span class="k">DESC</span> <span class="k">LIMIT</span> <span class="mi">1</span><span class="p">;</span>
+</code></pre></div></li>
+</ol>
+
+<p><em>Note</em>: If a field contains a mixture of different data types across different records, such as both int and decimal values, then queries fail unless <code>store.mongo.all_text_mode = true</code> and aggregations fail in that case. For more information refer to <a href="https://issues.apache.org/jira/browse/DRILL-1475">DRILL-1475</a> and <a href="https://issues.apache.org/jira/browse/DRILL-1460">DRILL-1460</a>.</p>
+
+<p>To set <code>store.mongo.all_text_mode = true</code>, execute the following command in sqlline:</p>
+<div class="highlight"><pre><code class="language-sql" data-lang="sql"><span class="k">alter</span> <span class="k">session</span> <span class="k">set</span> <span class="n">store</span><span class="p">.</span><span class="n">mongo</span><span class="p">.</span><span class="n">all_text_mode</span> <span class="o">=</span> <span class="k">true</span>
+</code></pre></div>
+<h2>Securely Accessing MongoDB</h2>
+
+<p>Create two databases, emp and zips. For each database, create a user with read privileges. As an example, for the zips database, create a user “apache” with read privileges. For the emp database, create a user “drill” with read privileges.</p>
+
+<p>The apache user will be able to query the zips database by using the following storage plugin configuration:</p>
+<div class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span> 
+  <span class="nt">&quot;type&quot;</span><span class="p">:</span> <span class="s2">&quot;mongo&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;connection&quot;</span><span class="p">:</span> <span class="s2">&quot;mongodb://apache:apache@localhost:27017/zips&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;enabled&quot;</span><span class="p">:</span> <span class="kc">true</span>
+<span class="p">}</span>
+</code></pre></div>
+<p>The <code>drill</code> user will be able to query the <code>emp</code> database by using the following storage plugin configuration:</p>
+<div class="highlight"><pre><code class="language-json" data-lang="json"><span class="p">{</span> 
+  <span class="nt">&quot;type&quot;</span><span class="p">:</span> <span class="s2">&quot;mongo&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;connection&quot;</span><span class="p">:</span> <span class="s2">&quot;mongodb://drill:drill@localhost:27017/emp&quot;</span><span class="p">,</span>
+  <span class="nt">&quot;enabled&quot;</span><span class="p">:</span> <span class="kc">true</span> 
+<span class="p">}</span>
+</code></pre></div>
+<p><em>Note</em>: The security patch may be included in next release. Check <a href="https://issues.apache.org/jira/browse/DRILL-1502">DRILL-1502</a> for status.</p>
+
+<h2>Optimizations</h2>
+
+<p>The MongoDB storage plugin supports predicate pushdown and projection pushdown. As of now, predicate pushdown is implemented for the following filters: <code>&gt;</code>, <code>&gt;=</code>, <code>&lt;</code>, <code>&lt;=</code>, <code>==</code>, <code>!=</code>, <code>isNull</code> and <code>isNotNull</code>.</p>
+
+<p>We are excited about the release of the MongoDB storage plugin, and we believe that Drill is the perfect SQL query tool for MongoDB.</p>
+
+  </article>
+ <div id="disqus_thread"></div>
+    <script type="text/javascript">
+        /* * * CONFIGURATION VARIABLES: EDIT BEFORE PASTING INTO YOUR WEBPAGE * * */
+        var disqus_shortname = 'drill'; // required: replace example with your forum shortname
+
+        /* * * DON'T EDIT BELOW THIS LINE * * */
+        (function() {
+            var dsq = document.createElement('script'); dsq.type = 'text/javascript'; dsq.async = true;
+            dsq.src = '//' + disqus_shortname + '.disqus.com/embed.js';
+            (document.getElementsByTagName('head')[0] || document.getElementsByTagName('body')[0]).appendChild(dsq);
+        })();
+    </script>
+    <noscript>Please enable JavaScript to view the <a href="http://disqus.com/?ref_noscript">comments powered by Disqus.</a></noscript>
+    
+</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 Incubator, 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/>
+<strong>DISCLAIMER</strong><br/>
+Apache Drill is an effort undergoing incubation at The Apache Software Foundation sponsored by the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further<br/>
+review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not<br/>
+necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.
+</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/blog/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/blog/index.html?rev=1641986&view=auto
==============================================================================
--- drill/site/trunk/content/drill/blog/index.html (added)
+++ drill/site/trunk/content/drill/blog/index.html Thu Nov 27 01:28:55 2014
@@ -0,0 +1,102 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+
+
+<title>Blog - 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/incubator-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>Blog</h1>
+
+</div>
+										
+<div class="int_text" align="left"><!-- previously: site.posts -->
+<p><a class="post-link" href="/blog/2014/11/19/sql-on-mongodb/">SQL on MongoDB</a> (Nov 19, 2014)<br/>The MongoDB storage plugin for Drill enables analytical queries on MongoDB databases. Drill's schema-free JSON data model is a natural fit for MongoDB's data model.</p>
+
+<p class="info">Want to contribute a blog post? Check out the source for some of the <a href="https://github.com/tshiran/drill-website/tree/gh-pages/blog/_posts">existing posts</a> to see how it's done. When you're ready, email your Markdown file to <a href="mailto:dev@drill.apache.org">dev@drill.apache.org</a>.</p>
+<h1>Third-Party Articles</h1>
+<!-- previously: site.posts -->
+<p><a class="post-link" href="https://www.mapr.com/blog/how-turn-raw-data-yelp-insights-minutes-apache-drill">How to Turn Raw Data from Yelp into Insights in Minutes with Apache Drill</a> (Nov 13, 2014)<br/></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 Incubator, 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/>
+<strong>DISCLAIMER</strong><br/>
+Apache Drill is an effort undergoing incubation at The Apache Software Foundation sponsored by the Apache Incubator PMC. Incubation is required of all newly accepted projects until a further<br/>
+review indicates that the infrastructure, communications, and decision making process have stabilized in a manner consistent with other successful ASF projects. While incubation status is not<br/>
+necessarily a reflection of the completeness or stability of the code, it does indicate that the project has yet to be fully endorsed by the ASF.
+</div>
+</div>
+
+<script>
+(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ga('create', 'UA-53379651-1', 'auto');
+ga('send', 'pageview');
+</script>
+
+</body>
+</html>

Modified: drill/site/trunk/content/drill/community/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/community/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/community/index.html (original)
+++ drill/site/trunk/content/drill/community/index.html Thu Nov 27 01:28:55 2014
@@ -6,20 +6,20 @@
 <meta charset="UTF-8">
 
 
-<title>Community1 - Apache Drill</title>
+<title>Community - Apache Drill</title>
 
-<link href="/drill/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/style.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/button.css" rel="stylesheet" type="text/css">
-
-<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon">
-<link rel="icon" href="/drill/favicon.ico" type="image/x-icon">
-
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery.easing.1.3.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/modernizr.custom.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script>
+<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>
 
@@ -33,37 +33,37 @@
 
 <div id="menu" class="mw">
 <ul>
-  <li class="logo"><a href="/drill/"></a></li>
+  <li class="logo"><a href="/"></a></li>
   <li>
-    <a href="/drill/overview/">Documentation</a>
+    <a href="/overview/">Documentation</a>
     <ul>
-      <li><a href="/drill/overview/">Overview&nbsp;&nbsp;&nbsp;&nbsp;</a></li>
+      <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="/drill/why/">Why Drill? &nbsp;&nbsp;&nbsp;&nbsp;</a></li>
-      <li><a href="/drill/architecture/">Architecture</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="/drill/community/">Community</a>
+    <a href="/community/">Community</a>
     <ul>
-      <li><a href="/drill/team/">Team</a></li>
-      <li><a href="/drill/community/#events">Events and Meetups</a></li>
-      <li><a href="/drill/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/drill/community/#getinvolved">Get Involved</a></li>
+      <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/incubator-drill" target="_blank">GitHub</a></li>
     </ul>
   </li>
-  <li><a href="/drill/faq/">FAQ</a></li>
-  <li><a href="http://drill-user.org" target="_blank">Blog</a></li>
-	<li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/drill/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </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="/drill/download/">Download</a></li>
+  <li class="d"><a href="/download/">Download</a></li>
 </ul>
 </div>
 
 <div class="int_title">
-<h1>Community1</h1>
+<h1>Community</h1>
 
 </div>
 										
@@ -174,6 +174,15 @@
                         <td>Jim Bates</td>
                         <td><a rel="nofollow" href="http://globalbigdatabootcamp.com/" target="_new">Click Here</a></td>
                     </tr>
+										<tr>
+                        <td>12/10/14</td>
+                        <td>Houston Hadoop Meetup</td>
+                        <td>Houston</td>
+                        <td>Jim Bates</td>
+                        <td><a rel="nofollow" href="http://www.meetup.com/Houston-Hadoop-Meetup-Group/events/218626903/" target="_new">Click Here</a></td>
+                    </tr>
+										      	
+
                 </tbody>
             </table>
 

Added: drill/site/trunk/content/drill/css/main.css
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/css/main.css?rev=1641986&view=auto
==============================================================================
--- drill/site/trunk/content/drill/css/main.css (added)
+++ drill/site/trunk/content/drill/css/main.css Thu Nov 27 01:28:55 2014
@@ -0,0 +1,449 @@
+/**
+ * Reset some basic elements
+ */
+body, h1, h2, h3, h4, h5, h6,
+p, blockquote, pre, hr,
+dl, dd, ol, ul, figure {
+  margin: 0;
+  padding: 0; }
+
+/**
+ * Basic styling
+ */
+body {
+  font-family: Helvetica, Arial, sans-serif;
+  font-size: 16px;
+  line-height: 1.5;
+  font-weight: 300;
+  color: #111;
+  background-color: #fdfdfd;
+  -webkit-text-size-adjust: 100%; }
+
+/**
+ * Set `margin-bottom` to maintain vertical rhythm
+ */
+h1, h2, h3, h4, h5, h6,
+p, blockquote, pre,
+ul, ol, dl, figure,
+.highlight {
+  margin-bottom: 15px; }
+
+/**
+ * Images
+ */
+img {
+  max-width: 100%;
+  vertical-align: middle; }
+
+/**
+ * Figures
+ */
+figure > img {
+  display: block; }
+
+figcaption {
+  font-size: 14px; }
+
+/**
+ * Lists
+ */
+ul, ol {
+  margin-left: 30px; }
+
+li > ul,
+li > ol {
+  margin-bottom: 0; }
+
+/**
+ * Headings
+ */
+h1, h2, h3, h4, h5, h6 {
+  font-weight: 300; }
+
+/**
+ * Links
+ */
+a {
+  color: #2a7ae2;
+  text-decoration: none; }
+  a:visited {
+    color: #1756a9; }
+  a:hover {
+    color: #111;
+    text-decoration: underline; }
+
+/**
+ * Blockquotes
+ */
+blockquote {
+  color: #828282;
+  border-left: 4px solid #e8e8e8;
+  padding-left: 15px;
+  font-size: 18px;
+  letter-spacing: -1px;
+  font-style: italic; }
+  blockquote > :last-child {
+    margin-bottom: 0; }
+
+/**
+ * Code formatting
+ */
+pre,
+code {
+  font-size: 15px;
+  border: 1px solid #e8e8e8;
+  border-radius: 3px;
+  background-color: #eef; }
+
+code {
+  padding: 1px 5px; }
+
+pre {
+  padding: 8px 12px;
+  overflow-x: scroll; }
+  pre > code {
+    border: 0;
+    padding-right: 0;
+    padding-left: 0; }
+
+/**
+ * Wrapper
+ */
+.wrapper {
+  max-width: -webkit-calc(800px - (30px * 2));
+  max-width: calc(800px - (30px * 2));
+  margin-right: auto;
+  margin-left: auto;
+  padding-right: 30px;
+  padding-left: 30px; }
+  @media screen and (max-width: 800px) {
+    .wrapper {
+      max-width: -webkit-calc(800px - (30px));
+      max-width: calc(800px - (30px));
+      padding-right: 15px;
+      padding-left: 15px; } }
+
+/**
+ * Clearfix
+ */
+.wrapper:after, .footer-col-wrapper:after {
+  content: "";
+  display: table;
+  clear: both; }
+
+/**
+ * Icons
+ */
+.icon > svg {
+  display: inline-block;
+  width: 16px;
+  height: 16px;
+  vertical-align: middle; }
+  .icon > svg path {
+    fill: #828282; }
+
+/**
+ * Site header
+ */
+.site-header {
+  border-top: 5px solid #424242;
+  border-bottom: 1px solid #e8e8e8;
+  min-height: 56px;
+  position: relative; }
+
+.site-title {
+  font-size: 26px;
+  line-height: 56px;
+  letter-spacing: -1px;
+  margin-bottom: 0;
+  float: left; }
+  .site-title, .site-title:visited {
+    color: #424242; }
+
+.site-nav {
+  float: right;
+  line-height: 56px; }
+  .site-nav .menu-icon {
+    display: none; }
+  .site-nav .page-link {
+    color: #111;
+    line-height: 1.5; }
+    .site-nav .page-link:not(:first-child) {
+      margin-left: 20px; }
+  @media screen and (max-width: 600px) {
+    .site-nav {
+      position: absolute;
+      top: 9px;
+      right: 30px;
+      background-color: #fdfdfd;
+      border: 1px solid #e8e8e8;
+      border-radius: 5px;
+      text-align: right; }
+      .site-nav .menu-icon {
+        display: block;
+        float: right;
+        width: 36px;
+        height: 26px;
+        line-height: 0;
+        padding-top: 10px;
+        text-align: center; }
+        .site-nav .menu-icon > svg {
+          width: 18px;
+          height: 15px; }
+          .site-nav .menu-icon > svg path {
+            fill: #424242; }
+      .site-nav .trigger {
+        clear: both;
+        display: none; }
+      .site-nav:hover .trigger {
+        display: block;
+        padding-bottom: 5px; }
+      .site-nav .page-link {
+        display: block;
+        padding: 5px 10px; } }
+
+/**
+ * Site footer
+ */
+.site-footer {
+  border-top: 1px solid #e8e8e8;
+  padding: 30px 0; }
+
+.footer-heading {
+  font-size: 18px;
+  margin-bottom: 15px; }
+
+.contact-list,
+.social-media-list {
+  list-style: none;
+  margin-left: 0; }
+
+.footer-col-wrapper {
+  font-size: 15px;
+  color: #828282;
+  margin-left: -15px; }
+
+.footer-col {
+  float: left;
+  margin-bottom: 15px;
+  padding-left: 15px; }
+
+.footer-col-1 {
+  width: -webkit-calc(35% - (30px / 2));
+  width: calc(35% - (30px / 2)); }
+
+.footer-col-2 {
+  width: -webkit-calc(20% - (30px / 2));
+  width: calc(20% - (30px / 2)); }
+
+.footer-col-3 {
+  width: -webkit-calc(45% - (30px / 2));
+  width: calc(45% - (30px / 2)); }
+
+@media screen and (max-width: 800px) {
+  .footer-col-1,
+  .footer-col-2 {
+    width: -webkit-calc(50% - (30px / 2));
+    width: calc(50% - (30px / 2)); }
+
+  .footer-col-3 {
+    width: -webkit-calc(100% - (30px / 2));
+    width: calc(100% - (30px / 2)); } }
+@media screen and (max-width: 600px) {
+  .footer-col {
+    float: none;
+    width: -webkit-calc(100% - (30px / 2));
+    width: calc(100% - (30px / 2)); } }
+/**
+ * Page content
+ */
+.page-content {
+  padding: 30px 0; }
+
+.page-heading {
+  font-size: 20px; }
+
+.post-list {
+  margin-left: 0;
+  list-style: none; }
+  .post-list > li {
+    margin-bottom: 30px; }
+
+.post-meta {
+  font-size: 14px;
+  color: #828282; }
+
+.post-link {
+  display: block;
+  font-size: 24px; }
+
+/**
+ * Posts
+ */
+.post-header {
+  margin-bottom: 30px; }
+
+.post-title {
+  font-size: 42px;
+  letter-spacing: -1px;
+  line-height: 1; }
+  @media screen and (max-width: 800px) {
+    .post-title {
+      font-size: 36px; } }
+
+.post-content {
+  margin-bottom: 30px; }
+  .post-content h2 {
+    font-size: 32px; }
+    @media screen and (max-width: 800px) {
+      .post-content h2 {
+        font-size: 28px; } }
+  .post-content h3 {
+    font-size: 26px; }
+    @media screen and (max-width: 800px) {
+      .post-content h3 {
+        font-size: 22px; } }
+  .post-content h4 {
+    font-size: 20px; }
+    @media screen and (max-width: 800px) {
+      .post-content h4 {
+        font-size: 18px; } }
+
+/**
+ * Syntax highlighting styles
+ */
+.highlight {
+  background: #fff; }
+  .highlight .c {
+    color: #998;
+    font-style: italic; }
+  .highlight .err {
+    color: #a61717;
+    background-color: #e3d2d2; }
+  .highlight .k {
+    font-weight: bold; }
+  .highlight .o {
+    font-weight: bold; }
+  .highlight .cm {
+    color: #998;
+    font-style: italic; }
+  .highlight .cp {
+    color: #999;
+    font-weight: bold; }
+  .highlight .c1 {
+    color: #998;
+    font-style: italic; }
+  .highlight .cs {
+    color: #999;
+    font-weight: bold;
+    font-style: italic; }
+  .highlight .gd {
+    color: #000;
+    background-color: #fdd; }
+  .highlight .gd .x {
+    color: #000;
+    background-color: #faa; }
+  .highlight .ge {
+    font-style: italic; }
+  .highlight .gr {
+    color: #a00; }
+  .highlight .gh {
+    color: #999; }
+  .highlight .gi {
+    color: #000;
+    background-color: #dfd; }
+  .highlight .gi .x {
+    color: #000;
+    background-color: #afa; }
+  .highlight .go {
+    color: #888; }
+  .highlight .gp {
+    color: #555; }
+  .highlight .gs {
+    font-weight: bold; }
+  .highlight .gu {
+    color: #aaa; }
+  .highlight .gt {
+    color: #a00; }
+  .highlight .kc {
+    font-weight: bold; }
+  .highlight .kd {
+    font-weight: bold; }
+  .highlight .kp {
+    font-weight: bold; }
+  .highlight .kr {
+    font-weight: bold; }
+  .highlight .kt {
+    color: #458;
+    font-weight: bold; }
+  .highlight .m {
+    color: #099; }
+  .highlight .s {
+    color: #d14; }
+  .highlight .na {
+    color: #008080; }
+  .highlight .nb {
+    color: #0086B3; }
+  .highlight .nc {
+    color: #458;
+    font-weight: bold; }
+  .highlight .no {
+    color: #008080; }
+  .highlight .ni {
+    color: #800080; }
+  .highlight .ne {
+    color: #900;
+    font-weight: bold; }
+  .highlight .nf {
+    color: #900;
+    font-weight: bold; }
+  .highlight .nn {
+    color: #555; }
+  .highlight .nt {
+    color: #000080; }
+  .highlight .nv {
+    color: #008080; }
+  .highlight .ow {
+    font-weight: bold; }
+  .highlight .w {
+    color: #bbb; }
+  .highlight .mf {
+    color: #099; }
+  .highlight .mh {
+    color: #099; }
+  .highlight .mi {
+    color: #099; }
+  .highlight .mo {
+    color: #099; }
+  .highlight .sb {
+    color: #d14; }
+  .highlight .sc {
+    color: #d14; }
+  .highlight .sd {
+    color: #d14; }
+  .highlight .s2 {
+    color: #d14; }
+  .highlight .se {
+    color: #d14; }
+  .highlight .sh {
+    color: #d14; }
+  .highlight .si {
+    color: #d14; }
+  .highlight .sx {
+    color: #d14; }
+  .highlight .sr {
+    color: #009926; }
+  .highlight .s1 {
+    color: #d14; }
+  .highlight .ss {
+    color: #990073; }
+  .highlight .bp {
+    color: #999; }
+  .highlight .vc {
+    color: #008080; }
+  .highlight .vg {
+    color: #008080; }
+  .highlight .vi {
+    color: #008080; }
+  .highlight .il {
+    color: #099; }

Modified: drill/site/trunk/content/drill/css/style.css
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/css/style.css?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/css/style.css (original)
+++ drill/site/trunk/content/drill/css/style.css Thu Nov 27 01:28:55 2014
@@ -25,7 +25,7 @@ pre {
     border: 1px solid #ccc;
     border-radius: 2px;
     background-color: #f8f8f8;
-		overflow:auto;
+		overflow: auto;
 }
 
 a.anchor {
@@ -833,4 +833,15 @@ div.download table a.find {
 
 div.download table a.find:hover {
 	background-color:#145aa8;
+}
+
+p.info {
+	background-color: #ffc;
+	border: solid 1px #cc9;
+	padding: 5px;
+}
+
+/* This is to address an issue in Markdown processing which introduces <p> inside <li>. */
+li p {
+	margin-top: 0px;
 }
\ No newline at end of file

Modified: drill/site/trunk/content/drill/download/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/download/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/download/index.html (original)
+++ drill/site/trunk/content/drill/download/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Download - Apache Drill</title>
 
-<link href="/drill/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/style.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/button.css" rel="stylesheet" type="text/css">
-
-<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon">
-<link rel="icon" href="/drill/favicon.ico" type="image/x-icon">
-
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery.easing.1.3.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/modernizr.custom.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script>
+<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>
 
@@ -33,32 +33,32 @@
 
 <div id="menu" class="mw">
 <ul>
-  <li class="logo"><a href="/drill/"></a></li>
+  <li class="logo"><a href="/"></a></li>
   <li>
-    <a href="/drill/overview/">Documentation</a>
+    <a href="/overview/">Documentation</a>
     <ul>
-      <li><a href="/drill/overview/">Overview&nbsp;&nbsp;&nbsp;&nbsp;</a></li>
+      <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="/drill/why/">Why Drill? &nbsp;&nbsp;&nbsp;&nbsp;</a></li>
-      <li><a href="/drill/architecture/">Architecture</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="/drill/community/">Community</a>
+    <a href="/community/">Community</a>
     <ul>
-      <li><a href="/drill/team/">Team</a></li>
-      <li><a href="/drill/community/#events">Events and Meetups</a></li>
-      <li><a href="/drill/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/drill/community/#getinvolved">Get Involved</a></li>
+      <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/incubator-drill" target="_blank">GitHub</a></li>
     </ul>
   </li>
-  <li><a href="/drill/faq/">FAQ</a></li>
-  <li><a href="http://drill-user.org" target="_blank">Blog</a></li>
-	<li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/drill/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </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="/drill/download/">Download</a></li>
+  <li class="d"><a href="/download/">Download</a></li>
 </ul>
 </div>
 

Modified: drill/site/trunk/content/drill/faq/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/faq/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/faq/index.html (original)
+++ drill/site/trunk/content/drill/faq/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Frequently Asked Questions - Apache Drill</title>
 
-<link href="/drill/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/style.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/drill/css/button.css" rel="stylesheet" type="text/css">
-
-<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon">
-<link rel="icon" href="/drill/favicon.ico" type="image/x-icon">
-
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery-1.11.1.min.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/lib/jquery.easing.1.3.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/modernizr.custom.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script>
+<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>
 
@@ -33,32 +33,32 @@
 
 <div id="menu" class="mw">
 <ul>
-  <li class="logo"><a href="/drill/"></a></li>
+  <li class="logo"><a href="/"></a></li>
   <li>
-    <a href="/drill/overview/">Documentation</a>
+    <a href="/overview/">Documentation</a>
     <ul>
-      <li><a href="/drill/overview/">Overview&nbsp;&nbsp;&nbsp;&nbsp;</a></li>
+      <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="/drill/why/">Why Drill? &nbsp;&nbsp;&nbsp;&nbsp;</a></li>
-      <li><a href="/drill/architecture/">Architecture</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="/drill/community/">Community</a>
+    <a href="/community/">Community</a>
     <ul>
-      <li><a href="/drill/team/">Team</a></li>
-      <li><a href="/drill/community/#events">Events and Meetups</a></li>
-      <li><a href="/drill/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/drill/community/#getinvolved">Get Involved</a></li>
+      <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/incubator-drill" target="_blank">GitHub</a></li>
     </ul>
   </li>
-  <li><a href="/drill/faq/">FAQ</a></li>
-  <li><a href="http://drill-user.org" target="_blank">Blog</a></li>
-	<li style="width:30px; padding-left: 2px; padding-right:10px"><a href="https://twitter.com/apachedrill" target="_blank"><img src="/drill/images/twitterbw.png" alt="" align="center" width="22" style="padding: 0px 10px 1px 0px;"></a> </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="/drill/download/">Download</a></li>
+  <li class="d"><a href="/download/">Download</a></li>
 </ul>
 </div>
 
@@ -67,110 +67,118 @@
 
 </div>
 										
-<div class="int_text" align="left">            <h3>What use cases should I consider using Drill for?</h3>
-            <p>
-            	Drill provides low latency SQL queries on large-scale datasets. Example use cases for Drill include
-                <ul>
-                	<li>Interactive data exploration/data discovery</li>
-                    <li>Adhoc BI/reporting queries</li>
-                    <li>Analytics on NoSQL data</li>
-                    <li>Real time or Day zero analytics (i.e analyze data as it comes with no preparation/ETL)</li>
-				</ul>
-           	</p>
-            <p>We expect Drill to be used in lot more use cases where low latency is required.</p>
-    
-            <h3>Does Drill replace Hive for batch processing? What about my OLTP applications?</h3>
-            <p>Drill complements batch-processing frameworks such as Hive, Pig, MapReduce to support low latency queries. Drill at this point doesn't make an optimal choice for OLTP/operational applications that require sub-second response times. </p>
-            
-            <h3>There are lots of SQL on Hadoop technologies out there. How is Drill different?</h3>
-            <p>
-                Drill takes a different approach to SQL-on-Hadoop than Hive and other related technologies. The goal for Drill is to bring the SQL ecosystem and performance of the relational systems to Hadoop-scale data without compromising on the flexibility of Hadoop/NoSQL systems. Drill provides a flexible query environment for users with the key capabilities as below.
-                <ul>
-                    <li>Self-describing data support without centralized schema definitions/management</li>
-                    <li>Support for complex/multi-structured data types</li>
-                    <li>ANSI SQL support (not SQL "Like") &amp; BI tool integration</li> 
-                    <li>Extensibility to go beyond Hadoop environments</li>
-                </ul>
-            </p>
-    
-            <h3>What is self-describing data?</h3>
-            <p>Self-describing data is where schema is specified as part of the data itself. File formats such as Parquet, JSON, ProtoBuf, XML, AVRO and NoSQL databases are all examples of self-describing data. Some of these data formats also dynamic and complex in that every record in the data can have its own set of columns/attributes and each column can be semi-structured/nested.</p>
-    
-            <h3>How does Drill support queries on self-describing data?</h3>
-            <p>
-                Drill enables queries on self-describing data using the fundamental architectural foundations as below.<br>
-                <ul>
-                    <li>Dynamic schema discovery or late binding:  Drill allows performing queries directly on self-describing data such as Files, HBase without defining overlay schema definitions in Hive metastore.  The schema is discovered on the fly at the query time. With the dynamic schema discovery, Drill makes it easy to support dynamic and rapidly evolving data models.</li>
-                    <li>Flexible data model:  Drill is built from the ground up for complex/semi-structured data commonly seen in Hadoop/NoSQL systems. Drill provides intuitive extensions to SQL to represent and operate on complex data. The internal data model of Drill is hierarchical and columnar with which it can represent and perform efficient SQL processing on complex data natively without flattening into rows either at the design time or runtime.</li> 
-                </ul>
-            </p>
-            
-            <p>Together with the dynamic data discovery and a flexible data model that can handle complex data types, Drill allows users to get fast and complete value from all their data.</p>
-    
-            <h3>But I already have schemas defined in Hive metastore? Can I use that with Drill?</h3>
-            <p>Yes, Hive also serves as data source for Drill. So you can simply point to the Hive metastore from Drill and start performing low latency queries on Hive tables with no modifications. </p>
-    
-            <h3>Is Drill trying to be "anti-schema" or "anti-dba"?</h3>
-            <p>
-                Of course not! Central EDW schemas work great if data models are not changing often, value of data is well understood and is ready to be operationalized for regular reporting purposes. However, during data exploration and discovery phase, rigid modeling requirement poses challenges and delays value from data, especially in the Hadoop/NoSQL environments where the data is highly complex, dynamic and evolving fast. Few challenges include
-                <ul>
-                    <li>Complex data models (eg: JSON)  are hard to map to relational paradigms</li>
-                    <li>Centralized schemas are hard to keep up with when data models evolve fast</li>
-                    <li>Static models defined for known questions are not enough for the diversity and volumes of big data</li>
-                    <li>Non-repetitive/ad hoc queries and short-term data exploration needs may not justify modeling costs</li>
-                </ul>
-            </p>
-    
-            <p>Drill is all about flexibility. The flexible schema management capabilities in Drill lets users explore the data in its native format as it comes in directly and create models/structure if needed in Hive metastore or using the CREATE TABLE/CREATE VIEW syntax within Drill.</p>
-    
-            <h3>What does a Drill query look like?</h3>
-            <p>Drill uses a de-centralized metadata model and relies on its storage plugins to provide with the metadata. Drill supports queries on file system (distributed and local), HBase and Hive tables. There is a storage plugin associated with each data source that is supported by Drill.<br><br>
-            Here is the anatomy of a Drill query. </p>
-            <img src="images/overview-img1.png" width="550" alt="">
-    
-            <h3>Can I connect to Drill from my BI tools (such as Tableau, Microstrategy, etc.)?</h3>
-            <p>Yes, Drill provides JDBC/ODBC drivers for integrating with BI/SQL based tools. </p>
-    
-            <h3>What SQL functionality can Drill support?</h3>
-            <p>
-                Drill provides ANSI standard SQL (not SQL "Like" or Hive QL) with support for all key analytics functionality such as SQL data types, joins, aggregations, filters, sort, sub-queries (including correlated), joins in where clause etc. <a href="https://cwiki.apache.org/confluence/display/DRILL/SQL+Overview" target="new">Click here</a> for reference on SQL functionality in Drill.
-            </p>
-    
-            <h3>What Hadoop distributions does Drill work with?</h3>
-            <p>Drill is not designed with a particular Hadoop distribution in mind and we expect it to work with all Hadoop distributions that support Hadoop 2.3.x file client API. We have validated it so far with Apache Hadoop/MapR/CDH and Amazon EMR* distributions.</p>
-            <p><em style="font-size:14px">* Custom configuration required. Please contact <a href="drill-user@incubator.apache.org">drill-user@incubator.apache.org</a> for questions</em></p>
-            
-            <h3>How does Drill achieve performance?</h3>
-            <p>
-                Drill is built from the ground up for performance on large-scale datasets. The key architectural components that help in achieving performance include. 
-                <ul>
-                    <li>Distributed query optimization &amp; execution</li>
-                    <li>Columnar execution</li>
-                    <li>Vectorization</li>
-                    <li>Runtime compilation &amp; code generation</li>
-                    <li>Optimistic/pipelined execution</li>
-                </ul>
-            </p>
-    
-            <h3>Does Drill support multi-tenant/high concurrency environments?</h3>
-            <p>Drill is built to support several 100s of queries at any given point. Clients can submit requests to any node running Drillbit service in the cluster (no master-slave concept). To support more users, you simply have to add more nodes to the cluster.</p>
-            
-            <h3>Do I need to load data into Drill to start querying it?</h3>
-            <p>No. Drill can query data "in situ".</p>
-    
-            <h3>What is the best way to get started with Drill?</h3>
-            <p>The best way to get started is to just try it out. It just takes a few minutes even if you do not have a cluster. Here is a good place to start -  <a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes" target="_new">Apache Drill in 10 minutes.</a></p>
-    
-    
-            <h3>How can I ask questions and provide feedback?</h3>
-            <p>Please post your questions and feedback on <a href="mailto:drill-user@incubator.apache.org">drill-user@incubator.apache.org</a>. We are happy to have you try out Drill and help with any questions!</p>
-    
-            <h3>How can I contribute to Drill?</h3>
-            <p>
-                Please refer to the <a href="/drill/community/#getinvolved">Get Involved</a> page on how to get involved with Drill.<br>
-                <a href="https://cwiki.apache.org/confluence/display/DRILL/Contributing" target="_new">Here is how you can contribute.</a><br>
-                Please contact <a href="mailto:drill-dev@incubator.apache.org">drill-dev@incubator.apache.org</a> for any questions.
-            </p></div>
+<div class="int_text" align="left"><h2>What use cases should I consider using Drill for?</h2>
+
+<p>Drill provides low latency SQL queries on large-scale datasets. Example use cases for Drill include</p>
+
+<ul>
+<li>Interactive data exploration/data discovery</li>
+<li>Adhoc BI/reporting queries</li>
+<li>Analytics on NoSQL data</li>
+<li>Real time or Day zero analytics (i.e analyze data as it comes with no preparation/ETL)</li>
+</ul>
+
+<p>We expect Drill to be used in lot more use cases where low latency is required.</p>
+
+<h2>Does Drill replace Hive for batch processing? What about my OLTP applications?</h2>
+
+<p>Drill complements batch-processing frameworks such as Hive, Pig, MapReduce to support low latency queries. Drill at this point doesn&#39;t make an optimal choice for OLTP/operational applications that require sub-second response times.</p>
+
+<h2>There are lots of SQL on Hadoop technologies out there. How is Drill different?</h2>
+
+<p>Drill takes a different approach to SQL-on-Hadoop than Hive and other related technologies. The goal for Drill is to bring the SQL ecosystem and performance of the relational systems to Hadoop-scale data without compromising on the flexibility of Hadoop/NoSQL systems. Drill provides a flexible query environment for users with the key capabilities as below.</p>
+
+<ul>
+<li>Self-describing data support without centralized schema definitions/management</li>
+<li>Support for complex/multi-structured data types</li>
+<li>ANSI SQL support (not SQL &quot;Like&quot;) &amp; BI tool integration</li>
+<li>Extensibility to go beyond Hadoop environments</li>
+</ul>
+
+<h2>What is self-describing data?</h2>
+
+<p>Self-describing data is where schema is specified as part of the data itself. File formats such as Parquet, JSON, ProtoBuf, XML, AVRO and NoSQL databases are all examples of self-describing data. Some of these data formats also dynamic and complex in that every record in the data can have its own set of columns/attributes and each column can be semi-structured/nested.</p>
+
+<h2>How does Drill support queries on self-describing data?</h2>
+
+<p>Drill enables queries on self-describing data using the fundamental architectural foundations:</p>
+
+<ul>
+<li>Dynamic schema discovery or late binding:  Drill allows performing queries directly on self-describing data such as Files, HBase without defining overlay schema definitions in Hive metastore.  The schema is discovered on the fly at the query time. With the dynamic schema discovery, Drill makes it easy to support dynamic and rapidly evolving data models.</li>
+<li>Flexible data model:  Drill is built from the ground up for complex/semi-structured data commonly seen in Hadoop/NoSQL systems. Drill provides intuitive extensions to SQL to represent and operate on complex data. The internal data model of Drill is hierarchical and columnar with which it can represent and perform efficient SQL processing on complex data natively without flattening into rows either at the design time or runtime.</li>
+</ul>
+
+<p>Together with the dynamic data discovery and a flexible data model that can handle complex data types, Drill allows users to get fast and complete value from all their data.</p>
+
+<h2>But I already have schemas defined in Hive metastore? Can I use that with Drill?</h2>
+
+<p>Yes, Hive also serves as data source for Drill. So you can simply point to the Hive metastore from Drill and start performing low latency queries on Hive tables with no modifications.</p>
+
+<h2>Is Drill trying to be &quot;anti-schema&quot; or &quot;anti-DBA&quot;?</h2>
+
+<p>Of course not! Central EDW schemas work great if data models are not changing often, value of data is well understood and is ready to be operationalized for regular reporting purposes. However, during data exploration and discovery phase, rigid modeling requirement poses challenges and delays value from data, especially in the Hadoop/NoSQL environments where the data is highly complex, dynamic and evolving fast. Few challenges include</p>
+
+<ul>
+<li>Complex data models (eg: JSON)  are hard to map to relational paradigms</li>
+<li>Centralized schemas are hard to keep up with when data models evolve fast</li>
+<li>Static models defined for known questions are not enough for the diversity and volumes of big data</li>
+<li>Non-repetitive/ad hoc queries and short-term data exploration needs may not justify modeling costs</li>
+</ul>
+
+<p>Drill is all about flexibility. The flexible schema management capabilities in Drill lets users explore the data in its native format as it comes in directly and create models/structure if needed in Hive metastore or using the CREATE TABLE/CREATE VIEW syntax within Drill.</p>
+
+<h2>What does a Drill query look like?</h2>
+
+<p>Drill uses a de-centralized metadata model and relies on its storage plugins to provide with the metadata. Drill supports queries on file system (distributed and local), HBase and Hive tables. There is a storage plugin associated with each data source that is supported by Drill.</p>
+
+<p>Here is the anatomy of a Drill query.</p>
+
+<p><img src="/images/overview-img1.png" alt=""></p>
+
+<h2>Can I connect to Drill from my BI tools (Tableau, MicroStrategy, etc.)?</h2>
+
+<p>Yes, Drill provides JDBC/ODBC drivers for integrating with BI/SQL based tools.</p>
+
+<h2>What SQL functionality can Drill support?</h2>
+
+<p>Drill provides ANSI standard SQL (not SQL &quot;Like&quot; or Hive QL) with support for all key analytics functionality such as SQL data types, joins, aggregations, filters, sort, sub-queries (including correlated), joins in where clause etc. <a href="https://cwiki.apache.org/confluence/display/DRILL/SQL+Overview">Click here</a> for reference on SQL functionality in Drill.</p>
+
+<h2>What Hadoop distributions does Drill work with?</h2>
+
+<p>Drill is not designed with a particular Hadoop distribution in mind and we expect it to work with all Hadoop distributions that support Hadoop 2.3.x+ API. We have validated it so far with Apache Hadoop/MapR/CDH/Amazon EMR distributions (Amazon EMR requires a custom configuration required - contact <a href="mailto:drill-user@incubator.apache.org">drill-user@incubator.apache.org</a> for questions.</p>
+
+<h2>How does Drill achieve performance?</h2>
+
+<p>Drill is built from the ground up for performance on large-scale datasets. The key architectural components that help in achieving performance include. </p>
+
+<ul>
+<li>Distributed query optimization &amp; execution</li>
+<li>Columnar execution</li>
+<li>Vectorization</li>
+<li>Runtime compilation &amp; code generation</li>
+<li>Optimistic/pipelined execution</li>
+</ul>
+
+<h2>Does Drill support multi-tenant/high concurrency environments?</h2>
+
+<p>Drill is built to support several 100s of queries at any given point. Clients can submit requests to any node running Drillbit service in the cluster (no master-slave concept). To support more users, you simply have to add more nodes to the cluster.</p>
+
+<h2>Do I need to load data into Drill to start querying it?</h2>
+
+<p>No. Drill can query data &quot;in situ&quot;.</p>
+
+<h2>What is the best way to get started with Drill?</h2>
+
+<p>The best way to get started is to just try it out. It just takes a few minutes even if you do not have a cluster. Here is a good place to start: <a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+in+10+Minutes">Apache Drill in 10 minutes</a>.</p>
+
+<h2>How can I ask questions and provide feedback?</h2>
+
+<p>Please post your questions and feedback on <a href="mailto:drill-user@incubator.apache.org">drill-user@incubator.apache.org</a>. We are happy to have you try out Drill and help with any questions!</p>
+
+<h2>How can I contribute to Drill?</h2>
+
+<p>Please refer to the <a href="/community/#getinvolved">Get Involved</a> page on how to get involved with Drill.</p>
+</div>
 
 
 <div id="footer" class="mw">



Mime
View raw message