Apache Drill is a schema-free query engine for use with NoSQL or Hadoop data or file storage systems and databases.
N/A
HPE Data Fabric
Score 9.4 out of 10
N/A
HPE Data Fabric (formerly MapR, acquired by HPE in 2019) is a software-defined datastore and file system that simplifies data management and analytics by unifying data across core, edge, and multicloud sources into a single platform.
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.
Hortonworks and Cloudera are both sort of hacky. We have to do a lot of extra steps to automate those two. MapR has far fewer issues and doesn't force you into a once size fits all deployment scenario. There are multiple ways to deploy and some are more amenable to automation, …
When we were shopping, Mapr had the momentum, high availability even on Hadoop 1.x, an improved file system and better a central control system. Now it looks like the situation has changed a lot.
We supported all three Hadoop vendors with our Hadoop RDBMS product. Here's how I see the commercial Hadoop distribution world. If you need raw performance and don't mind proprietary technology, go with MapR. If you care about the most pure open source, go with Hortonworks. If …
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.
If you need Hadoop and just need raw speed for I/O and have a Hadoop savvy group of engineers who don't need/like web UIs, then MapR is a great fit for you. If you are new to Hadoop or have DevOps folks that are not Hadoop gurus, choosing MapR as your Hadoop vendor will have a steeper learning curve as you will need to do more training and build more admin consoles for them.
I think MapR's main problem is name recognition. Hortonworks and Cloudera both are big names in the industry, but their deployment mechanisms are a little more difficult to use, especially when trying to fully automate it's deployment.
Documentation could always be better. But really, if that's your main weakness, it's everybody's weakness.
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
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
Hortonworks and Cloudera are both sort of hacky. We have to do a lot of extra steps to automate those two. MapR has far fewer issues and doesn't force you into a once size fits all deployment scenario. There are multiple ways to deploy and some are more amenable to automation, MapR just has that in spades