Apache Pig vs. Azure HDInsight

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.

Incentivized

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.

Incentivized

• 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."

Incentivized

• Shows live changes in analytics. Shows you how social media is working for us. Since we promote weekly events this is something that we really need to pay attention to.
• Azure in itself is very user-friendly, HDInsight is a great addition. For our purposes, we definitely also utilized the power query to translate data to Excel.

Incentivized

• 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

Incentivized

• Had issues while using Azure ARM Templates for deployments.
• The cost structure suited for high end temporary data analytics, rather than a traditional frequently queried data warehouse.

Incentivized

It is quick, fast and easy to implement Apache Pig which makes is quite popular to be used.

Incentivized

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.

Incentivized

The documentation is adequate. I'm not sure how large of an external community there is for support.

Incentivized

Inexpert, isolated teams... not good for support an excessively complex platform. Lots of weeks or months for a complex problem troubleshoot. Many time lost stuck on MindTree, before the case was finally escalated with Microsoft!

Incentivized

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.

Incentivized

Many times you just need spark performing fast and cheap. Azure HDInsight Includes lots of features and not required software. Also its libraries and runtime versions are pritty old. But, what is great Is you don't need to have an expert in your team and things -when work- performs always in the exact same way. Also, as I mentioned, for a starter that's a great ROI.

Incentivized

• 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.

Incentivized

• ROI is of course there, as no legacy software for data presentation.
• No manual intervention for data retrieval.
• Data is available anywhere as requested.

Incentivized