Drill 1.2.0 Release Notes

Version 1.2.0
Release Date November 7, 2015
Works with MapR version See Drill Support Matrix

Noteworthy New Features in MapR Distribution of Drill

This release introduces a number of enhancements, including the following ones:

  • Partition pruning improvements
  • Optimizes reads of Parquet-backed, Hive tables.
  • Improved Hive support

    Supports Hive 1.2.1 and using multiple Hive versions (same as corresponding MapR platform version).

  • Analytical/Window functions support

    Adds Lead, Lag, First_Value, Last_Value, and Ntile support and allows multiple window functions in the same query.

  • DROP TABLE Command
  • Parquet metadata caching

    Improves query performance on a large number of files.

  • Security support for the Web Console
  • Row key filter pushdown

    Improves performance when querying HPE Ezmeral Data Fabric Database and HBase.

  • Improvements in the Drill JDBC driver.
  • Read support for the Parquet INT96 data type support

    A new TIMESTAMP_IMPALA type used with the CONVERT_FROM function decodes a timestamp from Hive or Impala.

  • Improved correlated subqueries
  • Support for UNION DISTINCT syntax
  • Improved LIMIT processing

Known Issues

The MapR 1.2 release of Drill does not include fixes for the following issues that were fixed in the Apache Drill 1.2 release:

Drill JIRA Description
DRILL-1065 You cannot issue the ALTER SESSION RESET command to reset an option to its default system value.
DRILL-2361 Drill returns the following error message when column aliases for aggregate or group by fields include a dot (.):

Field references must be singular names.
DRILL-2879 Drill cannot parse JSON files with the BSON OID data type, a MongoDB extension to the JSON format. Drill may also have issues parsing JSON files with the BSON Binary data type.
DRILL-3791 Testing of the JDBC storage plugin with MySQL is incomplete.
DRILL-3869 Queries submitted through the Drill Web Console with a trailing semicolon (;) fail, and Drill returns the following error message: org.apache.drill.common.exceptions.UserRemoteException: PARSE ERROR: Encountered ";" at line 1, column 42. Was expecting one of: "OFFSET" ... "FETCH" ...
DRILL-3888 The test JAR file configurations exist in each module’s POM file instead of the root POM file.
DRILL-3916 Drill-bits cannot load the JDBC storage plugin when starting because the plugin does not exist.