--- description: Discover the benefits and disadvantages of Apache Hive. Learn the software price, see the description, and read the most helpful reviews for UK business users. image: https://gdm-localsites-assets-gfprod.imgix.net/images/capterra/og_logo-e5a8c001ed0bd1bb922639230fcea71a.png?auto=format%2Cenhance%2Ccompress title: Apache Hive Pricing, Cost & Reviews - Capterra UK 2026 --- Breadcrumb: [Home](/) > [ETL Tools](/directory/31099/etl/software) > [Apache Hive](/software/170238/apache-hive) # Apache Hive Canonical: https://www.capterra.co.uk/software/170238/apache-hive Page: 1 / 2\ Next: [Next page](https://www.capterra.co.uk/software/170238/apache-hive?page=2) > ETL solution that allows users to execute query to large datasets, located in Hadoop, aggregate it, and provide analysis of data. > > Verdict: Rated **4.2/5** by 17 users. Top-rated for **Likelihood to recommend**. ----- ## Quick Stats & Ratings | Metric | Rating | Detail | | **Overall** | **4.2/5** | 17 Reviews | | Ease of Use | 4.1/5 | Based on overall reviews | | Customer Support | 4.2/5 | Based on overall reviews | | Value for Money | 4.5/5 | Based on overall reviews | | Features | 4.0/5 | Based on overall reviews | | Recommendation percentage | 70% | (7/10 Likelihood to recommend) | ## About the vendor - **Company**: Apache Software Foundation - **Founded**: 2011 ## Commercial Context - **Pricing model**: Per Feature - **Target Audience**: 1,001–5,000, 5,001–10,000, 10,000+ - **Available Countries**: Germany ## Category - [ETL Tools](https://www.capterra.co.uk/directory/31099/etl/software) ## Alternatives 1. [Cloudiway](https://www.capterra.co.uk/software/172428/cloudiway) — 4.8/5 (125 reviews) 2. [Talend Open Studio](https://www.capterra.co.uk/software/1025397/talend-open-studio) — 4.6/5 (14 reviews) 3. [Kdetools](https://www.capterra.co.uk/software/179670/kdetools) — 1.0/5 (1 reviews) 4. [Ab Initio](https://www.capterra.co.uk/software/1016838/ab-initio) — 5.0/5 (1 reviews) ## Reviews ### "Hive is the goldmine for data enthusiasts" — 5.0/5 > **Vidya** | *27 April 2025* | Information Technology & Services | Recommendation rating: 9.0/10 > > **Pros**: Hive is a great capable data warehouse tool for data analysis and performing etl transformations at large scale > > **Cons**: Hive processing is not very efficient in producing faster runs in line with other emerging tools like spark > > Overall Hive emerged as a great query engine with distributed processing and very capable for data analytics ----- ### "SQL approach of processing data from a distributed file system" — 4.0/5 > **Monish** | *20 April 2020* | Computer Software | Recommendation rating: 8.0/10 > > **Pros**: Data on a distributed filesystem such as HDFS or S3 can be used directly for processing and modified using SQL with the help of HIVE, No need for writing complex java programs for executing map reduce, HIVE as implemented a SQL way of executing Map Reduce job's Hive has many configuration queries which increases the scope of optimisation for the under ling MR jobs, example sort mb , parallelism, number of reducers, size per reducer etc ... Hive tables data are always stores on files, even if its not a external table, these files can be directly used as a input for a MR job HIVE sql syntaxes are quit similar to that of mysql, HIVE provides good java libraries, such as sqoop which helps data table schema and data transfer from DB to HIVE etc ... > > **Cons**: HIVE queries are comparatively slower than the native DB's such as mysql, snowflake or psql, meta data's and caching can be maintained to improve the performances > > I am having a Good Experience, Hive Has been a great help to the big data world, performance is the only problem which is reasonable since it has to deal with distributed file system ----- ### "Review on Apache Hive" — 3.0/5 > **Mallikarjuna** | *12 September 2020* | Information Technology & Services | Recommendation rating: 2.0/10 > > **Pros**: As a user I would pass some good things about hive it’s interface for Hadoop and it’s interfaces to different databases along with file system and we can integrate relation between file to file too > > **Cons**: It’s very flexible and good at performance while load data from larger files and it’s good interface between homo and heterogeneous databases > > I would strongly recommend to all to use and get an experience with this software ----- ### "A useful Data Warehouse for all the BigData enthusiasts" — 4.0/5 > **Verified Reviewer** | *14 February 2023* | Information Technology & Services | Recommendation rating: 7.0/10 > > **Pros**: It is simple to use as it really feels like a Database with its SQL like framework that easily parses queries behind the scenes into Mapreduce capable of supporting both internal and external data tables. It assins data to the machines in a cluster for faster performance with fault-tolerant capability to protect data at all cost. > > **Cons**: Hive looks for data in the local machine and not HDFS, so there is no direct way to transfer files/data from local machine to HDFS (need to use external application). Execution time is not so fast as it takes a long time especially when there is a usage of joins in the queries as it relies on external disc space compared to Spark that uses in-memory space leading it to be more faster than hive. When hive is restarted, all the metadata gets erased. > > Basically you can store all the data that is structured in Hive built on top of Hadoop, that enables to store data easily and query them using SQL ----- ### "The Bigdata DatawareHouse that works seamlessly with Spark\!\!" — 5.0/5 > **Diego** | *21 June 2021* | Marketing & Advertising | Recommendation rating: 10.0/10 > > **Pros**: I love how easy is to integrate Apache Hive with Spark and perform SQL queries as if the tables were stored on Hadoop or S3 or GCP buckets. It is also very familiar to Spark users of tables stored on other file systems since it is based on the same storage (Hadoop HDFS) as regular Spark. And the best feature is that it is open source\!\! So, no extra cost for licensing\!\! > > **Cons**: One thing is regarding its limitation of only being able to work with structured data and only being able to query tables, but for the regular use we do on our company it is more than enough (we do not have much unstructured data anyways). > > Apache Hive has solved us the need of doing repetitive transformation over the final clean tables processed by our ETL process for all our analytical and business analytics tasks, now that we have the Data Warehouse in place we no longer have to extract summary extracts or perform any repetitive queries we did in the past, now we have designed a robust star schema with the main KPIs and calculations with all the look up tables we need and all without switching from technology or framework all in the same Apache Spark project\!\! ----- Page: 1 / 2\ Next: [Next page](https://www.capterra.co.uk/software/170238/apache-hive?page=2) ## Links - [View on Capterra](https://www.capterra.co.uk/software/170238/apache-hive) ## This page is available in the following languages | Locale | URL | | de | | | de-AT | | | de-CH | | | en | | | en-AE | | | en-AU | | | en-CA | | | en-GB | | | en-IE | | | en-IL | | | en-IN | | | en-NZ | | | en-SG | | | en-ZA | | | es | | | es-AR | | | es-CL | | | es-CO | | | es-CR | | | es-DO | | | es-EC | | | es-MX | | | es-PA | | | es-PE | | | fr | | | fr-BE | | | fr-CA | | | fr-LU | | | nl | | | nl-BE | | | pt | | | pt-PT | | ----- ## Structured Data