Hive: When SQL marries with Hadoop
September 20, 2020
Hive: When SQL marries with Hadoop
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with Apache Hive
Hive plays a vital role in our company, together with Hadoop storage. It makes the query and aggregation much easier for old DBA background data analyst, while still benefiting a lot from the performance boost brought by Hadoop. It makes big data analysis more feasible and close to the daily business context.
- The SQL, like query interface, is the core value and shining core of the Hive.
- It supports various data formats stored and also allows indexing.
- It is fast.
- No transaction support.
- No sub-query support.
- Can only deal with the cold data (non-real time).
- It exposes the distributed calculation world (Hadoop) to the users but doesn't require the user to have the in-depth understanding of boilerplate details, it reduces the time of learning and let the data analyst can focus their efforts on the core business.
Apache Hive decouples the query layer from the storage layer, it is more flexible and expandable.
Do you think Apache Hive delivers good value for the price?
Yes
Are you happy with Apache Hive's feature set?
Yes
Did Apache Hive live up to sales and marketing promises?
I wasn't involved with the selection/purchase process
Did implementation of Apache Hive go as expected?
Yes
Would you buy Apache Hive again?
Yes