TrustRadius: an HG Insights company

Apache Hive Reviews & Insights

Score8 out of 10

95 Reviews and Ratings

Community insights

TrustRadius Insights for Apache Hive are summaries of user sentiment data from TrustRadius reviews and, when necessary, third party data sources.

Business Problems Solved

Apache Hive is a versatile software that has been widely used across various departments and organizations for different use cases. It has proven to be particularly helpful in handling large datasets, migrating data between different operating systems, synchronizing programs, and fetching and generating product metrics. Users have found value in using Hive for data analytics, engineering, data science, product management, and IT-related tasks such as improving analysis of big datasets stored in Hadoop HDFS.

Furthermore, Apache Hive has simplified the process of filtering and cleaning data using SQL, reducing the learning curve for handling big data. It allows users to run SQL queries against data in Hadoop, enabling efficient analysis of large datasets without the need to learn a new language. Additionally, Hive has been utilized for building reports, analyzing data stored in the Hadoop file system, processing events gathered in HDFS, and converting them into parquet files for fast querying.

Overall, users have praised Apache Hive for its scalability, accessibility, and cost-effectiveness in storing and retrieving analytics data. It has provided an intuitive solution for storing large datasets, querying big sets of data using SQL, aggregating massive datasets into distilled information for data-driven decision making, and creating external and internal tables in Hadoop/BigData projects. With its ability to process both unstructured and structured data efficiently, Hive has become an essential tool for data analysts, engineers, and business analysts across organizations.

Apache Hive Reviews

1 Review
Small Businesses (1-50 employees)

Hive, a very powerful open source data warehouse solution.

Rating: 10 out of 10

Use Cases and Deployment Scope

Hive is used by data team to store the largest datasets of the company. Data is partitioned in Hive and can be queried by Impala.

Pros

  • Partition to increase query efficiency.
  • Serde to support different data storage format.
  • Integrate well with Impala and data can be queried by Impala.
  • Support of parquet compression format

Cons

  • Speed is slower compared to Impala since it uses map reduce

Likelihood to Recommend

Hive is a data warehouse and it does not allow for updates and deletions. If data needs to be updated frequently, it might not be the best storage solution for that purpose.