Item: Apache Hive
Rating: 7
Author: Verified User

Overall Satisfaction with Apache Hive

Use Cases and Deployment Scope

Our company primarily uses Apache Hive to manage our data warehouse by being able to query multiple databases. We partition our tables as well as monitor query performance on very custom data queries by using this hive. Hive is only used by our data analysts and an overseas data warehouse team with only a few shared licenses existing on our virtual machines.

Pros and Cons

Pros

Monitor query performance
Manage tables in the data warehouse
Uses standard SQL

Cons

UI is quite dated and not intuitive
Open-source, so does not have consistent updates or support
Not the most optimal for ETL processes

Return on Investment

No licensing costs
Little training needed for most users

Support Rating

Open-source software with little incentive to innovate or have consistent support to push out updates and changes to the platform

Usability

It uses standard SQL, which most architects and developers are quite familiar with writing. The user interface and general intuitiveness of navigation are very dated and will require some searching for documentation before being able to find what certain functions are able to do. Works well but is still quite slow compared to similar products such as Impala.

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?

Did implementation of Apache Hive go as expected?

Would you buy Apache Hive again?

Yes

Likelihood to Recommend

Apache Hive is well suited for organizations looking for an initial tool to begin their process of managing their data warehouse as it is open-source and relatively easy to set up. This works well with some legacy systems and many consoles support this. While Hive used to be quite revolutionary, it has fallen behind many other tools that are more performant or specialized for managing DBs, writing queries, and partitioning tables.

Comments

Please log in to join the conversation

Apache Hive: SQL, open-source querying tool