http://git-wip-us.apache.org/repos/asf/drill-site/blob/7ac75bd4/docs/apache-drill-1-12-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/docs/apache-drill-1-12-0-release-notes/index.html 
b/docs/apache-drill-1-12-0-release-notes/index.html
new file mode 100644
index 0000000..62b2504
--- /dev/null
+++ b/docs/apache-drill-1-12-0-release-notes/index.html
@@ -0,0 +1,1609 @@
+<!DOCTYPE html>
+<html>
+
+<head>
+
+<meta charset="UTF-8">
+<meta name=viewport content="width=device-width, initial-scale=1">
+
+
+<title>Apache Drill 1.12.0 Release Notes - Apache Drill</title>
+
+<link 
href="//maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" 
rel="stylesheet" type="text/css"/>
+<link href='//fonts.googleapis.com/css?family=PT+Sans' 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>
+
+<div id="menu" class="mw">
+<ul>
+  <li class='toc-categories'>
+  <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa 
fa-bars"></i></a>
+  </li>
+  <li class="logo"><a href="/"></a></li>
+  <li class='expand-menu'>
+  <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span 
class='expand-icon'><i class="fa fa-bars"></i></span></a>
+  </li>
+  <li class='clear-float'></li>
+  <li class="documentation-menu">
+    <a href="/docs/">Documentation</a>
+    <ul>
+      
+        <li><a href="/docs/getting-started/">Getting Started</a></li>
+      
+        <li><a href="/docs/architecture/">Architecture</a></li>
+      
+        <li><a href="/docs/tutorials/">Tutorials</a></li>
+      
+        <li><a href="/docs/install-drill/">Install Drill</a></li>
+      
+        <li><a href="/docs/configure-drill/">Configure Drill</a></li>
+      
+        <li><a href="/docs/connect-a-data-source/">Connect a Data 
Source</a></li>
+      
+        <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
+      
+        <li><a href="/docs/query-data/">Query Data</a></li>
+      
+        <li><a href="/docs/performance-tuning/">Performance Tuning</a></li>
+      
+        <li><a href="/docs/log-and-debug/">Log and Debug</a></li>
+      
+        <li><a href="/docs/sql-reference/">SQL Reference</a></li>
+      
+        <li><a href="/docs/data-sources-and-file-formats/">Data Sources and 
File Formats</a></li>
+      
+        <li><a href="/docs/develop-custom-functions/">Develop Custom 
Functions</a></li>
+      
+        <li><a href="/docs/troubleshooting/">Troubleshooting</a></li>
+      
+        <li><a href="/docs/developer-information/">Developer 
Information</a></li>
+      
+        <li><a href="/docs/release-notes/">Release Notes</a></li>
+      
+        <li><a href="/docs/sample-datasets/">Sample Datasets</a></li>
+      
+        <li><a href="/docs/project-bylaws/">Project Bylaws</a></li>
+      
+    </ul>
+  </li>
+  <li class='nav'>
+    <a href="/community-resources/">Community</a>
+    <ul>
+      <li><a href="/team/">Team</a></li>
+      <li><a href="/mailinglists/">Mailing Lists</a></li>
+      <li><a href="/community-resources/">Community Resources</a></li>
+    </ul>
+  </li>
+  <li class='nav'><a href="/faq/">FAQ</a></li>
+  <li class='nav'><a href="/blog/">Blog</a></li>
+  <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill"; 
title="apachedrill on twitter" target="_blank"><img 
src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> 
</li>
+  <li class='search-bar'>
+    <form id="drill-search-form">
+      <input type="text" placeholder="Search Apache Drill" 
id="drill-search-term" />
+      <button type="submit">
+        <i class="fa fa-search"></i>
+      </button>
+    </form>
+  </li>
+  <li class="d">
+    <a href="/download/">
+      <i class="fa fa-cloud-download"></i> Download
+    </a>
+  </li>
+</ul>
+</div>
+
+    <link href="/css/content.css" rel="stylesheet" type="text/css">
+
+
+      
+
+
+
+
+<aside class="sidebar">
+  <div class="docsidebar">
+    <div class="docsidebarwrapper">
+      <ul style="display: block;">
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Getting 
Started</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-introduction/">Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/why-drill/">Why Drill</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: 
void(0);">Architecture</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/architecture-introduction/">Architecture Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-query-execution/">Drill Query Execution</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/core-modules/">Core Modules</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/performance/">Performance</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: 
void(0);">Tutorials</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/tutorials-introduction/">Tutorials Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-the-yelp-academic-dataset/">Analyzing the Yelp Academic 
Dataset</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Learn 
Drill with the MapR Sandbox</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill 
Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/getting-to-know-the-drill-sandbox/">Getting to Know the Drill 
Sandbox</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lesson-1-learn-about-the-data-set/">Lesson 1: Learn about the Data 
Set</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lesson-2-run-queries-with-ansi-sql/">Lesson 2: Run Queries with 
ANSI SQL</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/lesson-3-run-queries-on-complex-data-types/">Lesson 3: Run Queries 
on Complex Data Types</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/summary/">Summary</a></li>
+              
+            </ul>
+            
+          
+            
+              <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>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/analyzing-data-using-window-functions/">Analyzing Data Using Window 
Functions</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Install 
Drill</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/install-drill-introduction/">Install Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/migrating-parquet-data/">Migrating Parquet Data</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
Drill in Embedded Mode</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/embedded-mode-prerequisites/">Embedded Mode Prerequisites</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-linux-and-mac-os-x/">Installing Drill on Linux 
and Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-on-linux-and-mac-os-x/">Starting Drill on Linux and 
Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-windows/">Installing Drill on Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-on-windows/">Starting Drill on Windows</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
Drill in Distributed Mode</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/distributed-mode-prerequisites/">Distributed Mode 
Prerequisites</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-drill-on-the-cluster/">Installing Drill on the 
Cluster</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/starting-drill-in-distributed-mode/">Starting Drill in Distributed 
Mode</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/starting-the-web-console/">Starting the Web Console</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/identifying-multiple-drill-versions-in-a-cluster/">Identifying 
Multiple Drill Versions in a Cluster</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Configure 
Drill</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configure-drill-introduction/">Configure Drill Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-drill-memory/">Configuring Drill Memory</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Securing 
Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/securing-drill-introduction/">Securing Drill Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/secure-communication-paths/">Secure Communication Paths</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/roles-and-privileges/">Roles and Privileges</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-user-impersonation/">Configuring User 
Impersonation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-inbound-impersonation/">Configuring Inbound 
Impersonation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-user-impersonation-with-hive-authorization/">Configuring
 User Impersonation with Hive Authorization</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-user-security/">Configuring User Security</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-plain-security/">Configuring Plain Security</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-kerberos-security/">Configuring Kerberos 
Security</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-web-console-and-rest-api-security/">Configuring Web 
Console and REST API Security</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuring a Multitenant Cluster</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-a-multitenant-cluster-introduction/">Configuring a 
Multitenant Cluster Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-multitenant-resources/">Configuring Multitenant 
Resources</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-resources-for-a-shared-drillbit/">Configuring Resources 
for a Shared Drillbit</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuration Options</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuration-options-introduction/">Configuration Options 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/start-up-options/">Start-Up Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/planning-and-execution-options/">Planning and Execution 
Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/persistent-configuration-storage/">Persistent Configuration 
Storage</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/ports-used-by-drill/">Ports Used by Drill</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Connect a Data 
Source</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/connect-a-data-source-introduction/">Connect a Data Source 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Storage 
Plugin Configuration</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/workspaces/">Workspaces</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-default-input-format/">Drill Default Input Format</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-storage-plugin/">Hive Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/rdbms-storage-plugin/">RDBMS Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/mongodb-storage-plugin/">MongoDB Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/mapr-db-format/">MapR-DB Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/httpd-storage-plugin/">HTTPD Storage Plugin</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">ODBC/JDBC 
Interfaces</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/interfaces-introduction/">Interfaces Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-the-jdbc-driver/">Using the JDBC Driver</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>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Installing 
the ODBC Driver</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-linux/">Installing the Driver on 
Linux</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS 
X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/installing-the-driver-on-windows/">Installing the Driver on 
Windows</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Configuring ODBC</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/odbc-configuration-reference/">ODBC Configuration Reference</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/logging-and-tracing/">Logging and Tracing</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-odbc-on-linux/">Configuring ODBC on Linux</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-odbc-on-mac-os-x/">Configuring ODBC on Mac OS X</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-odbc-on-windows/">Configuring ODBC on Windows</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Using 
Drill Explorer</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-explorer-introduction/">Drill Explorer Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/connecting-drill-explorer-to-data/">Connecting Drill Explorer to 
Data</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/browsing-data-and-defining-views/">Browsing Data and Defining 
Views</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Using 
Drill with BI Tools</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-drill-with-bi-tools-introduction/">Using Drill with BI Tools 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/tableau-examples/">Tableau Examples</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-microstrategy-analytics-with-apache-drill/">Using 
MicroStrategy Analytics with Apache Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-tibco-spotfire-desktop-with-drill/">Using Tibco Spotfire 
Desktop with Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco 
Spotfire Server with Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-qlik-sense-with-drill/">Using Qlik Sense with Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-apache-drill-with-tableau-10-2/">Using Apache Drill with 
Tableau 10.2</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with 
Tableau 9 Desktop</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with 
Tableau 9 Server</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-information-builders-webfocus-with-apache-drill/">Using 
Information Builders’ WebFOCUS with Apache Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/configuring-jreport-with-drill/">Configuring JReport with 
Drill</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Query 
Data</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-data-introduction/">Query Data Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Querying a 
File System</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-a-file-system-introduction/">Querying a File System 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-avro-files/">Querying Avro Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-json-files/">Querying JSON Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-parquet-files/">Querying Parquet Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-directories/">Querying Directories</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-sequence-files/">Querying Sequence Files</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-hbase/">Querying HBase</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Querying 
Complex Data</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/querying-complex-data-introduction/">Querying Complex Data 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-flat-data/">Selecting Flat Data</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, 
Clauses, and Joins</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a 
Column</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple 
Columns Within Nested Data</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-hive/">Querying Hive</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-the-information-schema/">Querying the INFORMATION 
SCHEMA</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/querying-system-tables/">Querying System Tables</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-and-canceling-queries-in-the-drill-web-console/">Monitoring
 and Canceling Queries in the Drill Web Console</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <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>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Partition 
Pruning</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/partition-pruning-introduction/">Partition Pruning 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/how-to-partition-data/">How to Partition Data</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/asynchronous-parquet-reader/">Asynchronous Parquet Reader</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/optimizing-parquet-metadata-reading/">Optimizing Parquet Metadata 
Reading</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/parquet-filter-pushdown/">Parquet Filter Pushdown</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-metadata-caching/">Hive Metadata Caching</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/choosing-a-storage-format/">Choosing a Storage Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Query 
Plans and Tuning</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-plans-and-tuning-introduction/">Query Plans and Tuning 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/join-planning-guidelines/">Join Planning Guidelines</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/guidelines-for-optimizing-aggregation/">Guidelines for Optimizing 
Aggregation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/modifying-query-planning-options/">Modifying Query Planning 
Options</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sort-based-and-hash-based-memory-constrained-operators/">Sort-Based 
and Hash-Based Memory-Constrained Operators</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/enabling-query-queuing/">Enabling Query Queuing</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/throttling/">Throttling</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/">Controlling
 Parallelization to Balance Performance with Multi-Tenancy</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Identifying Performance Issues</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-plans/">Query Plans</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-profiles/">Query Profiles</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: 
void(0);">Performance Tuning Reference</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-profile-column-descriptions/">Query Profile Column 
Descriptions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/physical-operators/">Physical Operators</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/monitoring-metrics/">Monitoring Metrics</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <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>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-audit-logging/">Query Audit Logging</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">SQL 
Reference</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Data 
Types</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/supported-data-types/">Supported Data Types</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/handling-different-data-types/">Handling Different Data 
Types</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/lexical-structure/">Lexical Structure</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/operators/">Operators</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/math-and-trig/">Math and Trig</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/data-type-conversion/">Data Type Conversion</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/date-time-functions-and-arithmetic/">Date/Time Functions and 
Arithmetic</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/string-manipulation/">String Manipulation</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/aggregate-and-aggregate-statistical/">Aggregate and Aggregate 
Statistical</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/functions-for-handling-nulls/">Functions for Handling Nulls</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL Window 
Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sql-window-functions-introduction/">SQL Window Functions 
Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/aggregate-window-functions/">Aggregate Window Functions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/ranking-window-functions/">Ranking Window Functions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/value-window-functions/">Value Window Functions</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/sql-window-functions-examples/">SQL Window Functions 
Examples</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Nested 
Data Functions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/nested-data-limitations/">Nested Data Limitations</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/flatten/">FLATTEN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/kvgen/">KVGEN</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/repeated-count/">REPEATED_COUNT</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/query-directory-functions/">Query Directory Functions</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Commands</a></li>
+              <ul style="display: none">
+              
+                <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/set/">SET</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/reset/">RESET</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-temporary-table-as-cttas/">CREATE TEMPORARY TABLE AS 
(CTTAS)</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/create-function-using-jar/">CREATE FUNCTION USING JAR</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/partition-by-clause/">PARTITION BY Clause</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/">DESCRIBE</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drop-function-using-jar/">DROP FUNCTION USING JAR</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drop-table/">DROP TABLE</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/">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-list/">SELECT List</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/from-clause/">FROM Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/group-by-clause/">GROUP BY Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/having-clause/">HAVING Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/limit-clause/">LIMIT Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/offset-clause/">OFFSET Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/order-by-clause/">ORDER BY Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/union-set-operator/">UNION Set Operator</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/where-clause/">WHERE Clause</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/with-clause/">WITH Clause</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>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">SQL 
Conditional Expressions</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/case/">CASE</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/reserved-keywords/">Reserved Keywords</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sql-extensions/">SQL Extensions</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Data Sources 
and File Formats</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File 
Formats Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type 
Mapping</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive 
UDF</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/parquet-format/">Parquet Format</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/json-data-model/">JSON Data Model</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/text-files-csv-tsv-psv/">Text Files: CSV, TSV, PSV</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/sequence-files/">Sequence Files</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Develop Custom 
Functions</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/develop-custom-functions-introduction/">Develop Custom Functions 
Introduction</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/developing-a-simple-function/">Developing a Simple Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/tutorial-develop-a-simple-function/">Tutorial: Develop a Simple 
Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/developing-an-aggregate-function/">Developing an Aggregate 
Function</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Adding 
Custom Functions to Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/adding-custom-functions-to-drill-introduction/">Adding Custom 
Functions to Drill Introduction</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/manually-adding-custom-functions-to-drill/">Manually Adding Custom 
Functions to Drill</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/creating-custom-authenticators/">Creating Custom 
Authenticators</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/dynamic-udfs/">Dynamic UDFs</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/using-custom-functions-in-queries/">Using Custom Functions in 
Queries</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/custom-function-interfaces/">Custom Function Interfaces</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" 
href="/docs/troubleshooting/">Troubleshooting</a></li>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Developer 
Information</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/rest-api/">REST API</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Develop 
Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Contribute 
to Drill</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution 
Guidelines</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution 
Ideas</a></li>
+              
+            </ul>
+            
+          
+            
+              <li class="toctree-l2"><a href="javascript: void(0);">Design 
Docs</a></li>
+              <ul style="display: none">
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/rpc-overview/">RPC Overview</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/query-stages/">Query Stages</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/useful-research/">Useful Research</a></li>
+              
+                <li class="toctree-l3"><a class="reference internal" 
href="/docs/value-vectors/">Value Vectors</a></li>
+              
+            </ul>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1 current_section "><a href="javascript: 
void(0);">Release Notes</a></li>
+          <ul class="current_section">
+          
+            
+              <li class="toctree-l2 current"><a class="reference internal" 
href="/docs/apache-drill-1-12-0-release-notes/">Apache Drill 1.12.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-11-0-release-notes/">Apache Drill 1.11.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-10-0-release-notes/">Apache Drill 1.10.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-9-0-release-notes/">Apache Drill 1.9.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-8-0-release-notes/">Apache Drill 1.8.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-5-0-release-notes/">Apache Drill 1.5.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-4-0-release-notes/">Apache Drill 1.4.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-3-0-release-notes/">Apache Drill 1.3.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-2-0-release-notes/">Apache Drill 1.2.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-1-0-release-notes/">Apache Drill 1.1.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-7-0-release-notes/">Apache Drill 0.7.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-6-0-release-notes/">Apache Drill 0.6.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release 
Notes</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 
Release Notes (Apache Drill Alpha)</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 
Release Notes (Apache Drill Alpha)</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a href="javascript: void(0);">Sample 
Datasets</a></li>
+          <ul style="display: none">
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/aol-search/">AOL Search</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/enron-emails/">Enron Emails</a></li>
+            
+          
+            
+              <li class="toctree-l2"><a class="reference internal" 
href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
+            
+          
+          </ul>
+        
+      
+        
+          <li class="toctree-l1"><a class="reference internal" 
href="/docs/project-bylaws/">Project Bylaws</a></li>
+        
+      
+      </ul>
+
+    </div>
+  </div>
+</aside>
+
+
+<nav class="breadcrumbs">
+  <li><a href="/docs/">Docs</a></li>
+ 
+  
+    <li><a href="/docs/release-notes/">Release Notes</a></li>
+  
+  <li>Apache Drill 1.12.0 Release Notes</li>
+</nav>
+
+<div class="main-content-wrapper">
+  <div class="main-content">
+
+    
+      <a class="edit-link" 
href="https://github.com/apache/drill/blob/gh-pages/_docs/rn/001-1.12.0-rn.md"; 
target="_blank"><i class="fa fa-pencil-square-o"></i></a>
+    
+
+    <div class="int_title left">
+      <h1>Apache Drill 1.12.0 Release Notes</h1>
+
+    </div>
+
+     
+
+    <link href="/css/docpage.css" rel="stylesheet" type="text/css">
+
+    <div class="int_text" align="left">
+      
+        <p><strong>Release date:</strong>  December 15, 2017</p>
+
+<p>Today, we&#39;re happy to announce the availability of Drill 1.12.0. You 
can download it <a href="https://drill.apache.org/download/";>here</a>.</p>
+
+<h2 id="new-features-and-improvements">New Features and Improvements</h2>
+
+<p>This release of Drill provides the following new features and improvements: 
</p>
+
+<ul>
+<li>Kafka and OpenTSDB storage plugins (DRILL-4779, DRILL-5337)</li>
+<li>SSL/TLS support (DRILL-5431)</li>
+<li>Network encryption support (DRILL-5682)</li>
+<li>Queue-based memory assignment for buffering operators (DRILL-5716)</li>
+<li>A collection of networking functions that facilitate network analysis 
using Drill (DRILL-5834)</li>
+<li>Support for the libpam4j PAM authenticator (DRILL-5820)</li>
+<li>Filter pushdown for Parquet can handle files with multiple rowgroups 
(DRILL-5795)</li>
+<li>UTF-8 is enabled in the query string by default (DRILL-5772)</li>
+<li>IF NOT EXISTS support for CREATE TABLE and CREATE VIEWS (DRILL-5952)</li>
+<li>Geometry functions, <code>ST_AsGeoJSON</code> and <code>ST_AsJSON</code>, 
that return GeoJSON and JSON representations (DRILL-5962, DRILL-5960) </li>
+<li>JMX metrics for failed and canceled queries (DRILL-5909)</li>
+<li>Syntax highlighting and error checking for storage plugin configurations 
(DRILL-5981)</li>
+<li>System options improvements, including a new internal system options table 
(DRILL-5723)</li>
+<li>Ability to prevent users from accessing a path outside the current 
workspace (DRILL-5964)</li>
+<li>Ability to put the server in quiescent mode for a graceful shutdown 
(DRILL-4286)</li>
+<li>The Drill Web Console lists the completion of successfully completed 
queries as &quot;successful&quot; (DRILL-5923)</li>
+</ul>
+
+<p>The following sections list additional bug fixes and improvements:  </p>
+
+<h2>        Sub-task
+</h2>
+
+<ul>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5253'>DRILL-5253</a>] -       
  External sort fails with OOM error (Fails to allocate sv2)
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5801'>DRILL-5801</a>] -       
  Label the Gantt chart that indicates the lifespan details of the various 
minor fragments
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5802'>DRILL-5802</a>] -       
  Provide a sortable table for tables within a query profile
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5803'>DRILL-5803</a>] -       
  Show the hostname for each minor fragment in operator table
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5867'>DRILL-5867</a>] -       
  List profiles in pages rather than a long verbose listing
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5881'>DRILL-5881</a>] -       
  Java Client: [Threat Modeling] Drillbit may be spoofed by an attacker and 
this may lead to data being written to the attacker&#39;s target instead of 
Drillbit
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5882'>DRILL-5882</a>] -       
  C++ Client: [Threat Modeling] Drillbit may be spoofed by an attacker and this 
may lead to data being written to the attacker&#39;s target instead of Drillbit
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6031'>DRILL-6031</a>] -       
  Document support for dots in field names 
+</li>
+</ul>
+                            
+
+<h2>        Bug
+</h2>
+
+<ul>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-1051'>DRILL-1051</a>] -       
  Casting timestamp as date gives wrong result for dates earlier than 1883
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-1499'>DRILL-1499</a>] -       
  Different column order could appear in the result set for a schema-less 
select * query, even there are no changing schemas.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-3241'>DRILL-3241</a>] -       
  Query with window function runs out of direct memory and does not report back 
to client that it did
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-3407'>DRILL-3407</a>] -       
  CTAS Auto Partition : The plan for count(*) should show the list of files 
scanned
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-3449'>DRILL-3449</a>] -       
  When Foreman node dies, the FragmentExecutor still tries to send status 
updates to Foreman
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-3827'>DRILL-3827</a>] -       
  Empty metadata file causes queries on the table to fail
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-3829'>DRILL-3829</a>] -       
  Metadata Caching : Drill should ignore a corrupted cache file
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4139'>DRILL-4139</a>] -       
  Fix parquet partition pruning for BIT, INTERVAL and DECIMAL types
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4255'>DRILL-4255</a>] -       
  SELECT DISTINCT query over JSON data returns UNSUPPORTED OPERATION
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4640'>DRILL-4640</a>] -       
  Unable to submit physical plan from Web UI on Windows
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4686'>DRILL-4686</a>] -       
  Aggregation query over HBase table results in IllegalStateException: Failure 
while reading vector
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4734'>DRILL-4734</a>] -       
  Query against HBase table on a 5 node cluster fails with SchemaChangeException
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4735'>DRILL-4735</a>] -       
  Count(dir0) on parquet returns 0 result
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5002'>DRILL-5002</a>] -       
  Using hive&#39;s date functions on top of date column gives wrong results for 
local time-zone
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5146'>DRILL-5146</a>] -       
  Unnecessary spilling to disk by sort when we only have 5000 rows with one 
column
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5166'>DRILL-5166</a>] -       
  Select with options returns NPE
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5185'>DRILL-5185</a>] -       
  Union all not passing type info when the output contains 0 rows
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5268'>DRILL-5268</a>] -       
  SYSTEM ERROR: UnsupportedOperationException: Unable to get size for minor 
type [MAP] and mode [REQUIRED]
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5269'>DRILL-5269</a>] -       
  SYSTEM ERROR: JsonMappingException: No suitable constructor found for type 
[simple type, class org.apache.drill.exec.store.direct.DirectSubScan]
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5327'>DRILL-5327</a>] -       
  Hash aggregate can return empty batch which can cause schema change exception
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5339'>DRILL-5339</a>] -       
  Web UI: flaws in query profile display on error
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5341'>DRILL-5341</a>] -       
  Web UI: remove duplicating link to documentation in Options page
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5346'>DRILL-5346</a>] -       
  Web UI: remove link on user in query profile list
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5357'>DRILL-5357</a>] -       
  Partition pruning information not available in query plan for COUNT aggregate 
query
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5416'>DRILL-5416</a>] -       
  Vectors read from disk report incorrect memory sizes
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5442'>DRILL-5442</a>] -       
  Managed Sort: IndexOutOfBounds with a join over an inlist
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5443'>DRILL-5443</a>] -       
  Managed External Sort fails with OOM while spilling to disk
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5445'>DRILL-5445</a>] -       
  Assertion Error in Managed External Sort when dealing with repeated maps
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5447'>DRILL-5447</a>] -       
  Managed External Sort : Unable to allocate sv2 vector
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5464'>DRILL-5464</a>] -       
  Fix JSON reader when it deals with empty file
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5465'>DRILL-5465</a>] -       
  Managed external sort results in an OOM
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5478'>DRILL-5478</a>] -       
  Spill file size parameter is not honored by the managed external sort
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5480'>DRILL-5480</a>] -       
  Empty batch returning from HBase may cause SchemaChangeException even when 
data does not have different schema
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5507'>DRILL-5507</a>] -       
  Millions of &quot;Failure finding Drillbit running on host&quot; info 
messages in foreman logs
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5513'>DRILL-5513</a>] -       
  Managed External Sort : OOM error during the merge phase
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5519'>DRILL-5519</a>] -       
  Sort fails to spill and results in an OOM
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5525'>DRILL-5525</a>] -       
  Inconsistent, unhelpful semantics for batch, field schema comparison
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5546'>DRILL-5546</a>] -       
  Schema change problems caused by empty batch
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5547'>DRILL-5547</a>] -       
  Drill config options and session options do not work as intended
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5564'>DRILL-5564</a>] -       
  IllegalStateException: allocator[op:21:1:5:HashJoinPOP]: buffer space 
(16674816) + prealloc space (0) + child space (0) != allocated (16740352)
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5582'>DRILL-5582</a>] -       
  [Threat Modeling] Drillbit may be spoofed by an attacker and this may lead to 
data being written to the attacker&#39;s target instead of Drillbit
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5594'>DRILL-5594</a>] -       
  Excessive buffer reallocations during merge phase of external sort
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5597'>DRILL-5597</a>] -       
  Incorrect &quot;bits&quot; vector allocation in nullable vectors allocateNew()
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5602'>DRILL-5602</a>] -       
  Repeated List Vector fails to initialize the offset vector
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5617'>DRILL-5617</a>] -       
  Spill file name collisions when spill file is on a shared file system
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5645'>DRILL-5645</a>] -       
  negation of expression causes null pointer exception
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5660'>DRILL-5660</a>] -       
  Drill 1.10 queries fail due to Parquet Metadata &quot;corruption&quot; from 
DRILL-3867
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5663'>DRILL-5663</a>] -       
  Drillbit fails to start when only keystore path is provided without keystore 
password.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5675'>DRILL-5675</a>] -       
  Drill C++ Client Date Time Literals Support Metadata Mapping is Incorrect
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5686'>DRILL-5686</a>] -       
  Warning for sasl.max_wrapped_size contain incorrect syntax
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5687'>DRILL-5687</a>] -       
  Disable TestMergeJoinWithSchemaChanges#testMissingAndNewColumns
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5694'>DRILL-5694</a>] -       
  hash agg spill to disk, second phase OOM
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5698'>DRILL-5698</a>] -       
  Drill should start in embedded mode using java 1.8.0_144
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5699'>DRILL-5699</a>] -       
  Drill Web UI Page Source Has Links To External Sites
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5701'>DRILL-5701</a>] -       
  drill.connections.rpc.&lt;user/control/data&gt;.&lt;encrypted/unencrypted&gt; 
metric not behaving correctly
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5702'>DRILL-5702</a>] -       
  Jdbc Driver Class not found
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5710'>DRILL-5710</a>] -       
  drill-config.sh incorrectly exits with Java 1.7 or later is required to run 
Apache Drill
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5714'>DRILL-5714</a>] -       
  Fix NPE when mapr-db plugin is used in table function
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5715'>DRILL-5715</a>] -       
  Performance of refactored HashAgg operator regressed
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5717'>DRILL-5717</a>] -       
  change some date time unit cases with specific timezone or Local
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5721'>DRILL-5721</a>] -       
  Query with only root fragment and no non-root fragment hangs when Drillbit to 
Drillbit Control Connection has network issues
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5725'>DRILL-5725</a>] -       
  Update Jackson version to 2.7.8
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5727'>DRILL-5727</a>] -       
  Update release profile to generate SHA-512 checksum.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5729'>DRILL-5729</a>] -       
  Fix Travis Checks
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5737'>DRILL-5737</a>] -       
  Hash Agg uses more than the allocated memory under certain low memory 
conditions
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5740'>DRILL-5740</a>] -       
  hash agg fail to read spill file
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5743'>DRILL-5743</a>] -       
  Using order by clause in a select * query on hbase table returns only the 
row_key and order by field(s)
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5744'>DRILL-5744</a>] -       
  External sort fails with OOM error
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5745'>DRILL-5745</a>] -       
  Invalid &quot;location&quot; information in Drill web server
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5746'>DRILL-5746</a>] -       
  Pcap PR manually edited Protobuf files, values lost on next build
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5749'>DRILL-5749</a>] -       
  Foreman and Netty threads occure deadlock 
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5751'>DRILL-5751</a>] -       
  Fix unit tests to use local file system even if it is not set by default
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5753'>DRILL-5753</a>] -       
  Managed External Sort: One or more nodes ran out of memory while executing 
the query.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5755'>DRILL-5755</a>] -       
  TOP_N_SORT operator does not free memory while running
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5757'>DRILL-5757</a>] -       
  CONVERT_TO_JSON function is failed while using non-existence field as a 
parameter.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5761'>DRILL-5761</a>] -       
  Disable Lilith ClassicMultiplexSocketAppender by default
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5763'>DRILL-5763</a>] -       
  Fix NPE during MapRDBSubScan deserialization
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5765'>DRILL-5765</a>] -       
  Json query profile is not shown on Web UI
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5766'>DRILL-5766</a>] -       
  Stored XSS in APACHE DRILL
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5771'>DRILL-5771</a>] -       
  Fix serDe errors for format plugins
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5775'>DRILL-5775</a>] -       
  Select * query on a maprdb binary table fails
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5790'>DRILL-5790</a>] -       
  PCAP format explicitly opens local file
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5792'>DRILL-5792</a>] -       
  CONVERT_FROM_JSON on an empty file throws runtime exception
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5804'>DRILL-5804</a>] -       
  External Sort times out, may be infinite loop
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5811'>DRILL-5811</a>] -       
  Large number of &quot;Failure finding Drillbit&quot; messages when using MFS
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5812'>DRILL-5812</a>] -       
  Restore the minor fragment Gantt chart Canvas
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5816'>DRILL-5816</a>] -       
  Hash function produces skewed results on String values with same leading 
prefix
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5819'>DRILL-5819</a>] -       
  Default value of security.admin.user_groups and security.admin.users is 
&quot;true&quot;
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5822'>DRILL-5822</a>] -       
  The query with &quot;SELECT *&quot; with &quot;ORDER BY&quot; clause and 
`planner.slice_target`=1 doesn&#39;t preserve column order
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5824'>DRILL-5824</a>] -       
  1st phase Hash Aggregate allocates more memory than the limit
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5830'>DRILL-5830</a>] -       
  Resolve regressions to MapR DB from DRILL-5546
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5838'>DRILL-5838</a>] -       
  Fix MaprDB filter pushdown for the case of nested field (reg. of DRILL-4264)
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5839'>DRILL-5839</a>] -       
  Handle Empty Batches in Merge Receiver
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5840'>DRILL-5840</a>] -       
  A query that includes sort completes, and then loses Drill connection. Drill 
becomes unresponsive, and cannot restart because it cannot communicate with 
Zookeeper
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5845'>DRILL-5845</a>] -       
  Columns returned by select with &quot;ORDER BY&quot; and &quot;LIMIT&quot; 
clauses are not in correct order.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5849'>DRILL-5849</a>] -       
  Add freemarker lib to dependencyManagement to ensure proper version is used 
when resolving dependency version conflicts
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5853'>DRILL-5853</a>] -       
  Sort removal based on NULL direction
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5854'>DRILL-5854</a>] -       
  IllegalStateException when empty batch is received.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5857'>DRILL-5857</a>] -       
  Fix NumberFormatException in Hive unit tests
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5859'>DRILL-5859</a>] -       
  Time for query queuing timeout not display correctly in WebUI
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5863'>DRILL-5863</a>] -       
  Sortable table incorrectly sorts minor fragments and time elements lexically 
instead of sorting by implicit value
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5864'>DRILL-5864</a>] -       
  Selecting a non-existing field from a MapR-DB JSON table fails with NPE
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5872'>DRILL-5872</a>] -       
  Deserialization of profile JSON fails due to totalCost being reported as 
&quot;NaN&quot;
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5874'>DRILL-5874</a>] -       
  NPE in AnonWebUserConnection.cleanupSession()
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5878'>DRILL-5878</a>] -       
  TableNotFound exception is being reported for a wrong storage plugin.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5887'>DRILL-5887</a>] -       
  Display process user/ groups in Drill UI
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5888'>DRILL-5888</a>] -       
  jdbc-all-jar unit tests broken because of dependency on hadoop.security
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5890'>DRILL-5890</a>] -       
  Tests Leak Many Open File Descriptors
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5895'>DRILL-5895</a>] -       
  Fix unit tests for mongo storage plugin
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5896'>DRILL-5896</a>] -       
  Handle vector creation in HbaseRecordReader to avoid NullableInt vectors later
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5898'>DRILL-5898</a>] -       
  Query returns columns in the wrong order
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5906'>DRILL-5906</a>] -       
  java.lang.NullPointerException while quering Hive ORC tables on MapR cluster. 
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5923'>DRILL-5923</a>] -       
  State of a successfully completed query shown as &quot;COMPLETED&quot;
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5941'>DRILL-5941</a>] -       
  Skip header / footer logic works incorrectly for Hive tables when file has 
several input splits
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5972'>DRILL-5972</a>] -       
  Slow performance for query on INFORMATION_SCHEMA.TABLE
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5979'>DRILL-5979</a>] -       
  unnable to access temporary table from drill web interface
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5986'>DRILL-5986</a>] -       
  Update jackson-databind version to 2.7.9.1
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5987'>DRILL-5987</a>] -       
  Two versions of javassist on the classpath
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6006'>DRILL-6006</a>] -       
  Label current is missing on Web UI since the same drillbits with different 
status are considered to be different
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6007'>DRILL-6007</a>] -       
  web ui index page is refreshed at high pace 
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6017'>DRILL-6017</a>] -       
  Fix for SHUTDOWN button being visible for non Admin users
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6019'>DRILL-6019</a>] -       
  Only admin should be able to access shutdown resources
+</li>
+<li>Order by doesn't sort columns when window function is involved in the 
query</li>
+<li>MIN MAX DIR tests fail and return incorrect results</li>
+<li>header.line.count does not work for Hive table with data file size &gt; 
chunk size</li>
+<li>lang.NoClassDefFoundError exception not handled in 
org.apache.drill.exec.rpc.security.ClientAuthenticatorProvider</li>
+<li>Investigate jackson-databind vulnerabilities CVE-2017-15095 &amp; 
CVE-2017-7525</li>
+<li>Null Pointer Exception with query using table function</li>
+<li>Fix XSS vulnerabilities in Drill</li>
+<li>Some queries in concurrent execution get stuck in STARTING phase</li>
+<li>hashagg.num_partitions cannot be set by "alter session" or "alter 
system"</li>
+<li>Query with 2-way JOIN fails with "Hash join does not support schema 
changes"</li>
+<li>RowKeyJoin is generated instead of IndexScan for queries with derived 
table/ table functions</li>
+<li>ConvertCountToDirectScan rule enhancements</li>
+<li>Drill wrong old date-time values displaying</li>
+<li>Warning message "Exception while trying to prune partition" when query on 
view</li>
+<li>Drill not able to read MapR-DB when FQDN is longer than 64 characters</li>
+<li>Pam authentication with Centrify doesn't work by JPam restriction</li>
+<li>Hash aggregate does not support schema changes</li>
+<li>Simple query with only one join condition failed with "Hash join does not 
support schema changes"</li>
+<li>UnsupportedOperationException: Unable to get holder type for minor type 
[LATE] and mode [OPTIONAL].</li>
+<li>Query on TPC-H SF100 dataset fails with "Hash join does not support schema 
changes" [MapR-DB JSON Tables]</li>
+</ul>
+                                        
+
+<h2>        Improvement
+</h2>
+
+<ul>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-1691'>DRILL-1691</a>] -       
  ConvertCountToDirectScan rule should be applicable for 2 or more COUNT 
aggregates
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4264'>DRILL-4264</a>] -       
  Allow field names to include dots
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5089'>DRILL-5089</a>] -       
  Skip initializing all enabled storage plugins for every query
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5106'>DRILL-5106</a>] -       
  Refactor SkipRecordsInspector to exclude check for predefined file formats
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5259'>DRILL-5259</a>] -       
  Allow listing a user-defined number of profiles 
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5338'>DRILL-5338</a>] -       
  Web UI: add better visual indication for PLANNING, QUEUED, EXECUTION in Query 
Profile that they are part of total time duration
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5704'>DRILL-5704</a>] -       
  Improve error message on client side when queries fail with &quot;Failed to 
create schema tree.&quot; when Impersonation is enabled and logins are anonymous
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5709'>DRILL-5709</a>] -       
  Provide a value vector method to convert a vector to nullable
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5716'>DRILL-5716</a>] -       
  Queue-based memory assignment for buffering operators
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5726'>DRILL-5726</a>] -       
  Support Impersonation without authentication for REST API
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5795'>DRILL-5795</a>] -       
  Filter pushdown for parquet handles multi rowgroup file
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5808'>DRILL-5808</a>] -       
  Reduce memory allocator strictness for &quot;managed&quot; operators
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5815'>DRILL-5815</a>] -       
  Provide option to set query memory as percent of total
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5832'>DRILL-5832</a>] -       
  Migrate OperatorFixture to use SystemOptionManager rather than mock
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5834'>DRILL-5834</a>] -       
  Add Networking Functions
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5842'>DRILL-5842</a>] -       
  Refactor and simplify the fragment, operator contexts for testing
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5862'>DRILL-5862</a>] -       
  Update project parent pom xml to the latest ASF version
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5893'>DRILL-5893</a>] -       
  Maven forkCount property is too aggressive causing builds to fail on some 
machines.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5899'>DRILL-5899</a>] -       
  Simple pattern matchers can work with DrillBuf directly
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5909'>DRILL-5909</a>] -       
  need new JMX metrics for (FAILED and CANCELED) queries
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5910'>DRILL-5910</a>] -       
  Logging exception when  custom AuthenticatorFactory not found
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5921'>DRILL-5921</a>] -       
  Counters metrics should be listed in table
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5943'>DRILL-5943</a>] -       
  Avoid the strong check introduced by DRILL-5582 for PLAIN mechanism
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5952'>DRILL-5952</a>] -       
  Implement &quot;CREATE TABLE IF NOT EXISTS&quot;
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5960'>DRILL-5960</a>] -       
  Add function STAsGeoJSON to extend GIS support
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5962'>DRILL-5962</a>] -       
  Add function STAsJSON to extend GIS support
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5964'>DRILL-5964</a>] -       
  Do not allow queries to access paths outside the current workspace root
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5980'>DRILL-5980</a>] -       
  Make queryType param for REST API case insensitive
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5981'>DRILL-5981</a>] -       
  Add Syntax Highlighting and Error Checking to Storage Plugin Config Page
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5989'>DRILL-5989</a>] -       
  Run Smoke Tests On Travis
+</li>
+</ul>
+            
+
+<h2>        New Feature
+</h2>
+
+<ul>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4286'>DRILL-4286</a>] -       
  Have an ability to put server in quiescent mode of operation
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-4779'>DRILL-4779</a>] -       
  Kafka storage plugin support
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5337'>DRILL-5337</a>] -       
  OpenTSDB storage plugin
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5431'>DRILL-5431</a>] -       
  Support SSL
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5682'>DRILL-5682</a>] -       
  Apache Drill should support network encryption
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5723'>DRILL-5723</a>] -       
  Support System/Session Internal Options And Additional Option System Fixes
+</li>
+</ul>
+                                                                    
+
+<h2>        Task
+</h2>
+
+<ul>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5601'>DRILL-5601</a>] -       
  Rollup of External Sort memory management fixes
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5685'>DRILL-5685</a>] -       
  Provide a way to set common environment variable between sqlline and Drillbit 
differently.
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5758'>DRILL-5758</a>] -       
  Rollup of external sort fixes to issues found by QA
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5772'>DRILL-5772</a>] -       
  Enable UTF-8 support in query string by default
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5781'>DRILL-5781</a>] -       
  Fix unit test failures to use tests config even if default config is available
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5820'>DRILL-5820</a>] -       
  Add support for libpam4j Pam Authenticator
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5911'>DRILL-5911</a>] -       
  Upgrade esri-geometry-api version to 2.0.0 to avoid dependency on org.json 
library
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-5917'>DRILL-5917</a>] -       
  Ban org.json:json library in Drill
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6000'>DRILL-6000</a>] -       
  Graceful Shutdown Unit Tests Should Not Be Run On Travis
+</li>
+<li>[<a 
href='https://issues.apache.org/jira/browse/DRILL-6011'>DRILL-6011</a>] -       
  Update log info message in DrillClient
+</li>
+</ul>
+                
+
+    
+      
+        <div class="doc-nav">
+  
+  <span class="previous-toc"><a href="/docs/release-notes/">← Release 
Notes</a></span><span class="next-toc"><a 
href="/docs/apache-drill-1-11-0-release-notes/">Apache Drill 1.11.0 Release 
Notes →</a></span>
+</div>
+
+    
+    </div>
+  </div>
+</div>
+
+  </div>
+  <p class="push"></p>
+<div id="footer" class="mw">
+<div class="wrapper">
+Copyright © 2012-2014 The Apache Software Foundation, licensed under the 
Apache License, Version 2.0.<br>
+Apache and the Apache feather logo are tra

<TRUNCATED>

Reply via email to