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.
Read full review Like any NoSQL database, whether it's
MongoDB or not, it's best suited for unstructured data. It's also well suited for storing raw data before processing it and performing any type of ETL on the data.
Read full review 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 Read full review Scalable Instantly and automatically serverless database for any large scale business. Quick access and response to data queries due to high speed in reading and writing data Create a powerful digital experience for your customers with real-time offers and agile access to DB with super-fast analysis and comparison for best recommendation Read full review Cons deployment. Not as easy configuration isn't as straight forward, especially with the documentation Garbage collection could be improved upon Read full review Expensive, so be careful of the use case. We had a thought time migrating from traditional DBs to Cosmos. Azure should provide a seamless platform for the migration of data from on-premises to cloud. Read full review Likelihood to Renew 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
Read full review It's efficient, easy to scale, and works. We do have to do a bit of administration, but less now than when we started with this a couple of years ago. Microsoft continues to improve its self-management capability.
Read full review Usability It has very good compatibility and adaptability with other APIs and developers can safely create new apps because it is compatible with various tools and can be easily managed and run under the cloud, and in terms of security, it is one of the best of its kind, which is very powerful and excellent.
Read full review Support Rating Microsoft is the best when it comes to after-sales support. They have a well-structured training and knowledge base portal that anyone can use. They are usually quick to respond to cases and are on point for on-call support. I have no complaints from a support standpoint. Pretty happy with the support.
Read full review Alternatives Considered 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
Read full review Cosmos DB is unique in the industry as a true multi-model, cloud-native database engine that comes with solutions for geo-redundancy, multi-master writes, (globally!) low latency, and cost-effective hosting built in . I've yet to see anything else that even comes close to the power that Cosmos DB packs into its solution. The simplicity and tooling support are nice bonus features as well.
Read full review 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). Read full review It's made managing raw data much easier It provides a way to maintain raw data at a low cost It's easy to massage the data Read full review ScreenShots