Overall Satisfaction with Apache Hive
Apache Hive is being used in our company mainly for big data analysis. It has greatly helps us with data processing & analysis. It is being used across the whole organization. The business problem addressed by it is that it has been helping our organization in storing large data sets and easily accessing them.
- Querying in Apache Hive is very simple because it is very similar to SQL.
- Hive produces good ad hoc queries required for data analysis.
- Another advantage of Hive is that it is scalable.
- Apache Hive isn't designed for and doesn't support online processing of data.
- Sub queries not supported.
- Updating the data can be a problematic task.
- Installation and set up of the clusters is easy.
- Effective handling of the complex queries and large set of data.
I considered Hive because it is the best suited option when it comes to larger data access. Besides, learning HiveQL is comparatively easy.