drill-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From a..@apache.org
Subject [14/51] [abbrv] [partial] drill-site git commit: Revert "Website update"
Date Fri, 24 Feb 2017 23:18:39 GMT
http://git-wip-us.apache.org/repos/asf/drill-site/blob/bdf0f883/_site/docs/apache-drill-1-2-0-release-notes/index.html
----------------------------------------------------------------------
diff --git a/_site/docs/apache-drill-1-2-0-release-notes/index.html b/_site/docs/apache-drill-1-2-0-release-notes/index.html
deleted file mode 100644
index 70c0bd4..0000000
--- a/_site/docs/apache-drill-1-2-0-release-notes/index.html
+++ /dev/null
@@ -1,1583 +0,0 @@
-<!DOCTYPE html>
-<html>
-
-<head>
-
-<meta charset="UTF-8">
-<meta name=viewport content="width=device-width, initial-scale=1">
-<meta name="robots" content="noindex">
-
-<title>Apache Drill 1.2.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="/drill/css/site.css" rel="stylesheet" type="text/css"/>
-
-<link rel="shortcut icon" href="/drill/favicon.ico" type="image/x-icon"/>
-<link rel="icon" href="/drill/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="/drill/js/modernizr.custom.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/js/script.js"></script>
-<script language="javascript" type="text/javascript" src="/drill/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="/drill/"></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="/drill/docs/">Documentation</a>
-    <ul>
-      
-        <li><a href="/drill/docs/getting-started/">Getting Started</a></li>
-      
-        <li><a href="/drill/docs/architecture/">Architecture</a></li>
-      
-        <li><a href="/drill/docs/tutorials/">Tutorials</a></li>
-      
-        <li><a href="/drill/docs/install-drill/">Install Drill</a></li>
-      
-        <li><a href="/drill/docs/configure-drill/">Configure Drill</a></li>
-      
-        <li><a href="/drill/docs/connect-a-data-source/">Connect a Data Source</a></li>
-      
-        <li><a href="/drill/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li>
-      
-        <li><a href="/drill/docs/query-data/">Query Data</a></li>
-      
-        <li><a href="/drill/docs/performance-tuning/">Performance Tuning</a></li>
-      
-        <li><a href="/drill/docs/log-and-debug/">Log and Debug</a></li>
-      
-        <li><a href="/drill/docs/sql-reference/">SQL Reference</a></li>
-      
-        <li><a href="/drill/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li>
-      
-        <li><a href="/drill/docs/develop-custom-functions/">Develop Custom Functions</a></li>
-      
-        <li><a href="/drill/docs/troubleshooting/">Troubleshooting</a></li>
-      
-        <li><a href="/drill/docs/developer-information/">Developer Information</a></li>
-      
-        <li><a href="/drill/docs/release-notes/">Release Notes</a></li>
-      
-        <li><a href="/drill/docs/sample-datasets/">Sample Datasets</a></li>
-      
-        <li><a href="/drill/docs/project-bylaws/">Project Bylaws</a></li>
-      
-    </ul>
-  </li>
-  <li class='nav'>
-    <a href="/drill/community-resources/">Community</a>
-    <ul>
-      <li><a href="/drill/team/">Team</a></li>
-      <li><a href="/drill/mailinglists/">Mailing Lists</a></li>
-      <li><a href="/drill/community-resources/">Community Resources</a></li>
-    </ul>
-  </li>
-  <li class='nav'><a href="/drill/faq/">FAQ</a></li>
-  <li class='nav'><a href="/drill/blog/">Blog</a></li>
-  <li id="twitter-menu-item"><a href="https://twitter.com/apachedrill" title="apachedrill on twitter" target="_blank"><img src="/drill/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="/drill/download/">
-      <i class="fa fa-cloud-download"></i> Download
-    </a>
-  </li>
-</ul>
-</div>
-
-    <link href="/drill/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="/drill/docs/drill-introduction/">Drill Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/architecture-introduction/">Architecture Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/drill-query-execution/">Drill Query Execution</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/core-modules/">Core Modules</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/tutorials-introduction/">Tutorials Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/drill-in-10-minutes/">Drill in 10 Minutes</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill Sandbox</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/getting-to-know-the-drill-sandbox/">Getting to Know the Drill Sandbox</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/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="/drill/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="/drill/docs/summary/">Summary</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/analyzing-social-media/">Analyzing Social Media</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/install-drill-introduction/">Install Drill Introduction</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="/drill/docs/embedded-mode-prerequisites/">Embedded Mode Prerequisites</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/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="/drill/docs/installing-drill-on-windows/">Installing Drill on Windows</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/distributed-mode-prerequisites/">Distributed Mode Prerequisites</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/installing-drill-on-the-cluster/">Installing Drill on the Cluster</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/starting-drill-in-distributed-mode/">Starting Drill in Distributed Mode</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/starting-the-web-console/">Starting the Web Console</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="/drill/docs/configure-drill-introduction/">Configure Drill Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/configuring-drill-memory/">Configuring Drill Memory</a></li>
-            
-          
-            
-              <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="/drill/docs/configuring-a-multitenant-cluster-introduction/">Configuring a Multitenant Cluster Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/configuring-multitenant-resources/">Configuring Multitenant Resources</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/configuring-resources-for-a-shared-drillbit/">Configuring Resources for a Shared Drillbit</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/configuring-user-impersonation/">Configuring User Impersonation</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/configuring-user-authentication/">Configuring User Authentication</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/configuring-user-impersonation-with-hive-authorization/">Configuring User Impersonation with Hive Authorization</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/configuring-web-console-and-rest-api-security/">Configuring Web Console and REST API Security</a></li>
-            
-          
-            
-              <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="/drill/docs/configuration-options-introduction/">Configuration Options Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/start-up-options/">Start-Up Options</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/planning-and-execution-options/">Planning and Execution Options</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/persistent-configuration-storage/">Persistent Configuration Storage</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/ports-used-by-drill/">Ports Used by Drill</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/connect-a-data-source-introduction/">Connect a Data Source Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/workspaces/">Workspaces</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/drill-default-input-format/">Drill Default Input Format</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/file-system-storage-plugin/">File System Storage Plugin</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/hive-storage-plugin/">Hive Storage Plugin</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/rdbms-storage-plugin/">RDBMS Storage Plugin</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/mongodb-storage-plugin/">MongoDB Storage Plugin</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/mapr-db-format/">MapR-DB Format</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/s3-storage-plugin/">S3 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="/drill/docs/interfaces-introduction/">Interfaces Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/using-the-jdbc-driver/">Using the JDBC Driver</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/installing-the-driver-on-linux/">Installing the Driver on Linux</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/installing-the-driver-on-windows/">Installing the Driver on Windows</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/installing-the-tdc-file-on-windows/">Installing the TDC File 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="/drill/docs/odbc-configuration-reference/">ODBC Configuration Reference</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/configuring-odbc-on-linux/">Configuring ODBC on Linux</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/configuring-odbc-on-mac-os-x/">Configuring ODBC on Mac OS X</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/configuring-odbc-on-windows/">Configuring ODBC on Windows</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/drill-explorer-introduction/">Drill Explorer Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/connecting-drill-explorer-to-data/">Connecting Drill Explorer to Data</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/using-drill-with-bi-tools-introduction/">Using Drill with BI Tools Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/tableau-examples/">Tableau Examples</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/using-tibco-spotfire-desktop-with-drill/">Using Tibco Spotfire Desktop with Drill</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/using-qlik-sense-with-drill/">Using Qlik Sense with Drill</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/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="/drill/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="/drill/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="/drill/docs/querying-a-file-system-introduction/">Querying a File System Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/querying-json-files/">Querying JSON Files</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/querying-parquet-files/">Querying Parquet Files</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/querying-plain-text-files/">Querying Plain Text Files</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/querying-directories/">Querying Directories</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/querying-sequence-files/">Querying Sequence Files</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/querying-complex-data-introduction/">Querying Complex Data Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/sample-data-donuts/">Sample Data: Donuts</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/selecting-flat-data/">Selecting Flat Data</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, Clauses, and Joins</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a Column</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/querying-hive/">Querying Hive</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/querying-the-information-schema/">Querying the INFORMATION SCHEMA</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/querying-system-tables/">Querying System Tables</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/partition-pruning/">Partition Pruning</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/optimizing-parquet-metadata-reading/">Optimizing Parquet Metadata Reading</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/query-plans-and-tuning-introduction/">Query Plans and Tuning Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/join-planning-guidelines/">Join Planning Guidelines</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/guidelines-for-optimizing-aggregation/">Guidelines for Optimizing Aggregation</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/modifying-query-planning-options/">Modifying Query Planning Options</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/enabling-query-queuing/">Enabling Query Queuing</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/query-plans/">Query Plans</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/query-profile-column-descriptions/">Query Profile Column Descriptions</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/physical-operators/">Physical Operators</a></li>
-              
-            </ul>
-            
-          
-          </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="/drill/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/error-messages/">Error Messages</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/modify-logback-xml/">Modify logback.xml</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/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="/drill/docs/supported-data-types/">Supported Data Types</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/handling-different-data-types/">Handling Different Data Types</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/lexical-structure/">Lexical Structure</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/about-sql-function-examples/">About SQL Function Examples</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/math-and-trig/">Math and Trig</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/data-type-conversion/">Data Type Conversion</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/date-time-functions-and-arithmetic/">Date/Time Functions and Arithmetic</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/string-manipulation/">String Manipulation</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/aggregate-and-aggregate-statistical/">Aggregate and Aggregate Statistical</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/aggregate-window-functions/">Aggregate Window Functions</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/ranking-window-functions/">Ranking Window Functions</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/value-window-functions/">Value Window Functions</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/nested-data-limitations/">Nested Data Limitations</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/flatten/">FLATTEN</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/kvgen/">KVGEN</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/repeated-count/">REPEATED_COUNT</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/repeated-contains/">REPEATED_CONTAINS</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/supported-sql-commands/">Supported SQL Commands</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/alter-session/">ALTER SESSION</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/alter-system/">ALTER SYSTEM</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/partition-by-clause/">PARTITION BY Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/create-view/">CREATE VIEW</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/describe/">DESCRIBE</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/drop-table/">DROP TABLE</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/drop-view/">DROP VIEW</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/explain/">EXPLAIN</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/select/">SELECT</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/select-list/">SELECT List</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/from-clause/">FROM Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/group-by-clause/">GROUP BY Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/having-clause/">HAVING Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/limit-clause/">LIMIT Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/offset-clause/">OFFSET Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/order-by-clause/">ORDER BY Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/union-set-operator/">UNION Set Operator</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/where-clause/">WHERE Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/with-clause/">WITH Clause</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/show-files/">SHOW FILES</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/show-tables/">SHOW TABLES</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/case/">CASE</a></li>
-              
-            </ul>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/reserved-keywords/">Reserved Keywords</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/data-sources-and-file-formats-introduction/">Data Sources and File Formats Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive UDF</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/parquet-format/">Parquet Format</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/json-data-model/">JSON Data Model</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/text-files-csv-tsv-psv/">Text Files: CSV, TSV, PSV</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/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="/drill/docs/develop-custom-functions-introduction/">Develop Custom Functions Introduction</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/developing-a-simple-function/">Developing a Simple Function</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/tutorial-develop-a-simple-function/">Tutorial: Develop a Simple Function</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/developing-an-aggregate-function/">Developing an Aggregate Function</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/adding-custom-functions-to-drill/">Adding Custom Functions to Drill</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/using-custom-functions-in-queries/">Using Custom Functions in Queries</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/custom-function-interfaces/">Custom Function Interfaces</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a class="reference internal" href="/drill/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="/drill/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="/drill/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/drill-patch-review-tool/">Drill Patch Review Tool</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="/drill/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution Guidelines</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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="/drill/docs/drill-plan-syntax/">Drill Plan Syntax</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/rpc-overview/">RPC Overview</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/query-stages/">Query Stages</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/docs/useful-research/">Useful Research</a></li>
-              
-                <li class="toctree-l3"><a class="reference internal" href="/drill/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"><a class="reference internal" href="/drill/docs/apache-drill-1-3-0-release-notes/">Apache Drill 1.3.0 Release Notes</a></li>
-            
-          
-            
-              <li class="toctree-l2 current"><a class="reference internal" href="/drill/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="/drill/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="/drill/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="/drill/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="/drill/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="/drill/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="/drill/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="/drill/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="/drill/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="/drill/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="/drill/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release Notes</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="/drill/docs/aol-search/">AOL Search</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/enron-emails/">Enron Emails</a></li>
-            
-          
-            
-              <li class="toctree-l2"><a class="reference internal" href="/drill/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li>
-            
-          
-          </ul>
-        
-      
-        
-          <li class="toctree-l1"><a class="reference internal" href="/drill/docs/project-bylaws/">Project Bylaws</a></li>
-        
-      
-      </ul>
-
-    </div>
-  </div>
-</aside>
-
-
-<nav class="breadcrumbs">
-  <li><a href="/drill/docs/">Docs</a></li>
- 
-  
-    <li><a href="/drill/docs/release-notes/">Release Notes</a></li>
-  
-  <li>Apache Drill 1.2.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/009-1.2.0-rn.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a>
-    
-
-    <div class="int_title left">
-      <h1>Apache Drill 1.2.0 Release Notes</h1>
-
-    </div>
-
-    <link href="/drill/css/docpage.css" rel="stylesheet" type="text/css">
-
-    <div class="int_text" align="left">
-      
-        <p><strong>Release date:</strong>  October 16, 2015</p>
-
-<p>Today we&#39;re happy to announce the availability of Drill 1.2.0, providing more than 150 bug fixes and a number of new features. These release notes include links to the following Jira issues:</p>
-
-<ul>
-<li><a href="/drill/docs/apache-drill-1-2-0-release-notes/#enhancements-and-bug-fixes">Enhancements and bug fixes</a></li>
-<li><a href="/drill/docs/apache-drill-1-2-0-release-notes/#important-unresolved-issues">Important unresolved issues</a></li>
-</ul>
-
-<h2 id="noteworthy-new-features-in-drill-1.2.0">Noteworthy New Features in Drill 1.2.0</h2>
-
-<p>This release of Drill introduces a number of enhancements, including the following ones:</p>
-
-<ul>
-<li>Support for JDBC data sources, such as MySQL, through a <a href="/drill/docs/jdbc-storage-plugin/">new JDBC Storage plugin</a><br></li>
-<li>Improvements in the Drill JDBC driver including inclusion of
-<a href="/drill/api/1.2/jdbc/">Javadocs</a> and better application dependency compatibility<br></li>
-<li>Enhancements to Avro file formats<br>
-
-<ul>
-<li><a href="https://issues.apache.org/jira/browse/DRILL-3565">Support for complex data types</a>, such as UNION and MAP<br></li>
-<li><a href="https://issues.apache.org/jira/browse/DRILL-3720">Optimized Avro file processing</a> (block-wise)<br></li>
-</ul></li>
-<li>Partition pruning improvements<br></li>
-<li>A number of new <a href="/drill/docs/sql-window-functions">SQL window functions</a><br>
-
-<ul>
-<li>NTILE<br></li>
-<li>LAG and LEAD<br></li>
-<li>FIRST_VALUE and LAST_VALUE<br></li>
-</ul></li>
-<li><a href="/drill/docs/configuring-web-console-and-rest-api-security/">HTTPS support</a> for Web Console operations<br></li>
-<li>Performance improvements for <a href="/drill/docs/querying-hbase/#querying-big-endian-encoded-data">querying HBase</a>, which includes leveraging <a href="/drill/docs/querying-hbase/#leveraging-hbase-ordered-byte-encoding">ordered byte encoding</a><br></li>
-<li><a href="/drill/docs/querying-hive/#optimizing-reads-of-parquet-backed-tables">Optimized reads</a> of Parquet-backed, Hive tables<br></li>
-<li>Read support for the <a href="/drill/docs/parquet-format/#about-int96-support">Parquet INT96 type</a> and a new TIMESTAMP_IMPALA type used with the <a href="/drill/docs/supported-data-types/#data-types-for-convert_to-and-convert_from-functions">CONVERT_FROM</a> function decodes a timestamp from Hive or Impala.<br></li>
-<li><a href="/drill/docs/optimizing-parquet-metadata-reading/">Parquet metadata caching</a> to improve query performance on a large number of files</li>
-<li><a href="/drill/docs/drop-table/">DROP TABLE</a> command<br></li>
-<li>Improved correlated subqueries<br></li>
-<li>Union Distinct<br></li>
-<li>Improved LIMIT processing<br></li>
-</ul>
-
-<h2 id="enhancements-and-bug-fixes">Enhancements and Bug Fixes</h2>
-
-<h2>        Sub-task
-</h2>
-
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3364'>DRILL-3364</a>] -         Prune scan range if the filter is on the leading field with byte comparable encoding
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3553'>DRILL-3553</a>] -         add support for LEAD and LAG window functions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3608'>DRILL-3608</a>] -         add support for FIRST_VALUE and LAST_VALUE
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3616'>DRILL-3616</a>] -         Memory leak in a cleanup code after canceling queries with window functions spilling to disk
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3619'>DRILL-3619</a>] -         Add support for NTILE window function
-</li>
-</ul>
-                            
-
-<h2>        Bug
-</h2>
-
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-343'>DRILL-343</a>] -         Document update required to describe sqlline usage for Windows
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1395'>DRILL-1395</a>] -         UNION ALL query fails &quot;while setting up Foreman&quot;
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1457'>DRILL-1457</a>] -         Limit operator optimization : push limit operator past exchange operator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1651'>DRILL-1651</a>] -         Allow Filter to push past Project with ITEM operator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1773'>DRILL-1773</a>] -         Issues when using JAVA code through Drill JDBC driver
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1795'>DRILL-1795</a>] -         TPCH SF1000 Queries fail with DecoderException: java.lang.NullPointerException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1816'>DRILL-1816</a>] -         Scan Error with JSON on large no of records with Complex Types
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1831'>DRILL-1831</a>] -         LIKE operator not working with SQL [charlist] Wildcard
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1929'>DRILL-1929</a>] -         After canceling query in sqlline subsequent query in same session hangs
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1938'>DRILL-1938</a>] -         Fix error message when reserved words are used in query.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1976'>DRILL-1976</a>] -         Possible Memory Leak in drill jdbc client when dealing with wide columns (5000 chars long)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2050'>DRILL-2050</a>] -         Accountor closed with outstanding buffer
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2053'>DRILL-2053</a>] -         Column names are case sensitive if column is coming from WITH clause
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2095'>DRILL-2095</a>] -         Order by on a repeated index inside a sub query results in an NPE
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2098'>DRILL-2098</a>] -         correct startup on windows
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2166'>DRILL-2166</a>] -         left join with complex type throw ClassTransformationException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2190'>DRILL-2190</a>] -         Failure to order by function if DISTINCT clause is present
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2274'>DRILL-2274</a>] -         Unable to allocate sv2 buffer after repeated attempts : JOIN, Order by used in query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2304'>DRILL-2304</a>] -         Case sensitivity - system and session options are case sensitive
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2312'>DRILL-2312</a>] -         JDBC driver returning incorrect data after extended usage
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2313'>DRILL-2313</a>] -         Query fails when one of the operands is a DATE literal without an explicit cast
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2318'>DRILL-2318</a>] -         Query fails when an ORDER BY clause is used with WITH-CLAUSE
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2361'>DRILL-2361</a>] -         Column aliases cannot include dots
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2398'>DRILL-2398</a>] -         IS NOT DISTINCT FROM predicate returns incorrect result when used as a join filter
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2418'>DRILL-2418</a>] -         Memory leak during execution if comparison function is not found
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2445'>DRILL-2445</a>] -         JDBC : Connection.rollback method currently throws UnsuportedOperationException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2451'>DRILL-2451</a>] -         JDBC : Connection.commit throws an UnsupportedOperationException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2459'>DRILL-2459</a>] -         INFO._SCHEMA&#39;s CHARACTER_MAXIMUM_LENGTH is -1 for type CHAR
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2482'>DRILL-2482</a>] -         JDBC : calling getObject when the actual column type is &#39;NVARCHAR&#39; results in NoClassDefFoundError
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2519'>DRILL-2519</a>] -         INFORMATION_SCHEMA.COLUMNS is missing &lt;interval_qualifier&gt; info
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2522'>DRILL-2522</a>] -         Implement INFORMATION_SCHEMA.* enough for relevant tools [bug]
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2530'>DRILL-2530</a>] -         getColumns() doesn&#39;t return right COLUMN_SIZE for INTERVAL types
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2588'>DRILL-2588</a>] -         Profile UI: &quot;First Start&quot; field contains incorrect data  
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2625'>DRILL-2625</a>] -         org.apache.drill.common.StackTrace should follow standard stacktrace format
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2643'>DRILL-2643</a>] -         HashAggBatch/HashAggTemplate call incoming.cleanup() twice resulting in warnings
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2644'>DRILL-2644</a>] -         Data Types page should list and describe all data types
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2649'>DRILL-2649</a>] -         Math and Trig page seems to refer to types that are not Drill SQL types
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2650'>DRILL-2650</a>] -         Cancelled queries json profile shows query end time occurs before fragments end time 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2688'>DRILL-2688</a>] -         Use of ORDER BY on right side of Union All results in SqlValidatorException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2721'>DRILL-2721</a>] -         Identify, fix _existing_ INFO._SCHEMA columns in conflict with SQL spec. by 1.0
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2722'>DRILL-2722</a>] -         Query profile data not being sent/received (and web UI not updated)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2724'>DRILL-2724</a>] -         Implicit cast test fails in Union All query (reports type mismatch)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2727'>DRILL-2727</a>] -         CTAS select * from CSV file results in Exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2737'>DRILL-2737</a>] -         Sqlline throws Runtime exception when JDBC ResultSet throws a SQLException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2745'>DRILL-2745</a>] -         Query returns IOB Exception when JSON data with empty arrays is input to flatten function
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2760'>DRILL-2760</a>] -         Quoted strings from CSV file appear in query output in different forms
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2777'>DRILL-2777</a>] -         CTAS, order by and flatten of repeated list result in ExpandConversionRule error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2800'>DRILL-2800</a>] -         Performance regression introduced with commit: a6df26a  (Patch for DRILL-2512)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2802'>DRILL-2802</a>] -         Projecting dir[n] by itself results in projecting of all columns
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2815'>DRILL-2815</a>] -         Some PathScanner logging, misc. cleanup.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2837'>DRILL-2837</a>] -         Resolve what Statement.cancel() really should do
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2843'>DRILL-2843</a>] -         Reading empty CSV file fails with error (rather than yielding zero rows)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2851'>DRILL-2851</a>] -         Memory LEAK - FLATTEN function fails when input array has 99,999 integer type elements
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2852'>DRILL-2852</a>] -         CASTing the column &#39;dir0&#39; in view causes partition pruning to fail 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2862'>DRILL-2862</a>] -         Convert_to/Convert_From throw assertion when an incorrect encoding type is specified
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2864'>DRILL-2864</a>] -         Unable to cast string literal with the valid value in ISO 8601 format to interval
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2867'>DRILL-2867</a>] -         Session level parameter drill.exec.testing.controls  appears to be set even though it was not
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2890'>DRILL-2890</a>] -         C++ Client: Update query submitter usage to clarify using authentication 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2924'>DRILL-2924</a>] -         IOBException when querying a table which has 1 file and a subfolder with 1 file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2935'>DRILL-2935</a>] -         Casting varchar to varbinary fails
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2937'>DRILL-2937</a>] -         Result for integer values from json files contains &quot;$numberLong&quot; in front of value
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2949'>DRILL-2949</a>] -         TPC-DS queries 1 and 30 fail with CannotPlanException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3030'>DRILL-3030</a>] -         Foreman hangs trying to cancel non-root fragments
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3045'>DRILL-3045</a>] -         Drill is not partition pruning due to internal off-heap memory limit for planning phase
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3056'>DRILL-3056</a>] -         Numeric literal in an IN list is casted to decimal even when decimal type is disabled
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3076'>DRILL-3076</a>] -         USING clause should not be supported in drill 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3095'>DRILL-3095</a>] -         Memory Leak : Failure while closing accountor.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3096'>DRILL-3096</a>] -         &quot;State change requested from ... --&gt; ... for &quot; blank after &quot;for&quot;
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3122'>DRILL-3122</a>] -         Changing a session option to default value results in status as changed
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3133'>DRILL-3133</a>] -         MergingRecordBatch can leak memory if query is canceled before batches in rawBatches were loaded
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3141'>DRILL-3141</a>] -         sqlline throws an exception when query is cancelled
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3151'>DRILL-3151</a>] -         ResultSetMetaData not as specified by JDBC (null/dummy value, not &quot;&quot;/etc.)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3153'>DRILL-3153</a>] -         DatabaseMetaData.getIdentifierQuoteString() returns (standard) double-quote, not Drill&#39;s back quote
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3156'>DRILL-3156</a>] -         Calcite tracing is broken in Drill 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3160'>DRILL-3160</a>] -         Make JDBC Javadoc documentation available to users
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3163'>DRILL-3163</a>] -         Fix hang/ leak issue exposed by TestDrillbitResilience#foreman_runTryEnd
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3189'>DRILL-3189</a>] -         Disable ALLOW PARTIAL/DISALLOW PARTIAL in window function grammar
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3243'>DRILL-3243</a>] -         Need a better error message - Use of alias in window function definition
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3257'>DRILL-3257</a>] -         TPCDS query 74 results in a StackOverflowError on Scale Factor 1
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3271'>DRILL-3271</a>] -         Hive : Tpch 01.q fails with a verification issue for SF100 dataset
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3284'>DRILL-3284</a>] -         Document incompatibility between drill&#39;s to_date and hive&#39;s unix_timestamp
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3287'>DRILL-3287</a>] -         Changing session level parameter back to the default value does not change it&#39;s status back to DEFAULT
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3292'>DRILL-3292</a>] -         SUM(constant) OVER(...) returns wrong results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3297'>DRILL-3297</a>] -         Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3312'>DRILL-3312</a>] -         PageReader.allocatePageData() calls BufferAllocator.buffer(int) but doesn&#39;t check if the result is null
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3322'>DRILL-3322</a>] -         Something broken in or around RPC timeout setup?
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3347'>DRILL-3347</a>] -         Resolve: ResultSet.getObject(...) for VARCHAR returns ...hadoop.io.Text, not String
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3348'>DRILL-3348</a>] -         NPE when two different window functions are used in projection list and order by clauses
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3360'>DRILL-3360</a>] -         Window function defined within another window function 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3382'>DRILL-3382</a>] -         CTAS with order by clause fails with IOOB exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3393'>DRILL-3393</a>] -         Quotes not being recognized in tab delimited (tsv) files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3412'>DRILL-3412</a>] -         Projections are not getting push down below Window operator
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3441'>DRILL-3441</a>] -         CompliantTextRecordReader#isStarQuery loops indefinitely
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3445'>DRILL-3445</a>] -         BufferAllocator.buffer() implementations should throw an OutOfMemoryRuntimeException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3448'>DRILL-3448</a>] -         typo in QueryManager.DrillbitStatusListener will cause the Foreman to hang if a Drillbit dies
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3455'>DRILL-3455</a>] -         If a drillbit, that contains fragments for the current query, dies the QueryManager will fail the query even if those fragments already finished successfully
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3463'>DRILL-3463</a>] -         Unit test of project pushdown in TestUnionAll should put more precisely plan attribute  in plan verification. 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3464'>DRILL-3464</a>] -         Index out of bounds exception while performing concat()
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3476'>DRILL-3476</a>] -         Filter on nested element gives wrong results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3479'>DRILL-3479</a>] -         Sqlline from drill v1.1.0 displays version as 1.0.0
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3483'>DRILL-3483</a>] -         Clarify CommonConstants&#39; constants.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3484'>DRILL-3484</a>] -         Error using functions with no parameters when `drill.exec.functions.cast_empty_string_to_null` is set to true
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3497'>DRILL-3497</a>] -         Throw UserException#validationError for errors when modifying options
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3500'>DRILL-3500</a>] -         Provide additional information while registering storage plugin optimizer rules
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3502'>DRILL-3502</a>] -         JDBC driver can cause conflicts
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3503'>DRILL-3503</a>] -         Make PruneScanRule have a pluggable partitioning mechanism
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3509'>DRILL-3509</a>] -         Empty JSON files trigger exception when used in a union
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3537'>DRILL-3537</a>] -         Empty Json file can potentially result into wrong results 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3542'>DRILL-3542</a>] -         Rebase Drill on Calcite 1.4.0 release
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3550'>DRILL-3550</a>] -         Incorrect results reading complex data with schema change
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3551'>DRILL-3551</a>] -         CTAS from complex Json source with schema change  is not written (and hence not read back ) correctly
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3554'>DRILL-3554</a>] -         Union over TIME and TIMESTAMP values throws SchemaChangeException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3555'>DRILL-3555</a>] -         Changing defaults for planner.memory.max_query_memory_per_node causes queries with window function to fail
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3557'>DRILL-3557</a>] -         Reading empty CSV file fails with SYSTEM ERROR
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3566'>DRILL-3566</a>] -         Calling Connection.prepareStatement throws a ClassCastException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3573'>DRILL-3573</a>] -         Enable TPC-H query 17 in unit tests
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3574'>DRILL-3574</a>] -         Empty Over Clause should trigger Union-Exchange to be added below
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3579'>DRILL-3579</a>] -         Drill on Hive query fails if partition table has __HIVE_DEFAULT_PARTITION__
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3580'>DRILL-3580</a>] -         wrong plan for window function queries containing function(col1 + colb)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3583'>DRILL-3583</a>] -         SUM on varchar column produces incorrect error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3595'>DRILL-3595</a>] -         Wrong results returned by query that uses LEAD window function
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3596'>DRILL-3596</a>] -         Allow only (&lt;expression&gt;) or (&lt;expression&gt;, 1) for LEAD and LAG window functions as input parameters
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3599'>DRILL-3599</a>] -         Wrong results returned by LEAD(col-name, -1) 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3601'>DRILL-3601</a>] -         LEAD function used without OVER clause should not plan
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3604'>DRILL-3604</a>] -         LEAD(&lt;varchar-column&gt;) returns IOB Exception 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3605'>DRILL-3605</a>] -         Wrong results - Lead(char-column) 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3606'>DRILL-3606</a>] -         Wrong results - Lead(char-column) without PARTITION BY clause
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3617'>DRILL-3617</a>] -         Apply &quot;shading&quot; to JDBC-all Jar file to avoid version conflicts
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3621'>DRILL-3621</a>] -         Wrong results when Drill on Hbase query contains rowkey &quot;or&quot; or &quot;IN&quot;
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3622'>DRILL-3622</a>] -         With user authentication enabled, only admin users should be able to change system options
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3635'>DRILL-3635</a>] -         IllegalArgumentException - not a Parquet file (too small)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3638'>DRILL-3638</a>] -         Incorrect results LEAD(&lt;float-type-column&gt;) 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3642'>DRILL-3642</a>] -         External Sort will leak memory if query is cancelled while it&#39;s spilling to disk
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3643'>DRILL-3643</a>] -         NTILE(0) returns RuntimeException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3645'>DRILL-3645</a>] -         typo in drill documentation 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3648'>DRILL-3648</a>] -         NTILE function returns incorrect results
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3649'>DRILL-3649</a>] -         LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3653'>DRILL-3653</a>] -         Assert in a query with both avg aggregate and avg window aggregate functions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3654'>DRILL-3654</a>] -         FIRST_VALUE(&lt;char-column&gt;/&lt;varchar-column&gt;) returns IOB Exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3657'>DRILL-3657</a>] -         Wrong result with SUM(1) window function when multiple partitions are present
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3658'>DRILL-3658</a>] -         Missing org.apache.hadoop in the JDBC jar
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3663'>DRILL-3663</a>] -         Drill View aliases being lost via ‘order by’
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3667'>DRILL-3667</a>] -         Random Assertion Error while planning
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3668'>DRILL-3668</a>] -         Incorrect results FIRST_VALUE function
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3673'>DRILL-3673</a>] -         Memory leak in parquet writer on CTAS
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3677'>DRILL-3677</a>] -         Wrong result with LEAD window function when used in multiple windows in the same query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3679'>DRILL-3679</a>] -         IOB Exception : when window functions used in outer and inner query
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3680'>DRILL-3680</a>] -         window function query returns Incorrect results 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3684'>DRILL-3684</a>] -         CTAS : Memory Leak when using CTAS with tpch sf100
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3685'>DRILL-3685</a>] -         Failure to execute query with NTILE and ROW_NUMBER window functions with different window definitions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3689'>DRILL-3689</a>] -         incorrect results : aggregate AVG returns wrong results over results returned by LEAD function.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3690'>DRILL-3690</a>] -         Partitioning pruning produces wrong results when there are nested expressions in the filter
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3691'>DRILL-3691</a>] -         CTAS Memory Leak : IllegalStateException
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3700'>DRILL-3700</a>] -         Exception in a query with multiple fist_value window functions with different partitions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3702'>DRILL-3702</a>] -         PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3707'>DRILL-3707</a>] -         Fix for DRILL-3616 can cause a NullPointerException in ExternalSort cleanup
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3711'>DRILL-3711</a>] -         Windows unit test failure on 1.2 snapshot 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3716'>DRILL-3716</a>] -         Drill should push filter past aggregate in order to improve query performance.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3718'>DRILL-3718</a>] -         quotes in .tsv trigger exception 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3719'>DRILL-3719</a>] -         Adding negative sign in front of EXTRACT triggers Assertion Error
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3732'>DRILL-3732</a>] -         Drill leaks memory if external sort hits out of disk space exception
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3735'>DRILL-3735</a>] -         Directory pruning is not happening when number of files is larger than 64k
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3736'>DRILL-3736</a>] -         Documentation for partition is misleading/wrong syntax
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3737'>DRILL-3737</a>] -         CTAS from empty text file fails with NPE
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3746'>DRILL-3746</a>] -         Hive query fails if the table contains external partitions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3757'>DRILL-3757</a>] -         Link to IntelliJ IDEA settings jar on the contributors guidelines page is broken.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3758'>DRILL-3758</a>] -         InvalidRecordException while selecting from a table with multiple parquet file
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3767'>DRILL-3767</a>] -         SchemaPath.getCompoundPath(String...strings) reverses it&#39;s input array
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3773'>DRILL-3773</a>] -         Mongo RecordReader projection pushdown doesn&#39;t work past first level paths
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3778'>DRILL-3778</a>] -         Add rest of DRILL-3160 (making JDBC Javadoc available)
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3779'>DRILL-3779</a>] -         NPE during mergeAndSpill operation of external sort
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3781'>DRILL-3781</a>] -         Using CURRENT_DATE in a group by throws a column not found error for hive tables and csv files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3783'>DRILL-3783</a>] -         Incorrect results : COUNT(&lt;column-name&gt;) over results returned by UNION ALL 
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3784'>DRILL-3784</a>] -         simple Jdbc program fails with NoClassDefFoundError
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3788'>DRILL-3788</a>] -         Directory based partition pruning not taking effect with metadata caching
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3809'>DRILL-3809</a>] -         PrelFinalizable.SHUTTLE causes ArrayIndexOutOfBoundsException when multiple queries are run concurrently
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3811'>DRILL-3811</a>] -         AtomicRemainder incorrectly accounts for transferred allocations
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3817'>DRILL-3817</a>] -         Refresh metadata does not work when used with sub schema  
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3819'>DRILL-3819</a>] -         Remove redundant filter for files start with &quot;.&quot;
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3884'>DRILL-3884</a>] -         Hive native scan has lower parallelization leading to performance degradation
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3892'>DRILL-3892</a>] -         Metadata cache not being leveraged when partition pruning is taking place
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3901'>DRILL-3901</a>] -         Performance regression with doing Explain of COUNT(*) over 100K files
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3917'>DRILL-3917</a>] -         IllegalArgumentException when running query after creating metadata cache
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3918'>DRILL-3918</a>] -         Avoid extra loading of the metadata cache file
-</li>
-</ul>
-                        
-
-<h2>        Improvement
-</h2>
-
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-1666'>DRILL-1666</a>] -         Provide Test cases for Mongo Storage plugin
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2332'>DRILL-2332</a>] -         Drill should be consistent with Implicit casting rules across data formats
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2424'>DRILL-2424</a>] -         Ignore hidden files in directory path
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2699'>DRILL-2699</a>] -         Collect all cleanup errors before reporting a failure to the client
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2748'>DRILL-2748</a>] -         Filter is not pushed down into subquery with the group by
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2908'>DRILL-2908</a>] -         Support reading the Parquet int 96 type
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3121'>DRILL-3121</a>] -         Hive partition pruning is not happening
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3209'>DRILL-3209</a>] -         [Umbrella] Plan reads of Hive tables as native Drill reads when a native reader for the underlying table format exists
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3295'>DRILL-3295</a>] -         UNION (distinct type) is supported now
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3341'>DRILL-3341</a>] -         Move OperatorWrapper list and FragmentWrapper list creation to ProfileWrapper ctor
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3354'>DRILL-3354</a>] -         TestBuilder can check if the number of result batches equals some expected value
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3450'>DRILL-3450</a>] -         Rename NonRootStatusReporter to FragmentStatusReporter
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3467'>DRILL-3467</a>] -         Restrict &#39;show databases&#39; based on underlying permissions.
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3536'>DRILL-3536</a>] -         Add support for LEAD, LAG, NTILE, FIRST_VALUE and LAST_VALUE window functions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3545'>DRILL-3545</a>] -         Need documentation on BINARY_STRING and STRING_BINARY functions
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3565'>DRILL-3565</a>] -         Add support for Avro UNION type
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3589'>DRILL-3589</a>] -         JDBC driver maven artifact includes a lot of unnecessary dependencies
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3652'>DRILL-3652</a>] -         Need to document order of operations with window functions and flatten
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3720'>DRILL-3720</a>] -         Avro Record Reader should process Avro files by per block basis
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3888'>DRILL-3888</a>] -         Build test jars for all Drill Modules
-</li>
-</ul>
-            
-
-<h2>        New Feature
-</h2>
-
-<ul>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2743'>DRILL-2743</a>] -         Parquet file metadata caching
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3180'>DRILL-3180</a>] -         Apache Drill JDBC storage plugin to query rdbms systems such as MySQL and Netezza from Apache Drill
-</li>
-<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3470'>DRILL-3470</a>] -         Add support for multiple partition by clause

<TRUNCATED>

Mime
View raw message