TrustRadius: an HG Insights company

Apache Drill

Score8 out of 10

6 Reviews and Ratings

What is Apache Drill?

Apache Drill is an open-source, distributed SQL query engine for analyzing data where it already resides. It provides schema-free SQL access to files, Hadoop data, NoSQL databases, and cloud object storage, allowing users to query raw and semi-structured data without first loading it into a warehouse or defining and maintaining a fixed schema.

Read more details.

Categories & Use Cases

Product Demos

Who Buys & Uses Apache Drill

Apache Drill Reviews

What users are saying about Apache Drill.
View all Apache Drill reviews

Apache Drill vs PrestoDB

Incentivized
Anson AbrahamView profile
Data Loard in Engineering at Envisagenics, Inc. (51-200 employees)

Pros

  • queries multiple data sources with ease.
  • supports sql, so non technical users who know sql, can run query sets
  • 3rd party tools, like tableau, zoom data and looker were able to connect with no issues

Cons

  • deployment. Not as easy
  • configuration isn't as straight forward, especially with the documentation
  • Garbage collection could be improved upon

Return on Investment

  • Configuration has taken some serious time out.
  • Garbage collection tuning. is a constant hassle. time and effort applied to it, vs dedicating resources elsewhere.
  • w/ sql support, reduces the need of devs to generate the resultset for analysts, when they can run queries themselves (if they know sql).

Alternatives Considered

prestodb, impala and apache phoenix

Other Software Used

Apache Spark, Apache Flume, Apache Kafka, Apache Lucene