Apache Drill 1.14.0 Release Notes

<!DOCTYPE html> <html> <head> <meta charset="UTF-8"> <meta name=viewport content="width=device-width, initial-scale=1"> <title>Apache Drill 1.14.0 Release Notes - Apache Drill</title> <link href="https://maxcdn.bootstrapcdn.com/font-awesome/4.3.0/css/font-awesome.min.css" rel="stylesheet" type="text/css"/> <link href="/css/site.css" rel="stylesheet" type="text/css"/> <link rel="shortcut icon" href="/favicon.ico" type="image/x-icon"/> <link rel="icon" href="/favicon.ico" type="image/x-icon"/> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/1.11.1/jquery.min.js" language="javascript" type="text/javascript"></script> <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.3/jquery.easing.min.js" language="javascript" type="text/javascript"></script> <script language="javascript" type="text/javascript" src="/js/modernizr.custom.js"></script> <script language="javascript" type="text/javascript" src="/js/script.js"></script> <script language="javascript" type="text/javascript" src="/js/drill.js"></script> </head> <body onResize="resized();"> <div class="page-wrap"> <div class="bui"></div> <div id="menu" class="mw"> <ul> <li class='toc-categories'> <a class="expand-toc-icon" href="javascript:void(0);"><i class="fa fa-bars"></i></a> </li> <li class="logo"><a href="/"></a></li> <li class='expand-menu'> <a href="javascript:void(0);"><span class='menu-text'>Menu</span><span class='expand-icon'><i class="fa fa-bars"></i></span></a> </li> <li class="clear-float"></li> <li class="nav"> <a>Language</a> <ul> <li> <a style="font-weight: bold;" href="/docs/apache-drill-1-14-0-release-notes/" >en</a> </li> <li> <a href="/zh/docs/apache-drill-1-14-0-release-notes/" >zh</a> </li> </ul> </li> <li class="apache-link"> <a href="/apacheASF/">Apache</a> </li> <li class="poweredby"> <a href="/poweredBy">Powered By</a> </li> <li class="documentation-menu"> <a href="/docs/">Documentation</a> <ul> <li><a href="/docs/getting-started/">Getting Started</a></li> <li><a href="/docs/architecture/">Architecture</a></li> <li><a href="/docs/tutorials/">Tutorials</a></li> <li><a href="/docs/drill-on-yarn/">Drill-on-YARN</a></li> <li><a href="/docs/install-drill/">Install Drill</a></li> <li><a href="/docs/configure-drill/">Configure Drill</a></li> <li><a href="/docs/connect-a-data-source/">Connect a Data Source</a></li> <li><a href="/docs/odbc-jdbc-interfaces/">ODBC/JDBC Interfaces</a></li> <li><a href="/docs/query-data/">Query Data</a></li> <li><a href="/docs/performance-tuning/">Performance Tuning</a></li> <li><a href="/docs/log-and-debug/">Log and Debug</a></li> <li><a href="/docs/sql-reference/">SQL Reference</a></li> <li><a href="/docs/data-sources-and-file-formats/">Data Sources and File Formats</a></li> <li><a href="/docs/develop-custom-functions/">Develop Custom Functions</a></li> <li><a href="/docs/troubleshooting/">Troubleshooting</a></li> <li><a href="/docs/developer-information/">Developer Information</a></li> <li><a href="/docs/release-notes/">Release Notes</a></li> <li><a href="/docs/sample-datasets/">Sample Datasets</a></li> <li><a href="/docs/project-bylaws/">Project Bylaws</a></li> <li><a href="/docs/ecosystem/">Ecosystem</a></li> </ul> </li> <li class='nav'> <a href="/community-resources/">Community</a> <ul> <li><a href="/team/">Team</a></li> <li><a href="/mailinglists/">Mailing Lists</a></li> <li><a href="/community-resources/">Community Resources</a></li> </ul> </li> <li class='nav'><a href="/faq/">FAQ</a></li> <li class='nav'><a href="/blog/">Blog</a></li> <li class="social-menu-item"><a href="https://twitter.com/apachedrill" title="apachedrill on twitter" target="_blank"><img src="/images/twitter_32_26_white.png" alt="twitter logo" align="center"></a> </li> <li class="social-menu-item"><a href="https://join.slack.com/t/apache-drill/shared_invite/enQtNTQ4MjM1MDA3MzQ2LTJlYmUxMTRkMmUwYmQ2NTllYmFmMjU4MDk0NjYwZjBmYjg0MDZmOTE2ZDg0ZjBlYmI3Yjc4Y2I2NTQyNGVlZTc" title="Apache Drill Slack channels" target="_blank"><img src="/images/slack-logo.svg" alt="Slack logo" align="center"></a> </li> <li class='search-bar'> <form id="drill-search-form"> <input type="text" placeholder="Search Apache Drill" id="drill-search-term" /> <button type="submit"> <i class="fa fa-search"></i> </button> </form> </li> <li class="d"> <a href="/download/"> <i class="fa fa-cloud-download"></i> Download </a> </li> </ul> </div> <link href="/css/content.css" rel="stylesheet" type="text/css"> <aside class="sidebar"> <div class="docsidebar"> <div class="docsidebarwrapper"> <ul style="display: block;"> <li class="toctree-l1"><a href="javascript: void(0);">Getting Started</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/drill-introduction/">Drill Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/why-drill/">Why Drill</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Architecture</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/architecture-introduction/">Architecture Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/drill-query-execution/">Drill Query Execution</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/core-modules/">Core Modules</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/performance/">Performance</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Tutorials</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/tutorials-introduction/">Tutorials Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/drill-in-10-minutes/">Drill in 10 Minutes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-the-yelp-academic-dataset/">Analyzing the Yelp Academic Dataset</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Learn Drill with the MapR Sandbox</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/about-the-mapr-sandbox/">About the MapR Sandbox</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-apache-drill-sandbox/">Installing the Apache Drill Sandbox</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/getting-to-know-the-drill-sandbox/">Getting to Know the Drill Sandbox</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/lesson-1-learn-about-the-data-set/">Lesson 1: Learn about the Data Set</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/lesson-2-run-queries-with-ansi-sql/">Lesson 2: Run Queries with ANSI SQL</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/lesson-3-run-queries-on-complex-data-types/">Lesson 3: Run Queries on Complex Data Types</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/summary/">Summary</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-highly-dynamic-datasets/">Analyzing Highly Dynamic Datasets</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-social-media/">Analyzing Social Media</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/analyzing-data-using-window-functions/">Analyzing Data Using Window Functions</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/orchestrating-queries-with-airflow/">Orchestrating queries with Airflow</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Drill-on-YARN</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/drill-on-yarn-introduction/">Drill-on-YARN Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/creating-a-basic-drill-cluster/">Creating a Basic Drill Cluster</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/launch-drill-under-yarn/">Launch Drill Under YARN</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/configuration-reference/">Configuration Reference</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/drill-on-yarn-command-line-tool/">Drill-on-YARN Command-Line Tool</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/using-the-drill-on-yarn-web-ui/">Using the Drill-on-YARN Web UI</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/multiple-drill-clusters/">Multiple Drill Clusters</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/enabling-web-ui-security/">Enabling Web UI Security</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/appendix-a-release-note-issues/">Appendix A: Release Note Issues</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/appendix-b-drill-env-sh-settings/">Appendix B: drill-env.sh Settings</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/appendix-c-troubleshooting/">Appendix C: Troubleshooting</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/appendix-d-recreate-the-drill-archive/">Appendix D: Recreate the Drill Archive</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Install Drill</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/install-drill-introduction/">Install Drill Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/migrating-parquet-data/">Migrating Parquet Data</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Installing Drill in Embedded Mode</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/embedded-mode-prerequisites/">Embedded Mode Prerequisites</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/running-drill-on-docker/">Running Drill on Docker</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-linux-and-mac-os-x/">Installing Drill on Linux and Mac OS X</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/starting-drill-on-linux-and-mac-os-x/">Starting Drill on Linux and Mac OS X</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-windows/">Installing Drill on Windows</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/starting-drill-on-windows/">Starting Drill on Windows</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Installing Drill in Distributed Mode</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/distributed-mode-prerequisites/">Distributed Mode Prerequisites</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-on-the-cluster/">Installing Drill on the Cluster</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/starting-drill-in-distributed-mode/">Starting Drill in Distributed Mode</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/starting-the-web-ui/">Starting the Web UI</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/stopping-drill/">Stopping Drill</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/identifying-multiple-drill-versions-in-a-cluster/">Identifying Multiple Drill Versions in a Cluster</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Extended</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-drill-in-distributed-mode-with-gcp-dataproc/">Installing Drill in Distributed Mode with GCP Dataproc</a></li> </ul> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Configure Drill</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/configure-drill-introduction/">Configure Drill Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-drill-memory/">Configuring Drill Memory</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Securing Drill</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/securing-drill-introduction/">Securing Drill Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/secure-communication-paths/">Secure Communication Paths</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/roles-and-privileges/">Roles and Privileges</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-user-impersonation/">Configuring User Impersonation</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-inbound-impersonation/">Configuring Inbound Impersonation</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-user-impersonation-with-hive-authorization/">Configuring User Impersonation with Hive Authorization</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-user-security/">Configuring User Security</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-plain-security/">Configuring Plain Security</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-ssl-tls-for-encryption/">Configuring SSL/TLS for Encryption</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-libpam4j-as-the-pam-authenticator/">Using libpam4j as the PAM Authenticator</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-jpam-as-the-pam-authenticator/">Using jpam as the PAM Authenticator</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-htpasswd-file-authentication/">Configuring htpasswd file authentication</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-hashicorp-vault-authentication/">Configuring HashiCorp Vault authentication</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-kerberos-security/">Configuring Kerberos Security</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-drill-to-use-spnego-for-http-authentication/">Configuring Drill to use SPNEGO for HTTP Authentication</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-web-ui-and-rest-api-security/">Configuring Web UI and REST API Security</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-custom-acls-to-secure-znodes/">Configuring Custom ACLs to Secure znodes</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Configuring a Multitenant Cluster</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-a-multitenant-cluster-introduction/">Configuring a Multitenant Cluster Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-multitenant-resources/">Configuring Multitenant Resources</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-resources-for-a-shared-drillbit/">Configuring Resources for a Shared Drillbit</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Configuration Options</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/configuration-options-introduction/">Configuration Options Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/start-up-options/">Start-Up Options</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/planning-and-execution-options/">Planning and Execution Options</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/persistent-configuration-storage/">Persistent Configuration Storage</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/global-query-list/">Global Query List</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/ports-and-bind-addresses-used-by-drill/">Ports and Bind Addresses Used by Drill</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-the-drill-shell/">Configuring the Drill Shell</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/configuring-cgroups-to-control-cpu-usage/">Configuring cgroups to Control CPU Usage</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Connect a Data Source</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/connect-a-data-source-introduction/">Connect a Data Source Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/storage-plugin-registration/">Storage Plugin Registration</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Storage Plugin Configuration</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/plugin-configuration-basics/">Plugin Configuration Basics</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-storage-plugins/">Configuring Storage Plugins</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/storage-plugin-authentication-modes/">Storage plugin authentication modes</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/workspaces/">Workspaces</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/drill-default-input-format/">Drill Default Input Format</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/file-system-storage-plugin/">File System Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/hbase-storage-plugin/">HBase Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/hive-storage-plugin/">Hive Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/rdbms-storage-plugin/">RDBMS Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/mongodb-storage-plugin/">MongoDB Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/mapr-db-format/">MapR-DB Format</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/s3-storage-plugin/">S3 Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/oci-os-storage-plugin/">OCI OS Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/opentsdb-storage-plugin/">OpenTSDB Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/kafka-storage-plugin/">Kafka Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/azure-blob-storage-plugin/">Azure Blob Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/druid-storage-plugin/">Druid Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/http-storage-plugin/">HTTP Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/elasticsearch-storage-plugin/">ElasticSearch Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/splunk-storage-plugin/">Splunk Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/cassandra-storage-plugin/">Cassandra Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/dropbox-storage-plugin/">Dropbox Storage Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/google-sheets-storage-plugin/">Google Sheets Storage Plugin</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">ODBC/JDBC Interfaces</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/interfaces-introduction/">Interfaces Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/using-the-jdbc-driver/">Using the JDBC Driver</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/using-jdbc-with-squirrel-on-windows/">Using JDBC with SQuirreL on Windows</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Installing the ODBC Driver</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-linux/">Installing the Driver on Linux</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-mac-os-x/">Installing the Driver on Mac OS X</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/installing-the-driver-on-windows/">Installing the Driver on Windows</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Configuring ODBC</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/odbc-configuration-reference/">ODBC Configuration Reference</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/logging-and-tracing/">Logging and Tracing</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-odbc-on-linux/">Configuring ODBC on Linux</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-odbc-on-mac-os-x/">Configuring ODBC on Mac OS X</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-odbc-on-windows/">Configuring ODBC on Windows</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/testing-the-odbc-connection/">Testing the ODBC Connection</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Using Drill Explorer</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/drill-explorer-introduction/">Drill Explorer Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/connecting-drill-explorer-to-data/">Connecting Drill Explorer to Data</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/browsing-data-and-defining-views/">Browsing Data and Defining Views</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Using Drill with BI Tools</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/using-drill-with-bi-tools-introduction/">Using Drill with BI Tools Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/tableau-examples/">Tableau Examples</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-microstrategy-analytics-with-apache-drill/">Using MicroStrategy Analytics with Apache Drill</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-tibco-spotfire-desktop-with-drill/">Using Tibco Spotfire Desktop with Drill</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-tibco-spotfire-server-with-drill/">Configuring Tibco Spotfire Server with Drill</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-qlik-sense-with-drill/">Using Qlik Sense with Drill</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-10-2/">Using Apache Drill with Tableau 10.2</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-desktop/">Using Apache Drill with Tableau 9 Desktop</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-apache-drill-with-tableau-9-server/">Using Apache Drill with Tableau 9 Server</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-information-builders-webfocus-with-apache-drill/">Using Information Builders’ WebFOCUS with Apache Drill</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-jreport-with-drill/">Configuring JReport with Drill</a></li> </ul> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Query Data</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/query-data-introduction/">Query Data Introduction</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Querying a File System</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-a-file-system-introduction/">Querying a File System Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-avro-files/">Querying Avro Files</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-json-files/">Querying JSON Files</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-parquet-files/">Querying Parquet Files</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-plain-text-files/">Querying Plain Text Files</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-directories/">Querying Directories</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-sequence-files/">Querying Sequence Files</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/querying-hbase/">Querying HBase</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Querying Complex Data</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-complex-data-introduction/">Querying Complex Data Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/sample-data-donuts/">Sample Data: Donuts</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/selecting-flat-data/">Selecting Flat Data</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/using-sql-functions-clauses-and-joins/">Using SQL Functions, Clauses, and Joins</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/selecting-nested-data-for-a-column/">Selecting Nested Data for a Column</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/selecting-multiple-columns-within-nested-data/">Selecting Multiple Columns Within Nested Data</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/querying-hive/">Querying Hive</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/querying-the-information-schema/">Querying the INFORMATION SCHEMA</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Querying Indexes</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/querying-indexes-introduction/">Querying Indexes Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/queries-that-qualify-for-index-based-query-plans/">Queries that Qualify for Index-Based Query Plans</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/types-of-indexes/">Types of Indexes</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/index-selection/">Index Selection</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/designing-indexes-for-your-queries/">Designing Indexes for Your Queries</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/configuring-index-planning/">Configuring Index Planning</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/verifying-index-use/">Verifying Index Use</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/querying-system-tables/">Querying System Tables</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/monitoring-and-canceling-queries-in-the-drill-web-ui/">Monitoring and Canceling Queries in the Drill Web UI</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 href="javascript: void(0);">Drill Metastore</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/using-drill-metastore/">Using Drill Metastore</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/drill-iceberg-metastore/">Drill Iceberg Metastore</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/rdbms-metastore/">RDBMS Metastore</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/mongo-metastore/">Mongo Metastore</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/performance-tuning-introduction/">Performance Tuning Introduction</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Partition Pruning</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/partition-pruning-introduction/">Partition Pruning Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/how-to-partition-data/">How to Partition Data</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/asynchronous-parquet-reader/">Asynchronous Parquet Reader</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/optimizing-parquet-metadata-reading/">Optimizing Parquet Metadata Reading</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/parquet-filter-pushdown/">Parquet Filter Pushdown</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/hive-metadata-caching/">Hive Metadata Caching</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/choosing-a-storage-format/">Choosing a Storage Format</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Query Plans and Tuning</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/query-plans-and-tuning-introduction/">Query Plans and Tuning Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/join-planning-guidelines/">Join Planning Guidelines</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/guidelines-for-optimizing-aggregation/">Guidelines for Optimizing Aggregation</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/modifying-query-planning-options/">Modifying Query Planning Options</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/sort-based-and-hash-based-memory-constrained-operators/">Sort-Based and Hash-Based Memory-Constrained Operators</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/enabling-query-queuing/">Enabling Query Queuing</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/throttling/">Throttling</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/controlling-parallelization-to-balance-performance-with-multi-tenancy/">Controlling Parallelization to Balance Performance with Multi-Tenancy</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Identifying Performance Issues</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/query-plans/">Query Plans</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/query-profiles/">Query Profiles</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Performance Tuning Reference</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/query-profile-column-descriptions/">Query Profile Column Descriptions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/physical-operators/">Physical Operators</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/monitoring-metrics/">Monitoring Metrics</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Log and Debug</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/log-and-debug-introduction/">Log and Debug Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/error-messages/">Error Messages</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/modify-logback-xml/">Modify logback.xml</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/review-the-java-stack-trace/">Review the Java Stack Trace</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/query-audit-logging/">Query Audit Logging</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">SQL Reference</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/sql-reference-introduction/">SQL Reference Introduction</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Data Types</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/supported-data-types/">Supported Data Types</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/date-time-and-timestamp/">Date, Time, and Timestamp</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/handling-different-data-types/">Handling Different Data Types</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/lexical-structure/">Lexical Structure</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/operators/">Operators</a></li> <li class="toctree-l2"><a href="javascript: void(0);">SQL Functions</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/about-sql-function-examples/">About SQL Function Examples</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/math-and-trig/">Math and Trig</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/statistical/">Statistical</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/data-type-conversion/">Data Type Conversion</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/data-type-functions/">Data Type Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/date-time-functions-and-arithmetic/">Date/Time Functions and Arithmetic</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/string-manipulation/">String Manipulation</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/aggregate-and-aggregate-statistical/">Aggregate and Aggregate Statistical</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/functions-for-handling-nulls/">Functions for Handling Nulls</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/phonetic-functions/">Phonetic Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/string-distance-functions/">String Distance Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/cryptography-functions/">Cryptography Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/sql-dialect-compatibility-functions/">SQL dialect compatibility functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/gis-functions/">GIS functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/time-series-analysis-functions/">Time Series Analysis Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/ip-networking-functions/">IP Networking functions</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">SQL Window Functions</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-introduction/">SQL Window Functions Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/aggregate-window-functions/">Aggregate Window Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/ranking-window-functions/">Ranking Window Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/value-window-functions/">Value Window Functions</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/sql-window-functions-examples/">SQL Window Functions Examples</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Nested Data Functions</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/nested-data-limitations/">Nested Data Limitations</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/flatten/">FLATTEN</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/kvgen/">KVGEN</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/repeated-count/">REPEATED_COUNT</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/repeated-contains/">REPEATED_CONTAINS</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/list-creation-functions/">COLLECT_LIST</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/query-directory-functions/">Query Directory Functions</a></li> <li class="toctree-l2"><a href="javascript: void(0);">SQL Commands</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/supported-sql-commands/">Supported SQL Commands</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/analyze-table-refresh-metadata/">ANALYZE TABLE REFRESH METADATA</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/analyze-table-compute-statistics/">ANALYZE TABLE COMPUTE STATISTICS</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/set/">SET</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/refresh-table-metadata/">REFRESH TABLE METADATA</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/reset/">RESET</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/alter-system/">ALTER SYSTEM</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/create-or-replace-schema/">CREATE OR REPLACE SCHEMA</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/create-table-as-ctas/">CREATE TABLE AS (CTAS)</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/create-temporary-table-as-cttas/">CREATE TEMPORARY TABLE AS (CTTAS)</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/create-function-using-jar/">CREATE FUNCTION USING JAR</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/partition-by-clause/">PARTITION BY Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/create-view/">CREATE VIEW</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/describe/">DESCRIBE</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/drop-function-using-jar/">DROP FUNCTION USING JAR</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/drop-table/">DROP TABLE</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/drop-view/">DROP VIEW</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/explain/">EXPLAIN</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/lateral-join/">LATERAL Join</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/select/">SELECT</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/select-list/">SELECT List</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/from-clause/">FROM Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/group-by-clause/">GROUP BY Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/having-clause/">HAVING Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/limit-clause/">LIMIT Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/offset-clause/">OFFSET Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/order-by-clause/">ORDER BY Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/set-operators/">Set Operators</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/where-clause/">WHERE Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/with-clause/">WITH Clause</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-databases-and-show-schemas/">SHOW DATABASES and SHOW SCHEMAS</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-files/">SHOW FILES</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/show-tables/">SHOW TABLES</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/use/">USE</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/pivot-operators/">Pivot Operators</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">SQL Conditional Expressions</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/case/">CASE</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/reserved-keywords/">Reserved Keywords</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/sql-extensions/">SQL Extensions</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Data Sources and File Formats</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/data-sources-and-file-formats-introduction/">Data Sources and File Formats Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/hive-to-drill-data-type-mapping/">Hive-to-Drill Data Type Mapping</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/deploying-and-using-a-hive-udf/">Deploying and Using a Hive UDF</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/parquet-format/">Parquet Format</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/logfile-plugin/">Logfile Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/json-data-model/">JSON Data Model</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/text-files-csv-tsv-psv/">Text Files: CSV, TSV, PSV</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/sequence-files/">Sequence Files</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/httpd-format-plugin/">HTTPD Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/image-metadata-format-plugin/">Image Metadata Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/syslog-format-plugin/">Syslog Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/ltsv-format-plugin/">LTSV Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/spss-format-plugin/">SPSS Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/esri-shapefile-format-plugin/">ESRI Shapefile Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/excel-format-plugin/">Excel Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/hdf5-format-plugin/">HDF5 Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/ms-access-format-plugin/">Microsoft Access Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/xml-format-plugin/">XML Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/iceberg-format-plugin/">Iceberg Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/delta-lake-format-plugin/">Delta Lake Format Plugin</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/sas-format-plugin/">SAS Format Plugin</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Develop Custom Functions</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/develop-custom-functions-introduction/">Develop Custom Functions Introduction</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/developing-a-simple-function/">Developing a Simple Function</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/tutorial-develop-a-simple-function/">Tutorial: Develop a Simple Function</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/developing-an-aggregate-function/">Developing an Aggregate Function</a></li> <li class="toctree-l2"><a href="javascript: void(0);">Adding Custom Functions to Drill</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/adding-custom-functions-to-drill-introduction/">Adding Custom Functions to Drill Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/manually-adding-custom-functions-to-drill/">Manually Adding Custom Functions to Drill</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/creating-custom-authenticators/">Creating Custom Authenticators</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/dynamic-udfs/">Dynamic UDFs</a></li> </ul> <li class="toctree-l2"><a class="reference internal" href="/docs/using-custom-functions-in-queries/">Using Custom Functions in Queries</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/custom-function-interfaces/">Custom Function Interfaces</a></li> </ul> <li class="toctree-l1"><a class="reference internal" href="/docs/troubleshooting/">Troubleshooting</a></li> <li class="toctree-l1"><a href="javascript: void(0);">Developer Information</a></li> <ul style="display: none"> <li class="toctree-l2"><a href="javascript: void(0);">REST API</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/rest-api-introduction/">REST API Introduction</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/submitting-queries-from-the-rest-api-when-impersonation-is-enabled-and-authentication-is-disabled/">Submitting Queries from the REST API when Impersonation is Enabled and Authentication is Disabled</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/use-postman-to-run-sql-queries-on-drill-data-sources/">Use Postman to Run SQL Queries on Drill Data Sources</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Develop Drill</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/compiling-drill-from-source/">Compiling Drill from Source</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/useful-information-for-drill-developers/">Useful Information for Drill Developers</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Contribute to Drill</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/apache-drill-contribution-guidelines/">Apache Drill Contribution Guidelines</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/apache-drill-contribution-ideas/">Apache Drill Contribution Ideas</a></li> </ul> <li class="toctree-l2"><a href="javascript: void(0);">Design Docs</a></li> <ul style="display: none"> <li class="toctree-l3"><a class="reference internal" href="/docs/drill-plan-syntax/">Drill Plan Syntax</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/rpc-overview/">RPC Overview</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/query-stages/">Query Stages</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/useful-research/">Useful Research</a></li> <li class="toctree-l3"><a class="reference internal" href="/docs/value-vectors/">Value Vectors</a></li> </ul> </ul> <li class="toctree-l1 current_section "><a href="javascript: void(0);">Release Notes</a></li> <ul class="current_section"> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-21-2-release-notes/">Apache Drill 1.21.2 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-21-1-release-notes/">Apache Drill 1.21.1 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-21-0-release-notes/">Apache Drill 1.21.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-20-3-release-notes/">Apache Drill 1.20.3 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-20-2-release-notes/">Apache Drill 1.20.2 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-20-1-release-notes/">Apache Drill 1.20.1 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-20-0-release-notes/">Apache Drill 1.20.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-19-0-release-notes/">Apache Drill 1.19.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-18-0-release-notes/">Apache Drill 1.18.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-17-0-release-notes/">Apache Drill 1.17.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-16-0-release-notes/">Apache Drill 1.16.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-15-0-release-notes/">Apache Drill 1.15.0 Release Notes</a></li> <li class="toctree-l2 current"><a class="reference internal" href="/docs/apache-drill-1-14-0-release-notes/">Apache Drill 1.14.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-13-0-release-notes/">Apache Drill 1.13.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-12-0-release-notes/">Apache Drill 1.12.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-11-0-release-notes/">Apache Drill 1.11.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-10-0-release-notes/">Apache Drill 1.10.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-9-0-release-notes/">Apache Drill 1.9.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-8-0-release-notes/">Apache Drill 1.8.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-7-0-release-notes/">Apache Drill 1.7.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-6-0-release-notes/">Apache Drill 1.6.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-5-0-release-notes/">Apache Drill 1.5.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-4-0-release-notes/">Apache Drill 1.4.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-3-0-release-notes/">Apache Drill 1.3.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-2-0-release-notes/">Apache Drill 1.2.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-1-0-release-notes/">Apache Drill 1.1.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-1-0-0-release-notes/">Apache Drill 1.0.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-9-0-release-notes/">Apache Drill 0.9.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-8-0-release-notes/">Apache Drill 0.8.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-7-0-release-notes/">Apache Drill 0.7.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-6-0-release-notes/">Apache Drill 0.6.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-5-0-release-notes/">Apache Drill 0.5.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-0-4-0-release-notes/">Apache Drill 0.4.0 Release Notes</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/apache-drill-m1-release-notes-apache-drill-alpha/">Apache Drill M1 Release Notes (Apache Drill Alpha)</a></li> </ul> <li class="toctree-l1"><a href="javascript: void(0);">Sample Datasets</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/enron-emails/">Enron Emails</a></li> <li class="toctree-l2"><a class="reference internal" href="/docs/wikipedia-edit-history/">Wikipedia Edit History</a></li> </ul> <li class="toctree-l1"><a class="reference internal" href="/docs/project-bylaws/">Project Bylaws</a></li> <li class="toctree-l1"><a href="javascript: void(0);">Ecosystem</a></li> <ul style="display: none"> <li class="toctree-l2"><a class="reference internal" href="/docs/using-saiku-analytics-with-apache-drill/">Using Saiku Analytics with Apache Drill</a></li> </ul> </ul> </div> </div> </aside> <nav class="breadcrumbs"> <li><a href="/docs/">Docs</a></li> <li><a href="/docs/release-notes/">Release Notes</a></li> <li>Apache Drill 1.14.0 Release Notes</li> </nav> <div class="main-content-wrapper"> <div class="main-content"> <a class="edit-link" href="https://github.com/apache/drill-site/blob/master/_docs/en/rn/052-1.14.0-rn.md" target="_blank"><i class="fa fa-pencil-square-o"></i></a> <div class="int_title left"> <h1>Apache Drill 1.14.0 Release Notes</h1> </div>  <div class="int_text" align="left"> <p><strong>Release date:</strong> August 05, 2018</p> <p>Today, we’re happy to announce the availability of Drill 1.14.0. You can download it <a href="https://drill.apache.org/download/">here</a>.</p> <h2 id="new-features-and-improvements">New Features and Improvements</h2> <p>This release of Drill provides the following new features and improvements:</p> <ul> <li>Ability to <a href="/docs/running-drill-on-docker/">run Drill in a Docker container</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6346">DRILL-6346</a>)</li> <li>Ability to <a href="/docs/configuring-storage-plugins/#exporting-storage-plugin-configurations">export and save your storage plugin configurations</a> to a JSON file for reuse. (<a href="https://issues.apache.org/jira/browse/DRILL-4580">DRILL-4580</a>)</li> <li>Ability to manage storage plugin configurations in the Drill configuration file, <a href="/docs/configuring-storage-plugins/#configuring-storage-plugins-with-the-storage-plugins-override.conf-file">storage-plugins-override.conf</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6494">DRILL-6494</a>)</li> <li><a href="/docs/data-type-functions/">Functions that return data type information</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6361">DRILL-6361</a>)</li> <li>The Drill <a href="/docs/kafka-storage-plugin/#filter-pushdown-support">kafka storage plugin supports filter pushdown for query conditions</a> on certain Kafka metadata fields in messages. (<a href="https://issues.apache.org/jira/browse/DRILL-5977">DRILL-5977</a>)</li> <li><a href="/docs/sort-based-and-hash-based-memory-constrained-operators/#spill-to-disk">Spill to disk</a> for the Hash Join operator. (<a href="https://issues.apache.org/jira/browse/DRILL-6027">DRILL-6027</a>)</li> <li>The dfs storage plugin supports a <a href="/docs/logfile-plugin/">Logfile plugin extension</a> that enables Drill to directly read and query log files of any format. (<a href="https://issues.apache.org/jira/browse/DRILL-6104">DRILL-6104</a>)</li> <li><a href="/docs/phonetic-functions/">Phonetic</a> and <a href="/docs/phonetic-functions/">string distance</a> functions. (<a href="https://issues.apache.org/jira/browse/DRILL-6519">DRILL-6519</a>)</li> <li>The <a href="/docs/hive-storage-plugin/#setting-hive-properties">store.hive.conf.properties option</a> enables you to specify Hive properties at the session level using the SET command. (<a href="https://issues.apache.org/jira/browse/DRILL-6575">DRILL-6575</a>)</li> <li><a href="/docs/configuring-cgroups-to-control-cpu-usage/">Drill can directly manage the CPU resources</a> through the Drill start-up script, drill-env.sh; you no longer have to manually add the PID to the cgroup.procs file each time a Drillbit restarts. (<a href="https://issues.apache.org/jira/browse/DRILL-143">DRILL-143</a>)</li> <li>Drill can query the metadata in various image formats with the <a href="/docs/image-metadata-format-plugin/">image metadata format plugin</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-4364">DRILL-4364</a>)</li> <li><a href="/docs/supported-data-types/#decimal-data-type">Enhanced decimal data type support</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6094">DRILL-6094</a>)</li> <li><a href="/docs/limit-clause/#limit-0">Option to push LIMIT(0) on top of SCAN</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-6574">DRILL-6574</a>)</li> <li>Parquet filter pushdown improvements: - Drill can <a href="/docs/parquet-filter-pushdown/#viewing-the-query-plan">infer filter conditions</a> for join queries and push the filter conditions down to the data source. (<a href="https://issues.apache.org/jira/browse/DRILL-6173">DRILL-6173</a>) - Drill uses a native reader to read Hive tables when you enable the <a href="/docs/configuration-options-introduction/">store.hive.optimize_scan_with_native_readers option</a>. When enabled, Drill reads data faster and applies filter pushdown optimizations. (<a href="https://issues.apache.org/jira/browse/DRILL-6331">DRILL-6331</a>)</li> <li>Early release of <a href="/docs/lateral-join/">lateral join</a>. (<a href="https://issues.apache.org/jira/browse/DRILL-5999">DRILL-5999</a>)</li> </ul> <p><strong>Note:</strong> New MapR Drill <a href="https://package.mapr.com/tools/MapR-ODBC/MapR_Drill/MapRDrill_odbc_v1.3.22.1055/">ODBC</a> and <a href="https://package.mapr.com/tools/MapR-JDBC/MapR_Drill/MapRDrill_jdbc_v1.6.0.1001/">JDBC</a> drivers are available for Drill 1.14. Earlier versions of the drivers do not work with Drill 1.14.</p> <p>The following sections list all the fixes and improvements in this release:</p> <h2> Sub-task </h2> <ul> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5030">DRILL-5030</a>] - Drill SSL Docs have Bad Link to Oracle Website </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5847">DRILL-5847</a>] - Flat Parquet Reader Performance Analysis </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5848">DRILL-5848</a>] - Implement Parquet Columnar Processing & Use Bulk APIs for processing </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6281">DRILL-6281</a>] - Refactor TimedRunnable </li> </ul> <h2> Bug </h2> <ul> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-3539">DRILL-3539</a>] - CTAS over empty json file throws NPE </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-3964">DRILL-3964</a>] - CTAS fails with NPE when source JSON file is empty </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4020">DRILL-4020</a>] - The not-equal operator returns incorrect results when used on the HBase row key </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4337">DRILL-4337</a>] - Drill fails to read INT96 fields from hive generated parquet files </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4742">DRILL-4742</a>] - Using convert_from timestamp_impala gives a random error </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4834">DRILL-4834</a>] - decimal implementation is vulnerable to overflow errors, and extremely complex </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5188">DRILL-5188</a>] - TPC-DS query16 fails - IllegalArgumentException: Target must be less than target count </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5201">DRILL-5201</a>] - Query bug: null values in result of a conditioned query </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5281">DRILL-5281</a>] - JdbcSchema throws exception when detecting nullable for columns </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5495">DRILL-5495</a>] - convert_from function on top of int96 data results in ArrayIndexOutOfBoundsException </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5927">DRILL-5927</a>] - Root allocator consistently Leaks a buffer in unit tests </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5990">DRILL-5990</a>] - Apache Drill /status API returns OK ('Running') even with JRE while queries will not work - make status API reflect the fact that Drill is broken on JRE or stop Drill starting up with JRE </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6008">DRILL-6008</a>] - Unable to shutdown Drillbit using short domain name </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6009">DRILL-6009</a>] - No drillbits on index page </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6010">DRILL-6010</a>] - Working drillbit showing as in QUIESCENT state </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6016">DRILL-6016</a>] - Error reading INT96 created by Apache Spark </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6082">DRILL-6082</a>] - RpcExceptionHandler log doesn't print "cause" for exception </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6103">DRILL-6103</a>] - lsb_release: command not found </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6125">DRILL-6125</a>] - PartitionSenderRootExec can leak memory because close method is not synchronized </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6132">DRILL-6132</a>] - HashPartitionSender leaks memory </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6182">DRILL-6182</a>] - Doc bug on parameter 'drill.exec.spill.fs' </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6199">DRILL-6199</a>] - Filter push down doesn't work with more than one nested subqueries </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6202">DRILL-6202</a>] - Deprecate usage of IndexOutOfBoundsException to re-alloc vectors </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6203">DRILL-6203</a>] - Repeated Map Vector does not give correct payload bytecount. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6212">DRILL-6212</a>] - A simple join is recursing too deep in planning and eventually throwing stack overflow. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6224">DRILL-6224</a>] - The metrics' page has gauges reset to near zero values and does not seem to update </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6241">DRILL-6241</a>] - Saffron properties config has the excessive permissions </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6242">DRILL-6242</a>] - Output format for nested date, time, timestamp values in an object hierarchy </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6250">DRILL-6250</a>] - Sqlline start command with password appears in the sqlline.log </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6252">DRILL-6252</a>] - Foreman node is going down when the non foreman node is stopped </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6254">DRILL-6254</a>] - IllegalArgumentException: the requested size must be non-negative </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6255">DRILL-6255</a>] - Drillbit while sending control message to itself creates a connection instead of submitting locally </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6256">DRILL-6256</a>] - Remove references to java 7 from readme and other files </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6262">DRILL-6262</a>] - IndexOutOfBoundException in RecordBatchSize for empty variableWidthVector </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6274">DRILL-6274</a>] - MergeJoin Memory Manager is still using Fragmentation Factor </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6275">DRILL-6275</a>] - drillbit direct_current memory usage is not populated/updated </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6277">DRILL-6277</a>] - Query fails with DATA_READ ERROR when correlated subquery has "always false" filter </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6278">DRILL-6278</a>] - DRILL-5993 Made Debugging Generated Code Harder </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6282">DRILL-6282</a>] - Update Drill's Metrics dependencies </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6283">DRILL-6283</a>] - WebServer stores SPNEGO client principal without taking any conversion rule </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6286">DRILL-6286</a>] - Regression: incorrect reference to shutdown in drillbit.log </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6287">DRILL-6287</a>] - apache-release profile should be disabled by default </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6295">DRILL-6295</a>] - PartitionerDecorator may close partitioners while CustomRunnable are active during query cancellation </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6298">DRILL-6298</a>] - Add debug log for merge join batch sizing </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6299">DRILL-6299</a>] - Parquet query returns unexpected results </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6302">DRILL-6302</a>] - NPE in Drillbit.java in close method </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6307">DRILL-6307</a>] - Handle empty batches in record batch sizer correctly </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6311">DRILL-6311</a>] - No logging information in drillbit.log / drillbit.out </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6318">DRILL-6318</a>] - Push down limit past flatten is incorrect </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6338">DRILL-6338</a>] - License headers are not added to generated proto buf files with new license changes. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6341">DRILL-6341</a>] - Mongo Tests Fail on OSX 10.13.4 </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6342">DRILL-6342</a>] - Parquet filter pushdown doesn't work in case of filtering fields inside arrays of complex fields </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6343">DRILL-6343</a>] - bit vector copyFromSafe is not doing realloc </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6351">DRILL-6351</a>] - Drill fails with NullPointerException when starting in embedded mode </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6364">DRILL-6364</a>] - WebUI does not cleanly handle shutdown and state toggling when Drillbits go on and offline </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6374">DRILL-6374</a>] - Transitive Closure leads to TPCH Queries regressions and OOM when run concurrency test </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6380">DRILL-6380</a>] - Mongo db storage plugin tests can hang on jenkins. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6387">DRILL-6387</a>] - TestTpchDistributedConcurrent tests are ignored, they should be enabled. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6393">DRILL-6393</a>] - Radians should take an argument (x) </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6401">DRILL-6401</a>] - Precision for decimal data types may be lost for the case when cast with literal is used </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6402">DRILL-6402</a>] - Repeated Value Vectors copyFrom methods are not updating the value count and writer index correctly for values vector </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6411">DRILL-6411</a>] - Make batch memory sizing logs uniform across all operators </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6413">DRILL-6413</a>] - Specific query returns an exception if filter a boolean column by "equals" operator </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6415">DRILL-6415</a>] - Unit test TestGracefulShutdown.testRestApiShutdown times out </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6416">DRILL-6416</a>] - Unit test TestTpchDistributedConcurrent.testConcurrentQueries fails with AssertionError </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6431">DRILL-6431</a>] - Unnest operator requires table and a single column alias to be specified. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6435">DRILL-6435</a>] - MappingSet is stateful, so it can't be shared between threads </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6437">DRILL-6437</a>] - Travis Fails Because Logs Are Flooded. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6442">DRILL-6442</a>] - Adjust Hbase disk cost & row count estimation when filter push down is applied </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6443">DRILL-6443</a>] - Search feature for profiles is available only for running OR completed queries, but not both </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6447">DRILL-6447</a>] - Unsupported Operation when reading parquet data </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6450">DRILL-6450</a>] - Visualized plans for profiles querying JDBC sources is broken </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6455">DRILL-6455</a>] - JDBC Scan Operator does not appear in profile </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6456">DRILL-6456</a>] - Planner shouldn't create any exchanges on the right side of Lateral Join. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6459">DRILL-6459</a>] - Unable to view profile of a running query </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6463">DRILL-6463</a>] - ProfileParser cannot parse costs when using MockScanBatch </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6467">DRILL-6467</a>] - Percentage usage of memory is reported as zero by the WebUI </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6468">DRILL-6468</a>] - OOMs trigger graceful shutdown when terminating Drill. This can cause a hang. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6470">DRILL-6470</a>] - http://repo.dremio.com/release/ can not open </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6471">DRILL-6471</a>] - Different result for CAST String and Decimal literals as Decimal </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6472">DRILL-6472</a>] - Drill allows to use decimal zero precision in CAST function for CTAS </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6474">DRILL-6474</a>] - Queries with ORDER BY and OFFSET (w/o LIMIT) do not return any rows </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6475">DRILL-6475</a>] - Unnest: Null fieldId Pointer </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6476">DRILL-6476</a>] - Generate explain plan which shows relation between Lateral and the corresponding Unnest. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6477">DRILL-6477</a>] - Drillbit hangs/crashes with OOME Java Heap Space for a large query through WebUI </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6478">DRILL-6478</a>] - enhance debug logs for batch sizing </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6485">DRILL-6485</a>] - Typo in drill-env.sh </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6486">DRILL-6486</a>] - BitVector split and transfer does not work correctly for non byte-multiple transfer lengths </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6487">DRILL-6487</a>] - Negative row count when selecting from a json file with an OFFSET clause </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6488">DRILL-6488</a>] - Drill native client - compile error due to usage of "template inline" </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6489">DRILL-6489</a>] - Fix filter push down for Hbase & Mapr-DB binary tables when convert function is used in a view </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6491">DRILL-6491</a>] - Prevent merge join for full outer join at planning stage </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6496">DRILL-6496</a>] - VectorUtil.showVectorAccessibleContent does not log vector content </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6499">DRILL-6499</a>] - No need to calculate stdRowWidth for every batch by default </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6512">DRILL-6512</a>] - Remove unnecessary processing overhead from RecordBatchSizer </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6513">DRILL-6513</a>] - Drill should only allow valid values when users set planner.memory.max_query_memory_per_node </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6523">DRILL-6523</a>] - Fix NPE for describe of partial schema </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6529">DRILL-6529</a>] - Project Batch Sizing causes two LargeFileCompilation tests to timeout </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6530">DRILL-6530</a>] - JVM crash with a query involving multiple json files with one file having a schema change of one column from string to list </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6535">DRILL-6535</a>] - ClassCastException in Lateral Unnest queries when dealing with schema changed json data </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6537">DRILL-6537</a>] - Limit the batch size for buffering operators based on how much memory they get </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6539">DRILL-6539</a>] - Record count not set for this vector container error </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6542">DRILL-6542</a>] - IndexOutOfBoundsException for multilevel lateral queries with schema changed partitioned complex data </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6546">DRILL-6546</a>] - Allow unnest function with nested columns and complex expressions </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6548">DRILL-6548</a>] - IllegalStateException: Unexpected EMIT outcome received in buildSchema phase </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6551">DRILL-6551</a>] - Concat function results in SYSTEM ERROR: IllegalStateException: Tried to remove unmanaged buffer. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6553">DRILL-6553</a>] - Fix TopN for unnest operator </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6557">DRILL-6557</a>] - Use size in bytes during Hive statistics calculation if present </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6568">DRILL-6568</a>] - Jenkins Regression: TPCDS query 68 fails with IllegalStateException: Unexpected EMIT outcome received in buildSchema phase </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6570">DRILL-6570</a>] - IndexOutOfBoundsException when using Flat Parquet Reader </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6576">DRILL-6576</a>] - Unnest reports incoming record counts incorrectly </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6578">DRILL-6578</a>] - Ensure the Flat Parquet Reader can handle query cancellation </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6583">DRILL-6583</a>] - Add space between pagination links in Profiles (WebUI) list </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6588">DRILL-6588</a>] - System table columns incorrectly marked as non-nullable </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6591">DRILL-6591</a>] - When query fails on Web UI, result page does not show any error </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6592">DRILL-6592</a>] - Unnest perf improvements - record batch sizer is called too frequently </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6594">DRILL-6594</a>] - Data batches for Project operator are not being split properly and exceed the maximum specified </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6596">DRILL-6596</a>] - Variable length vectors use unnecessary emptyByteArray to fill empties </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6603">DRILL-6603</a>] - Filter pushdown for a null value eliminates all except one rowgroup </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6606">DRILL-6606</a>] - Hash Join returns incorrect data types when joining subqueries with limit 0 </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6612">DRILL-6612</a>] - Query fails with AssertionError when joining persistent and temporary tables </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6614">DRILL-6614</a>] - Allow usage of MapRDBFormatPlugin for HiveStoragePlugin </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6622">DRILL-6622</a>] - UNION on tpcds sf100 tables hit SYSTEM ERROR: NullPointerException </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6624">DRILL-6624</a>] - Fix loss of the table row type when the same schema name was specified as single path and as a complex path in the same query </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6626">DRILL-6626</a>] - Hash Aggregate: Index out of bounds with small output batch size and spilling </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6627">DRILL-6627</a>] - Adding REGEX_SUB_SCAN operator to protobuf file </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6632">DRILL-6632</a>] - drill-jdbc-all jar size limit too small for release build </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6637">DRILL-6637</a>] - Root pom: Release build needs to remove dep to tests in maven-javadoc-plugin </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6651">DRILL-6651</a>] - Compilation error in IDE due to missing package name </li> </ul> <h2> New Feature </h2> <ul> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-143">DRILL-143</a>] - Support CGROUPs resource management </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4276">DRILL-4276</a>] - Need a way to check on status of drillbits </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4364">DRILL-4364</a>] - Image Metadata Format Plugin </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5261">DRILL-5261</a>] - Expose REST endpoint in zookeeper </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6027">DRILL-6027</a>] - Implement spill to disk for the Hash Join </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6375">DRILL-6375</a>] - ANY_VALUE aggregate function </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6423">DRILL-6423</a>] - Export query result as a CSV file </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6432">DRILL-6432</a>] - Allow to print the visualized query plan only </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6454">DRILL-6454</a>] - Native MapR DB plugin support for Hive MapR-DB json table </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6494">DRILL-6494</a>] - Drill Plugins Handler </li> </ul> <h2> Improvement </h2> <ul> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-2746">DRILL-2746</a>] - Filter is not pushed into subquery past UNION ALL </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-3130">DRILL-3130</a>] - Project can be pushed below union all / union to improve performance </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-3855">DRILL-3855</a>] - Enable FilterSetOpTransposeRule, DrillProjectSetOpTransposeRule </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4091">DRILL-4091</a>] - Support more functions in gis contrib module </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4525">DRILL-4525</a>] - Query with BETWEEN clause on Date and Timestamp values fails with Validation Error </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4580">DRILL-4580</a>] - Provide options to import and export storage plugin configurations </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-4829">DRILL-4829</a>] - Configure the address to bind to </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5305">DRILL-5305</a>] - Query Profile must display Query ID </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5584">DRILL-5584</a>] - When Compiling Apache Drill C++ Client, versioning information are not present in the binary </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5700">DRILL-5700</a>] - nohup support for sqlline </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5797">DRILL-5797</a>] - Use more often the new parquet reader </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5846">DRILL-5846</a>] - Improve Parquet Reader Performance for Flat Data types </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5924">DRILL-5924</a>] - native-client: Support user-specified CXX_FLAGS </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5977">DRILL-5977</a>] - predicate pushdown support kafkaMsgOffset </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6005">DRILL-6005</a>] - Fix TestGracefulShutdown tests to skip check for loopback address usage in distributed mode </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6053">DRILL-6053</a>] - Avoid excessive locking in LocalPersistentStore </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6094">DRILL-6094</a>] - Decimal data type enhancements </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6104">DRILL-6104</a>] - Generic Logfile Format Plugin </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6145">DRILL-6145</a>] - Enable usage of Hive MapR-DB JSON handler </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6147">DRILL-6147</a>] - Limit batch size for Flat Parquet Reader </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6161">DRILL-6161</a>] - Allocate memory for outgoing vectors based on sizing calculations </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6162">DRILL-6162</a>] - Enhance record batch sizer to retain nesting information for map columns. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6173">DRILL-6173</a>] - Support transitive closure during filter push down and partition pruning </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6230">DRILL-6230</a>] - Extend row set readers to handle hyper vectors </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6231">DRILL-6231</a>] - Fix memory allocation for repeated list vector </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6234">DRILL-6234</a>] - Improve Documentation of VariableWidthVector Behavior </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6236">DRILL-6236</a>] - batch sizing for hash join </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6239">DRILL-6239</a>] - Add Build and License Badges to README.md </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6243">DRILL-6243</a>] - Alert box to confirm shutdown of drillbit after clicking shutdown button </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6248">DRILL-6248</a>] - Support pushdown into System Table </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6249">DRILL-6249</a>] - Add Markdown Docs for Unit Testing and Link to it in README.md </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6259">DRILL-6259</a>] - Support parquet filter push down for complex types </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6279">DRILL-6279</a>] - Web UI should indicate when operators have spilled in-memory data to disk </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6284">DRILL-6284</a>] - Add operator metrics for batch sizing for flatten </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6289">DRILL-6289</a>] - Cluster view should show more relevant information </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6296">DRILL-6296</a>] - Add operator metrics for batch sizing for merge join </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6303">DRILL-6303</a>] - Provide a button to copy the Drillbit's JStack shown in /threads </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6310">DRILL-6310</a>] - limit batch size for hash aggregate </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6320">DRILL-6320</a>] - Don't Allow Javadoc comments for license headers </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6331">DRILL-6331</a>] - Parquet filter pushdown does not support the native hive reader </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6333">DRILL-6333</a>] - Generate and host Javadocs on Apache Drill website </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6334">DRILL-6334</a>] - Code cleanup </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6335">DRILL-6335</a>] - Refactor row set abstractions to prepare for unions </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6339">DRILL-6339</a>] - New option to disable TopN (for testing Sort) </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6340">DRILL-6340</a>] - Output Batch Control in Project using the RecordBatchSizer </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6345">DRILL-6345</a>] - Add LOG10 function implementation </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6346">DRILL-6346</a>] - Create an Official Drill Docker Container </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6347">DRILL-6347</a>] - Inconsistent method name "field". </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6348">DRILL-6348</a>] - Unordered Receiver does not report its memory usage </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6356">DRILL-6356</a>] - batch sizing for union all </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6361">DRILL-6361</a>] - Provide sqlTypeOf() and modeOf() functions </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6389">DRILL-6389</a>] - Fix building javadocs </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6418">DRILL-6418</a>] - Handle Schema change in Unnest And Lateral for unnest field / non-unnest field </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6424">DRILL-6424</a>] - Updating FasterXML Jackson libraries </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6436">DRILL-6436</a>] - Store context and name in AbstractStoragePlugin instead of replicating fields in each StoragePlugin </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6438">DRILL-6438</a>] - Remove excess logging from tests </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6440">DRILL-6440</a>] - Fix ignored unit tests in unnest </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6466">DRILL-6466</a>] - Add HttpOnly flag for response cookie </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6479">DRILL-6479</a>] - Support for EMIT outcome in Hash Aggregate </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6502">DRILL-6502</a>] - Rename CorrelatePrel to LateralJoinPrel </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6503">DRILL-6503</a>] - Performance improvements in lateral </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6505">DRILL-6505</a>] - Drill Web UI query: support back button or add "edit query" </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6515">DRILL-6515</a>] - Render a linkage between the Unnest operator and its source operator </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6516">DRILL-6516</a>] - Support for EMIT outcome in streaming agg </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6519">DRILL-6519</a>] - Add String Distance and Phonetic Functions </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6545">DRILL-6545</a>] - Projection Push down into Lateral Join operator. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6549">DRILL-6549</a>] - batch sizing for nested loop join </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6554">DRILL-6554</a>] - Minor code improvements in parquet statistics handling </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6560">DRILL-6560</a>] - Allow options for controlling the batch size per operator </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6561">DRILL-6561</a>] - Lateral excluding the columns from output container provided by projection push into rules </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6574">DRILL-6574</a>] - Add option to push LIMIT(0) on top of SCAN (late limit 0 optimization) </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6575">DRILL-6575</a>] - Add store.hive.conf.properties option to allow set Hive properties at session level </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6577">DRILL-6577</a>] - Change Hash-Join default to not fallback (into pre-1.14 unlimited memory) </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6579">DRILL-6579</a>] - Add sanity checks to Parquet Reader </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6581">DRILL-6581</a>] - Improve C++ Client SSL Implementation </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6586">DRILL-6586</a>] - Add SSL Hostname verification with zookeeper connection mode support </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6587">DRILL-6587</a>] - Add support for custom SSL CTX Options </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6601">DRILL-6601</a>] - LageFileCompilation testProject times out </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6650">DRILL-6650</a>] - Remove Stray Semicolon in Printing Results Listener </li> </ul> <h2> Task </h2> <ul> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-5937">DRILL-5937</a>] - Make prepare.statement.create_timeout_ms default to 30 seconds instead of 10 seconds </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6061">DRILL-6061</a>] - Doc Request: Global Query List showing queries from all Drill foreman nodes </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6237">DRILL-6237</a>] - Upgrade checkstyle version to 5.9 or above </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6270">DRILL-6270</a>] - Add debug startup option flag for drill in embedded and server mode </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6271">DRILL-6271</a>] - Update copyright range in NOTICE </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6272">DRILL-6272</a>] - Remove binary jars files from source distribution </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6273">DRILL-6273</a>] - Remove dependency licensed under Category X </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6288">DRILL-6288</a>] - Upgrade org.javassist:javassist and org.reflections:reflections </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6290">DRILL-6290</a>] - Refactor TestInfoSchemaFilterPushDown tests to use PlanTestBase utility methods </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6294">DRILL-6294</a>] - Update Calcite version to 1.16.0 </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6300">DRILL-6300</a>] - Refresh protobuf C++ source files </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6301">DRILL-6301</a>] - Parquet Performance Analysis </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6321">DRILL-6321</a>] - Lateral Join: Planning changes - enable submitting physical plan </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6323">DRILL-6323</a>] - Lateral Join - Initial implementation </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6328">DRILL-6328</a>] - Consolidate developer docs in docs/ folder of drill repo. </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6353">DRILL-6353</a>] - Upgrade Parquet MR dependencies </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6363">DRILL-6363</a>] - Upgrade jmockit and mockito libs </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6419">DRILL-6419</a>] - E2E Integration test for Lateral&Unnest </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6420">DRILL-6420</a>] - Add Lateral and Unnest Keyword for highlighting on WebUI </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6421">DRILL-6421</a>] - Refactor DecimalUtility and CoreDecimalUtility classes </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6426">DRILL-6426</a>] - Refactor TestFunctionsWithTypeExpoQueries test to be independent on limit 0 optimization option </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6445">DRILL-6445</a>] - Fix existing test cases in TestScripts.java and add new test case for DRILLBIT_CONTEXT variable </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6446">DRILL-6446</a>] - Support for EMIT outcome in TopN </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6481">DRILL-6481</a>] - Refactor ParquetXXXPredicate classes </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6498">DRILL-6498</a>] - Support for EMIT outcome in ExternalSortBatch </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6500">DRILL-6500</a>] - Update Apache Drill security documentation </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6526">DRILL-6526</a>] - Refactor FileSystemConfig to disallow direct access from the code to its variables </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6531">DRILL-6531</a>] - Errors in example for "Aggregate Function Interface" Boaz Ben-Zvi Fri 6/15, 5:54 PM Bridget Bevens </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6534">DRILL-6534</a>] - Upgrade ZooKeeper patch version to 3.4.12 and add Apache Curator to dependencyManagement </li> <li>[<a href="https://issues.apache.org/jira/browse/DRILL-6559">DRILL-6559</a>] - Travis timing out </li> </ul> <div class="doc-nav"> <span class="previous-toc"><a href="/docs/apache-drill-1-15-0-release-notes/">← Apache Drill 1.15.0 Release Notes</a></span><span class="next-toc"><a href="/docs/apache-drill-1-13-0-release-notes/">Apache Drill 1.13.0 Release Notes →</a></span> </div> </div> </div> </div> </div> <p class="push"></p> <div id="footer" class="mw"> <div class="wrapper"> Copyright © 2012-2025 The Apache Software Foundation, licensed under the Apache License, Version 2.0.<br> Apache and the Apache feather logo are trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.<br/><br/> </div> </div> <script type="text/javascript" src="https://s7.addthis.com/js/300/addthis_widget.js#pubid=ra-548b2caa33765e8d" async="async"></script> </body> </html>

CINXE.COM

Apache Drill 1.14.0 Release Notes - Apache Drill