nrentachintala

Apache Drill 1.6 is now available for MapR Converged Data Platform

Blog Post created by nrentachintala Employee on Apr 6, 2016

Release Announcement: Apache Hadoop Ecosystem - Drill 1.6

 

April 6, 2016

 

Apache drill.jpegToday we are very excited to announce the release of Apache Drill 1.6 on the MapR Converged Data Platform.

 

 

 

 

Drill 1.6 Release Highlights

  • New storage plugin for MapR-DB (document database)

  • Enhanced stability and scale with a new and improved memory allocator

  • Enhanced query  performance

    • Query planning speedups via early application of partition pruning

    • Faster query planning on Hive table queries

    • Optimized reading of Parquet metadata cache

    • Row count-based pruning to speed up Limit N queries

    • Optimized Tableau experience with limit 0 performance improvements

  • End-to-end security from BI tool to MapR/Drill with client impersonation (this is supported only with JDBC;  a new ODBC driver with this feature will  follow shortly).

  • New SQL Window function frame syntaxJDK 1.8 support

    • RANGE BETWEEN UNBOUNDED PRECEDING AND UNBOUNDED FOLLOWING

    • ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW

    • RANGE BETWEEN CURRENT ROW AND CURRENT ROW

  • JDK 1.8 support

  • Many more bug fixes and enhancements

 

At MapR, we are also very excited about this release due to the unique value it brings to you by combining Drill with the recently announced MapR-DB document database capabilities as part of the MapR 5.1 release.  A new MapR-DB document database format plugin is introduced in Drill 1.6, which enables you to query JSON tables in MapR-DB directly. This means that no ETL and no transformation is required at any layer. This combination gives you end-to-end flexibility when it comes to JSON in order to store, update, and query the data in its natural form and fidelity at Hadoop scale in global environments using familiar ANSI SQL capabilities. The result is that you now have operational analytics capabilities, and most importantly, are able to quickly adapt to changes to data models in the underlying applications. This agility means you’ll realize much faster time to value.

 

Learn More

 

Release Notes

Drill 1.6 release notes

 

Download and Install

Drill 1.6 Installation

 

Component and System Compatibility Matrix

MapR Drill 1.6.0 is certified on the MapR v5.1.0 converged data platform. See the Interoperability Matrix pages for information about the compatibility of Drill with operating systems and ecosystem projects.

 

Related Community Resources

drill (find all content with this tag)

 

Have a question?

Ask in Answers or comment below.

 

Get Notified of all Release Announcements

How to get notified of release, product and patch announcements

Outcomes