Apache Pig vs. Azure HDInsight

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
Azure HDInsight
Score 5.0 out of 10
N/A
HDInsight is an implementation of the Apache Hadoop technology stack on the Microsoft Azure cloud platform: It is based on the Hortonworks Hadoop distribution. Microsoft Azure HDInsight includes implementations of Apache Spark, HBase, Storm, Pig, Hive, Sqoop, Oozie, Ambari, etc. It also integrates with with business intelligence (BI) tools such as Power BI, Excel, SQL Server Analysis Services, and SQL Server Reporting Services.N/A
Pricing
Apache PigAzure HDInsight
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache PigAzure HDInsight
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details——
More Pricing Information
Best Alternatives
Apache PigAzure HDInsight
Small Businesses

No answers on this topic

No answers on this topic

Medium-sized Companies
Cloudera Manager
Cloudera Manager
Score 9.7 out of 10
Cloudera Manager
Cloudera Manager
Score 9.7 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 8.8 out of 10
IBM Analytics Engine
IBM Analytics Engine
Score 8.8 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache PigAzure HDInsight
Likelihood to Recommend
8.1
(9 ratings)
9.1
(5 ratings)
Usability
10.0
(1 ratings)
8.9
(4 ratings)
Support Rating
6.0
(1 ratings)
8.9
(4 ratings)
User Testimonials
Apache PigAzure HDInsight
Likelihood to Recommend
Apache
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
Microsoft
If you want to save costs and just pay for what you use, I highly recommend it. It will help you also to work with data for your reports and analytics. on the other hand I think it could be the subscription you have but high volume of data make it slow but not so much. anyway I think it's really good because it's from Microsoft which always is friendly to use it as all the suit they have.
Read full review
Pros
Apache
  • Its performance, ease of use, and simplicity in learning and deployment.
  • Using this tool, we can quickly analyze large amounts of data.
  • It's adequate for map-reducing large datasets and fully abstracted MapReduce.
Read full review
Microsoft
  • Data is presented without interfering others (IT or other dept).
  • Data is managed properly and is available for retrievable any time.
  • Legacy use of CD/DVD and Pendrive are not required.
Read full review
Cons
Apache
  • UDFS Python errors are not interpretable. Developer struggles for a very very long time if he/she gets these errors.
  • Being in early stage, it still has a small community for help in related matters.
  • It needs a lot of improvements yet. Only recently they added datetime module for time series, which is a very basic requirement.
Read full review
Microsoft
  • The only problem I have come across is when loading large volumes of data I sometimes get an error message, I assume this means something is corrupt from within. I would love a way for this to be resolved without having to start over.
Read full review
Usability
Apache
It is quick, fast and easy to implement Apache Pig which makes is quite popular to be used.
Read full review
Microsoft
Azure HDInsight is usable on the top of Azure Data Lake and gives us the benefit of analyzing large scale data workload in Hadoop. Usability and support from Microsoft are outstanding.
Read full review
Support Rating
Apache
The documentation is adequate. I'm not sure how large of an external community there is for support.
Read full review
Microsoft
I highly recommend it.
Read full review
Alternatives Considered
Apache
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 which can be coded with Python, Java.
Read full review
Microsoft
At this time I have not used any other similar products... I am open to it but Azure HDInsight and its components really work well for our organization.
Read full review
Return on Investment
Apache
  • Higher learning curve than other similar technologies so on-boarding new engineers or change ownership of Apache Pig code tends to be a bit of a headache
  • Once the language is learned and understood it can be relatively straightforward to write simple Pig scripts so development can go relatively quickly with a skilled team
  • As distributed technologies grow and improve, overall Apache Pig feels left in the dust and is more legacy code to support than something to actively develop with.
Read full review
Microsoft
  • Less implementation cost.
  • No hosting services cost.
  • Faster data retrieval.
Read full review
ScreenShots