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:45 UTC

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

http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/querying-parquet-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-parquet-files/index.html b/docs/querying-parquet-files/index.html
index 947cc99..ea1c5a6 100644
--- a/docs/querying-parquet-files/index.html
+++ b/docs/querying-parquet-files/index.html
@@ -9,26 +9,21 @@
 
 <title>Querying Parquet Files - 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,7 +886,7 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
@@ -818,23 +897,23 @@
   <li>Querying Parquet Files</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/query-data/query-a-file-system/020-querying-parquet-files.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/query-data/query-a-file-system/020-querying-parquet-files.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Querying Parquet Files</h1>
+    <div class="int_title left">
+      <h1>Querying Parquet Files</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>Your Drill installation includes a <code>sample-data</code> directory with Parquet files
+    <div class="int_text" align="left">
+      
+        <p>Your Drill installation includes a <code>sample-data</code> directory with Parquet files
 that you can query. Use SQL syntax to query the <code>region.parquet</code> and
 <code>nation.parquet</code> files in the <code>sample-data</code> directory.</p>
 
@@ -843,41 +922,36 @@ that you can query. Use SQL syntax to query the <code>region.parquet</code> and
   <p class="last">Your Drill installation location may differ from the examples used here.  </p>
 </div> 
 
-<p>The examples assume that Drill was installed in embedded mode on your machine following the <a href="/docs/drill-in-10-minutes">Drill in 10 Minutes </a> tutorial. If you installed Drill in distributed mode, or your <code>sample-data</code> directory differs from the location used in the examples, make sure to change the <code>sample-data</code> directory to the correct location before you run the queries.</p>
+<p>The examples assume that Drill was <a href="/docs/installing-drill-in-embedded-mode">installed in embedded mode</a>. If you installed Drill in distributed mode, or your <code>sample-data</code> directory differs from the location used in the examples. Change the <code>sample-data</code> directory to the correct location before you run the queries.</p>
 
 <h2 id="region-file">Region File</h2>
 
-<p>If you followed the Apache Drill in 10 Minutes instructions to install Drill
-in embedded mode, the path to the parquet file varies between operating
-systems.</p>
-
 <p>To view the data in the <code>region.parquet</code> file, issue the query appropriate for
 your operating system:</p>
 
 <ul>
 <li><p>Linux  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-0.4.0-incubating/sample-data/region.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-1.0.0/sample-data/region.parquet`;
 </code></pre></div></li>
 <li><p>Mac OS X  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-0.4.0-incubating/sample-data/region.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-1.0.0/sample-data/region.parquet`;
 </code></pre></div></li>
 <li><p>Windows  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-0.4.0-incubating\sample-data\region.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-1.0.0\sample-data\region.parquet`;
 </code></pre></div></li>
 </ul>
 
 <p>The query returns the following results:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+
-|   EXPR$0   |   EXPR$1   |
-+------------+------------+
-| AFRICA     | lar deposits. blithely final packages cajole. regular waters ar |
-| AMERICA    | hs use ironic, even requests. s |
-| ASIA       | ges. thinly even pinto beans ca |
-| EUROPE     | ly final courts cajole furiously final excuse |
-| MIDDLE EAST | uickly special accounts cajole carefully blithely close reques |
-+------------+------------+
-5 rows selected (0.165 seconds)
-0: jdbc:drill:zk=local&gt;
+<div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+--------------+-----------------------+
+| R_REGIONKEY  |    R_NAME    |       R_COMMENT       |
++--------------+--------------+-----------------------+
+| 0            | AFRICA       | lar deposits. blithe  |
+| 1            | AMERICA      | hs use ironic, even   |
+| 2            | ASIA         | ges. thinly even pin  |
+| 3            | EUROPE       | ly final courts cajo  |
+| 4            | MIDDLE EAST  | uickly special accou  |
++--------------+--------------+-----------------------+
+5 rows selected (0.272 seconds)
 </code></pre></div>
 <h2 id="nation-file">Nation File</h2>
 
@@ -890,60 +964,59 @@ your operating system:</p>
 
 <ul>
 <li><p>Linux  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-0.4.0-incubating/sample-data/nation.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/opt/drill/apache-drill-1.0.0/sample-data/nation.parquet`;
 </code></pre></div></li>
 <li><p>Mac OS X  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-0.4.0-incubating/sample-data/nation.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`/Users/max/drill/apache-drill-1.0.0-incubating/sample-data/nation.parquet`;
 </code></pre></div></li>
 <li><p>Windows  </p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-0.4.0-incubating\sample-data\nation.parquet`;
+<div class="highlight"><pre><code class="language-text" data-lang="text">SELECT * FROM dfs.`C:\drill\apache-drill-1.0.0-incubating\sample-data\nation.parquet`;
 </code></pre></div></li>
 </ul>
 
 <p>The query returns the following results:</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">+------------+------------+------------+------------+
-|   EXPR$0   |   EXPR$1   |   EXPR$2   |   EXPR$3   |
-+------------+------------+------------+------------+
-| 0          | 0          | ALGERIA    |  haggle. carefully final deposits det |
-| 1          | 1          | ARGENTINA  | al foxes promise slyly according to t |
-| 2          | 1          | BRAZIL     | y alongside of the pending deposits.  |
-| 3          | 1          | CANADA     | eas hang ironic, silent packages. sly |
-| 4          | 4          | EGYPT      | y above the carefully unusual theodol |
-| 5          | 0          | ETHIOPIA   | ven packages wake quickly. regu |
-| 6          | 3          | FRANCE     | refully final requests. regular, iron |
-| 7          | 3          | GERMANY    | l platelets. regular accounts x-ray:  |
-| 8          | 2          | INDIA      | ss excuses cajole slyly across the pa |
-| 9          | 2          | INDONESIA  |  slyly express asymptotes. regular de |
-| 10         | 4          | IRAN       | efully alongside of the slyly final d |
-| 11         | 4          | IRAQ       | nic deposits boost atop the quickly f |
-| 12         | 2          | JAPAN      | ously. final, express gifts cajole a |
-| 13         | 4          | JORDAN     | ic deposits are blithely about the ca |
-| 14         | 0          | KENYA      |  pending excuses haggle furiously dep |
-| 15         | 0          | MOROCCO    | rns. blithely bold courts among the c |
-| 16         | 0          | MOZAMBIQUE | s. ironic, unusual asymptotes wake bl |
-| 17         | 1          | PERU       | platelets. blithely pending dependenc |
-| 18         | 2          | CHINA      | c dependencies. furiously express not |
-| 19         | 3          | ROMANIA    | ular asymptotes are about the furious |
-| 20         | 4          | SAUDI ARABIA | ts. silent requests haggle. closely |
-| 21         | 2          | VIETNAM    | hely enticingly express accounts. eve |
-| 22         | 3          | RUSSIA     |  requests against the platelets use n |
-| 23         | 3          | UNITED KINGDOM | eans boost carefully special requ |
-| 24         | 1          | UNITED STATES | y final packages. slow foxes cajol |
-+------------+------------+------------+------------+
-25 rows selected (2.401 seconds)
-0: jdbc:drill:zk=local&gt;
+<div class="highlight"><pre><code class="language-text" data-lang="text">+--------------+-----------------+--------------+-----------------------+
+| N_NATIONKEY  |     N_NAME      | N_REGIONKEY  |       N_COMMENT       |
++--------------+-----------------+--------------+-----------------------+
+| 0            | ALGERIA         | 0            |  haggle. carefully f  |
+| 1            | ARGENTINA       | 1            | al foxes promise sly  |
+| 2            | BRAZIL          | 1            | y alongside of the p  |
+| 3            | CANADA          | 1            | eas hang ironic, sil  |
+| 4            | EGYPT           | 4            | y above the carefull  |
+| 5            | ETHIOPIA        | 0            | ven packages wake qu  |
+| 6            | FRANCE          | 3            | refully final reques  |
+| 7            | GERMANY         | 3            | l platelets. regular  |
+| 8            | INDIA           | 2            | ss excuses cajole sl  |
+| 9            | INDONESIA       | 2            |  slyly express asymp  |
+| 10           | IRAN            | 4            | efully alongside of   |
+| 11           | IRAQ            | 4            | nic deposits boost a  |
+| 12           | JAPAN           | 2            | ously. final, expres  |
+| 13           | JORDAN          | 4            | ic deposits are blit  |
+| 14           | KENYA           | 0            |  pending excuses hag  |
+| 15           | MOROCCO         | 0            | rns. blithely bold c  |
+| 16           | MOZAMBIQUE      | 0            | s. ironic, unusual a  |
+| 17           | PERU            | 1            | platelets. blithely   |
+| 18           | CHINA           | 2            | c dependencies. furi  |
+| 19           | ROMANIA         | 3            | ular asymptotes are   |
+| 20           | SAUDI ARABIA    | 4            | ts. silent requests   |
+| 21           | VIETNAM         | 2            | hely enticingly expr  |
+| 22           | RUSSIA          | 3            |  requests against th  |
+| 23           | UNITED KINGDOM  | 3            | eans boost carefully  |
+| 24           | UNITED STATES   | 1            | y final packages. sl  |
++--------------+-----------------+--------------+-----------------------+
+25 rows selected (0.102 seconds)
 </code></pre></div>
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/querying-json-files/">← Querying JSON Files</a></span><span class="next-toc"><a href="/docs/querying-plain-text-files/">Querying Plain Text Files →</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/querying-plain-text-files/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-plain-text-files/index.html b/docs/querying-plain-text-files/index.html
index 4cc29e4..6633dcd 100644
--- a/docs/querying-plain-text-files/index.html
+++ b/docs/querying-plain-text-files/index.html
@@ -9,26 +9,21 @@
 
 <title>Querying Plain Text Files - 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,7 +886,7 @@
 </aside>
 
 
-  <nav class="breadcrumbs">
+<nav class="breadcrumbs">
   <li><a href="/docs/">Docs</a></li>
  
   
@@ -818,23 +897,23 @@
   <li>Querying Plain Text Files</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/query-data/query-a-file-system/030-querying-plain-text-files.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/query-data/query-a-file-system/030-querying-plain-text-files.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Querying Plain Text Files</h1>
+    <div class="int_title left">
+      <h1>Querying Plain Text Files</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 use Drill to access both structured file types and plain text files
+    <div class="int_text" align="left">
+      
+        <p>You can use Drill to access both structured file types and plain text files
 (flat files). This section shows a few simple examples that work on flat
 files:</p>
 
@@ -875,19 +954,19 @@ records:</p>
 </code></pre></div>
 <p>Drill recognizes each row as an array of values and returns one column for
 each row.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">    0: jdbc:drill:zk=local&gt; select * from dfs.`/Users/brumsby/drill/plays.csv`;
-
-+------------+
-|  columns   |
-+------------+
-| [&quot;1599&quot;,&quot;As You Like It&quot;] |
-| [&quot;1601&quot;,&quot;Twelfth Night&quot;] |
-| [&quot;1594&quot;,&quot;Comedy of Errors&quot;] |
-| [&quot;1595&quot;,&quot;Romeo and Juliet&quot;] |
+<div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select * from dfs.`/Users/brumsby/drill/plays.csv`;
+
++-----------------------------------+
+|              columns              |
++-----------------------------------+
+| [&quot;1599&quot;,&quot;As You Like It&quot;]         |
+| [&quot;1601&quot;,&quot;Twelfth Night&quot;]          |
+| [&quot;1594&quot;,&quot;Comedy of Errors&quot;]       |
+| [&quot;1595&quot;,&quot;Romeo and Juliet&quot;]       |
 | [&quot;1596&quot;,&quot;The Merchant of Venice&quot;] |
-| [&quot;1610&quot;,&quot;The Tempest&quot;] |
-| [&quot;1599&quot;,&quot;Hamlet&quot;] |
-+------------+
+| [&quot;1610&quot;,&quot;The Tempest&quot;]            |
+| [&quot;1599&quot;,&quot;Hamlet&quot;]                 |
++-----------------------------------+
 7 rows selected (0.089 seconds)
 </code></pre></div>
 <h2 id="columns[n]-syntax">Columns[n] Syntax</h2>
@@ -897,17 +976,17 @@ rows in a more readable, column by column, format. (This syntax uses a zero-
 based index, so the first column is column <code>0</code>.)</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select columns[0], columns[1] from dfs.`/Users/brumsby/drill/plays.csv`;
 
-+------------+------------+
-|   EXPR$0   |   EXPR$1   |
-+------------+------------+
-| 1599       | As You Like It |
-| 1601       | Twelfth Night |
-| 1594       | Comedy of Errors |
-| 1595       | Romeo and Juliet |
++------------+------------------------+
+|   EXPR$0   |         EXPR$1         |
++------------+------------------------+
+| 1599       | As You Like It         |
+| 1601       | Twelfth Night          |
+| 1594       | Comedy of Errors       |
+| 1595       | Romeo and Juliet       |
 | 1596       | The Merchant of Venice |
-| 1610       | The Tempest |
-| 1599       | Hamlet     |
-+------------+------------+
+| 1610       | The Tempest            |
+| 1599       | Hamlet                 |
++------------+------------------------+
 7 rows selected (0.137 seconds)
 </code></pre></div>
 <p>You can use aliases to return meaningful column names. Note that <code>YEAR</code> is a
@@ -915,17 +994,17 @@ reserved word, so the <code>Year</code> alias must be enclosed by back ticks.</p
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select columns[0] as `Year`, columns[1] as Play 
 from dfs.`/Users/brumsby/drill/plays.csv`;
 
-+------------+------------+
-|    Year    |    Play    |
-+------------+------------+
-| 1599       | As You Like It |
-| 1601       | Twelfth Night |
-| 1594       | Comedy of Errors |
-| 1595       | Romeo and Juliet |
++------------+------------------------+
+|    Year    |    Play                |
++------------+------------------------+
+| 1599       | As You Like It         |
+| 1601       | Twelfth Night          |
+| 1594       | Comedy of Errors       |
+| 1595       | Romeo and Juliet       |
 | 1596       | The Merchant of Venice |
-| 1610       | The Tempest |
-| 1599       | Hamlet     |
-+------------+------------+
+| 1610       | The Tempest            |
+| 1599       | Hamlet                 |
++------------+------------------------+
 7 rows selected (0.113 seconds)
 </code></pre></div>
 <p>You cannot refer to the aliases in subsequent clauses of the query. Use the
@@ -934,28 +1013,28 @@ example:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=local&gt; select columns[0] as `Year`, columns[1] as Play 
 from dfs.`/Users/brumsby/drill/plays.csv` where columns[0]&gt;1599;
 
-+------------+------------+
-|    Year    |    Play    |
-+------------+------------+
++------------+---------------+
+|    Year    |      Play     |
++------------+---------------+
 | 1601       | Twelfth Night |
-| 1610       | The Tempest |
-+------------+------------+
+| 1610       | The Tempest   |
++------------+---------------+
 2 rows selected (0.201 seconds)
 </code></pre></div>
 <p>Note that the restriction with the use of aliases applies to queries against
 all data sources.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/querying-parquet-files/">← Querying Parquet Files</a></span><span class="next-toc"><a href="/docs/querying-directories/">Querying Directories →</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/querying-system-tables/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-system-tables/index.html b/docs/querying-system-tables/index.html
index b91aa6e..fbb0f5f 100644
--- a/docs/querying-system-tables/index.html
+++ b/docs/querying-system-tables/index.html
@@ -9,26 +9,21 @@
 
 <title>Querying System Tables - 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 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">
+<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 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>
  
   
@@ -816,23 +895,23 @@
   <li>Querying System Tables</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/query-data/070-query-sys-tbl.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/query-data/070-query-sys-tbl.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Querying System Tables</h1>
+    <div class="int_title left">
+      <h1>Querying System Tables</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>Drill has a sys database that contains system tables. You can query the system
+    <div class="int_text" align="left">
+      
+        <p>Drill has a sys database that contains system tables. You can query the system
 tables for information about Drill, including Drill ports, the Drill version
 running on the system, and available Drill options. View the databases in
 Drill to identify the sys database, and then use the sys database to view
@@ -842,21 +921,21 @@ system tables that you can query.</p>
 
 <p>Issue the <code>SHOW DATABASES</code> command to view Drill databases.</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181&gt; show databases;
-+-------------+
-| SCHEMA_NAME |
-+-------------+
-| M7          |
-| hive.default|
-| dfs.default |
-| dfs.root    |
-| dfs.views   |
-| dfs.tmp     |
-| dfs.tpcds   |
-| sys         |
-| cp.default  |
-| hbase       |
++--------------------+
+|      SCHEMA_NAME   |
++--------------------+
+| M7                 |
+| hive.default       |
+| dfs.default        |
+| dfs.root           |
+| dfs.views          |
+| dfs.tmp            |
+| dfs.tpcds          |
+| sys                |
+| cp.default         |
+| hbase              |
 | INFORMATION_SCHEMA |
-+-------------+
++--------------------+
 11 rows selected (0.162 seconds)
 </code></pre></div>
 <p>Drill returns <code>sys</code> in the database results.</p>
@@ -893,13 +972,13 @@ requests.</p>
 
 <h3 id="query-the-drillbits-table.">Query the drillbits table.</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181&gt; select * from drillbits;
-+------------------+------------+--------------+------------+---------+
-|   host            | user_port | control_port | data_port  |  current|
++-------------------+------------+--------------+------------+---------+
+|   host            |  user_port | control_port | data_port  |  current|
 +-------------------+------------+--------------+------------+--------+
-| qa-node115.qa.lab | 31010     | 31011        | 31012      | true    |
-| qa-node114.qa.lab | 31010     | 31011        | 31012      | false   |
-| qa-node116.qa.lab | 31010     | 31011        | 31012      | false   |
-+------------+------------+--------------+------------+---------------+
+| qa-node115.qa.lab | 31010      | 31011        | 31012      | true    |
+| qa-node114.qa.lab | 31010      | 31011        | 31012      | false   |
+| qa-node116.qa.lab | 31010      | 31011        | 31012      | false   |
++-------------------+------------+--------------+------------+---------+
 3 rows selected (0.146 seconds)
 </code></pre></div>
 <ul>
@@ -921,12 +1000,12 @@ query. This Drillbit is the Foreman for the current session.<br></li>
 
 <h3 id="query-the-version-table.">Query the version table.</h3>
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181&gt; select * from version;
-+------------+----------------+-------------+-------------+------------+
-| commit_id  | commit_message | commit_time | build_email | build_time |
-+------------+----------------+-------------+-------------+------------+
-| 108d29fce3d8465d619d45db5f6f433ca3d97619 | DRILL-1635: Additional fix for validation exceptions. | 14.11.2014 @ 02:32:47 UTC | Unknown    | 14.11.2014 @ 03:56:07 UTC |
-+------------+----------------+-------------+-------------+------------+
-1 row selected (0.144 seconds)
++-------------------------------------------+--------------------------------------------------------------------+----------------------------+--------------+----------------------------+
+|                 commit_id                 |                           commit_message                           |        commit_time         | build_email  |         build_time         |
++-------------------------------------------+--------------------------------------------------------------------+----------------------------+--------------+----------------------------+
+| d8b19759657698581cc0d01d7038797952888123  | DRILL-3100: TestImpersonationDisabledWithMiniDFS fails on Windows  | 15.05.2015 @ 05:18:03 UTC  | Unknown      | 15.05.2015 @ 06:52:32 UTC  |
++-------------------------------------------+--------------------------------------------------------------------+----------------------------+--------------+----------------------------+
+1 row selected (0.099 seconds)
 </code></pre></div>
 <ul>
 <li>commit_id<br>
@@ -949,21 +1028,21 @@ The time that the release was built.</li>
 
 <p>The following example shows a query on the system options:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">0: jdbc:drill:zk=10.10.100.113:5181&gt; select * from options where type=&#39;SYSTEM&#39; limit 10;
-+------------+------------+------------+------------+------------+------------+------------+
-|    name   |   kind    |   type    |  num_val   | string_val |  bool_val  | float_val  |
-+------------+------------+------------+------------+------------+------------+------------+
-| exec.max_hash_table_size | LONG       | SYSTEM    | 1073741824 | null     | null      | null      |
-| planner.memory.max_query_memory_per_node | LONG       | SYSTEM    | 2048       | null     | null      | null      |
-| planner.join.row_count_estimate_factor | DOUBLE   | SYSTEM    | null      | null      | null      | 1.0       |
-| planner.affinity_factor | DOUBLE  | SYSTEM    | null      | null      | null       | 1.2      |
-| exec.errors.verbose | BOOLEAN | SYSTEM    | null      | null      | false      | null     |
-| planner.disable_exchanges | BOOLEAN   | SYSTEM    | null      | null      | false      | null     |
-| exec.java_compiler_debug | BOOLEAN    | SYSTEM    | null      | null      | true      | null      |
-| exec.min_hash_table_size | LONG       | SYSTEM    | 65536     | null      | null      | null       |
-| exec.java_compiler_janino_maxsize | LONG       | SYSTEM   | 262144    | null      | null      | null      |
-| planner.enable_mergejoin | BOOLEAN    | SYSTEM    | null      | null      | true      | null       |
-+------------+------------+------------+------------+------------+------------+------------+
-10 rows selected (0.334 seconds)  
++-------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
+|                      name                       |   kind   |  type   |  status  |   num_val   | string_val  | bool_val  | float_val  |
++-------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
+| drill.exec.functions.cast_empty_string_to_null  | BOOLEAN  | SYSTEM  | DEFAULT  | null        | null        | false     | null       |
+| drill.exec.storage.file.partition.column.label  | STRING   | SYSTEM  | DEFAULT  | null        | dir         | null      | null       |
+| exec.errors.verbose                             | BOOLEAN  | SYSTEM  | DEFAULT  | null        | null        | false     | null       |
+| exec.java_compiler                              | STRING   | SYSTEM  | DEFAULT  | null        | DEFAULT     | null      | null       |
+| exec.java_compiler_debug                        | BOOLEAN  | SYSTEM  | DEFAULT  | null        | null        | true      | null       |
+| exec.java_compiler_janino_maxsize               | LONG     | SYSTEM  | DEFAULT  | 262144      | null        | null      | null       |
+| exec.max_hash_table_size                        | LONG     | SYSTEM  | DEFAULT  | 1073741824  | null        | null      | null       |
+| exec.min_hash_table_size                        | LONG     | SYSTEM  | DEFAULT  | 65536       | null        | null      | null       |
+| exec.queue.enable                               | BOOLEAN  | SYSTEM  | DEFAULT  | null        | null        | false     | null       |
+| exec.queue.large                                | LONG     | SYSTEM  | DEFAULT  | 10          | null        | null      | null       |
++-------------------------------------------------+----------+---------+----------+-------------+-------------+-----------+------------+
+10 rows selected (0.216 seconds)
 </code></pre></div>
 <ul>
 <li>name<br>
@@ -983,23 +1062,21 @@ The default value, which is of the double, float, or long double data type;
 otherwise, null.</li>
 </ul>
 
-<p>For information about how to configure Drill system and session options, see<a href="/docs/planning-and-execution-options">
-Planning and Execution Options</a>.</p>
+<p>For information about how to configure Drill system and session options, see <a href="/docs/planning-and-execution-options">Planning and Execution Options</a>.</p>
 
-<p>For information about how to configure Drill start-up options, see<a href="/docs/start-up-options"> Start-Up
-Options</a>.</p>
+<p>For information about how to configure Drill start-up options, see <a href="/docs/start-up-options">Start-Up Options</a>.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/querying-the-information-schema/">← Querying the INFORMATION SCHEMA</a></span><span class="next-toc"><a href="/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/">Monitoring and Canceling Queries in the Drill Web UI →</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/querying-the-information-schema/index.html
----------------------------------------------------------------------
diff --git a/docs/querying-the-information-schema/index.html b/docs/querying-the-information-schema/index.html
index e510475..698a4ae 100644
--- a/docs/querying-the-information-schema/index.html
+++ b/docs/querying-the-information-schema/index.html
@@ -9,26 +9,21 @@
 
 <title>Querying the INFORMATION SCHEMA - 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>
  
   
@@ -816,23 +895,23 @@
   <li>Querying the INFORMATION SCHEMA</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/query-data/060-querying-the-information-schema.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/query-data/060-querying-the-information-schema.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Querying the INFORMATION SCHEMA</h1>
+    <div class="int_title left">
+      <h1>Querying the INFORMATION SCHEMA</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 are using Drill to connect to multiple data sources, you need a
+    <div class="int_text" align="left">
+      
+        <p>When you are using Drill to connect to multiple data sources, you need a
 simple mechanism to discover what each data source contains. The information
 schema is an ANSI standard set of metadata tables that you can query to return
 information about all of your Drill data sources (or schemas). Data sources
@@ -938,17 +1017,19 @@ WHERE TABLE_NAME = &#39;Orders&#39; AND TABLE_SCHEMA = &#39;HiveTest.SalesDB&#39
 | OrderTotal  | Decimal    |
 +-------------+------------+
 </code></pre></div>
+<p>In this release, Drill disables the DECIMAL data type, including casting to DECIMAL and reading DECIMAL types from Parquet and Hive. <a href="/docs/supported-data-types#enabling-the-decimal-type">Enable the DECIMAL data type</a> if performance is not an issue.</p>
+
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/querying-hive/">← Querying Hive</a></span><span class="next-toc"><a href="/docs/querying-system-tables/">Querying System Tables →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>