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 App Service

    Score8.2 out of 10
    N/AThe Microsoft Azure App Service is a PaaS that enables users to build, deploy, and scale web apps and APIs, a fully managed service with built-in infrastructure maintenance, security patching, and scaling. Includes Azure Web Apps, Azure Mobile Apps, Azure API Apps, allowing developers to use popular frameworks including .NET, .NET Core, Java, Node.js, Python, PHP, and Ruby.

    $9.49

    per month

    Pricing
    Apache HiveAzure App Service
    Editions & Modules
    No answers on this topic
    Shared Environment for dev/test
    $9.49
    per month
    Basic Dedicated environment for dev/test
    $54.75
    per month
    Standard Run production workloads
    $73
    per month
    Premium Enhanced performance and scale
    $146
    per month
    Offerings
    Pricing Offerings
    Apache HiveAzure App Service
    Free Trial
    NoYes
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details—Free and Shared (preview) plans are ideal for testing applications in a managed Azure environment. Basic, Standard and Premium plans are for production workloads and run on dedicated Virtual Machine instances. Each instance can support multiple applications and domains.
    More Pricing Information
    Community Pulse
    Apache HiveAzure App Service
    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
    82%
    Would buy again
    9 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    18 Answers
    91%
    Delivers good value for the price
    10 Answers
    Happy with the feature set
    100%
    Happy with the feature set
    19 Answers
    91%
    Happy with the feature set
    10 Answers
    Lived up to sales and marketing promises
    90%
    Lived up to sales and marketing promises
    9 Answers
    89%
    Lived up to sales and marketing promises
    8 Answers
    Implementation went as expected
    89%
    Implementation went as expected
    17 Answers
    91%
    Implementation went as expected
    10 Answers
    Features
    Apache HiveAzure App Service
    Platform-as-a-Service
    Comparison of Platform-as-a-Service features of Apache Hive and Azure App Service
    Feature
    Apache Hive
    -
    Ratings
    Azure App Service
    6.2
    7 Ratings
    22% below category average
    Ease of building user interfaces00 Ratings7.37 Ratings
    Scalability00 Ratings6.97 Ratings
    Platform management overhead00 Ratings7.37 Ratings
    Workflow engine capability00 Ratings6.35 Ratings
    Platform access control00 Ratings7.46 Ratings
    Services-enabled integration00 Ratings5.86 Ratings
    Development environment creation00 Ratings6.27 Ratings
    Development environment replication00 Ratings5.96 Ratings
    Issue monitoring and notification00 Ratings6.17 Ratings
    Issue recovery00 Ratings4.26 Ratings
    Upgrades and platform fixes00 Ratings4.76 Ratings
    Best Alternatives
    Apache HiveAzure App Service
    Small Businesses
    No answers on this topic
    IBM Cloud Foundry
    Score8.5 out of 10
    Medium-sized Companies
    Cloudera Enterprise Data Hub
    Score9 out of 10
    IBM Cloud Private
    Score9.6 out of 10
    Enterprises
    Oracle Exadata
    Score9.8 out of 10
    AWS Elastic Beanstalk
    Score8.6 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Apache HiveAzure App Service
    Likelihood to Recommend
    8.0
    (35 ratings)
    6.9
    (11 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    -
    (0 ratings)
    Usability
    8.5
    (7 ratings)
    6.5
    (3 ratings)
    Support Rating
    7.0
    (6 ratings)
    10.0
    (2 ratings)
    User Testimonials
    Apache HiveAzure App Service
    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
    You may easily deploy your apps to Azure App Service if they were written in Visual Studio IDE (typically.NET applications). With a few clicks of the mouse, you may already deploy your application to a remote server using the Visual Studio IDE. As a result of the portal's bulk and complexity, I propose Heroku for less-experienced developers.
    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
    • Extremely easy to deploy and update from Visual Studio
    • It integrates seamlessly with other Azure PaaS resources
    • It has an in-depth integration with AppInsights, so you can understand errors and their root cause easily.
    • Easy to create and delete, what is not the same case in a IaaS resource
    • It escalates based on CPU workload and some other resource variables.
    • Configuration changes are almost immediate
    • Offers an excellent abstraction from hardware backend of the platform
    • That's updated very often, saving time and the risk of a self-performed update over a IaaS
    • That's really easy to develop for Web Apps
    • It supports Function Apps and Web Apps into the same "cost black box"
    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
    • Jumps between resource sizes can get expensive
    • You may wind up putting a lot of eggs in one basket--not necessarily a con but something to keep in mind (most of your data will likely be managed and processed through Microsoft products/services if you fully commit to Azure App Service).
    • Learning new technology. If you're moving from on-premises to Azure App Service (or any cloud solutions), you'll likely have to rethink how things are done to achieve the same end results (and/or resources may become expensive quickly).
    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
    No answers on this topic
    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
    I have given this rating because Azure App Service performs very well in terms of speed, reliability, and reducing overhead, and improves overall team productivity, with a little scope for improvement in complex testing scenarios and configurations, scalability concerns in a large setup, and similar tracking and audit needs.
    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 has always been known for providing a high standard in terms of customer support and Azure App Service (and as a matter of fact the whole Azure Platform) is no exception. Azure App Service never caused us any issues and we only contacted their customer support for questions regarding server locations and pricing. I feel pretty satisfied with how they treat their customers.
    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
    When we chose it, we did so because of its integration with Microsoft applications; now we need to integrate with AI, and Azure doesn't offer a good integration. That is the main reason to change it. It is still great to develop Windows- and Microsoft-based applications, but if we need to integrate with AI, Google wins by far.
    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
    • Deployment of ASP.NET apps at the organization has been sped up.
    • An option to offer access to the version control system on a third platform so that we could easily deploy our apps.
    • Because of Azure App Service's scalability capabilities, the costs of running the services are kept to a minimum. As a result, we may save hundreds of dollars each month compared to the expenses of traditional servers by using fewer resources during slack periods.
    Incentivized
    Read full review
    ScreenShots