TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Apache Hive

    Score8 out of 10
    N/AApache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.N/A

    Azure Cosmos DB

    Score9.1 out of 10
    N/AMicrosoft Azure Cosmos DB is Microsoft's Big Data analysis platform. It is a NoSQL database service and is a replacement for the earlier DocumentDB NoSQL database.N/A
    Pricing
    Apache HiveAzure Cosmos DB
    Editions & Modules
    No answers on this topic
    No answers on this topic
    Offerings
    Pricing Offerings
    Apache HiveAzure Cosmos DB
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details
    More Pricing Information
    Community Pulse
    Apache HiveAzure Cosmos DB
    Considered Both Products
    Apache
    No answer on this topic
    Microsoft
    No answer on this topic
    Key User Insights
    Would buy again
    95%
    Would buy again
    18 Answers
    No answers on this topic
    Delivers good value for the price
    100%
    Delivers good value for the price
    18 Answers
    No answers on this topic
    Happy with the feature set
    100%
    Happy with the feature set
    19 Answers
    No answers on this topic
    Lived up to sales and marketing promises
    90%
    Lived up to sales and marketing promises
    9 Answers
    No answers on this topic
    Implementation went as expected
    89%
    Implementation went as expected
    17 Answers
    No answers on this topic
    Best Alternatives
    Apache HiveAzure Cosmos DB
    Small Businesses
    No answers on this topic
    No answers on this topic
    Medium-sized Companies
    Cloudera Enterprise Data Hub
    Score9 out of 10
    HBase
    Score7.3 out of 10
    Enterprises
    Oracle Exadata
    Score9.8 out of 10
    Cassandra
    Score9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Apache HiveAzure Cosmos DB
    Likelihood to Recommend
    8.0
    (35 ratings)
    10.0
    (7 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    7.6
    (4 ratings)
    Usability
    8.5
    (7 ratings)
    8.8
    (2 ratings)
    Support Rating
    7.0
    (6 ratings)
    9.2
    (2 ratings)
    User Testimonials
    Apache HiveAzure Cosmos DB
    Likelihood to Recommend
    Apache
    Software work execution is on a large scale, it is good to use for new projects or organizational changes, data lineage mapping has always been dubious but this one has had good results. You can store and synchronize data from different departments, the storage process can be manual but it is best automated.
    Incentivized
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Pros
    Apache
    • Apache Hive allows use to write expressive solutions to complex problems thanks to its SQL-like syntax.
    • Relatively easy to set up and start using.
    • Very little ramp-up to start using the actual product, documentation is very thorough, there is an active community, and the code base is constantly being improved.
    Incentivized
    Read full review
    Microsoft
    • 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
    Incentivized
    Read full review
    Cons
    Apache
    • Some queries, particularly complex joins, are still quite slow and can take hours
    • Previous jobs and queries are not stored sometimes
    • Switching to Impala can sometimes be time-consuming (i.e. the system hangs, or is slow to respond).
    • Sometimes, directories and tables don't load properly which causes confusion
    Incentivized
    Read full review
    Microsoft
    • 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.
    Incentivized
    Read full review
    Likelihood to Renew
    Apache
    Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Usability
    Apache
    Hive is a very good big data analysis and ad-hoc query platform, which supports scaling also. The BI processes can be easily integrated with Hadoop via the Hive. It can deal with a much larger data set that traditional RDBMS can not. It is a "must-have" component of the big data domain.
    Incentivized
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Support Rating
    Apache
    Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.
    Incentivized
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Alternatives Considered
    Apache
    Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed. Amazon Redshift is the another product, I used in my recent organisation. Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
    Incentivized
    Read full review
    Microsoft
    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.
    Incentivized
    Read full review
    Return on Investment
    Apache
    • Apache hive is secured and scalable solution that helps in increasing the overall organization productivity.
    • Apache hive can handle and process large amount of data in a sufficient time manner.
    • It simplifies writing SQL queries, hence helping the organization as most companies use SQL for all query jobs.
    Incentivized
    Read full review
    Microsoft
    • 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
    Incentivized
    Read full review
    ScreenShots