drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tshi...@apache.org
Subject [22/51] [partial] drill-site git commit: Website update
Date Mon, 18 May 2015 23:38:57 GMT
http://git-wip-us.apache.org/repos/asf/drill-site/blob/ee640eab/docs/installing-the-driver-on-linux/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-linux/index.html b/docs/installing-the-driver-on-linux/index.html
index c5550b8..619d5e5 100644
--- a/docs/installing-the-driver-on-linux/index.html
+++ b/docs/installing-the-driver-on-linux/index.html
@@ -9,26 +9,21 @@
 
 <title>Installing the Driver on Linux - 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>
  
   
@@ -818,23 +897,23 @@
   <li>Installing the Driver on Linux</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/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.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/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/010-installing-the-driver-on-linux.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Installing the Driver on Linux</h1>
+    <div class="int_title left">
+      <h1>Installing the Driver on Linux</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>Install the MapR Drill ODBC Driver on the machine from which you connect to
+    <div class="int_text" align="left">
+      
+        <p>Install the MapR Drill ODBC Driver on the machine from which you connect to
 the Drill service. You can install the 32- or 64-bit driver on Linux. Install
 the version of the driver that matches the architecture of the client
 application that you use to access Drill. The 64-bit editions of Linux support
@@ -980,17 +1059,17 @@ variables permanently.</p>
 <p>Complete the steps listed in <a href="/docs/configuring-connections-on-linux-and-mac-os-x">Configuring ODBC Connections for Linux and Mac
 OS X</a>.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/odbc-on-linux-and-mac-introduction/">← ODBC on Linux and Mac Introduction</a></span><span class="next-toc"><a href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS X →</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/installing-the-driver-on-mac-os-x/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-mac-os-x/index.html b/docs/installing-the-driver-on-mac-os-x/index.html
index 723dc33..ba4357f 100644
--- a/docs/installing-the-driver-on-mac-os-x/index.html
+++ b/docs/installing-the-driver-on-mac-os-x/index.html
@@ -9,26 +9,21 @@
 
 <title>Installing the Driver on Mac OS X - 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>
  
   
@@ -818,23 +897,23 @@
   <li>Installing the Driver on Mac OS X</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/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.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/odbc-jdbc-interfaces/using-odbc-on-linux-and-mac-os-x/020-installing-the-driver-on-mac-os-x.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Installing the Driver on Mac OS X</h1>
+    <div class="int_title left">
+      <h1>Installing the Driver on Mac OS X</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>Install the MapR Drill ODBC Driver on the machine from which you connect to
+    <div class="int_text" align="left">
+      
+        <p>Install the MapR Drill ODBC Driver on the machine from which you connect to
 the Drill service.</p>
 
 <p>To install the MapR Drill ODBC Driver, complete the following steps:</p>
@@ -920,17 +999,17 @@ c/lib/universal</code></p>
 <p>Complete the steps listed in <a href="/docs/configuring-connections-on-linux-and-mac-os-x">Configuring ODBC Connections for Linux and Mac
 OS X</a>.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/installing-the-driver-on-linux/">← Installing the Driver on Linux</a></span><span class="next-toc"><a href="/docs/configuring-connections-on-linux-and-mac-os-x/">Configuring Connections on Linux and Mac OS X →</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/installing-the-driver-on-windows/index.html
----------------------------------------------------------------------
diff --git a/docs/installing-the-driver-on-windows/index.html b/docs/installing-the-driver-on-windows/index.html
index edf921b..7481222 100644
--- a/docs/installing-the-driver-on-windows/index.html
+++ b/docs/installing-the-driver-on-windows/index.html
@@ -9,26 +9,21 @@
 
 <title>Installing the Driver on Windows - 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>
  
   
@@ -818,23 +897,23 @@
   <li>Installing the Driver on Windows</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/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.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/odbc-jdbc-interfaces/using-odbc-on-windows/010-installing-the-driver-on-windows.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Installing the Driver on Windows</h1>
+    <div class="int_title left">
+      <h1>Installing the Driver on Windows</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 MapR Drill ODBC Driver installer is available for 32-bit and 64-bit
+    <div class="int_text" align="left">
+      
+        <p>The MapR Drill ODBC Driver installer is available for 32-bit and 64-bit
 applications on Windows. Both versions of the driver can be installed on a 64-bit
 machine.</p>
 
@@ -900,17 +979,17 @@ For example, you can press the SPACEBAR key.</li>
 
 <h4 id="what&#39;s-next?-go-to-step-2.-configure-odbc-connections-to-drill-data-sources.">What&#39;s Next? Go to <a href="/docs/configuring-connections-on-windows">Step 2. Configure ODBC Connections to Drill Data Sources</a>.</h4>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/using-odbc-on-windows/">← Using ODBC on Windows</a></span><span class="next-toc"><a href="/docs/configuring-connections-on-windows/">Configuring Connections on Windows →</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/interfaces-introduction/index.html
----------------------------------------------------------------------
diff --git a/docs/interfaces-introduction/index.html b/docs/interfaces-introduction/index.html
index db756da..77240ca 100644
--- a/docs/interfaces-introduction/index.html
+++ b/docs/interfaces-introduction/index.html
@@ -9,26 +9,21 @@
 
 <title>Interfaces 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/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,26 +895,26 @@
   <li>Interfaces 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/odbc-jdbc-interfaces/010-interfaces-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/odbc-jdbc-interfaces/010-interfaces-introduction.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>Interfaces Introduction</h1>
+    <div class="int_title left">
+      <h1>Interfaces 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>You can connect to Apache Drill through the following interfaces:</p>
+    <div class="int_text" align="left">
+      
+        <p>You can connect to Apache Drill through the following interfaces:</p>
 
 <ul>
-<li>Drill shell (SQLLine)</li>
+<li>Drill shell</li>
 <li>Drill Web UI</li>
 <li><a href="/docs/odbc-jdbc-interfaces#using-odbc-to-access-apache-drill-from-bi-tools">ODBC</a>*</li>
 <li><a href="/docs/using-jdbc/">JDBC</a></li>
@@ -850,8 +929,8 @@
 that you install the latest version of Apache Drill with the latest version of
 the Drill ODBC driver.</p>
 
-<p>For example, if you have Apache Drill 0.5 and a Drill ODBC driver installed on
-your machine, and then you upgrade to Apache Drill 0.6, do not assume that the
+<p>For example, if you have Apache Drill 0.8 and a Drill ODBC driver installed on
+your machine, and then you upgrade to Apache Drill 1.0, do not assume that the
 Drill ODBC driver installed on your machine will work with the new version of
 Apache Drill. Install the latest available Drill ODBC driver to ensure that
 the two components work together.</p>
@@ -883,17 +962,17 @@ steps:</p>
 Start</a>
 guide.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
-  <span class="previous-toc"><a href="/docs/odbc-jdbc-interfaces/">← ODBC/JDBC Interfaces</a></span><span class="next-toc"><a href="/docs/using-jdbc/">Using JDBC →</a></span>
+  <span class="previous-toc"><a href="/docs/odbc-jdbc-interfaces/">← ODBC/JDBC Interfaces</a></span><span class="next-toc"><a href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows →</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/json-data-model/index.html
----------------------------------------------------------------------
diff --git a/docs/json-data-model/index.html b/docs/json-data-model/index.html
index 7b89599..31e06ca 100644
--- a/docs/json-data-model/index.html
+++ b/docs/json-data-model/index.html
@@ -9,26 +9,21 @@
 
 <title>JSON Data Model - 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>
  
   
@@ -816,23 +895,23 @@
   <li>JSON Data Model</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/data-sources-and-file-formats/050-json-data-model.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/data-sources-and-file-formats/050-json-data-model.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
 
-      <div class="int_title">
-        <h1>JSON Data Model</h1>
+    <div class="int_title left">
+      <h1>JSON Data Model</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 supports <a href="http://www.json.org/">JSON (JavaScript Object Notation)</a>, a self-describing data format. The data itself implies its schema and has the following characteristics:</p>
+    <div class="int_text" align="left">
+      
+        <p>Drill supports <a href="http://www.json.org/">JSON (JavaScript Object Notation)</a>, a self-describing data format. The data itself implies its schema and has the following characteristics:</p>
 
 <ul>
 <li>Language-independent</li>
@@ -844,7 +923,7 @@
 
 <p>Using Drill you can natively query dynamic JSON data sets using SQL. Drill treats a JSON object as a SQL record. One object equals one row in a Drill table. </p>
 
-<p>Drill 0.8 and higher can <a href="/docs/drill-default-input-format#querying-compressed-json">query compressed .gz files</a> having JSON as well as uncompressed .json files. </p>
+<p>You can also <a href="/docs/drill-default-input-format#querying-compressed-json">query compressed .gz files</a> having JSON as well as uncompressed .json files. </p>
 
 <p>In addition to the examples presented later in this section, see <a href="https://www.mapr.com/blog/how-analyze-highly-dynamic-datasets-apache-drill">&quot;How to Analyze Highly Dynamic Datasets with Apache Drill&quot;</a> for information about how to analyze a JSON data set.</p>
 
@@ -863,7 +942,7 @@
 <li>Whitespace: used between tokens</li>
 </ul>
 
-<p>The following table shows SQL-JSON data type mapping, assuming you use the default <code>all_text_mode</code> option setting, false: </p>
+<p>The following table shows SQL-JSON data type mapping: </p>
 
 <table><thead>
 <tr>
@@ -894,27 +973,36 @@
 </tr>
 </tbody></table>
 
-<p>Drill does not support JSON lists of different types. For example, JSON does not enforce types or distinguish between integers and floating point values. When reading numerical values from a JSON file, Drill distinguishes integers from floating point numbers by the presence or lack of a decimal point. If some numbers in a JSON map or array appear with and without a decimal point, such as 0 and 0.0, Drill throws a schema change error.</p>
+<p>By default, Drill does not support JSON lists of different types. For example, JSON does not enforce types or distinguish between integers and floating point values. When reading numerical values from a JSON file, Drill distinguishes integers from floating point numbers by the presence or lack of a decimal point. If some numbers in a JSON map or array appear with and without a decimal point, such as 0 and 0.0, Drill throws a schema change error. You use the following options to read JSON lists of different types:</p>
+
+<ul>
+<li><code>store.json.read_numbers_as_double</code><br>
+Reads numbers from JSON files with or without a decimal point as DOUBLE. You need to cast numbers from DOUBLE to other numerical types only if you cannot use the numbers as DOUBLE.</li>
+<li><code>store.json.all_text_mode</code><br>
+Reads all data from JSON files as VARCHAR. You need to cast numbers from VARCHAR to numerical data types, such as DOUBLE or INTEGER.</li>
+</ul>
+
+<p>The default setting of <code>store.json.all_text_mode</code> and <code>store.json.read_numbers_as_double</code> options is false. Using either option prevents schema errors, but using <code>store.json.read_numbers_as_double</code> has an advantage over <code>store.json.all_text_mode</code>. Using <code>store.json.read_numbers_as_double</code> typically involves less explicit casting than using <code>store.json.all_text_mode</code> because you can often use the numerical data as is--DOUBLE.</p>
 
 <h3 id="handling-type-differences">Handling Type Differences</h3>
 
-<p>Use the all text mode to prevent the schema change error that occurs from when a JSON list includes different types, as described in the previous section. Set the <code>store.json.all_text_mode</code> property to true.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `store.json.all_text_mode` = true;
+<p>Set the <code>store.json.read_numbers_as_double</code> property to true.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `store.json.read_numbers_as_double` = true;
 </code></pre></div>
-<p>When you set this option, Drill reads all data from the JSON files as VARCHAR. After reading the data, use a SELECT statement in Drill to cast data as follows:</p>
+<p>When you set this option, Drill reads all numbers from the JSON files as DOUBLE. After reading the data, use a SELECT statement in Drill to cast data as follows:</p>
 
 <ul>
-<li>Cast JSON values to <a href="/docs/data-types">SQL types</a>, such as BIGINT, DECIMAL, FLOAT, and INTEGER.</li>
-<li>Cast JSON strings to <a href="/docs/supported-date-time-data-type-formats">Drill Date/Time Data Type Formats</a>.</li>
+<li>Cast JSON values to <a href="/docs/json-data-model/#data-type-mapping">SQL types</a>, such as BIGINT, FLOAT, and INTEGER.</li>
+<li>Cast JSON strings to <a href="/docs/date-time-and-timestamp">Drill Date/Time Data Type Formats</a>.</li>
 </ul>
 
-<p>Drill uses <a href="/docs/data-types">map and array data types</a> internally for reading complex and nested data structures from JSON. You can cast data in a map or array of data to return a value from the structure, as shown in <a href="/docs/lesson-2-run-queries-with-ansi-sql">“Create a view on a MapR-DB table”</a>. “Query Complex Data” shows how to access nested arrays.</p>
+<p>Drill uses <a href="/docs/handling-different-data-types/#handling-json-and-parquet-data">map and array data types</a> internally for reading complex and nested data structures from JSON. You can cast data in a map or array of data to return a value from the structure, as shown in <a href="/docs/lesson-2-run-queries-with-ansi-sql/#create-a-view-on-a-mapr-db-table">“Create a view on a MapR-DB table”</a>. <a href="/docs/querying-complex-data-introduction">“Query Complex Data”</a> shows how to access nested arrays.</p>
 
 <h2 id="reading-json">Reading JSON</h2>
 
-<p>To read JSON data using Drill, use a <a href="/docs/connect-to-a-data-source">file system storage plugin</a> that defines the JSON format. You can use the <code>dfs</code> storage plugin, which includes the definition. </p>
+<p>To read JSON data using Drill, use a <a href="/docs/file-system-storage-plugin/">file system storage plugin</a> that defines the JSON format. You can use the <code>dfs</code> storage plugin, which includes the definition. </p>
 
-<p>JSON data is often complex. Data can be deeply nested and semi-structured. but <a href="/docs/json-data-model#limitations-and-workaroumds">you can use workarounds </a> covered later.</p>
+<p>JSON data is often complex. Data can be deeply nested and semi-structured. but you can use <a href="/docs/json-data-model/#limitations-and-workarounds">workarounds </a> covered later.</p>
 
 <p>Drill reads tuples defined in single objects, having no comma between objects. A JSON object is an unordered set of name/value pairs. Curly braces delimit objects in the JSON file:</p>
 <div class="highlight"><pre><code class="language-text" data-lang="text">{ name: &quot;Apples&quot;, desc: &quot;Delicious&quot; }
@@ -948,7 +1036,7 @@ SELECT my column from dfs.`&lt;path_file_name&gt;`;
 </code></pre></div></li>
 </ul>
 
-<p>Drill performs the following actions, as shown in the complete <a href="/docs/create-table-as-ctas-command">CTAS command example</a>:</p>
+<p>Drill performs the following actions, as shown in the complete <a href="/docs/create-table-as-ctas/">CTAS command example</a>:</p>
 
 <ul>
 <li>Creates a directory using table name.</li>
@@ -1164,7 +1252,7 @@ FROM dfs.`/Users/drilluser/citylots.json`;
 +-------------------+
 1 row selected (0.19 seconds)
 </code></pre></div>
-<p>More examples of drilling down into an array are shown in <a href="/docs/query-3-selecting-nested-data-for-a-column">&quot;Selecting Nested Data for a Column&quot;</a>. </p>
+<p>More examples of drilling down into an array are shown in <a href="/docs/selecting-nested-data-for-a-column">&quot;Selecting Nested Data for a Column&quot;</a>. </p>
 
 <h3 id="example:-flatten-an-array-of-maps-using-a-subquery">Example: Flatten an Array of Maps using a Subquery</h3>
 
@@ -1308,7 +1396,7 @@ FROM dfs.`/Users/mypath/example.json` t;
 
 <ul>
 <li><p><a href="/docs/json-data-model#flatten-json-data">FLATTEN</a> separates a set of nested JSON objects into individual rows in a DRILL table.</p></li>
-<li><p><a href="/docs/json-data-model#generate-key-value-pairs">KVGEN</a> separates objects having more elements than optimal for querying.</p></li>
+<li><p><a href="/docs/kvgen/">KVGEN</a> separates objects having more elements than optimal for querying.</p></li>
 </ul>
 
 <h3 id="nested-column-names">Nested Column Names</h3>
@@ -1338,8 +1426,8 @@ FROM dfs.`/Users/mypath/example.json` t;
 
 <p>Drill interprets numbers that do not have a decimal point as BigInt values. In this example, Drill recognizes the first two coordinates as doubles and the third coordinate as a BigInt, which causes an error. </p>
 
-<p>Workaround: Set the <code>store.json.all_text_mode</code> property, described earlier, to true.</p>
-<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `store.json.all_text_mode` = true;
+<p>Workaround: Set the <code>store.json.read_numbers_as_double</code> property, described earlier, to true.</p>
+<div class="highlight"><pre><code class="language-text" data-lang="text">ALTER SYSTEM SET `store.json.read_numbers_as_double` = true;
 </code></pre></div>
 <h3 id="selecting-all-in-a-json-directory-query">Selecting all in a JSON directory query</h3>
 
@@ -1347,17 +1435,17 @@ FROM dfs.`/Users/mypath/example.json` t;
 
 <p>Workaround: Query each file individually.</p>
 
+    
       
-        
-          <div class="doc-nav">
+        <div class="doc-nav">
   
   <span class="previous-toc"><a href="/docs/parquet-format/">← Parquet Format</a></span><span class="next-toc"><a href="/docs/develop-custom-functions/">Develop Custom Functions →</a></span>
 </div>
 
-      
-      </div>
+    
     </div>
   </div>
+</div>
 
   </div>
   <p class="push"></p>


Mime
View raw message