Data warehouse made simple, yet powerful!
October 07, 2020

Data warehouse made simple, yet powerful!

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

Overall Satisfaction with Apache Hive

We are using Apache Hive in our whole company as the main data warehouse software solution covering all needed data warehousing tasks. It is being used to interact with huge datasets located in a distributed storage. Since we are using a variety of data formats Apache Hive enables us to query anything with unified SQL syntax.
  • Gives access to files stored in a variety of data storage systems
  • Facilitates ETL operations, reporting and data analysis
  • Supports queries expressed in a declarative language very similar to SQL
  • Not suitable for for online transaction processing workloads
  • Much more complicated than any typical RDBMS
  • Licensing model based on Apache License 2.0
  • We were able to achieve huge speed-up in the area of data insertion.
  • Data replication for disaster recovery is finally working for our customers.
From my experience Apache Hive is the easiest for database admins and experts to learn due to similarities between SQL and HiveQL, which makes it the best choice for majority of customers. The remaining platforms are more hard to use and are targeted mainly towards programmers, which are able to fully utilize features available only via programmable APIs.
Since Apache Hive is an open source, community developed project the easiest way to get help is to reach out to issue tracker or mailing list. The response we got from there was always very quick and answers were usually relevant. Another great way to solve issues is an easily accessible version control system with well documented source code.
Thanks to its high usability Apache Hive enables users to craft extensive queries really efficiently and at the same time to how to hold response times very low. HiveQL simplicity makes it super easy to manage large datasets, what was almost an impossible task before introduction of Apache Hive data warehousing platform in our company.

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

Apache Hive fits perfectly if scalability, performance and fault-tolerance are essential for your data warehousing needs. If you are required to process batch jobs Apache Hive will keep your customers happy. On the other hand, if you are working with web logs data and append-only flat-file type of data, then there are better solutions on the market.