Apache Drill vs PrestoDB
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

