Apache DrillApache Drill
What is Apache Drill?
Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages against NoSQL and Hadoop data storage systems. It was inspired in part by Google's Dremel.
Apache Drill is a tool in the Databases category of a tech stack.
Key Features
Low-latency SQL queriesDynamic queries on self-describing data in files (such as JSON, Parquet, text) and MapR-DB/HBase tables, without requiring metadata definitions in the Hive metastore.ANSI SQLNested data supportIntegration with Apache Hive (queries on Hive tables and views, support for all Hive file formats and Hive UDFs)BI/SQL tool integration using standard JDBC/ODBC drivers
Apache Drill Pros & Cons
Pros of Apache Drill
- ✓NoSQL and Hadoop
- ✓Free
- ✓Lightning speed and simplicity in face of data jungle
- ✓Well documented for fast install
- ✓Nested Data support
- ✓Read Structured and unstructured data
- ✓SQL interface to multiple datasources
- ✓V1.10 released - https://drill.apache.org/
Cons of Apache Drill
No cons listed yet.
Apache Drill Alternatives & Comparisons
What are some alternatives to Apache Drill?
Slick
It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.
Spring Data
It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.
Dataform
Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.
