Apache Hive vs. Cloudera Enterprise Data Hub

Apache Hive shines for ad-hoc analysis and plugging into BI tools. Its SQL-like syntax allows for ease of use not for only for engineers but also for data analysts. Through our experience, there are probably more desirable tools to use if you are planning on integrating Hive into your processing pipeline.

Incentivized

Cloudera is critical for constructing an organizational data center
while maximizing the value of that volume of data.



Cloudera is great for comprehending data and querying for valuable
replies.



Cloudera supports data transfer from a variety of external databases and
third-party platforms.

Incentivized

• Hive syntax is almost like SQL, so for someone already familiar with SQL it takes almost no effort to pick up Hive.
• To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format.
• Simplifies your experience with Hadoop especially for non-technical/coding partners.

Incentivized

• One of the oldest distributors of enterprise standard Hadoop.
• Distribution is based on open source Hadoop even though customizations are done on top of that.
• Faster updates and bug fixes to the products as they have Apache committers.
• Central configuration and control of your Hadoop platform (but still needs improvements).

Incentivized

• Use Hive for analytical work loads. Write once and read many scenarios. Do not prefer updates and deletes.
• Behind scenes Hive creates map reduce jobs. Hive performance is slow compared to Apache Spark.
• Map reduce writes the intermediate outputs to dial whereas Spark operates in in-memory and uses DAG.

Incentivized

• Not fully Open Source, couple of components of the distributions are privately owned, meaning with public contributions are not welcome
• Improvements to Cloudera manager can only be recommended. its very hard to get it done once recommended as the full control is with them.
• Should make components more aligned to Open Source rather than making it closed sourced.
• Custom Features of open source software tools supported only by Cloudera are tricky. Cant commit changes to tools like Hue.
• Improvements to Cluster Management tool is required, which are already available to its competitors.

Incentivized

Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.

Likely to renew the use in case the requirements for Cloudera remain valid. The rapid change in customer requirements and solutions that must be validated, integrated or tested changes. As the maturity of the solution increases, the requirements to renew use decrease. From a solution feature perspective by itself would probably grade 10.

Hive is a very good big data analysis and ad-hoc query platform, which supports scaling also. The BI processes can be easily integrated with Hadoop via the Hive. It can deal with a much larger data set that traditional RDBMS can not. It is a "must-have" component of the big data domain.

Incentivized

Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.

Incentivized

We have used a simple but necessary function such as merging certain data tables, which although they may be from different areas, complement each other or are necessary, you can use metadata if what you need is to validate the origin of your information and what impact it has, is also feasible.

Incentivized

Cloudera is a
great choice because it provides fast streaming data for tracking, breaks down
silos by providing unified self-service platforms for data-driven insights,
secures machine learning, AI solutions, and stores self-service data, enabling
our analysts to concentrate on more important tasks like displaying critical
information.

Incentivized

• Good ROI for being able to access data easily across the network, we have large amounts of data and this is a good system to access it
• Good ROI for being easy to learn how to use for new employees, not much time spent which saves costs
• Good ROI for being able to integrate with Spark and other applications, hence data can be analyzed through programs

Incentivized

• Cloudera products are the most widely. It is more business friendly as data is more secure. The sensitive data that you operate on is local to you and your project rather than processing this data on Cloud.
• Cloudera is definitely faster as wait time is reduced if on Cloud.
• A lot range of products are covered. So it is definitely good for businesses and had good returns on investments.