You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@drill.apache.org by ts...@apache.org on 2015/05/04 17:52:40 UTC

svn commit: r1677619 [17/17] - in /drill/site/trunk/content/drill: ./ architecture/ blog/ blog/2014/11/19/sql-on-mongodb/ blog/2014/12/02/drill-top-level-project/ blog/2014/12/09/running-sql-queries-on-amazon-s3/ blog/2014/12/11/apache-drill-qa-panelis...

Modified: drill/site/trunk/content/drill/feed.xml
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/feed.xml?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/feed.xml (original)
+++ drill/site/trunk/content/drill/feed.xml Mon May  4 15:52:37 2015
@@ -6,11 +6,48 @@
 </description>
     <link>/</link>
     <atom:link href="/feed.xml" rel="self" type="application/rss+xml"/>
-    <pubDate>Fri, 01 May 2015 11:13:25 -0700</pubDate>
-    <lastBuildDate>Fri, 01 May 2015 11:13:25 -0700</lastBuildDate>
+    <pubDate>Mon, 04 May 2015 08:51:11 -0700</pubDate>
+    <lastBuildDate>Mon, 04 May 2015 08:51:11 -0700</lastBuildDate>
     <generator>Jekyll v2.5.1</generator>
     
       <item>
+        <title>Drill 0.9 Released</title>
+        <description>&lt;p&gt;It has been about a month since the release of Drill 0.8, which included &lt;a href=&quot;/blog/drill-0.8-released/&quot;&gt;more than 240 improvements&lt;/a&gt;. Today we&amp;#39;re happy to announce the availability of Drill 0.9, providing additional enhancements and bug fixes. In fact, this release includes &lt;a href=&quot;https://issues.apache.org/jira/secure/ReleaseNote.jspa?projectId=12313820&amp;amp;version=12328813&quot;&gt;200 resolved JIRAs&lt;/a&gt;. Some of the noteworthy features in Drill 0.9 are:&lt;/p&gt;
+
+&lt;ul&gt;
+&lt;li&gt;&lt;strong&gt;Authentication&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-2674&quot;&gt;DRILL-2674&lt;/a&gt;). Drill now supports username/password authentication through the Java and C++ clients, as well as JDBC and ODBC. On the server-side, Drill leverages Linux PAM to securely validate the credentials. Users can choose to use an external user directory such as Active Directory or LDAP. To enable authentication, set the &lt;code&gt;security.user.auth&lt;/code&gt; option in &lt;code&gt;drill-override.conf&lt;/code&gt;.&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;Impersonation&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-2363&quot;&gt;DRILL-2363&lt;/a&gt;). Queries now execute and access resources using the identity of the user who submitted the query. Previously, all queries would run as the same user (eg, &lt;code&gt;drill&lt;/code&gt;). With the new impersonation capability, the query will fail if the submitting user does not have permission to read the requested file(s) in the distributed file system. To enable impersonation, set the &lt;code&gt;drill.exec.impersonation&lt;/code&gt; option in &lt;code&gt;drill-override.conf&lt;/code&gt;.&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;Ownership chaining&lt;/strong&gt;. Drill now allows views with different owners to be chained. This represents a very flexible access control solution. For example, an administrator with access to raw, sensitive data could create a view called &lt;code&gt;masked&lt;/code&gt; which would expose only a subset of the data to other users. The administrator would enable users to read the &lt;code&gt;masked&lt;/code&gt; view but not the raw data. Note that Drill provides an option &lt;code&gt;max_chained_user_hops&lt;/code&gt; that specifies how many ownership changed are allowed in a chain, thereby providing administrators (or data stewards) more control over sharing of data.&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;MongoDB authentication&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1502&quot;&gt;DRILL-1502&lt;/a&gt;). Drill can now connect to a MongoDB cluster that requires authentication.&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;Extended JSON datatypes&lt;/strong&gt;. Our friends at MongoDB invented &lt;a href=&quot;http://docs.mongodb.org/manual/reference/mongodb-extended-json/&quot;&gt;extended JSON&lt;/a&gt; - a set of extensions to the JSON format for supporting additional data types. We decided to embrace extended JSON in Drill. For example, standard JSON doesn&amp;#39;t have a time type, so a time could be represented as either a string or a number: &lt;code&gt;{&amp;quot;foo&amp;quot;: &amp;quot;19:20:30.450Z&amp;quot;}&lt;/code&gt; is just a string. With extended JSON, the &lt;code&gt;$time&lt;/code&gt; qualifier can be used to specify that &lt;code&gt;foo&lt;/code&gt; is a time &lt;code&gt;{&amp;quot;foo&amp;quot;: {&amp;quot;$time&amp;quot;: &amp;quot;19:20:30.450Z&amp;quot;}}&lt;/code&gt;.
+We now support a number of qualifiers including &lt;code&gt;$bin&lt;/code&gt;, &lt;code&gt;$date&lt;/code&gt;, &lt;code&gt;$time&lt;/code&gt;, &lt;code&gt;$interval&lt;/code&gt;, &lt;code&gt;$numberLong&lt;/code&gt; and &lt;code&gt;$dateDay&lt;/code&gt; (see &lt;a href=&quot;https://github.com/apache/drill/blob/master/exec/java-exec/src/test/resources/vector/complex/extended.json&quot;&gt;the example&lt;/a&gt;). We&amp;#39;re in the process of adding some additional qualifiers to make sure that all of MongoDB&amp;#39;s extended types are supported (this is particularly important when querying data in MongoDB).&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;Avro support&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1512&quot;&gt;DRILL-1512&lt;/a&gt;). Drill can now read Avro files. This patch was contributed by Andrew Selden at Elastic.co (formerly known as Elasticsearch).&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;Improved error messages&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-2675&quot;&gt;DRILL-2675&lt;/a&gt; and more). It can be challenging for a complex distributed system like Drill to translate low-level internal conditions into actionable messages to the user. This release includes several enhancements that enable Drill to accomplish just that in a variety of cases.&lt;/li&gt;
+&lt;li&gt;&lt;strong&gt;Parquet and Calcite enhancements&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1410&quot;&gt;DRILL-1410&lt;/a&gt; and &lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-1384&quot;&gt;DRILL-1384&lt;/a&gt;). Drill isn&amp;#39;t a traditional query engine - it&amp;#39;s the first analytical query engine with a JSON data model. This has required us to enhance Parquet (our columnar format) and Calcite (our SQL parser). These enhancements have now been contributed back to those projects, and Drill is using the latest versions which include these enhancements.&lt;/li&gt;
+&lt;li&gt;&lt;p&gt;&lt;strong&gt;New sys tables for memory and thread information&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-2275&quot;&gt;DRILL-2275&lt;/a&gt;). Drill includes two new &lt;code&gt;sys&lt;/code&gt; tables that provide real-time metrics about memory utilization and threads on each of the nodes in the cluster. You can run a simple &lt;code&gt;SELECT *&lt;/code&gt; to see what information is available:&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;o&quot;&gt;*&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;sys&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;drillmemory&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;o&quot;&gt;*&lt;/span&gt; &lt;span class=&quot;k&quot;&gt;FROM&lt;/span&gt; &lt;span class=&quot;n&quot;&gt;sys&lt;/span&gt;&lt;span class=&quot;p&quot;&gt;.&lt;/span&gt;&lt;span class=&quot;n&quot;&gt;drillbitthreads&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;li&gt;&lt;p&gt;&lt;strong&gt;Support for very wide tables&lt;/strong&gt; (&lt;a href=&quot;https://issues.apache.org/jira/browse/DRILL-2739&quot;&gt;DRILL-2739&lt;/a&gt;). Drill previously had some issues with tables that had more than 4095 colums. This limitation has been addressed.&lt;/p&gt;&lt;/li&gt;
+&lt;/ul&gt;
+
+&lt;p&gt;You can now &lt;a href=&quot;/download/&quot;&gt;download Drill 0.9&lt;/a&gt;. As always, you can check out the official &lt;a href=&quot;https://cwiki.apache.org/confluence/display/DRILL/Release+Notes&quot;&gt;release notes&lt;/a&gt; for more details.&lt;/p&gt;
+
+&lt;p&gt;We&amp;#39;re gearing up for Drill&amp;#39;s 1.0 release later this month. Stay tuned!&lt;/p&gt;
+
+&lt;p&gt;Happy Drilling!&lt;br&gt;
+Tomer Shiran and Jacques Nadeau&lt;/p&gt;
+</description>
+        <pubDate>Mon, 04 May 2015 00:00:00 -0700</pubDate>
+        <link>/blog/2015/05/04/drill-0.9-released/</link>
+        <guid isPermaLink="true">/blog/2015/05/04/drill-0.9-released/</guid>
+        
+        
+        <category>blog</category>
+        
+      </item>
+    
+      <item>
         <title>Apache Parquet Graduates to a Top-Level Project</title>
         <description>&lt;p&gt;It&amp;#39;s an exciting day. Apache Parquet, the de-facto standard columnar format for Hadoop, has graduated to an Apache top-level project.&lt;/p&gt;
 
@@ -502,164 +539,6 @@ Tomer Shiran&lt;/p&gt;
         
         
         <category>blog</category>
-        
-      </item>
-    
-      <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 id=&quot;drill-and-mongodb-setup-(standalone/replicated/sharded)&quot;&gt;Drill and MongoDB Setup (Standalone/Replicated/Sharded)&lt;/h2&gt;
-
-&lt;h3 id=&quot;standalone&quot;&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 id=&quot;replica-set&quot;&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 id=&quot;sharded/sharded-with-replica-set&quot;&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 id=&quot;endpoint-assignments&quot;&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 id=&quot;running-queries&quot;&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 id=&quot;securely-accessing-mongodb&quot;&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 id=&quot;optimizations&quot;&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>
     

Added: drill/site/trunk/content/drill/images/docs_intro.png
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/images/docs_intro.png?rev=1677619&view=auto
==============================================================================
Binary file - no diff available.

Propchange: drill/site/trunk/content/drill/images/docs_intro.png
------------------------------------------------------------------------------
    svn:mime-type = application/octet-stream

Modified: drill/site/trunk/content/drill/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/index.html?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/index.html (original)
+++ drill/site/trunk/content/drill/index.html Mon May  4 15:52:37 2015
@@ -12,12 +12,11 @@
 <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 href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
 <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
 <link href="/css/responsive.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">
 
@@ -37,11 +36,11 @@
 <div id="menu" class="mw">
 <ul>
   <li class='toc-categories'>
-    <a class="expand-toc-icon" href="javascript:void(0);">☰</a>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
   </li>
   <li class="logo"><a href="/"></a></li>
   <li class='expand-menu'>
-    <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'>☰</span></a>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
   </li>
   <li class='clear-float'></li>
   <li class="documentation-menu">
@@ -88,11 +87,8 @@
     <a href="/community/">Community</a>
     <ul>
       <li><a href="/team/">Team</a></li>
-      <li><a href="/community/#events">Events and Meetups</a></li>
-      <li><a href="/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/community/#getinvolved">Get Involved</a></li>
-      <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
-      <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/communityresources/">Community Resources</a></li>
     </ul>
   </li>
   <li class='nav'><a href="/faq/">FAQ</a></li>
@@ -136,10 +132,10 @@
 <div class="alertbar">
   <span class="strong">News:</span> 
   <!-- previously: site.posts -->
-  <a href="/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/">Apache Parquet Graduates to a Top-Level Project</a>
+  <a href="/blog/2015/05/04/drill-0.9-released/">Drill 0.9 Released</a>
   <span class="hor-bar"></span>
   <!-- previously: site.posts -->
-  <a href="/blog/2015/03/31/drill-0.8-released/">Drill 0.8 Released</a>
+  <a href="/blog/2015/04/30/apache-parquet-graudates-to-a-top-level-project/">Apache Parquet Graduates to a Top-Level Project</a>
 </div>
 
 <div class="mw introWrapper">

Modified: drill/site/trunk/content/drill/js/drill.js
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/js/drill.js?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/js/drill.js (original)
+++ drill/site/trunk/content/drill/js/drill.js Mon May  4 15:52:37 2015
@@ -37,11 +37,11 @@ Drill.Site = {
   },
 
   expandMenu: function(){
-    $("#menu ul li").addClass("force-expand");
+    $("#menu").addClass("force-expand");
   },
 
   contractMenu: function() {
-    $("#menu ul li").removeClass("force-expand");
+    $("#menu").removeClass("force-expand");
   },
 
   watchSearchBarMouseEnter: function() {
@@ -125,10 +125,10 @@ Drill.Docs = {
       //  This relies on .sidebar's 'left' attribute...may be a cleaner approach
       if($(".sidebar").css('left') == '0px'){
         Drill.Docs._contractSidebar();
-        //Drill.Docs._contractView();
+        Drill.Docs._contractView();
       } else {
         Drill.Docs._expandSidebar();
-        //Drill.Docs._expandView();
+        Drill.Docs._expandView();
       }
     })
   },
@@ -214,8 +214,9 @@ Drill.Docs = {
   },
 
   _expandView : function(){
-    $("nav.breadcrumbs li:first").addClass("force-expand");
+    $("nav.breadcrumbs").addClass("force-expand");
     $(".main-content").addClass("force-expand");
+    $("#footer").addClass("force-expand");
   },
 
   _contractSidebar : function() {
@@ -225,6 +226,7 @@ Drill.Docs = {
   _contractView : function() {
     $("nav.breadcrumbs li:first").removeClass("force-expand");
     $(".main-content").removeClass("force-expand");
+    $("#footer").removeClass("force-expand");
   },
 
   _make_current : function(that) {

Modified: drill/site/trunk/content/drill/js/script.js
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/js/script.js?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/js/script.js (original)
+++ drill/site/trunk/content/drill/js/script.js Mon May  4 15:52:37 2015
@@ -86,12 +86,12 @@ function moveReel(direction) {
 
 function onScroll() {
 	var ST = document.body.scrollTop || document.documentElement.scrollTop;
-	if ($("#menu.r").length) {
-		$("#menu.r").css({ top: ST+"px" });	
-	} else {
-		$("#menu").css({ top: "0px" });
-	}
+	//if ($("#menu.r").length) {
+	//	$("#menu.r").css({ top: ST+"px" });	
+	//} else {
+	//	$("#menu").css({ top: "0px" });
+	//}
 	
 	if (ST > 400) $("#subhead").addClass("show");	
 	else $("#subhead").removeClass("show");	
-}
\ No newline at end of file
+}

Added: drill/site/trunk/content/drill/mailinglists/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/mailinglists/index.html?rev=1677619&view=auto
==============================================================================
--- drill/site/trunk/content/drill/mailinglists/index.html (added)
+++ drill/site/trunk/content/drill/mailinglists/index.html Mon May  4 15:52:37 2015
@@ -0,0 +1,160 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>Mailing Lists - 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/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
+<link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
+<link href="/css/responsive.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>
+<script language="javascript" type="text/javascript" src="/js/drill.js"></script>
+
+
+</head>
+
+<body onResize="resized();">
+  <div class="page-wrap">
+    <div class="bui"></div>
+
+<div id="menu" class="mw">
+<ul>
+  <li class='toc-categories'>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
+  </li>
+  <li class="logo"><a href="/"></a></li>
+  <li class='expand-menu'>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
+  </li>
+  <li class='clear-float'></li>
+  <li class="documentation-menu">
+    <a href="/docs/">Documentation</a>
+    <ul>
+      
+        <li><a href="/docs/getting-started/">Getting Started</a></li>
+      
+        <li><a href="/docs/architecture/">Architecture</a></li>
+      
+        <li><a href="/docs/tutorials/">Tutorials</a></li>
+      
+        <li><a href="/docs/install-drill/">Install Drill</a></li>
+      
+        <li><a href="/docs/connect-a-data-source/">Connect a Data Source</a></li>
+      
+        <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+      
+        <li><a href="/docs/query-data/">Query Data</a></li>
+      
+        <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+      
+        <li><a href="/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li>
+      
+        <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li>
+      
+        <li><a href="/docs/manage-drill/">Manage Drill</a></li>
+      
+        <li><a href="/docs/developer-information/">Developer Information</a></li>
+      
+        <li><a href="/docs/release-notes/">Release Notes</a></li>
+      
+        <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
+      
+        <li><a href="/docs/archived-pages/">Archived Pages</a></li>
+      
+        <li><a href="/docs/progress-reports/">Progress Reports</a></li>
+      
+        <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+      
+    </ul>
+  </li>
+  <li class='nav'>
+    <a href="/community/">Community</a>
+    <ul>
+      <li><a href="/team/">Team</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/communityresources/">Community Resources</a></li>
+    </ul>
+  </li>
+  <li class='nav'><a href="/faq/">FAQ</a></li>
+  <li class='nav'><a href="/blog/">Blog</a></li>
+  <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill" title="apachedrill on twitter" target="_blank"><img src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> </li>
+  <li class='search-bar'>
+    <form id="drill-search-form">
+      <input type="text" placeholder="Search Apache Drill" id="drill-search-term" />
+      <button type="submit">
+        <i class="fa fa-search"></i>
+      </button>
+    </form>
+  </li>
+  <li class="d">
+    <a href="/download/">
+      <i class="fa fa-cloud-download"></i> Download
+    </a>
+  </li>
+</ul>
+</div>
+
+    <div class="int_title">
+<h1>Mailing Lists</h1>
+  
+</div>
+
+<div class="int_text" align="left"><p>All communication related to the Apache Drill project happens on the mailing lists:</p>
+
+<ul>
+<li><strong>User</strong> (this is where you should ask for help if you have any questions or issues)
+
+<ul>
+<li>Subscribe: <a href="mailto:user-subscribe@drill.apache.org">user-subscribe@drill.apache.org</a></li>
+<li>Unsubscribe: <a href="mailto:user-unsubscribe@drill.apache.org">user-unsubscribe@drill.apache.org</a></li>
+<li>Post: <a href="mailto:user@drill.apache.org">user@drill.apache.org</a></li>
+<li><a href="http://mail-archives.apache.org/mod_mbox/drill-user/">Archive</a></li>
+</ul></li>
+<li><strong>Dev</strong>
+
+<ul>
+<li>Subscribe: <a href="mailto:dev-subscribe@drill.apache.org">dev-subscribe@drill.apache.org</a></li>
+<li>Unsubscribe: <a href="mailto:dev-unsubscribe@drill.apache.org">dev-unsubscribe@drill.apache.org</a></li>
+<li>Post: <a href="mailto:dev@drill.apache.org">dev@drill.apache.org</a></li>
+<li><a href="http://mail-archives.apache.org/mod_mbox/drill-dev/">Archive</a></li>
+</ul></li>
+</ul>
+</div>
+
+  </div>
+  <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2014 The Apache Software Foundation, licensed under the Apache License, Version 2.0.<br>
+Apache and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.<br/><br/>
+</div>
+</div>
+
+  <script>
+(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
+(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
+m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
+})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
+
+ga('create', 'UA-53379651-1', 'auto');
+ga('send', 'pageview');
+</script>
+
+</body>
+</html>

Modified: drill/site/trunk/content/drill/overview/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/overview/index.html?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/overview/index.html (original)
+++ drill/site/trunk/content/drill/overview/index.html Mon May  4 15:52:37 2015
@@ -12,12 +12,11 @@
 <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 href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
 <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
 <link href="/css/responsive.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">
 
@@ -37,11 +36,11 @@
 <div id="menu" class="mw">
 <ul>
   <li class='toc-categories'>
-    <a class="expand-toc-icon" href="javascript:void(0);">☰</a>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
   </li>
   <li class="logo"><a href="/"></a></li>
   <li class='expand-menu'>
-    <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'>☰</span></a>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
   </li>
   <li class='clear-float'></li>
   <li class="documentation-menu">
@@ -88,11 +87,8 @@
     <a href="/community/">Community</a>
     <ul>
       <li><a href="/team/">Team</a></li>
-      <li><a href="/community/#events">Events and Meetups</a></li>
-      <li><a href="/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/community/#getinvolved">Get Involved</a></li>
-      <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
-      <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/communityresources/">Community Resources</a></li>
     </ul>
   </li>
   <li class='nav'><a href="/faq/">FAQ</a></li>

Modified: drill/site/trunk/content/drill/search/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/search/index.html?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/search/index.html (original)
+++ drill/site/trunk/content/drill/search/index.html Mon May  4 15:52:37 2015
@@ -12,12 +12,11 @@
 <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 href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
 <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
 <link href="/css/responsive.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">
 
@@ -37,11 +36,11 @@
 <div id="menu" class="mw">
 <ul>
   <li class='toc-categories'>
-    <a class="expand-toc-icon" href="javascript:void(0);">☰</a>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
   </li>
   <li class="logo"><a href="/"></a></li>
   <li class='expand-menu'>
-    <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'>☰</span></a>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
   </li>
   <li class='clear-float'></li>
   <li class="documentation-menu">
@@ -88,11 +87,8 @@
     <a href="/community/">Community</a>
     <ul>
       <li><a href="/team/">Team</a></li>
-      <li><a href="/community/#events">Events and Meetups</a></li>
-      <li><a href="/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/community/#getinvolved">Get Involved</a></li>
-      <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
-      <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/communityresources/">Community Resources</a></li>
     </ul>
   </li>
   <li class='nav'><a href="/faq/">FAQ</a></li>

Modified: drill/site/trunk/content/drill/team/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/team/index.html?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/team/index.html (original)
+++ drill/site/trunk/content/drill/team/index.html Mon May  4 15:52:37 2015
@@ -12,12 +12,11 @@
 <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 href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
 <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
 <link href="/css/responsive.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">
 
@@ -37,11 +36,11 @@
 <div id="menu" class="mw">
 <ul>
   <li class='toc-categories'>
-    <a class="expand-toc-icon" href="javascript:void(0);">☰</a>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
   </li>
   <li class="logo"><a href="/"></a></li>
   <li class='expand-menu'>
-    <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'>☰</span></a>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
   </li>
   <li class='clear-float'></li>
   <li class="documentation-menu">
@@ -88,11 +87,8 @@
     <a href="/community/">Community</a>
     <ul>
       <li><a href="/team/">Team</a></li>
-      <li><a href="/community/#events">Events and Meetups</a></li>
-      <li><a href="/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/community/#getinvolved">Get Involved</a></li>
-      <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
-      <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/communityresources/">Community Resources</a></li>
     </ul>
   </li>
   <li class='nav'><a href="/faq/">FAQ</a></li>
@@ -119,30 +115,87 @@
   
 </div>
 
-<div class="int_text" align="left"><p>
-    Apache Drill developer community now has a growing set of committers and over 40 contributors from different companies and universities.
-    Prominent Drill contributions today come from MapR Technologies, LinkedIn, Hortonworks, University of Wisconsin Madison, Pentaho and Cisco. <br><br>
-    <a href="https://cwiki.apache.org/confluence/display/DRILL/Apache+Drill+Contribution+Guidelines?from=iZHHAg">Click here</a> if you are interested in contributing to the development of Drill.
-</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;&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;
-    <br><strong>MC Srivas</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;srivas at apache dot org&gt;
-    <br><strong>Keys Botzum</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;kbotzum at apache dot org&gt;
-    <br><strong>Julian Hyde</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;jhyde at apache dot org&gt;
-    <br><strong>Tim Chen</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;tnachen at apache dot org&gt;
-    <br><strong>Mehant Baid</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;mehant at apache dot org&gt;
-    <br><strong>Jinfeng Ni</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;jni at apache dot org&gt;
-    <br><strong>Venki Korukanti</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;venki at apache dot org&gt;
-    <br><strong>Jason Altekruse</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;json at apache dot org&gt;
-    <br><strong>Aditya Kishore</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;adi at apache dot org&gt;
-    <br><strong>Parth Chandra</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;parthc at apache dot org&gt;
-    <br><strong>Aman Sinha</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;amansinha at apache dot org&gt;
-    <br><strong>Steven Phillips</strong>&nbsp;&nbsp;&nbsp;&nbsp;&lt;smp at apache dot org&gt;
-</p>
+<div class="int_text" align="left"><p>The Apache Drill developer community is growing rapidly. It currently includes dozens of contributors employed by many organizations, such as MapR, Intuit, Hortonworks, Elastic, LinkedIn, Pentaho, Cisco and the University of Wisconsin-Madison.</p>
+
+<p>We welcome contributions to the project. If you&#39;re interested in contributing, take a look at the <a href="/docs/contribute-to-drill/">contribution guide</a>. You can also ask questions on the <a href="mailto:dev@drill.apache.org">drill-dev</a> list.</p>
+
+<h2 id="drill-committers">Drill Committers</h2>
+
+<table><thead>
+<tr>
+<th>Name</th>
+<th>Alias (email is &lt;alias&gt;@apache.org)</th>
+</tr>
+</thead><tbody>
+<tr>
+<td><strong>Jacques Nadeau (PMC Chair and VP Apache Drill)</strong></td>
+<td><strong>jacques</strong></td>
+</tr>
+<tr>
+<td>Tomer Shiran</td>
+<td>tshiran</td>
+</tr>
+<tr>
+<td>Ted Dunning</td>
+<td>tdunning</td>
+</tr>
+<tr>
+<td>Jason Frantz</td>
+<td>jason</td>
+</tr>
+<tr>
+<td>MC Srivas</td>
+<td>srivas</td>
+</tr>
+<tr>
+<td>Julian Hyde</td>
+<td>jhyde</td>
+</tr>
+<tr>
+<td>Tim Chen</td>
+<td>tnachen</td>
+</tr>
+<tr>
+<td>Mehant Baid</td>
+<td>mehant</td>
+</tr>
+<tr>
+<td>Jinfeng Ni</td>
+<td>jni</td>
+</tr>
+<tr>
+<td>Venki Korukanti</td>
+<td>venki</td>
+</tr>
+<tr>
+<td>Jason Altekruse</td>
+<td>json</td>
+</tr>
+<tr>
+<td>Aditya Kishore</td>
+<td>adi</td>
+</tr>
+<tr>
+<td>Parth Chandra</td>
+<td>parthc</td>
+</tr>
+<tr>
+<td>Aman Sinha</td>
+<td>amansinha</td>
+</tr>
+<tr>
+<td>Steven Phillips</td>
+<td>smp</td>
+</tr>
+<tr>
+<td>Bridget Bevens</td>
+<td>bridgetb</td>
+</tr>
+<tr>
+<td>Hanifi Gunes</td>
+<td>hg</td>
+</tr>
+</tbody></table>
 </div>
 
   </div>

Modified: drill/site/trunk/content/drill/toc/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/toc/index.html?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/toc/index.html (original)
+++ drill/site/trunk/content/drill/toc/index.html Mon May  4 15:52:37 2015
@@ -383,6 +383,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -813,6 +815,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -1137,6 +1141,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -1485,6 +1491,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/tutorials-introduction/">Tutorials Introduction</a></li>
           
           
@@ -1859,6 +1867,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
               
             
@@ -2431,6 +2441,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -2674,6 +2686,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -2809,7 +2823,7 @@
               
             
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/storage-plugin-configuration-introduction/">Storage Plugin Configuration Introduction</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-introduction/">Plugin Configuration Introduction</a></li>
               
             
               
@@ -3126,6 +3140,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -3446,6 +3462,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -3622,6 +3640,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/interfaces-introduction/">Interfaces Introduction</a></li>
           
           
@@ -3817,6 +3837,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/odbc-on-linux-and-mac-introduction/">ODBC on Linux and Mac Introduction</a></li>
               
             
@@ -4220,6 +4242,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-windows/">Installing the Driver on Windows</a></li>
               
             
@@ -4810,6 +4834,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/query-data-introduction/">Query Data Introduction</a></li>
           
           
@@ -5040,6 +5066,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/querying-a-file-system-introduction/">Querying a File System Introduction</a></li>
               
             
@@ -5438,6 +5466,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/querying-complex-data-introduction/">Querying Complex Data Introduction</a></li>
               
             
@@ -6022,6 +6052,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li>
           
           
@@ -6316,6 +6348,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-data-types/">Supported Data Types</a></li>
               
             
@@ -6749,6 +6783,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
               
             
@@ -7098,6 +7134,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/nested-data-limitations/">Nested Data Limitations</a></li>
               
             
@@ -7496,6 +7534,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
             
@@ -7915,6 +7955,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/case/">CASE</a></li>
               
             
@@ -8450,6 +8492,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -8851,6 +8895,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -9013,7 +9059,7 @@
         
       
         
-          <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-different-workloads/">Configuring Different Workloads</a></li>
+          <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-a-multitenant-cluster/">Configuring a Multitenant Cluster</a></li>
           
           
           
@@ -9162,7 +9208,11 @@
               
             
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-different-workloads-introduction/">Configuring Different Workloads Introduction</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-a-multitenant-cluster-introduction/">Configuring a Multitenant Cluster Introduction</a></li>
+              
+            
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-multitenant-resources/">Configuring Multitenant Resources</a></li>
               
             
               
@@ -9392,6 +9442,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/configuration-options/">Configuration Options</a></li>
           
           
@@ -9555,6 +9607,8 @@
               
             
               
+            
+              
                 <li class="toctree-l3"><a class="reference internal" href="/docs/configuration-options-introduction/">Configuration Options Introduction</a></li>
               
             
@@ -10476,6 +10530,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -10851,6 +10907,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -11232,6 +11290,8 @@
             
               
             
+              
+            
             </ul>
           
         
@@ -11498,6 +11558,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -11748,6 +11810,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release Notes</a></li>
           
           
@@ -12168,6 +12232,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/aol-search/">AOL Search</a></li>
           
           
@@ -12671,6 +12737,8 @@
       
         
       
+        
+      
       </ul>
     
   
@@ -12883,6 +12951,8 @@
         
       
         
+      
+        
           <li class="toctree-l2"><a class="reference internal" href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
           
           
@@ -13059,6 +13129,8 @@
   
 
   
+
+  
 
   
 

Modified: drill/site/trunk/content/drill/why/index.html
URL: http://svn.apache.org/viewvc/drill/site/trunk/content/drill/why/index.html?rev=1677619&r1=1677618&r2=1677619&view=diff
==============================================================================
--- drill/site/trunk/content/drill/why/index.html (original)
+++ drill/site/trunk/content/drill/why/index.html Mon May  4 15:52:37 2015
@@ -12,12 +12,11 @@
 <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 href="/css/breadcrumbs.css" rel="stylesheet" type="text/css">
+<link href="/css/code.css" rel="stylesheet" type="text/css">
 <link rel="stylesheet" href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css">
 <link href="/css/responsive.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">
 
@@ -37,11 +36,11 @@
 <div id="menu" class="mw">
 <ul>
   <li class='toc-categories'>
-    <a class="expand-toc-icon" href="javascript:void(0);">☰</a>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a>
   </li>
   <li class="logo"><a href="/"></a></li>
   <li class='expand-menu'>
-    <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'>☰</span></a>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a>
   </li>
   <li class='clear-float'></li>
   <li class="documentation-menu">
@@ -88,11 +87,8 @@
     <a href="/community/">Community</a>
     <ul>
       <li><a href="/team/">Team</a></li>
-      <li><a href="/community/#events">Events and Meetups</a></li>
-      <li><a href="/community/#mailinglists">Mailing Lists</a></li>
-      <li><a href="/community/#getinvolved">Get Involved</a></li>
-      <li><a href="https://issues.apache.org/jira/browse/DRILL/" target="_blank">Issue Tracker</a></li>
-      <li><a href="https://github.com/apache/drill" target="_blank">GitHub</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/communityresources/">Community Resources</a></li>
     </ul>
   </li>
   <li class='nav'><a href="/faq/">FAQ</a></li>