Hive, last generation tooling but revolutionary for it's time.
September 16, 2016

Hive, last generation tooling but revolutionary for it's time.

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

Overall Satisfaction with Apache Hive

Hive was once a part of our platform but it never lived up to the promise of performant SQL on HDFS and thus was only truly useful for the users who didn't have the expertise or time to write MapReduce. With the advent of Spark, Hive's time is numbered and I would not invest in learning it specifically but instead use SparkSQL which has some of the better parts of Hive under the covers along with Spark's better execution engine.
  • Connect BI tools to non relational data stores
  • Simplify writing legacy MapReduce
  • Speed needs to be a lot better
  • Concurrency is not up to snuff
  • Helped ease BI tool connectivity to my NoSQL database
  • SparkSQL, Tez and Impala
All are improvements over the Hive tooling and are very much inspired by Hive. Hive was selected before they were on the market.
Hive is mostly useful in HDFS environments where legacy BI tools need to access the data. This is ok if there is a low concurrency of users but will fall over with any significant multi-user environment.