drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject svn commit: r1641986 [2/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
Added: drill/site/trunk/content/drill/feed.xml
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/feed.xml?rev=1641986&view=auto
==============================================================================
--- drill/site/trunk/content/drill/feed.xml (added)
+++ drill/site/trunk/content/drill/feed.xml Thu Nov 27 01:28:55 2014
@@ -0,0 +1,172 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
+  <channel>
+    <title>Apache Drill - Self-Service Data Exploration</title>
+    <description>Write an awesome description for your new site here. You can edit this line in _config.yml. It will appear in your document head meta (for Google search results) and in your feed.xml site description.
+</description>
+    <link>/</link>
+    <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
+    <pubDate>Wed, 26 Nov 2014 17:22:07 -0800</pubDate>
+    <lastBuildDate>Wed, 26 Nov 2014 17:22:07 -0800</lastBuildDate>
+    <generator>Jekyll v2.5.1</generator>
+    
+      <item>
+        <title>SQL on MongoDB</title>
+        <description>&lt;p&gt;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.&lt;/p&gt;
+
+&lt;p&gt;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.&lt;/p&gt;
+
+&lt;p&gt;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 &lt;a href=&quot;http://incubator.apache.org/drill/download/&quot;&gt;Drill 0.6 release&lt;/a&gt;.&lt;/p&gt;
+
+&lt;p&gt;The instructions are divided into the following subtopics:&lt;/p&gt;
+
+&lt;ul&gt;
+&lt;li&gt;Drill and Mongo setup (standalone/replicated/sharded)&lt;/li&gt;
+&lt;li&gt;Running queries&lt;/li&gt;
+&lt;li&gt;Securely accessing MongoDB&lt;/li&gt;
+&lt;li&gt;Optimizations&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h2&gt;Drill and MongoDB Setup (Standalone/Replicated/Sharded)&lt;/h2&gt;
+
+&lt;h3&gt;Standalone&lt;/h3&gt;
+
+&lt;ul&gt;
+&lt;li&gt;Start &lt;code&gt;mongod&lt;/code&gt; process (&lt;a href=&quot;http://docs.mongodb.org/manual/installation/&quot;&gt;Install MongoDB&lt;/a&gt;)&lt;/li&gt;
+&lt;li&gt;Start Drill in embedded mode (&lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Embedded+Mode&quot;&gt;Installing Drill in Embedded Mode&lt;/a&gt; &amp;amp; &lt;a href=&quot;https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=44994063&quot;&gt;Starting/Stopping Drill&lt;/a&gt;) &lt;/li&gt;
+&lt;li&gt;Access the Web UI through the local drillbit: &lt;a href=&quot;http://localhost:8047/&quot;&gt;http://localhost:8047/&lt;/a&gt;&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;Enable the Mongo storage plugin and update its configuration:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-json&quot; data-lang=&quot;json&quot;&gt;&lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;type&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongo&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;connection&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongodb://localhost:27017&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;enabled&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;kc&quot;&gt;true&lt;/span&gt;
+&lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;By default, &lt;code&gt;mongod&lt;/code&gt; listens on port 27017.&lt;/p&gt;
+
+&lt;p&gt;&lt;img src=&quot;/static/sql-on-mongodb/standalone.png&quot; alt=&quot;Drill on MongoDB in standalone mode&quot;&gt;&lt;/p&gt;
+
+&lt;h3&gt;Replica Set&lt;/h3&gt;
+
+&lt;ul&gt;
+&lt;li&gt;Start &lt;code&gt;mongod&lt;/code&gt; processes in replication mode&lt;/li&gt;
+&lt;li&gt;Start Drill in distributed mode (&lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode&quot;&gt;Installing Drill in Distributed Mode&lt;/a&gt; &amp;amp; &lt;a href=&quot;https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=44994063&quot;&gt;Starting/Stopping Drill&lt;/a&gt;)&lt;/li&gt;
+&lt;li&gt;Access the Web UI through any drillbit: &lt;a href=&quot;http://drillbit2:8047&quot;&gt;http://drillbit2:8047&lt;/a&gt;&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;Enable the Mongo storage plugin and update its configuration:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-json&quot; data-lang=&quot;json&quot;&gt;&lt;span class=&quot;p&quot;&gt;{&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;type&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongo&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;connection&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongodb://&amp;lt;host1&amp;gt;:&amp;lt;port1&amp;gt;,&amp;lt;host2&amp;gt;:&amp;lt;port2&amp;gt;&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;enabled&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;kc&quot;&gt;true&lt;/span&gt;
+&lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+&lt;p&gt;Where &lt;code&gt;host1&lt;/code&gt; and &lt;code&gt;host2&lt;/code&gt; are &lt;code&gt;mongod&lt;/code&gt; hostnames in the replica set.&lt;/p&gt;&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;&lt;img src=&quot;/static/sql-on-mongodb/replicated.png&quot; alt=&quot;Drill on MongoDB in replicated mode&quot;&gt;&lt;/p&gt;
+
+&lt;p&gt;In replicated mode, whichever drillbit receives the query connects to the nearest &lt;code&gt;mongod&lt;/code&gt; (local &lt;code&gt;mongod&lt;/code&gt;) to read the data.&lt;/p&gt;
+
+&lt;h3&gt;Sharded/Sharded with Replica Set&lt;/h3&gt;
+
+&lt;ul&gt;
+&lt;li&gt;Start Mongo processes in sharded mode&lt;/li&gt;
+&lt;li&gt;Start Drill in distributed mode (&lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/Installing+Drill+in+Distributed+Mode&quot;&gt;Installing Drill in Distributed Mode&lt;/a&gt; &amp;amp; &lt;a href=&quot;https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=44994063&quot;&gt;Starting/Stopping Drill&lt;/a&gt;)&lt;/li&gt;
+&lt;li&gt;Access the Web UI through any drillbit: &lt;a href=&quot;http://drillbit3:8047&quot;&gt;http://drillbit3:8047&lt;/a&gt;&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;Enable the Mongo storage plugin and update its configuration:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-json&quot; data-lang=&quot;json&quot;&gt;&lt;span class=&quot;p&quot;&gt;{&lt;/span&gt; 
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;type&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongo&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;connection&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongodb://&amp;lt;host1&amp;gt;:&amp;lt;port1&amp;gt;,&amp;lt;host2&amp;gt;:&amp;lt;port2&amp;gt;&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;enabled&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;kc&quot;&gt;true&lt;/span&gt;
+&lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+&lt;p&gt;Where &lt;code&gt;host1&lt;/code&gt; and &lt;code&gt;host2&lt;/code&gt; are the &lt;code&gt;mongos&lt;/code&gt; hostnames.&lt;/p&gt;&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;&lt;img src=&quot;/static/sql-on-mongodb/sharded.png&quot; alt=&quot;Drill on MongoDB in sharded mode&quot;&gt;&lt;/p&gt;
+
+&lt;p&gt;In sharded mode, drillbit first connects to the &lt;code&gt;mongos&lt;/code&gt; server to get the shard information.&lt;/p&gt;
+
+&lt;h2&gt;Endpoint Assignments&lt;/h2&gt;
+
+&lt;p&gt;Drill is designed to maximize data locality:&lt;/p&gt;
+
+&lt;ul&gt;
+&lt;li&gt;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.&lt;/li&gt;
+&lt;li&gt;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.&lt;/li&gt;
+&lt;li&gt;When some of drillbits and shards are colocated, and some of them are running on different machines, partial data locality is achieved.&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;h2&gt;Running Queries&lt;/h2&gt;
+
+&lt;p&gt;Here is a simple exercise that provides steps for creating an &lt;code&gt;empinfo&lt;/code&gt; collection in an &lt;code&gt;employee&lt;/code&gt; database in Mongo that you can query using Drill:&lt;/p&gt;
+
+&lt;ol&gt;
+&lt;li&gt;Download &lt;a href=&quot;http://media.mongodb.org/zips.json&quot;&gt;zips.json&lt;/a&gt; and the &lt;a href=&quot;/static/sql-on-mongodb/empinfo.json&quot;&gt;empinfo.json&lt;/a&gt; dataset referenced at the end of blog.&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;Import the zips.json and empinfo.json files into Mongo using the following command:  &lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;mongoimport --host localhost --db &lt;span class=&quot;nb&quot;&gt;test&lt;/span&gt; --collection zips &amp;lt; zips.json
+mongoimport --host localhost --db employee --collection empinfo &amp;lt; empinfo.json
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;Issue the following queries either from sqlline (Drill’s shell) or from the Drill Web UI to get corresponding results from the Mongo collection. &lt;/p&gt;
+
+&lt;ul&gt;
+&lt;li&gt;To issue queries from the web UI, open the Drill web UI and go to Query tab. &lt;/li&gt;
+&lt;li&gt;&lt;p&gt;To issue queries from sqlline, connect to sqlline using the following command: &lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-bash&quot; data-lang=&quot;bash&quot;&gt;&amp;lt;DRILLHOME&amp;gt;/bin/sqlline -u jdbc:drill:zk&lt;span class=&quot;o&quot;&gt;=&lt;/span&gt;zkhost:2181 -n admin -p admin
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;&lt;/li&gt;
+&lt;/ul&gt;&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;Queries:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-sql&quot; data-lang=&quot;sql&quot;&gt;&lt;span class=&quot;k&quot;&gt;SELECT&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;first_name&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;last_name&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;position_id&lt;/span&gt;
+&lt;span class=&quot;k&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;mongo&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;employee&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;`&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;empinfo&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;`&lt;/span&gt;
+&lt;span class=&quot;k&quot;&gt;WHERE&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;employee_id&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;mi&quot;&gt;1107&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;AND&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;position_id&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;mi&quot;&gt;17&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;AND&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;last_name&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;s1&quot;&gt;&amp;#39;Yonce&amp;#39;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;  
+
+&lt;span class=&quot;k&quot;&gt;SELECT&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;city&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;sum&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pop&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt;
+&lt;span class=&quot;k&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;mongo&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;test&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;`&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;zips&lt;/span&gt;&lt;span class=&quot;o&quot;&gt;`&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;zipcodes&lt;/span&gt;
+&lt;span class=&quot;k&quot;&gt;WHERE&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;state&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;IS&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;NOT&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;NULL&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;GROUP&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;BY&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;city&lt;/span&gt;
+&lt;span class=&quot;k&quot;&gt;ORDER&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;BY&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;sum&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;(&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;pop&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;)&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;DESC&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;LIMIT&lt;/span&gt; &lt;span class=&quot;mi&quot;&gt;1&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;;&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;&lt;/li&gt;
+&lt;/ol&gt;
+
+&lt;p&gt;&lt;em&gt;Note&lt;/em&gt;: If a field contains a mixture of different data types across different records, such as both int and decimal values, then queries fail unless &lt;code&gt;store.mongo.all_text_mode = true&lt;/code&gt; and aggregations fail in that case. For more information refer to &lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1475&quot;&gt;DRILL-1475&lt;/a&gt; and &lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1460&quot;&gt;DRILL-1460&lt;/a&gt;.&lt;/p&gt;
+
+&lt;p&gt;To set &lt;code&gt;store.mongo.all_text_mode = true&lt;/code&gt;, execute the following command in sqlline:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-sql&quot; data-lang=&quot;sql&quot;&gt;&lt;span class=&quot;k&quot;&gt;alter&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;session&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;set&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;store&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;mongo&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;all_text_mode&lt;/span&gt; &lt;span class=&quot;o&quot;&gt;=&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;true&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+&lt;h2&gt;Securely Accessing MongoDB&lt;/h2&gt;
+
+&lt;p&gt;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.&lt;/p&gt;
+
+&lt;p&gt;The apache user will be able to query the zips database by using the following storage plugin configuration:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-json&quot; data-lang=&quot;json&quot;&gt;&lt;span class=&quot;p&quot;&gt;{&lt;/span&gt; 
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;type&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongo&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;connection&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongodb://apache:apache@localhost:27017/zips&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;enabled&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;kc&quot;&gt;true&lt;/span&gt;
+&lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+&lt;p&gt;The &lt;code&gt;drill&lt;/code&gt; user will be able to query the &lt;code&gt;emp&lt;/code&gt; database by using the following storage plugin configuration:&lt;/p&gt;
+&lt;div class=&quot;highlight&quot;&gt;&lt;pre&gt;&lt;code class=&quot;language-json&quot; data-lang=&quot;json&quot;&gt;&lt;span class=&quot;p&quot;&gt;{&lt;/span&gt; 
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;type&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongo&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;connection&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;s2&quot;&gt;&amp;quot;mongodb://drill:drill@localhost:27017/emp&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;,&lt;/span&gt;
+  &lt;span class=&quot;nt&quot;&gt;&amp;quot;enabled&amp;quot;&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;:&lt;/span&gt; &lt;span class=&quot;kc&quot;&gt;true&lt;/span&gt; 
+&lt;span class=&quot;p&quot;&gt;}&lt;/span&gt;
+&lt;/code&gt;&lt;/pre&gt;&lt;/div&gt;
+&lt;p&gt;&lt;em&gt;Note&lt;/em&gt;: The security patch may be included in next release. Check &lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1502&quot;&gt;DRILL-1502&lt;/a&gt; for status.&lt;/p&gt;
+
+&lt;h2&gt;Optimizations&lt;/h2&gt;
+
+&lt;p&gt;The MongoDB storage plugin supports predicate pushdown and projection pushdown. As of now, predicate pushdown is implemented for the following filters: &lt;code&gt;&amp;gt;&lt;/code&gt;, &lt;code&gt;&amp;gt;=&lt;/code&gt;, &lt;code&gt;&amp;lt;&lt;/code&gt;, &lt;code&gt;&amp;lt;=&lt;/code&gt;, &lt;code&gt;==&lt;/code&gt;, &lt;code&gt;!=&lt;/code&gt;, &lt;code&gt;isNull&lt;/code&gt; and &lt;code&gt;isNotNull&lt;/code&gt;.&lt;/p&gt;
+
+&lt;p&gt;We are excited about the release of the MongoDB storage plugin, and we believe that Drill is the perfect SQL query tool for MongoDB.&lt;/p&gt;
+</description>
+        <pubDate>Wed, 19 Nov 2014 05:50:01 -0800</pubDate>
+        <link>/blog/2014/11/19/sql-on-mongodb/</link>
+        <guid isPermaLink="true">/blog/2014/11/19/sql-on-mongodb/</guid>
+        
+        
+        <category>blog</category>
+        
+      </item>
+    
+  </channel>
+</rss>

Modified: drill/site/trunk/content/drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/index.html (original)
+++ drill/site/trunk/content/drill/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Apache Drill - Self-Service Data Exploration</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>
 
@@ -77,7 +77,7 @@
     <div class="tc">
       <h1>Apache Drill</h1>
       <h1 style="font-size:20px">Self-Service Data Exploration</h1>
-      <a href="/drill/download/" class="btn btn-1 btn-1c"><span>NOW READY FOR DOWNLOAD</span></a>
+      <a href="/download/" class="btn btn-1 btn-1c"><span>NOW READY FOR DOWNLOAD</span></a>
     </div>
   </div>
 </div>

Modified: drill/site/trunk/content/drill/overview/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/overview/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/overview/index.html (original)
+++ drill/site/trunk/content/drill/overview/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Overview - 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>
 

Added: drill/site/trunk/content/drill/static/sql-on-mongodb/empinfo.json
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/static/sql-on-mongodb/empinfo.json?rev=1641986&view=auto
==============================================================================
--- drill/site/trunk/content/drill/static/sql-on-mongodb/empinfo.json (added)
+++ drill/site/trunk/content/drill/static/sql-on-mongodb/empinfo.json Thu Nov 27 01:28:55 2014
@@ -0,0 +1,18 @@
+{"employee_id":1101,"full_name":"Steve Eurich","first_name":"Steve","last_name":"Eurich","position_id":16,"position":"Store T","isFTE":true}
+{"employee_id":1102,"full_name":"Mary Pierson","first_name":"Mary","last_name":"Pierson","position_id":16,"position":"Store T","isFTE":true}
+{"employee_id":1103,"full_name":"Leo Jones","first_name":"Leo","last_name":"Jones","position_id":16,"position":"Store Tem","isFTE":true}
+{"employee_id":1104,"full_name":"Nancy Beatty","first_name":"Nancy","last_name":"Beatty","position_id":16,"position":"Store T","isFTE":false}
+{"employee_id":1105,"full_name":"Clara McNight","first_name":"Clara","last_name":"McNight","position_id":16,"position":"Store","isFTE":true}
+{"employee_id":1106,"full_name":"Marcella Isaacs","first_name":"Marcella","last_name":"Isaacs","position_id":17,"position":"Stor","isFTE":false}
+{"employee_id":1107,"full_name":"Charlotte Yonce","first_name":"Charlotte","last_name":"Yonce","position_id":17,"position":"Stor","isFTE":true}
+{"employee_id":1108,"full_name":"Benjamin Foster","first_name":"Benjamin","last_name":"Foster","position_id":17,"position":"Stor","isFTE":false}
+{"employee_id":1109,"full_name":"John Reed","first_name":"John","last_name":"Reed","position_id":17,"position":"Store Per","isFTE":false}
+{"employee_id":1110,"full_name":"Lynn Kwiatkowski","first_name":"Lynn","last_name":"Kwiatkowski","position_id":17,"position":"St","isFTE":true}
+{"employee_id":1111,"full_name":"Donald Vann","first_name":"Donald","last_name":"Vann","position_id":17,"position":"Store Per","isFTE":false}
+{"employee_id":1112,"full_name":"William Smith","first_name":"William","last_name":"Smith","position_id":17,"position":"St","isFTE":true}
+{"employee_id":1113,"full_name":"Amy Hensley","first_name":"Amy","last_name":"Hensley","position_id":17,"position":"Store Pe","isFTE":false}
+{"employee_id":1114,"full_name":"Judy Owens","first_name":"Judy","last_name":"Owens","position_id":17,"position":"Store Per","isFTE":true}
+{"employee_id":1115,"full_name":"Frederick Castillo","first_name":"Frederick","last_name":"Castillo","position_id":17,"position":"S","isFTE":false}
+{"employee_id":1116,"full_name":"Phil Munoz","first_name":"Phil","last_name":"Munoz","position_id":17,"position":"Store Per","isFTE":false}
+{"employee_id":1117,"full_name":"Lori Lightfoot","first_name":"Lori","last_name":"Lightfoot","position_id":17,"position":"Store","isFTE":true}
+{"employee_id":1,"full_name":"Kumar","first_name":"Anil","last_name":"B","position_id":19,"position":"Store","isFTE":true}
\ No newline at end of file

Added: drill/site/trunk/content/drill/static/sql-on-mongodb/replicated.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/static/sql-on-mongodb/replicated.png?rev=1641986&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/static/sql-on-mongodb/replicated.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/static/sql-on-mongodb/sharded.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/static/sql-on-mongodb/sharded.png?rev=1641986&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/static/sql-on-mongodb/sharded.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Added: drill/site/trunk/content/drill/static/sql-on-mongodb/standalone.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/static/sql-on-mongodb/standalone.png?rev=1641986&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/static/sql-on-mongodb/standalone.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Modified: drill/site/trunk/content/drill/team/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/team/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/team/index.html (original)
+++ drill/site/trunk/content/drill/team/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Team - 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>
 
@@ -74,7 +74,7 @@
             	</p>
             	<p><strong>Current list of Drill committers:</strong></p>
 						<p>
-<strong>Jacques Nadeau</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;jacques at apache dot org&gt;
+<strong>Jacques Nadeau</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;jacques at apache dot org&gt;&nbsp;&nbsp;&nbsp;&nbsp;(PMC Chair and VP Apache Drill)
 <br><strong>Tomer Shiran</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tshiran at apache dot org&gt;
 <br><strong>Ted Dunning</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tdunning at apache dot org&gt;
 <br><strong>Jason Frantz</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;jason at apache dot org&gt;

Modified: drill/site/trunk/content/drill/why/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/why/index.html?rev=1641986&r1=1641985&r2=1641986&view=diff
==============================================================================
--- drill/site/trunk/content/drill/why/index.html (original)
+++ drill/site/trunk/content/drill/why/index.html Thu Nov 27 01:28:55 2014
@@ -8,18 +8,18 @@
 
 <title>Why Drill - 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>
 



Mime
View raw message