---

title: “Apache Drill 1.15.0 Release Notes” slug: “Apache Drill 1.15.0 Release Notes” parent: “Release Notes”

Release date: December 31, 2018

Today, we're happy to announce the availability of Drill 1.15.0. You can download it here.

New Features and Improvements

This release of Drill provides the following new features and improvements:

• Drill can leverage indexes to create index-based query plans. (DRILL-6381)
• Support for aliases in the GROUP BY clause. (DRILL-1248)
• CROSS JOIN support. (DRILL-786)
• The INFORMATION_SCHEMA contains a FILES table that you can query for information about directories and files. (DRILL-6680)
• System functions table that exposes the available SQL functions in Drill and also detects UDFs that have been dynamically loaded into Drill. (DRILL-3988)
• New system options table. (DRILL-6684)
• Support for TIMESTAMPADD and TIMESTAMPDIFF datetime functions. (DRILL-3610)
• Ability to secure znodes with custom ACLs (Access Control Lists) (DRILL-5671).
• All cast and data type conversion functions return null for an empty string ('') when the drill.exec.functions.cast_empty_string_to_null option is enabled. (DRILL-6817)
• Storage plugin names are case-insensitive. (DRILL-6492)
• Ability to access your AWS access key ID and secret access key using the Credential Provider API for the S3 storage plugin. (DRILL-6662)
• Upgrade to SQLLine 1.6 includes the ability to add custom configuration. (DRILL-3853)
• New SQLLine connection parameters (DRILL-3933)
• New option, exec.query.return_result_set_for_ddl, prevents Drill from returning a result set for DDL statements when set to “false.” Useful for clients tools that connect to Drill (via JDBC) if they do not expect a result set. (DRILL-6834)
• Parquet filter pushdown for VARCHAR and DECIMAL data types (DRILL-6744)
• Improved query performance with the semi-join functionality inside the Hash-Join operator. (DRILL-6735)
• Lateral join functionality is enabled by default. (DRILL-6729)
• Support JPPD (Join Predicate Push Down). DRILL-6385
• Multiple Web UI improvements to simplify the use of options and submit queries, including:
  • Search field
  • Quick Filters (DRILL-5735)
  • Default button (DRILL-6668)
  • Web display options (DRILL-6544)
  • Meta+Enter key combination to submit queries (DRILL-6611)

The following sections provide a complete list of all the fixes and improvements in Drill 1.15: