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'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 "while setting up Foreman" -</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'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 'NVARCHAR' results in NoClassDefFoundError -</li> -<li>[<a href='https://issues.apache.org/jira/browse/DRILL-2519'>DRILL-2519</a>] - INFORMATION_SCHEMA.COLUMNS is missing <interval_qualifier> 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'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: "First Start" 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 'dir0' 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 "$numberLong" 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>] - "State change requested from ... --> ... for " blank after "for" -</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 ""/etc.) -</li> -<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3153'>DRILL-3153</a>] - DatabaseMetaData.getIdentifierQuoteString() returns (standard) double-quote, not Drill'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's to_date and hive'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'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'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' 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 (<expression>) or (<expression>, 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(<varchar-column>) 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 "shading" 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 "or" or "IN" -</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(<float-type-column>) -</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'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(<char-column>/<varchar-column>) 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's input array -</li> -<li>[<a href='https://issues.apache.org/jira/browse/DRILL-3773'>DRILL-3773</a>] - Mongo RecordReader projection pushdown doesn'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(<column-name>) 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 "." -</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 'show databases' 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>