Item: Apache Hive
Rating: 7
Author: Kristjan Gannon

Use Cases and Deployment Scope

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.

Pros and Cons

Flexibility through schema on read
Familiar SQL like query language
Functions for complex queries and analysis

Slower processing than other tools on the market

Return on Investment

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.

Support Rating

Apache Hive is open-source, so there are a solid community and information around it for support.

Usability

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.

Key Insights

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

Other Software Used

Oracle Java SE, Gradle, Scala

Likelihood to Recommend

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.

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

Overall Satisfaction with Apache Hive