TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Apache Pig

    Score8.4 out of 10
    N/AApache Pig is an open-source platform for processing and analyzing large datasets in distributed environments. It provides Pig Latin, a high-level dataflow language for defining transformations, and an execution layer that converts those programs into parallel processing jobs.

    $0

    Azure HDInsight

    Score8.8 out of 10
    N/AHDInsight 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
    YesNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Apache PigAzure HDInsight
    Considered Both Products
    Apache
    No answer on this topic
    Microsoft
    No answer on this topic
    Key User Insights
    Would buy again
    80%
    Would buy again
    4 Answers
    80%
    Would buy again
    4 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    5 Answers
    80%
    Delivers good value for the price
    4 Answers
    Happy with the feature set
    80%
    Happy with the feature set
    4 Answers
    80%
    Happy with the feature set
    4 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Best Alternatives
    Apache PigAzure HDInsight
    Small Businesses
    No answers on this topic
    No answers on this topic
    Medium-sized Companies
    Cloudera Data Hub
    Score9 out of 10
    Cloudera Data Hub
    Score9 out of 10
    Enterprises
    Cloudera Data Hub
    Score9 out of 10
    Cloudera Data Hub
    Score9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Apache PigAzure HDInsight
    Likelihood to Recommend
    8.2
    (9 ratings)
    4.0
    (6 ratings)
    Usability
    10.0
    (1 ratings)
    8.9
    (4 ratings)
    Support Rating
    6.0
    (1 ratings)
    1.0
    (5 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.
    Incentivized
    Read full review
    Microsoft
    Well suited: A tiny-mid sized company with no immediate plans of growing the volume of their data processing, that can afford long response times from support. Also it helps if you are not prone to put your hands on Linux and Spark configuration. In fact, it can make things go really faster if you also work with the bundle-in Jupyter. And, if you need to perform some diagnostics and / or administrative tasks, that's full of tools to find an understand the Root Cause. Ideal for non experts. Less appropriate: Big Data company, intense on demand cluster creation, mission critical, costs reduction, latest versions of libraries required, sophisticate customizations required.
    Incentivized
    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.
    Incentivized
    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.
    Incentivized
    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.
    Incentivized
    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.
    Incentivized
    Read full review
    Usability
    Apache
    It is quick, fast and easy to implement Apache Pig which makes is quite popular to be used.
    Incentivized
    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.
    Incentivized
    Read full review
    Support Rating
    Apache
    The documentation is adequate. I'm not sure how large of an external community there is for support.
    Incentivized
    Read full review
    Microsoft
    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
    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.
    Incentivized
    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.
    Incentivized
    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.
    Incentivized
    Read full review
    Microsoft
    • 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
    Read full review
    ScreenShots