Apache Pig vs. Hortonworks Data Platform

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Pig
Score 8.4 out of 10
N/A
Apache Pig is a programming tool for creating MapReduce programs used in Hadoop.N/A
Hortonworks Data Platform
Score 5.0 out of 10
N/A
Hortonworks Data Platform (HDP) is an open source framework for distributed storage and processing of large, multi-source data sets. HDP modernizes IT infrastructure and keeps data secure—in the cloud or on-premises—while helping to drive new revenue streams, improve customer experience, and control costs. Hortonworks merged with Cloudera in eary 2019.N/A
Pricing
Apache PigHortonworks Data Platform
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache PigHortonworks Data Platform
Free Trial
NoNo
Free/Freemium Version
YesNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Apache PigHortonworks Data Platform
Considered Both Products
Apache Pig
Chose Apache Pig
Apache Hadoop, Azure Data Lake Storage, Amazon EMR (Elastic MapReduce), Presto (formerly Presto DB), Confluent Platform and Alteryx
Chose Apache Pig
It takes me less time to write a Pig script than get a Spark program running for batch ETL workloads. Compared to Spark, Pig has a steeper learning curve because it employs a proprietary programming language. In one script and one fine, it can handle both Map Reduce and Hadoop. …
Chose Apache Pig
It can accommodate Map Reduce in a single script and a single fine. IT has very much documentation present for easy learning. SQL like queries makes it easy to understand
Chose Apache Pig
Apache Pig might help to start things faster at first and it was one of the best tool years back but it lacks important features that are needed in the data engineering world right now. Pig also has a steeper learning curve since it uses a proprietary language compared to Spark …
Chose Apache Pig
Pig is more focused on scripting in its own PigLatin language rather than integrate into another language like Java/Scala/Python/SQL.
However, for batch ETL workloads, I find that I can write a Pig script quicker than setting up and deploying a Spark program, for example.
Chose Apache Pig
Apache Pig is picked up quickly and can be implemented with very little coding skills. Also the other languages require exact matching of versions during installations which made them somewhat less user-friendly. Also most of the tasks that are done in map reduce can be done …
Chose Apache Pig
I use both Apache Pig and its alternatives like Apache Spark & Apache Hive. Apache Pig was one of the best options in Big Data's initial stages. But now alternatives have taken over the market, rendering Apache Pig behind in the competition. But it is still a better alternative …
Chose Apache Pig
Early on Apache Pig was a great tool for easily writing distributed processing applications without needing to write a complete Java MapReduce job from scratch, but as time as moved on there now better alternatives to get results faster for both ad-hoc analysis and for …
Chose Apache Pig
- Provided better ways for optimized hadoop jobs than Hive but not anymore.
- Spark DSL is much more advanced and compute times are significantly less.
Hortonworks Data Platform
Chose Hortonworks Data Platform
We chose [Hortonworks Data Platform] because it's free and because [it] was an IBM partner, suggested as big data platform after biginsights platform.
You can install in more physical computer without high specs, then you can use it in order to learn how to deploy, configure a …
Chose Hortonworks Data Platform
Hortonworks Data Platform is on par with, if not better than, Cloudera or Mapr. It provides a big list of components (25-30) that you can pick and use based on your needs. It provides an easy and convenient way to add/remove any of those. It provides a good way of integrating …
Chose Hortonworks Data Platform
Cloudera has been often compared to Hortonworks. We considered the both products and decided to try Hortonworks data platform, by several reasons. One of them was pricing and technical support. Generally speaking Cloudera outperforms Hortonworks in terms of functionalities, but …
Chose Hortonworks Data Platform
There are many alternatives, but in order to provide a short list:
- Cloudera CDP is the obvious contendant or alternative, being a leader in big data platforms
- MapR
Chose Hortonworks Data Platform
Cloudera is a more mature platform. It does not require upgrades as often. However, if you need advanced capabilities, you might be lacking with the Cloudera distribution platform. Many of the other tools in the ecosystem are the same or similar. Cost might also be a factor; …
Chose Hortonworks Data Platform
With its great performance and other benefits, we eventually moved from Cloudera to the Hortonworks platform.
Chose Hortonworks Data Platform
  • Licensing cost is high when compared to other distribution partners
  • VM setup - It's not as good as what Cloudera provides
Chose Hortonworks Data Platform
While Apache Hadoop is completely open sourced, Hortonworks Data Platform offers support as well as keeps pace with the open source versions. Also, the HDP open sources its own products, thus giving back to the community. I find using the Hortonworks Data Platform more …
Chose Hortonworks Data Platform

Apache, Cloudera, MapR, and IBM.

Hortonworks Data Platform is more efficient to use than Apache since you don't need to configure everything by yourself. Again, Cloudera, MapR, and IBM is proprietary software.

Best Alternatives
Apache PigHortonworks Data Platform
Small Businesses

No answers on this topic

No answers on this topic

Medium-sized Companies
Cloudera Manager
Cloudera Manager
Score 9.9 out of 10
Cloudera Manager
Cloudera Manager
Score 9.9 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 7.1 out of 10
IBM Analytics Engine
IBM Analytics Engine
Score 7.1 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache PigHortonworks Data Platform
Likelihood to Recommend
8.2
(0 ratings)
7.0
(0 ratings)
Usability
10.0
(0 ratings)
-
(0 ratings)
Support Rating
6.0
(0 ratings)
-
(0 ratings)
Implementation Rating
-
(0 ratings)
9.0
(0 ratings)
User Testimonials
Apache PigHortonworks Data Platform
Likelihood to Recommend
Apache Pig is best suited for ETL-based data processes. It is good in performance in handling and analyzing a large amount of data. it gives faster results than any other similar tool. It is easy to implement and any user with some initial training or some prior SQL knowledge can work on it. Apache Pig is proud to have a large community base globally.
Read full review
I recommend [Hortonworks Data Platform] as Big Data platform in order to start your developments. It's free. It's easy to use. You can install in more server or use a sandbox with you favorite virtualization platform ( vmware or oracle virtualbox). There is also a containerized version.
Manage our data in hdfs is simple; you can interact with server with REST API.
Read full review
Pros
  • Iterative Development - you can write aliases/variables, which are not immediately executed and these are stored in a DAG, which is only evaluated upon dumping or storing another alias.
  • Fast execution - Works with MapReduce, Tez, or Spark execution frameworks to provide fast run times at large scales.
  • Local and remote interoperability - Scripts that depend on testing a small dataset locally before moving to the full thing can simply be done with "pig -x local."
Read full review
  • It is a well suited data platform to support big data storage and analysis, with computational efficiency, good performance, and stability.
  • It is free to use. Online development community is well supported. Hortonworks engineers seem to have good experience and skill sets.
  • It is easy and fast to integrate with other tools or components for big data handling and analysis.
Read full review
Cons
  • May not fit every need and a SQL-like abstraction may be more effective for some tasks (look at Spark-SQL, Hive, or even an actual DBMS)
  • All Pig jobs are written in a Domain Specific Language so not a lot of transferable knowledge
  • Writing your own User Defined Functions (UDFS) is a nice feature but can be painful to implement in practice
Read full review
  • As an open source project collection, it relies strongly on community activity. You still have the option to contract premium consulting or training services.
  • Altough it is quickly evolving into Data Science tools availability (eg. Tensorflow incorporate in HDP 3), it can be cumbersome from a developer transitioning from a traditional IDE, into the notebook vs. datalake metaphore.
  • As expected for a big data infranstructure, the resource requirements base line is rather high. This means that if used on premise, you need to think of about 10 machines for a minimal reasonable deploy.
Read full review
Usability
It is quick, fast and easy to implement Apache Pig which makes is quite popular to be used.
Read full review
No answers on this topic
Support Rating
The documentation is adequate. I'm not sure how large of an external community there is for support.
Read full review
No answers on this topic
Implementation Rating
No answers on this topic
Try not to change variable names.
Read full review
Alternatives Considered
It takes me less time to write a Pig script than get a Spark program running for batch ETL workloads. Compared to Spark, Pig has a steeper learning curve because it employs a proprietary programming language. In one script and one fine, it can handle both Map Reduce and Hadoop. It has a large amount of documentation available to make learning more convenient.
Read full review
While Apache Hadoop is completely open sourced, Hortonworks Data Platform offers support as well as keeps pace with the open source versions. Also, the HDP open sources its own products, thus giving back to the community. I find using the Hortonworks Data Platform more intuitive than Cloudera or MapR versions.
Read full review
Return on Investment
  • Return on Investments are significant considering what it can do with traditional analysis techniques. But, other alternatives like Apache Spark, Hive being more efficient, it is hard to stick to Apache Pig.
  • It can handle large datasets pretty easily compared to SQL. But, again, alternatives are more efficient.
  • While working on unstructured, decentralized dataset, Pig is highly beneficial, as it is not a complete deviation from SQL, but it does not take you in complexity MapReduce as well.
Read full review
  • It provides a convenient way of quickly setting up a big data environment, easily setting up clusters with different configurations. It provides several security architectures that can be used as well. Since it provides a big list of components and packaged together, it is a great tool for companies to get set and utilize it for their use cases.
  • Since it uses Ambari extensively to install, upgrade and manage software, it is very convenient and easy to support and operationalize the components. Alerting and notifications, ability to create custom alerts give you the capability to add any number of alerts to meet your custom needs. It provides a great way to maintain other software by creating mpacks and the ability to add custom code, and you can add other software to be managed in a centralized tool.
  • The use and support of popular and useful open source software and the company's contribution to the community makes HDP a very useful tool that enables a quick, secure, easily maintainable suite of components that can help companies meet the needs of the business. What is great is that new components keep getting added based on any new useful tool that comes available, like Druid, and made available as part of the suite of components. That helps businesses keep up with new capabilities as they become available, and use them to solve their problems.
Read full review
ScreenShots