TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Apache Drill

    Score8 out of 10
    N/AApache Drill is an open-source, distributed SQL query engine for analyzing data where it already resides. It provides schema-free SQL access to files, Hadoop data, NoSQL databases, and cloud object storage, allowing users to query raw and semi-structured data without first loading it into a warehouse or defining and maintaining a fixed schema.N/A

    Hadoop

    Score7.4 out of 10
    N/AHadoop is an open source software from Apache, supporting distributed processing and data storage. Hadoop is popular for its scalability, reliability, and functionality available across commoditized hardware.N/A
    Pricing
    Apache DrillHadoop
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Apache DrillHadoop
    Free Trial
    NoNo
    Free/Freemium Version
    NoYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Apache DrillHadoop
    Considered Both Products
    Apache
    No answer on this topic
    Apache
    No answer on this topic
    Key User Insights
    Would buy again
    No answers on this topic
    100%
    Would buy again
    7 Answers
    Delivers good value for the price
    No answers on this topic
    100%
    Delivers good value for the price
    7 Answers
    Happy with the feature set
    No answers on this topic
    100%
    Happy with the feature set
    7 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    100%
    Lived up to sales and marketing promises
    6 Answers
    Implementation went as expected
    No answers on this topic
    80%
    Implementation went as expected
    4 Answers
    Best Alternatives
    Apache DrillHadoop
    Small Businesses
    IBM Cloudant
    Score7.4 out of 10
    No answers on this topic
    Medium-sized Companies
    IBM Cloudant
    Score7.4 out of 10
    Cloudera Data Hub
    Score9 out of 10
    Enterprises
    IBM Cloudant
    Score7.4 out of 10
    Cloudera Data Hub
    Score9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Apache DrillHadoop
    Likelihood to Recommend
    8.0
    (1 ratings)
    8.0
    (37 ratings)
    Likelihood to Renew
    7.0
    (1 ratings)
    9.6
    (8 ratings)
    Usability
    -
    (0 ratings)
    8.0
    (6 ratings)
    Performance
    -
    (0 ratings)
    8.0
    (1 ratings)
    Support Rating
    -
    (0 ratings)
    7.5
    (3 ratings)
    Online Training
    -
    (0 ratings)
    6.1
    (2 ratings)
    Data Sharing and Collaboration
    -
    (0 ratings)
    7.7
    (10 ratings)
    Data Sources
    -
    (0 ratings)
    8.7
    (10 ratings)
    User Testimonials
    Apache DrillHadoop
    Likelihood to Recommend
    Apache
    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.
    Incentivized
    Read full review
    Apache
    Altogether, I want to say that Apache Hadoop is well-suited to a larger and unstructured data flow like an aggregation of web traffic or even advertising. I think Apache Hadoop is great when you literally have petabytes of data that need to be stored and processed on an ongoing basis. Also, I would recommend that the software should be supplemented with a faster and interactive database for a better querying service. Lastly, it's very cost-effective so it is good to give it a shot before coming to any conclusion.
    Incentivized
    Read full review
    Pros
    Apache
    • 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
    Incentivized
    Read full review
    Apache
    • Handles large amounts of unstructured data well, for business level purposes
    • Is a good catchall because of this design, i.e. what does not fit into our vertical tables fits here.
    • Decent for large ETL pipelines and logging free-for-alls because of this, also.
    Incentivized
    Read full review
    Cons
    Apache
    • deployment. Not as easy
    • configuration isn't as straight forward, especially with the documentation
    • Garbage collection could be improved upon
    Incentivized
    Read full review
    Apache
    • Less organizational support system. Bugs need to be fixed and outside help take a long time to push updates
    • Not for small data sets
    • Data security needs to be ramped up
    • Failure in NameNode has no replication which takes a lot of time to recover
    Incentivized
    Read full review
    Likelihood to Renew
    Apache
    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
    Incentivized
    Read full review
    Apache
    Hadoop is organization-independent and can be used for various purposes ranging from archiving to reporting and can make use of economic, commodity hardware. There is also a lot of saving in terms of licensing costs - since most of the Hadoop ecosystem is available as open-source and is free
    Read full review
    Usability
    Apache
    No answers on this topic
    Apache
    As Hadoop enterprise licensed version is quite fine tuned and easy to use makes it good choice for Hadoop administrators. It’s scalability and integration with Kerberos is good option for authentication and authorisation. installation can be improved. logging can be improved so that it become easier for debugging purposes. parallel processing of data is achieved easily.
    Incentivized
    Read full review
    Support Rating
    Apache
    No answers on this topic
    Apache
    It's a great value for what you pay, and most Data Base Administrators (DBAs) can walk in and use it without substantial training. I tend to dabble on the analyst side, so querying the data I need feels like it can take forever, especially on higher traffic days like Monday.
    Incentivized
    Read full review
    Online Training
    Apache
    No answers on this topic
    Apache
    Hadoop is a complex topic and best suited for classrom training. Online training are a waste of time and money.
    Read full review
    Alternatives Considered
    Apache
    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
    Incentivized
    Read full review
    Apache
    Not used any other product than Hadoop and I don't think our company will switch to any other product, as Hadoop is providing excellent results. Our company is growing rapidly, Hadoop helps to keep up our performance and meet customer expectations. We also use HDFS which provides very high bandwidth to support MapReduce workloads.
    Incentivized
    Read full review
    Return on Investment
    Apache
    • 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).
    Incentivized
    Read full review
    Apache
    • There are many advantages of Hadoop as first it has made the management and processing of extremely colossal data very easy and has simplified the lives of so many people including me.
    • Hadoop is quite interesting due to its new and improved features plus innovative functions.
    Incentivized
    Read full review
    ScreenShots