Apache Hive: Big data querying tool w/SQL interface, but slower, more costly computation
September 21, 2020

Apache Hive: Big data querying tool w/SQL interface, but slower, more costly computation

Kristjan Gannon | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Apache Hive

We use Apache Hive to make data-driven decisions. It is used from finance to engineering to sales. It helps aggregate our massive data sets into distilled information.
  • Flexibility through schema on read
  • Familiar SQL like query language
  • Functions for complex queries and analysis
  • Slower processing than other tools on the market
  • Hive is crucial for our BI and reporting.
  • Hive costs can ramp up quickly and can cause negative ROI when implementing inefficient schemas, queries, etc.
Apache Hive is open-source, so there are a solid community and information around it for support.
HQL is a friendly SQL-based query language that provides familiarity to engineers and business analysts. Interfaces like Hue provide clean and modern tooling to ease the experience.

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

Apache Hive is useful for regularly reporting and analyzing data. In terms of ad-hoc analysis and debugging, the cycles can be quite long for querying, feedback, debugging queries, etc.