--- title: Hive Reviews meta_title: 'Hive Reviews 2026: Details, Pricing, & Features | G2' meta_description: Filter 60 reviews by the users' company size, role or industry to find out how Hive works for a business like yours. aggregate_rating: rating_value: 4.2 review_count: 60 scale: '5' date_modified: '2026-06-22' parent_category: name: IT Infrastructure url: https://www.g2.com/categories/it-infrastructure --- # Hive Reviews **Vendor:** The Apache Software Foundation **Category:** [Data Warehouse Solutions](https://www.g2.com/categories/data-warehouse) **Average Rating:** 4.2/5.0 **Total Reviews:** 60 ## About Hive Hive provides a mechanism to project structure onto this data and query the data using a SQL-like language called HiveQL. At the same time this language also allows traditional map/reduce programmers to plug in their custom mappers and reducers when it is inconvenient or inefficient to express this logic in HiveQL. ## Hive Reviews ### 1. Query Language for Hadoop **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Higher Education | Enterprise (> 1000 emp.) **Reviewed Date:** April 24, 2015 **What do you like best about Hive?** Hadoop does not have native query language, but Hive is a great addition to use on top of hadoop. I could point to a data stored in hadoop to a specific table and could use normal queries like I usually do in SQL. We can join and do aggregations etc. Makes life pretty simple. **What do you dislike about Hive?** It can be very slow as it runs on map reduce jobs underneath. Data cannot be updated but we will have to do a rewrite. **Recommendations to others considering Hive:** If you want SQL like data queries in Hadoop and big data, Hive is the way to go. **What problems is Hive solving and how is that benefiting you?** For people who are used to write SQL queries would have a very good time using Hive on top of hadoop for files stored in HDFS. ### 2. Hive Review **Rating:** 4.0/5.0 stars **Reviewed by:** Puneet S. | Software Engineer II, Internet, Enterprise (> 1000 emp.) **Reviewed Date:** April 07, 2015 **What do you like best about Hive?** -> Easy to configure/create a table for Big data or Streaming data -> Fast and easy to Query. Business/non-technical folks can use HUE for more interactive Querying on Hive tables -> HUE can have saved results and old queries along with exporting results in Excell.CSV **What do you dislike about Hive?** -> Joining and parsing multiple tables with huge sizes still remain a challenge. -> Some of SQL operations doesn't work in hive like non equality joins, **What problems is Hive solving and how is that benefiting you?** Dumping Site activity Big Data streaming data as well as data logs in Hive ### 3. Makes it easy to query large datasets **Rating:** 5.0/5.0 stars **Reviewed by:** Jiahong Z. | Senior Software Engineer, Internet, Enterprise (> 1000 emp.) **Reviewed Date:** July 08, 2015 **What do you like best about Hive?** The SQL-like syntax makes it easy to use **What do you dislike about Hive?** Its reliance on mapreduce makes it sometimes very slow even for a simple task **What problems is Hive solving and how is that benefiting you?** Run specific queries on hadoop files ### 4. Hive Review **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Education Management | Mid-Market (51-1000 emp.) **Reviewed Date:** April 02, 2015 **What do you like best about Hive?** Apache Hive is a tool built on top of Hadoop for analyzing large, unstructured data sets. Most BI and SQL developer tools can connect to Hive as easily as to any other database. **What do you dislike about Hive?** Unable to cancel a running query. Query tuning is difficult compared to RDBMS **What problems is Hive solving and how is that benefiting you?** We had a requiement to scan a large dataset for our predection algorithm. Initially we used RDBMS but the performace was very slow and user where not happy with it. We replaced RDBMS with the Hive and we are able to see a drastic improvment in the performance. ### 5. Great experience! **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** July 14, 2015 **What do you like best about Hive?** The progression of features, speed, etc brings me the strategic confidence I need in the SQL in hadoop space. **What do you dislike about Hive?** At this point, everything is on pint & theories it is great in hive 1.2 **What problems is Hive solving and how is that benefiting you?** Deriving value from masses of unstructured & structured data. ### 6. Used Hive for a Hadoop project **Rating:** 4.5/5.0 stars **Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.) **Reviewed Date:** July 08, 2015 **What do you like best about Hive?** Hive has a simple and intuitive interface and gets the job done. **What do you dislike about Hive?** So far Hive has met and exceeded all my expectations. **What problems is Hive solving and how is that benefiting you?** Working on a Hadoop system to determine recruiters that are spamming members too much. ### 7. SQL-like syntax makes it easy to use. **Rating:** 4.0/5.0 stars **Reviewed by:** Verified User in Internet | Enterprise (> 1000 emp.) **Reviewed Date:** July 08, 2015 **What do you like best about Hive?** The best part is being able to use a familiar syntax. **What do you dislike about Hive?** Doesn't support all MYSQL use-cases (understandably). **What problems is Hive solving and how is that benefiting you?** Ad-hoc queries on ETL'd production data. ### 8. Hive makes query on HDFS much easier, but not optimized nor fast enough **Rating:** 3.5/5.0 stars **Reviewed by:** Verified User in Computer Software | Mid-Market (51-1000 emp.) **Reviewed Date:** March 29, 2015 **What do you like best about Hive?** Hive can tell us the detailed progress of a query, and can incorporate UDFs in different languages **What do you dislike about Hive?** The query speed is way to slow, and it does not support positional arguments in GROUP BY and ORDER BY **Recommendations to others considering Hive:** Speed, speed, speed **What problems is Hive solving and how is that benefiting you?** We use Hive to run our nightly workflows on HDFS in batch for data aggregation and analysis. ### 9. A Great Way to Put Structure on Your Unstructured Data **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** May 14, 2014 **What do you like best about Hive?** If you know SQL you will be able to get Hive really quickly. Lots of the same functionality but not exactly SQL. Easy to create tables and start writing queries allowing you to dive deeper into your data. **What do you dislike about Hive?** As with all Hadoop tools lots of knobs to tweak. Takes a good bit of time optimize and finely tune your Hive install. **Recommendations to others considering Hive:** If you need to build a data warehouse on lots of data and don't want to pay for the likes of terradata or sql server, Hive is your tool. **What problems is Hive solving and how is that benefiting you?** Putting structure on unstructured. Once we chose hive to accomplish the aforementioned task we were able to bring our data to our data scientists quickly. An easier degree of acceptance to the Big Data idea. ### 10. best for batch processing **Rating:** 5.0/5.0 stars **Reviewed by:** Verified User in Information Technology and Services | Enterprise (> 1000 emp.) **Reviewed Date:** October 15, 2014 **What do you like best about Hive?** hiveql is more like SQL and really easy to learn **What do you dislike about Hive?** doesnt work good if you want a low latency queries **What problems is Hive solving and how is that benefiting you?** performance for 1TB of data ## Hive Discussions - [What is Hive workflow?](https://www.g2.com/discussions/what-is-hive-workflow) - [What is the Hive platform?](https://www.g2.com/discussions/what-is-the-hive-platform) - [How do I use Hive software?](https://www.g2.com/discussions/how-do-i-use-hive-software) - [What does hive software do?](https://www.g2.com/discussions/what-does-hive-software-do) - [How does this compare to other SQL-like languages?](https://www.g2.com/discussions/how-does-this-compare-to-other-sql-like-languages) - 1 upvote - [View Hive pricing details and edition comparison](https://www.g2.com/products/hive/reviews?page=2§ion=pricing&secure%5Bexpires_at%5D=2026-06-27+02%3A27%3A37+-0500&secure%5Bsession_id%5D=0dff9895-4547-4ba2-be58-049205883fac&secure%5Btoken%5D=489a261e61fc9559d7d085fd59c8754864bb723be99c12684a4c3138dd992a0e&format=llm_user) ## Hive Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics **Integration** - BI Tool Integration **Deployment** - On-Premise - Cloud **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization ## Top Hive Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.5/5.0 (707 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,147 reviews) - [Teradata Autonomous Knowledge Platform](https://www.g2.com/products/teradata-autonomous-knowledge-platform/reviews) - 4.3/5.0 (355 reviews)