Hive is solid data analytical tool
June 07, 2018
Hive is solid data analytical tool
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Apache Hive
Hive is currently used in our Data Warehouse in our company. It helps us give more structure to our data and as Hive sits on top of Hadoop, the MR engine. It is a big plus when you want to run a complex query and get faster results. This helps us facilitate the Business Intelligence team to use Hive as a self-querying tool.
- It's Fast!
- You can store a different kind of data structures here other than the standard ones
- Good scalability
- Good redundancy too
- It's not as ACID compliant as an RDBMS. It's a recently added feature and still needs work.
- This is not the tool to go for online data processing.
- It does not support sub-queries.
- It can't process data in real time.
- Helps to get good data insights from a vast and complex data stored
- It's easy to learn HiveSQL
- You don't have to worry about scalability as much with Hive
I have used Storm for real-time processing, but that only addresses a few data points. But for a larger access to data, Hive is well suited.