1. Home
  2. Data Warehouse Software
  3. Apache Hive Reviews
  4. User Review of Apache Hive
Hive - SQL-like query engine for big data platform
March 01, 2018

Hive - SQL-like query engine for big data platform

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Apache Hive

Hive is not used across whole organization but used by certain teams which require querying data from our big data store infrastructure like HDFS. It provides an interface to interact with and directly query HDFS, similar to the way we do it with any relational databases. It is a powerful tool for querying big data.
  • Querying, joining and aggregating data
  • In built-in and user-defined functions
  • Speed
  • Support for other big data frameworks like Spark
  • Need better user interfaces for browsing datastores and querying
  • It saves time on development because of its SQL-like syntax
  • It makes it easy to access big data
  • It's easy to connect reporting tools to Hive and build reports on top of it
[We selected Apache Hive because] It's from apache and opensource. So it's free.
[Well suited for] Enterprises who want to create data warehouses on top of Hadoop ecosystem for reporting purpose or get summaries or aggregation from big data. In short, if you have implemented Hadoop then you need Hive.