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/19 01:38:49 UTC

[14/51] [partial] drill-site git commit: Website update

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/planning-and-execution-options/index.html
----------------------------------------------------------------------
diff --git a/docs/planning-and-execution-options/index.html b/docs/planning-and-execution-options/index.html
index c259fd2..0ad8a51 100644
--- a/docs/planning-and-execution-options/index.html
+++ b/docs/planning-and-execution-options/index.html
@@ -9,26 +9,21 @@
 
 <title>Planning and Execution Options - Apache Drill</title>
 
-<link href="/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/css/style.css" rel="stylesheet" type="text/css">
-<link href="/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/css/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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.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 src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></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>
@@ -63,6 +58,12 @@
       
         <li><a href="/docs/query-data/">Query Data</a></li>
       
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
       
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
     </ul>
   </li>
   <li class='nav'>
@@ -110,7 +113,9 @@
 </ul>
 </div>
 
-      
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
       
 
 
@@ -149,14 +154,7 @@
             
           
             
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
             
           
           </ul>
@@ -203,6 +201,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+            
+          
           </ul>
         
       
@@ -300,7 +302,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
             
           
           </ul>
@@ -357,7 +359,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
             
           
             
@@ -409,6 +411,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
             
           
@@ -487,6 +493,32 @@
         
       
         
+          <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+            
+          
+          </ul>
+        
+      
+        
           <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
           <ul style="display: none">
           
@@ -563,27 +595,47 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
               
             </ul>
             
@@ -782,6 +834,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+            
+          
           </ul>
         
       
@@ -800,6 +856,29 @@
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+            
+          
+          </ul>
+        
+      
       </ul>
 
     </div>
@@ -807,7 +886,7 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
@@ -818,89 +897,47 @@
   <li>Planning and Execution Options</li>
 </nav>
 
-  <div class="main-content-wrapper">
-    <div class="main-content">
+<div class="main-content-wrapper">
+  <div class="main-content">
 
-      
-        <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
+    
+      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/configure-drill/configuration-options/030-planning-and-exececution-options.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Planning and Execution Options</h1>
+    <div class="int_title left">
+      <h1>Planning and Execution Options</h1>
 
-      </div>
+    </div>
 
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
-      <div class="int_text" align="left">
-        
-          <p>You can set Drill query planning and execution options per cluster, at the
+    <div class="int_text" align="left">
+      
+        <p>You can set Drill query planning and execution options per cluster, at the
 system or session level. Options set at the session level only apply to
 queries that you run during the current Drill connection. Options set at the
 system level affect the entire system and persist between restarts. Session
 level settings override system level settings.</p>
 
-<p>You can run the following query to see a list of the system and session
-planning and execution options:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT name FROM sys.options WHERE type in (SYSTEM, SESSION);
-</code></pre></div>
 <h2 id="configuring-planning-and-execution-options">Configuring Planning and Execution Options</h2>
 
 <p>Use the ALTER SYSTEM or ALTER SESSION commands to set options. Typically,
 you set the options at the session level unless you want the setting to
 persist across all sessions.</p>
 
-<p>The summary of system options lists default values. The following descriptions provide more detail on some of these options:</p>
-
-<h3 id="exec.min_hash_table_size">exec.min_hash_table_size</h3>
-
-<p>The default starting size for hash tables. Increasing this size is useful for very large aggregations or joins when you have large amounts of memory for Drill to use. Drill can spend a lot of time resizing the hash table as it finds new data. If you have large data sets, you can increase this hash table size to increase performance.</p>
-
-<h3 id="planner.add_producer_consumer">planner.add_producer_consumer</h3>
-
-<p>This option enables or disables a secondary reading thread that works out of band of the rest of the scanning fragment to prefetch data from disk. If you interact with a certain type of storage medium that is slow or does not prefetch much data, this option tells Drill to add a producer consumer reading thread to the operation. Drill can then assign one thread that focuses on a single reading fragment. If Drill is using memory, you can disable this option to get better performance. If Drill is using disk space, you should enable this option and set a reasonable queue size for the planner.producer_consumer_queue_size option.</p>
-
-<h3 id="planner.broadcast_threshold">planner.broadcast_threshold</h3>
-
-<p>Threshold, in terms of a number of rows, that determines whether a broadcast join is chosen for a query. Regardless of the setting of the broadcast_join option (enabled or disabled), a broadcast join is not chosen unless the right side of the join is estimated to contain fewer rows than this threshold. The intent of this option is to avoid broadcasting too many rows for join purposes. Broadcasting involves sending data across nodes and is a network-intensive operation. (The &quot;right side&quot; of the join, which may itself be a join or simply a table, is determined by cost-based optimizations and heuristics during physical planning.)</p>
-
-<h3 id="planner.enable_broadcast_join,-planner.enable_hashagg,-planner.enable_hashjoin,-planner.enable_mergejoin,-planner.enable_multiphase_agg,-planner.enable_streamagg">planner.enable_broadcast_join, planner.enable_hashagg, planner.enable_hashjoin, planner.enable_mergejoin, planner.enable_multiphase_agg, planner.enable_streamagg</h3>
-
-<p>These options enable or disable specific aggregation and join operators for queries. These operators are all enabled by default and in general should not be disabled.</p><p>Hash aggregation and hash join are hash-based operations. Streaming aggregation and merge join are sort-based operations. Both hash-based and sort-based operations consume memory; however, currently, hash-based operations do not spill to disk as needed, but the sort-based operations do. If large hash operations do not fit in memory on your system, you may need to disable these operations. Queries will continue to run, using alternative plans.</p>
-
-<h3 id="planner.producer_consumer_queue_size">planner.producer_consumer_queue_size</h3>
-
-<p>Determines how much data to prefetch from disk (in record batches) out of band of query execution. The larger the queue size, the greater the amount of memory that the queue and overall query execution consumes.</p>
-
-<h3 id="planner.width.max_per_node">planner.width.max_per_node</h3>
-
-<p>In this context <em>width</em> refers to fanout or distribution potential: the ability to run a query in parallel across the cores on a node and the nodes on a cluster. A physical plan consists of intermediate operations, known as query &quot;fragments,&quot; that run concurrently, yielding opportunities for parallelism above and below each exchange operator in the plan. An exchange operator represents a breakpoint in the execution flow where processing can be distributed. For example, a single-process scan of a file may flow into an exchange operator, followed by a multi-process aggregation fragment.</p>
-
-<p>The maximum width per node defines the maximum degree of parallelism for any fragment of a query, but the setting applies at the level of a single node in the cluster. The <em>default</em> maximum degree of parallelism per node is calculated as follows, with the theoretical maximum automatically scaled back (and rounded down) so that only 70% of the actual available capacity is taken into account: number of active drillbits (typically one per node) * number of cores per node * 0.7</p>
-
-<p>For example, on a single-node test system with 2 cores and hyper-threading enabled: 1 * 4 * 0.7 = 3</p>
-
-<p>When you modify the default setting, you can supply any meaningful number. The system does not automatically scale down your setting.</p>
-
-<h3 id="planner.width.max_per_query">planner.width.max_per_query</h3>
-
-<p>The max_per_query value also sets the maximum degree of parallelism for any given stage of a query, but the setting applies to the query as executed by the whole cluster (multiple nodes). In effect, the actual maximum width per query is the <em>minimum of two values</em>: min((number of nodes * width.max_per_node), width.max_per_query)</p>
-
-<p>For example, on a 4-node cluster where <code>width.max_per_node</code> is set to 6 and <code>width.max_per_query</code> is set to 30: min((4 * 6), 30) = 24</p>
-
-<p>In this case, the effective maximum width per query is 24, not 30.</p>
+<p>The <a href="/docs/configuration-options-introduction">summary of system options</a> lists default values and a short description of the planning and execution options. The planning option names have a planning preface. Execution options have an exe preface. For more information, see the section, &quot;Performance Turning&quot;.The following descriptions provide more detail on some of these options:</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/start-up-options/">← Start-Up Options</a></span><span class="next-toc"><a href="/docs/persistent-configuration-storage/">Persistent Configuration Storage →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/plugin-configuration-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/plugin-configuration-introduction/index.html b/docs/plugin-configuration-introduction/index.html
index 6e6c361..5677187 100644
--- a/docs/plugin-configuration-introduction/index.html
+++ b/docs/plugin-configuration-introduction/index.html
@@ -9,26 +9,21 @@
 
 <title>Plugin Configuration Introduction - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.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 src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></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>
@@ -63,6 +58,12 @@
       
         <li><a href="/docs/query-data/">Query Data</a></li>
       
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
       
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
     </ul>
   </li>
   <li class='nav'>
@@ -110,7 +113,9 @@
 </ul>
 </div>
 
-      
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
       
 
 
@@ -149,14 +154,7 @@
             
           
             
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
             
           
           </ul>
@@ -203,6 +201,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+            
+          
           </ul>
         
       
@@ -300,7 +302,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
             
           
           </ul>
@@ -357,7 +359,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
             
           
             
@@ -409,6 +411,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
             
           
@@ -487,6 +493,32 @@
         
       
         
+          <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+            
+          
+          </ul>
+        
+      
+        
           <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
           <ul style="display: none">
           
@@ -563,27 +595,47 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
               
             </ul>
             
@@ -782,6 +834,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+            
+          
           </ul>
         
       
@@ -800,6 +856,29 @@
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+            
+          
+          </ul>
+        
+      
       </ul>
 
     </div>
@@ -807,7 +886,7 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
@@ -818,28 +897,28 @@
   <li>Plugin Configuration Introduction</li>
 </nav>
 
-  <div class="main-content-wrapper">
-    <div class="main-content">
+<div class="main-content-wrapper">
+  <div class="main-content">
 
-      
-        <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/connect-a-data-source/035-plugin-configuration-introduction.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
+    
+      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/connect-a-data-source/035-plugin-configuration-introduction.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Plugin Configuration Introduction</h1>
+    <div class="int_title left">
+      <h1>Plugin Configuration Introduction</h1>
 
-      </div>
+    </div>
 
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
-      <div class="int_text" align="left">
-        
-          <p>When you add or update storage plugin instances on one Drill node in a Drill
+    <div class="int_text" align="left">
+      
+        <p>When you add or update storage plugin instances on one Drill node in a Drill
 cluster, Drill broadcasts the information to all of the other Drill nodes 
 to have identical storage plugin configurations. You do not need to
 restart any of the Drillbits when you add or update a storage plugin instance.</p>
 
-<p>Use the Drill Web UI to update or add a new storage plugin. Launch a web browser, go to: <code>http://&lt;IP address of the sandbox&gt;:8047</code>, and then go to the Storage tab. </p>
+<p>Use the Drill Web UI to update or add a new storage plugin. Launch a web browser, go to: <code>http://&lt;IP address or host name&gt;:8047</code>, and then go to the Storage tab. </p>
 
 <p>To create and configure a new storage plugin:</p>
 
@@ -913,13 +992,13 @@ name. Names are case-sensitive.</li>
   </tr>
   <tr>
     <td>"formats"</td>
-    <td>"psv"<br>"csv"<br>"tsv"<br>"parquet"<br>"json"<br>"maprdb"</td>
+    <td>"psv"<br>"csv"<br>"tsv"<br>"parquet"<br>"json"<br>"avro"<br>"maprdb" *</td>
     <td>yes</td>
     <td>One or more file formats of data Drill can read. Drill can implicitly detect some file formats based on the file extension or the first few bits of data within the file, but you need to configure an option for others.</td>
   </tr>
   <tr>
     <td>"formats" . . . "type"</td>
-    <td>"text"<br>"parquet"<br>"json"<br>"maprdb"</td>
+    <td>"text"<br>"parquet"<br>"json"<br>"maprdb" *</td>
     <td>yes</td>
     <td>The type of the format specified. For example, you can define two formats, csv and psv, as type "Text", but having different delimiters. Drill enables the maprdb plugin if you define the maprdb type.</td>
   </tr>
@@ -937,6 +1016,8 @@ name. Names are case-sensitive.</li>
   </tr>
 </table>
 
+<p>* Pertains only to distributed drill installations using the mapr-drill package.</p>
+
 <p>The configuration of other attributes, such as <code>size.calculator.enabled</code> in the hbase plugin and <code>configProps</code> in the hive plugin, are implementation-dependent and beyond the scope of this document.</p>
 
 <p>Although Drill can work with different file types in the same directory, restricting a Drill workspace to one file type prevents confusion.</p>
@@ -953,9 +1034,9 @@ name. Names are case-sensitive.</li>
 <p>Drill provides a REST API that you can use to create a storage plugin. Use an HTTP POST and pass two properties:</p>
 
 <ul>
-<li><p>name
+<li><p>name<br>
 The plugin name. </p></li>
-<li><p>config
+<li><p>config<br>
 The storage plugin definition as you would enter it in the Web UI.</p></li>
 </ul>
 
@@ -968,17 +1049,17 @@ The storage plugin definition as you would enter it in the Web UI.</p></li>
 
 <p>If you configure an HBase storage plugin using bootstrap-storage-plugins.json file and HBase is not install, you might experience a delay when executing the queries. Configure the <a href="http://hbase.apache.org/book.html#config.files">HBase client timeout</a> and retry settings in the config block of HBase plugin instance configuration.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/storage-plugin-configuration/">← Storage Plugin Configuration</a></span><span class="next-toc"><a href="/docs/workspaces/">Workspaces →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/ports-used-by-drill/index.html
----------------------------------------------------------------------
diff --git a/docs/ports-used-by-drill/index.html b/docs/ports-used-by-drill/index.html
index e5f9e89..a8a84b0 100644
--- a/docs/ports-used-by-drill/index.html
+++ b/docs/ports-used-by-drill/index.html
@@ -9,26 +9,21 @@
 
 <title>Ports Used by Drill - Apache Drill</title>
 
-<link href="/css/syntax.css" rel="stylesheet" type="text/css">
-<link href="/css/style.css" rel="stylesheet" type="text/css">
-<link href="/css/arrows.css" rel="stylesheet" type="text/css">
-<link href="/css/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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.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 src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></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>
@@ -63,6 +58,12 @@
       
         <li><a href="/docs/query-data/">Query Data</a></li>
       
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
       
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
     </ul>
   </li>
   <li class='nav'>
@@ -110,7 +113,9 @@
 </ul>
 </div>
 
-      
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
       
 
 
@@ -149,14 +154,7 @@
             
           
             
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
             
           
           </ul>
@@ -203,6 +201,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+            
+          
           </ul>
         
       
@@ -300,7 +302,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
             
           
           </ul>
@@ -357,7 +359,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
             
           
             
@@ -409,6 +411,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
             
           
@@ -487,6 +493,32 @@
         
       
         
+          <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+            
+          
+          </ul>
+        
+      
+        
           <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
           <ul style="display: none">
           
@@ -563,27 +595,47 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
               
             </ul>
             
@@ -782,6 +834,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+            
+          
           </ul>
         
       
@@ -800,6 +856,29 @@
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+            
+          
+          </ul>
+        
+      
       </ul>
 
     </div>
@@ -807,7 +886,7 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
@@ -816,23 +895,23 @@
   <li>Ports Used by Drill</li>
 </nav>
 
-  <div class="main-content-wrapper">
-    <div class="main-content">
+<div class="main-content-wrapper">
+  <div class="main-content">
 
-      
-        <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/configure-drill/100-ports-used-by-drill.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
+    
+      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/configure-drill/100-ports-used-by-drill.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Ports Used by Drill</h1>
+    <div class="int_title left">
+      <h1>Ports Used by Drill</h1>
 
-      </div>
+    </div>
 
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
-      <div class="int_text" align="left">
-        
-          <p>The following table provides a list of the ports that Drill uses, the port
+    <div class="int_text" align="left">
+      
+        <p>The following table provides a list of the ports that Drill uses, the port
 type, and a description of how Drill uses the port:</p>
 
 <table><thead>
@@ -869,17 +948,17 @@ type, and a description of how Drill uses the port:</p>
 </tr>
 </tbody></table>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/persistent-configuration-storage/">← Persistent Configuration Storage</a></span><span class="next-toc"><a href="/docs/partition-pruning/">Partition Pruning →</a></span>
+  <span class="previous-toc"><a href="/docs/persistent-configuration-storage/">← Persistent Configuration Storage</a></span><span class="next-toc"><a href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/progress-reports/index.html
----------------------------------------------------------------------
diff --git a/docs/progress-reports/index.html b/docs/progress-reports/index.html
index a49cf54..363795a 100644
--- a/docs/progress-reports/index.html
+++ b/docs/progress-reports/index.html
@@ -9,26 +9,21 @@
 
 <title>Progress Reports - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.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 src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></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>
@@ -63,6 +58,12 @@
       
         <li><a href="/docs/query-data/">Query Data</a></li>
       
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
       
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
     </ul>
   </li>
   <li class='nav'>
@@ -110,7 +113,9 @@
 </ul>
 </div>
 
-      
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
       
 
 
@@ -149,14 +154,7 @@
             
           
             
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
             
           
           </ul>
@@ -203,6 +201,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+            
+          
           </ul>
         
       
@@ -300,7 +302,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
             
           
           </ul>
@@ -357,7 +359,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
             
           
             
@@ -409,6 +411,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
             
           
@@ -487,6 +493,32 @@
         
       
         
+          <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+            
+          
+          </ul>
+        
+      
+        
           <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
           <ul style="display: none">
           
@@ -563,27 +595,47 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
               
             </ul>
             
@@ -782,6 +834,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+            
+          
           </ul>
         
       
@@ -800,6 +856,29 @@
           <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+            
+          
+          </ul>
+        
+      
       </ul>
 
     </div>
@@ -807,46 +886,46 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
   <li>Progress Reports</li>
 </nav>
 
-  <div class="main-content-wrapper">
-    <div class="main-content">
+<div class="main-content-wrapper">
+  <div class="main-content">
 
-      
-        <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/160-progress-reports.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
+    
+      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/160-progress-reports.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Progress Reports</h1>
+    <div class="int_title left">
+      <h1>Progress Reports</h1>
 
-      </div>
+    </div>
 
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
-      <div class="int_text" align="left">
+    <div class="int_text" align="left">
+      
+        <ul>
         
-          <ul>
-          
-            <li><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
-          
+          <li><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report</a></li>
         
-        </ul>
       
-        
-          <div class="doc-nav">
+      </ul>
+    
+      
+        <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/what-is-apache-drill/">← What is Apache Drill</a></span><span class="next-toc"><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report →</a></span>
+  <span class="previous-toc"><a href="/docs/partition-pruning/">← Partition Pruning</a></span><span class="next-toc"><a href="/docs/2014-q1-drill-report/">2014 Q1 Drill Report →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/project-bylaws/index.html
----------------------------------------------------------------------
diff --git a/docs/project-bylaws/index.html b/docs/project-bylaws/index.html
index 1f4e942..c9671dc 100644
--- a/docs/project-bylaws/index.html
+++ b/docs/project-bylaws/index.html
@@ -9,26 +9,21 @@
 
 <title>Project Bylaws - 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>
+<link href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/>
+<link href="/css/site.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 src="//ajax.googleapis.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script>
+<script src="//cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></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>
@@ -63,6 +58,12 @@
       
         <li><a href="/docs/query-data/">Query Data</a></li>
       
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/query-audit-logging/">Query Audit Logging</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>
@@ -81,6 +82,8 @@
       
         <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
       
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
     </ul>
   </li>
   <li class='nav'>
@@ -110,7 +113,9 @@
 </ul>
 </div>
 
-      
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
       
 
 
@@ -149,14 +154,7 @@
             
           
             
-              <li class="toctree-l2"><a href="javascript: void(0);">Architectural Highlights</a></li>
-              <ul style="display: none">
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/flexibility/">Flexibility</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/docs/performance/">Performance</a></li>
-              
-            </ul>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li>
             
           
           </ul>
@@ -203,6 +201,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li>
+            
+          
           </ul>
         
       
@@ -300,7 +302,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
             
           
           </ul>
@@ -357,7 +359,7 @@
             
           
             
-              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc/">Using JDBC</a></li>
+              <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li>
             
           
             
@@ -409,6 +411,10 @@
             
           
             
+              <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
+            
+          
+            
               <li class="toctree-l2"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li>
             
           
@@ -487,6 +493,32 @@
         
       
         
+          <li class="toctree-l1"><a href="javascript: void(0);">Performance Tuning</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" href="/docs/log-and-debug/">Log and Debug</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query Audit Logging</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/getting-query-information/">Getting Query Information</a></li>
+            
+          
+          </ul>
+        
+      
+        
           <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li>
           <ul style="display: none">
           
@@ -563,27 +595,47 @@
               
                 <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session-command/">ALTER SESSION Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-session/">ALTER SESSION</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-from/">SELECT FROM</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-group-by/">SELECT GROUP BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system-command/">ALTER SYSTEM Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-having/">SELECT HAVING</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas-command/">CREATE TABLE AS (CTAS) Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-limit/">SELECT LIMIT</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/create-view-command/">CREATE VIEW Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-offset/">SELECT OFFSET</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/describe-command/">DESCRIBE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-order-by/">SELECT ORDER BY</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/explain-commands/">EXPLAIN Commands</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-union/">SELECT UNION</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/select-statements/">SELECT Statements</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-where/">SELECT WHERE</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas-command/">SHOW DATABASES and SHOW SCHEMAS Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/select-with/">SELECT WITH</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files-command/">SHOW FILES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables-command/">SHOW TABLES Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li>
               
-                <li class="toctree-l3"><a class="reference internal" href="/docs/use-command/">USE Command</a></li>
+                <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li>
               
             </ul>
             
@@ -782,6 +834,10 @@
               <li class="toctree-l2"><a class="reference internal" href="/docs/what-is-apache-drill/">What is Apache Drill</a></li>
             
           
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/partition-pruning/">Partition Pruning</a></li>
+            
+          
           </ul>
         
       
@@ -800,6 +856,29 @@
           <li class="toctree-l1 current"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li>
         
       
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
+            
+          
+          </ul>
+        
+      
       </ul>
 
     </div>
@@ -807,30 +886,30 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
   <li>Project Bylaws</li>
 </nav>
 
-  <div class="main-content-wrapper">
-    <div class="main-content">
+<div class="main-content-wrapper">
+  <div class="main-content">
 
-      
-        <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/170-bylaws.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-      
+    
+      <a class="edit-link" href="https://github.com/apache/drill/blob/gh-pages/_docs/170-bylaws.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Project Bylaws</h1>
+    <div class="int_title left">
+      <h1>Project Bylaws</h1>
 
-      </div>
+    </div>
 
-      <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
 
-      <div class="int_text" align="left">
-        
-          <h2 id="introduction">Introduction</h2>
+    <div class="int_text" align="left">
+      
+        <h2 id="introduction">Introduction</h2>
 
 <p>This document defines the bylaws under which the Apache Drill project
 operates. It defines the roles and responsibilities of the project, who may
@@ -1000,17 +1079,17 @@ project will be unavailable.</p>
 
 <table ><tbody><tr><td valign="top" >Action</td><td valign="top" >Description</td><td valign="top" >Approval</td><td valign="top" >Binding Votes</td><td valign="top" >Minimum Length</td></tr><tr><td valign="top" >Code Change</td><td valign="top" >A change made to a codebase of the project and committed by a committer. This includes source code, documentation, website content, etc.</td><td valign="top" >Consensus approval of active committers, with a minimum of one +1. The code can be committed after the first +1</td><td valign="top" >Active committers</td><td valign="top" >1</td></tr><tr><td valign="top" >Release Plan</td><td valign="top" >Defines the timetable and actions for a release. The plan also nominates a Release Manager.</td><td valign="top" >Lazy majority</td><td valign="top" >Active committers</td><td valign="top" >3</td></tr><tr><td valign="top" >Product Release</td><td valign="top" >When a release of one of the project's products is ready, a vote is required to accept t
 he release as an official release of the project.</td><td valign="top" >Lazy Majority</td><td valign="top" >Active PMC members</td><td valign="top" >3</td></tr><tr><td valign="top" >Adoption of New Codebase</td><td valign="top" >When the codebase for an existing, released product is to be replaced with an alternative codebase. If such a vote fails to gain approval, the existing code base will continue. This also covers the creation of new sub-projects within the project.</td><td valign="top" >2/3 majority</td><td valign="top" >Active PMC members</td><td valign="top" >6</td></tr><tr><td valign="top" >New Committer</td><td valign="top" >When a new committer is proposed for the project.</td><td valign="top" >Lazy consensus</td><td valign="top" >Active PMC members</td><td valign="top" >3</td></tr><tr><td valign="top" >New PMC Member</td><td valign="top" >When a committer is proposed for the PMC.</td><td valign="top" >Lazy consensus</td><td valign="top" >Active PMC members</td><td valign
 ="top" >3</td></tr><tr><td valign="top" >Committer Removal</td><td valign="top" >When removal of commit privileges is sought. <em>Note: Such actions will also be referred to the ASF board by the PMC chair.</em></td><td valign="top" >Consensus</td><td valign="top" >Active PMC members (excluding the committer in question if a member of the PMC).</td><td valign="top" >6</td></tr><tr><td valign="top" >PMC Member Removal</td><td valign="top" >When removal of a PMC member is sought. <em>Note: Such actions will also be referred to the ASF board by the PMC chair.</em></td><td valign="top" >Consensus</td><td valign="top" >Active PMC members (excluding the member in question).</td><td valign="top" >6</td></tr><tr><td valign="top" >Modifying Bylaws</td><td valign="top" >Modifying this document.</td><td valign="top" >2/3 majority</td><td valign="top" >Active PMC members</td><td valign="top" >6</td></tr></tbody></table>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/2014-q1-drill-report/">← 2014 Q1 Drill Report</a></span><span class="next-toc"></span>
+  <span class="previous-toc"><a href="/docs/2014-q1-drill-report/">← 2014 Q1 Drill Report</a></span><span class="next-toc"><a href="/docs/log-and-debug/">Log and Debug →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>