Reliable and Cheaper one stop Data warehouse solution
December 28, 2020

Reliable and Cheaper one stop Data warehouse solution

Manjeet Singh | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Apache Hive

I have used Apache Hive in [the] last 3 companies and it's being used by the multiple departments spread across data analytics, engineering, data science and product management.
It's being used for fetching and generating all the product metrics, for fetching legal data whenever required. All the product history data is stored in it,
It's the one stop cheaper solution for storing and fetching all the analytics data
  • It is very easy to set up and start with
  • Apache Hive is a cheaper solution for data warehousing and aggregation compared to other products
  • One of the cons is the speed which is slightly lesser as compare to other enterprise solutions like BigQuery
  • Also, It needs to be maintained by the company itself
  • It's one of the top data warehouse solution
  • All the metrics computation and adhoc analysis is done using Apache Hive
Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed.
Amazon Redshift is the another product, I used in my recent organisation.
Both Redshift and BigQuery are managed solution whereas Hive needs to be managed

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?

Yes

Did implementation of Apache Hive go as expected?

Yes

Would you buy Apache Hive again?

Yes

It's fairly okay to set up and also cost is well within the pocket.
If our requirement of aggregation is within seconds for. Terabytes of data then we may have to lookup for other solutions