Release Announcement: Apache Hadoop Ecosystem - Drill 1.6
April 6, 2016
Today 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.
Download and Install
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)
- Explore Apache Drill Resources & Product Information
- Apache Drill Best Practices from the MapR Drill Team
Have a question?
Ask in Answers or comment below.