Drill 1.8 Released

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

The release provides the following bug fixes and improvements:

Metadata Cache Pruning

Drill now applies partition pruning to the metadata cache file. See Partition Pruning Introduction and Optimizing Parquet Metadata Reading.

IF EXISTS Support

You can include the new IF EXISTS parameter with the DROP TABLE and DROP VIEW commands to prevent Drill from returning error messages when a table or view does not exist. See DROP TABLE and DROP VIEW.

DESCRIBE SCHEMA Command

Drill now supports the DESCRIBE SCHEMA command which provides schema properties for storage plugin configurations and workspaces. See DESCRIBE.

Multi-Byte Delimiter Support

Drill now supports multi-byte delimiters for text files, such as \r\n. See List of Attributes and Definitions.

Filter Selectivity Estimate Parameters

New parameters set the minimum filter selectivity estimate to increase the parallelization of the major fragment performing a join. See System Options.

A complete list of JIRAs resolved in the 1.8.0 release can be found here.