3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101
12 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

Add comparison

Likelihood to Recommend

Apache Drill

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.
Anson Abraham profile photo

Databricks Unified Analytics Platform

Databricks has helped my teams write PySpark and Spark SQL jobs and test them out before formally integrating them in Spark jobs. Through Databricks we can create parquet and JSON output files. Datamodelers and scientists who are not very good with coding can get good insight into the data using the notebooks that can be developed by the engineers.
No photo available

Feature Rating Comparison

Platform Connectivity

Apache Drill
Databricks Unified Analytics Platform
8.3
Connect to Multiple Data Sources
Apache Drill
Databricks Unified Analytics Platform
9.0
Extend Existing Data Sources
Apache Drill
Databricks Unified Analytics Platform
9.0
Automatic Data Format Detection
Apache Drill
Databricks Unified Analytics Platform
7.0

Data Exploration

Apache Drill
Databricks Unified Analytics Platform
6.0
Visualization
Apache Drill
Databricks Unified Analytics Platform
6.0
Interactive Data Analysis
Apache Drill
Databricks Unified Analytics Platform
6.0

Data Preparation

Apache Drill
Databricks Unified Analytics Platform
8.0
Interactive Data Cleaning and Enrichment
Apache Drill
Databricks Unified Analytics Platform
8.0
Data Transformations
Apache Drill
Databricks Unified Analytics Platform
9.0
Data Encryption
Apache Drill
Databricks Unified Analytics Platform
7.0
Built-in Processors
Apache Drill
Databricks Unified Analytics Platform
8.0

Platform Data Modeling

Apache Drill
Databricks Unified Analytics Platform
8.3
Multiple Model Development Languages and Tools
Apache Drill
Databricks Unified Analytics Platform
9.0
Automated Machine Learning
Apache Drill
Databricks Unified Analytics Platform
8.0
Single platform for multiple model development
Apache Drill
Databricks Unified Analytics Platform
9.0
Self-Service Model Delivery
Apache Drill
Databricks Unified Analytics Platform
7.0

Model Deployment

Apache Drill
Databricks Unified Analytics Platform
7.5
Flexible Model Publishing Options
Apache Drill
Databricks Unified Analytics Platform
7.0
Security, Governance, and Cost Controls
Apache Drill
Databricks Unified Analytics Platform
8.0

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
Anson Abraham profile photo
  • Process raw data in One Lake (S3) env to relational tables and views
  • Share notebooks with our business analysts so that they can use the queries and generate value out of the data
  • Try out PySpark and Spark SQL queries on raw data before using them in our Spark jobs
  • Modern day ETL operations made easy using Databricks. Provide access mechanism for different set of customers
No photo available

Cons

  • deployment. Not as easy
  • configuration isn't as straight forward, especially with the documentation
  • Garbage collection could be improved upon
Anson Abraham profile photo
  • Databricks should come with a fine grained access control mechanism. If I have tables or views created then access mechanism should be able to restrict access to certain tables or columns based on the logged in user
  • There should be improved graphing and dash boarding provided from within Databricks
  • Better integration with AWS could help me code jobs in Databricks and run them in AWS EMR more easily using better devops pipelines
No photo available

Likelihood to Renew

Apache Drill7.0
Based on 1 answer
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
Anson Abraham profile photo
No score
No answers yet
No answers on this topic

Usability

No score
No answers yet
No answers on this topic
Databricks Unified Analytics Platform9.0
Based on 1 answer
This has been very useful in my organization for shared notebooks, integrated data pipeline automation and data sources integrations. Integration with AWS is seamless. Non tech users can easily learn how to use Databricks. You can have your company LDAP connect to it for login based access controls to some extent
No photo available

Alternatives Considered

compared to presto, has more support than prestodb.Impala has limitations to what drill can supportapache 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
Anson Abraham profile photo
Databricks was picked among other competitors. Closest competition in our organization was H2O.ai and Databricks came out to be more useful for ROI and time to market in our internal research.We could have used AWS products, however Databricks notebooks and ability to launch clusters directly from notebooks was seen as a very helpful tool for non tech users.
No photo available

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).
Anson Abraham profile photo
  • ROI for us has been tremendous. Time to market by processing raw data in our big data infrastructure has been pretty fast.
  • Non engineers can easily use Databricks, hence helping business customers.
  • Thousands of different data combinations can easily be joined and used by our data teams.
No photo available

Pricing Details

Apache Drill

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Databricks Unified Analytics Platform

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details