Item: Apache Hive
Rating: 8
Author: Verified User

Overall Satisfaction with Apache Hive

Use Cases and Deployment Scope

Apache Hive is primarily used by data analysts and data engineers at our company. We store most of our data in Hadoop and Apache Hive allows us to access the data faster than by writing MapReduce jobs.

Pros and Cons

Pros

Faster than writing MapReduce or scalding jobs to access data in Hadoop.
Syntax is essentially the same as that of SQL, making the barriers for entry to start using data low.

Cons

Apache Hive can be quite slow and is not suitable for interactive querying. Simple queries will take many minutes and more complex queries can take a very long time to finish running.

Return on Investment

Faster turnaround time for data asks that require access to data stored in Hadoop
Less overhead in training to learn MapReduce/Scala when trying to access data in Hadoop

Alternatives Considered

Presto

Presto is slightly less reliable but much faster for interactive querying. These tools would not be replacements for each other, but rather complements.

Likelihood to Recommend

Apache Hive is suitable for allowing easy access to data stored in Hadoop via a familiar SQL syntax. It is more suitable for one-off data pulls and less suitable for interactive querying due to its speed. For a better interactive querying experience, a solution like Presto would be more suitable.

Comments

Please log in to join the conversation

Easy access to data in Hadoop