Skip to main content
TrustRadius
Apache Drill

Apache Drill

Overview

What is Apache Drill?

Apache Drill is a schema-free query engine for use with NoSQL or Hadoop data or file storage systems and databases.

Read more

Learn from top reviewers

Apache Drill vs PrestoDB

Rating: 8 out of 10
February 13, 2018
IncentivizedVetted ReviewVerified User
Apache Drill was being used initially to evaluate running queries on data stored in multiple data stores (hDFS, postgres, cassandra). We were testing it out, over the use of P...
Continue reading
Anson Abraham
Engineer - Engineering
Data Loard
Envisagenics, Inc.
Apache Drill2 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing
Apache Drill

Apache Drill

N/A
Unavailable

What is Apache Drill?

Apache Drill is a schema-free query engine for use with NoSQL or Hadoop data or file storage systems and databases.

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

2 people also want pricing

Alternatives Pricing

MarkLogic Server

MarkLogic Server

$0.01
per MCU/per hour + 0.10 per GB/per month
What is MarkLogic Server?

MarkLogic Server is a multi-model database that has both NoSQL and trusted enterprise data management capabilities. The vendor states it is the most secure multi-model database, and it’s deployable in any environment. They state it is an ideal database to power a data hub.

Couchbase Capella

Couchbase Capella

$0.32
per hour per node
What is Couchbase Capella?

The Couchbase Capella product is a fully managed DBaaS automating setup and ongoing operations.

Return to navigation

Product Demos

Apache Drill and Google Sheets Demo

YouTube

Apache drill | Apache Spark Training |Spark webinar videos | Prwatech

YouTube

GSA D2D Demo with USCIS sample data, built with Python Flask, AWS EMR and Apache Drill

YouTube

Drill on the Anssr Platform

YouTube

Spotfire and Apache Drill Test Drive Demo | Big Data Analytics

YouTube

Tomer Shiran: Self Service Data Exploration with Apache Drill

YouTube
Return to navigation

Product Details

What is Apache Drill?

Apache Drill Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

Apache Drill has proven to be a versatile tool for data querying and analysis in various use cases. Users have found success in utilizing Apache Drill to query Parquet files in the Hadoop ecosystem, such as those stored in HDFS. Additionally, Apache Drill has been employed in data aggregators, allowing users to combine data from different databases and formats and transform them into valuable information.

Users have also taken advantage of Apache Drill's capabilities to query Kafka tables and join data stored in HBase with Kafka, enabling seamless integration between different data sources. Furthermore, Apache Drill's ease of use when querying CSV files and passing the results to Spark has been praised by users. The configuration process for joining multiple systems, working with different file types such as JSON and .gz files, and creating consumption views has been reported as effortless by many users.

Apache Drill has demonstrated its effectiveness in pulling data from multiple stores like Oracle and MongoDB simultaneously, simplifying the process of data migration across various sources. Its easy configuration of plugins for Parquet files has made it a valuable component in open-source projects within the Hadoop ecosystem. Moreover, Apache Drill's ability to provide insights into customer buying patterns and behavior has assisted businesses with product positioning and service optimization.

The flexibility of Apache Drill's data model allows users to query any type of data from almost any type of source, making it a preferred choice for those with SQL knowledge when working with NoSQL databases. With support for additional engines and data sources compared to its competitors, Apache Drill has won over users who have tested and compared it to alternatives such as PrestoDB.

Overall, Apache Drill serves as a powerful tool that fulfills the needs of users across a range of industries for querying and analyzing diverse datasets from multiple sources effortlessly.

Accessibility: Apache Drill being an open-source tool has made it accessible to a wide range of users. Many reviewers have appreciated the fact that they can freely use the tool without any cost implications.

Easy installation: Reviewers have found the installation process for Apache Drill to be easy and straightforward. This user-friendly installation experience has been praised by many users who were able to get started with the tool quickly.

Versatility in data querying: The ability of Apache Drill to query a large amount of data from any source by enabling plugins has been seen as a valuable feature by many reviewers. This flexibility allows users to easily integrate different data sources and perform complex queries without having to learn multiple query languages.

Limitation on query capabilities: Some users have expressed dissatisfaction with the limitation of only being able to query using view and select statements in Apache Drill. They have mentioned a desire to be able to create databases and tables, which is currently not supported.

Performance issues in stand-alone mode: Several reviewers have suggested that the performance on stand-alone mode could be improved. They mention that caching layers like Trino or Presto would have been beneficial for enhancing the software's speed and efficiency.

Difficulty in quick start with single instance: Some users found the quick start with a single instance to be challenging. This initial setup process has posed difficulties for those trying to get started quickly and efficiently.

View all reviews
(1-1 of 1)

Apache Drill vs PrestoDB

Rating: 8 out of 10
Incentivized
February 13, 2018
AA
Anson Abraham
Data Loard
Envisagenics, Inc. (Marketing and Advertising, 51-200 employees)
Vetted Review
Verified User
Apache Drill
2 years of experience
View profile
Use Cases and Deployment Scope
Apache Drill was being used initially to evaluate running queries on data stored in multiple data stores (hDFS, postgres, cassandra). We were testing it out, over the use of PrestoDB. But saw that Drill also supported HBASE and other engines. it was from that aspect, used Drill to query data across the multiple datasources, as more ec2 instances were created, since some of the data was also stored in s3.
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
Likelihood to Recommend
if you're doing joins from hBASE, hdfs, cassandra and redis, then this works.
Using it as a be all end all does not suit it. This is not your straight forward magic software that works for all scenarios. One needs to determine the use case to see if Apache Drill fits the needs. 3/4 of the time, usually it does.
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
compared to presto, has more support than prestodb.
Impala has limitations to what drill can support
apache phoenix only supports for hbase. no support for cassandra.
Apache drill was chosen, because of the multiple data stores that it supports htat the other 3 do not support. Presto does not support hbase as of yet. Impala does not support query to cassandra
Other Software Used
Likelihood to Renew
7
if Presto comes up with more support (ie hbase, s3), then its strongly possible that we'll move from apache drill to prestoDB. However, Apache drill needs more configuration ease, especially when it comes to garbage collection tuning. If apache drill could support also sparkSQL and Flume, then it does change drill into being something more valuable than prestoDB
Return to navigation