--- 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-08-09' 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. Great Experience. **Rating:** 2.5/5.0 stars **Reviewed by:** franco g. | Asistente jurídico, Small-Business (50 or fewer emp.) **Reviewed Date:** August 24, 2021 **What do you like best about Hive?** Hive is a data warehousing infrastructure built on top of Hadoop to provide data grouping, querying, and analysis. Apache Hive supports the analysis of large datasets stored under Hadoop's HDFS and in compatible systems like the Amazon file system. It offers a SQL-based query language called HiveQL5 with schemas to transparently read and convert queries in MapReduce, Apache Tez6, and Spark tasks. All three execution engines can run under YARN. To speed up queries, Hive provides indexes, which include bitmap indexes. **What do you dislike about Hive?** Offers many tools, has great growth potential **Recommendations to others considering Hive:** It is a software that allows you to enhance the performance of your company. **What problems is Hive solving and how is that benefiting you?** Possibility of storing metadata in an organized and easily accessible way. ### 2. One among many to do ETL **Rating:** 2.5/5.0 stars **Reviewed by:** Bharadwaj (Brad) C. | Director Of Engineering/Head of Reliability Engineering, Enterprise (> 1000 emp.) **Reviewed Date:** July 17, 2015 **What do you like best about Hive?** Hive syntax is almost like sql, so for someone already familiar with sql it takes almost no effort to pick up hive. But there are other tools that can do the same thing faster these days. Hive initially was really good to have; but more and more projects are now available to do SQL like operations on Big Data (like Drill). **What do you dislike about Hive?** Hive is comparatively slower than its competitors. Its easy to use but that comes with the cost of processing, If you are using it just for batch processing then hive is well and fine. It also does not have as rich of a scripting language. **Recommendations to others considering Hive:** Have better tools if you invest some more time/effort **What problems is Hive solving and how is that benefiting you?** In Retail, the business partners are more comfortable querying their own data instead of relying on Engineers. Hive solves one of that problems. The main purpouse of using Hive is to building reports and do analysis of data that is stored in the Hadoop file system. ### 3. Great tool for quick analyses **Rating:** 3.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?** Hive syntax is almost exactly like sql, so for someone already familiar with sql it takes almost no effort to pick up hive. It can perform a wide variety of analyses over very large sets of data and requires very little tuning if you are willing to wait a while for the results. **What do you dislike about Hive?** Hive can be a bit slow in comparison to other languages like Pig. It also does not have as rich of a scripting language. This is what makes it the second choice language for most data analysis jobs at LinkedIn. **Recommendations to others considering Hive:** I'd take a look at the user forums to see all the newest additions to Hive and I'd also consider whether your main use-case is scripting vs on-off analyses. I primarily use hive (so do many devs) to do our analyses since hive is trivially simple to use and it does pretty much everything sql will do, but it's not great for scripts and loading data into files, so if that is your use-case I'd consider looking into other options. **What problems is Hive solving and how is that benefiting you?** We are trying to mine data from massive data sets for a wide variety of purposes (debugging production issues, creating business metrics, models, and forecasts among other things). We have been able to do this very easily using our data warehouse and a combo of hive and Pig. ## 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?filters%5Bnps_score%5D%5B%5D=3§ion=pricing&secure%5Bexpires_at%5D=2026-08-13+16%3A26%3A39+-0500&secure%5Bsession_id%5D=c79a9413-ad2d-483a-98bb-5519fb03b5e8&secure%5Btoken%5D=0ce35e3597ce727a557f429409b046003c94f1190a7f7fe14ec8c35de01137ae&format=llm_user) ## Hive Features **Data Management** - Data Integration - Data Compression - Data Quality - Built-In Data Analytics - In-Database Machine Learning - Data Lake Analytics - ETL - Extract Transfer Load - Data Capture and Transfer - Real-Time Analytics - Reporting/Analytics **Integration** - BI Tool Integration **Deployment** - On-Premise - Cloud **Performance ** - Scalability **Security** - Data Governance - Data Security **Generative AI** - AI Text Generation - AI Text Summarization - Generative AI **Additional Functionality** - Parallel Processing - Ad hoc Analysis - Multiple Data Sources - API - In-Database Processing - Monitoring - Real-Time Reporting - Data Synchronization - Real-Time Monitoring - Data Connectors - Performance Metrics - Ad hoc Reporting - Alerts/Notifications - Access Controls/Permissions - Drag & Drop - Data Visualization - Data Import/Export - Match & Merge - Data Transformation - Secure Data Storage - Data Extraction - AI Copilot - Customizable Reports - Activity Dashboard - Data Migration - In-Memory Processing - Data Mapping ## Top Hive Alternatives - [Snowflake](https://www.g2.com/products/snowflake/reviews) - 4.6/5.0 (714 reviews) - [Google Cloud BigQuery](https://www.g2.com/products/google-cloud-bigquery/reviews) - 4.5/5.0 (1,145 reviews) - [Teradata Autonomous Knowledge Platform](https://www.g2.com/products/teradata-autonomous-knowledge-platform/reviews) - 4.3/5.0 (356 reviews)