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

    Hive

    Score9 out of 10
    N/AHive Technology offers their eponymous project management and process management application, providing integrations with many popularly used applications for productivity, cloud storage, and collaboration.

    $24

    per month per user

    Pricing
    Apache PigHive
    Editions & Modules
    No answers on this topic
    Free
    $0
    Lite
    $24
    per month per user
    Growth
    $34
    per month per user
    Pro
    $59
    per month per user
    Elite
    Contact Sales
    Offerings
    Pricing Offerings
    Apache PigHive
    Free Trial
    NoYes
    Free/Freemium Version
    YesYes
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details—A discount is offered for annual pricing.
    More Pricing Information
    Community Pulse
    Apache PigHive
    Considered Both Products
    Apache
    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. …
    Incentivized
    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
    Incentivized
    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 …
    Incentivized
    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.
    Incentivized
    Hive Technology
    No answer on this topic
    Key User Insights
    Would buy again
    80%
    Would buy again
    4 Answers
    92%
    Would buy again
    11 Answers
    Delivers good value for the price
    100%
    Delivers good value for the price
    5 Answers
    91%
    Delivers good value for the price
    10 Answers
    Happy with the feature set
    80%
    Happy with the feature set
    4 Answers
    92%
    Happy with the feature set
    11 Answers
    Lived up to sales and marketing promises
    No answers on this topic
    78%
    Lived up to sales and marketing promises
    7 Answers
    Implementation went as expected
    No answers on this topic
    75%
    Implementation went as expected
    6 Answers
    Features
    Apache PigHive
    Project Management
    Comparison of Project Management features of Apache Pig and Hive
    Feature
    Apache Pig
    -
    Ratings
    Hive
    9.1
    15 Ratings
    17% above category average
    Task Management00 Ratings9.015 Ratings
    Resource Management00 Ratings9.015 Ratings
    Gantt Charts00 Ratings10.014 Ratings
    Scheduling00 Ratings7.014 Ratings
    Workflow Automation00 Ratings9.014 Ratings
    Team Collaboration00 Ratings10.015 Ratings
    Support for Agile Methodology00 Ratings10.012 Ratings
    Support for Waterfall Methodology00 Ratings8.011 Ratings
    Document Management00 Ratings10.013 Ratings
    Email integration00 Ratings10.013 Ratings
    Mobile Access00 Ratings8.011 Ratings
    Timesheet Tracking00 Ratings10.09 Ratings
    Change request and Case Management00 Ratings10.011 Ratings
    Budget and Expense Management00 Ratings7.09 Ratings
    Professional Services Automation
    Comparison of Professional Services Automation features of Apache Pig and Hive
    Feature
    Apache Pig
    -
    Ratings
    Hive
    7.0
    12 Ratings
    9% below category average
    Quotes/estimates00 Ratings7.010 Ratings
    Invoicing00 Ratings7.07 Ratings
    Project & financial reporting00 Ratings7.010 Ratings
    Integration with accounting software00 Ratings7.09 Ratings
    Best Alternatives
    Apache PigHive
    Small Businesses
    No answers on this topic
    Any.do
    Score8 out of 10
    Medium-sized Companies
    Cloudera Manager (no longer available standalone)
    Score9.9 out of 10
    KanbanFlow
    Score7.3 out of 10
    Enterprises
    Hadoop
    Score7.5 out of 10
    Microsoft To Do
    Score7.9 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Apache PigHive
    Likelihood to Recommend
    8.2
    (9 ratings)
    9.0
    (15 ratings)
    Usability
    10.0
    (1 ratings)
    8.0
    (1 ratings)
    Support Rating
    6.0
    (1 ratings)
    9.4
    (2 ratings)
    User Testimonials
    Apache PigHive
    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
    Hive Technology
    Hive is a powerful tool for data analysis and management that is well-suited for a wide range of scenarios. Here are some specific examples of scenarios where Hive might be particularly well-suited: Data warehousing: Hive is often used as a data warehousing platform, allowing users to store and analyze large amounts of structured and semi-structured data. It is especially good at handling data that is too large to be stored and analyzed on a single machine, and supports a wide variety of data formats. Batch processing: Hive is designed for batch processing of large datasets, making it well-suited for tasks such as data ETL (extract, transform, load), data cleansing, and data aggregation.Simple queries on large datasets: Hive is optimized for simple queries on large datasets, making it a good choice for tasks such as data exploration and summary statistics. Data transformation: Hive allows users to perform data transformations and manipulations using custom scripts written in Java, Python, or other programming languages. This can be useful for tasks such as data cleansing, data aggregation, and data transformation. On the other hand, here are some specific examples of scenarios where Hive might be less appropriate: Real-time queries: Hive is a batch-oriented system, which means that it is designed to process large amounts of data in a batch mode rather than in real-time. While it is possible to use Hive for real-time queries, it may not be the most efficient choice for this type of workload. Complex queries: Hive is optimized for simple queries on large datasets, but may struggle with more complex queries or queries that require multiple joins or subqueries.Very large datasets: While Hive is designed to scale horizontally and can handle large amounts of data, it may not scale as well as some other tools for very large datasets or complex workloads.
    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
    Hive Technology
    • Simplicity, it offers a clean environment without risking the outcome. An example of this are the timesheets that allow a fast way to keep track of progress
    • Interaction, the different options make it faster and easier to interact and collaborate in the development of a product. An example of this would be Hive Notes for meetings
    • The different visualisations it offers allow to explore the best ways to affront your projects. I really like the Gantt mappings view to understand who can be contacted at each point
    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
    Hive Technology
    • Organizing tasks by assignees could be better. It's a little cumbersome to check off each person you want. Can you group these?
    • I don't really use any view besides task view. Is there something better I could be using?
    • It would be nice if attachments showed up in a nicer format, maybe with a preview?
    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
    Hive Technology
    Its a easy tool, the best way to organize the workflow but has room for more improvements.
    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
    Hive Technology
    Our CSR is easily accessible and they have support built into the app itself. They also have a pretty robust support site. We also took advantage of the free trial and learned so much by putting Hive through the paces and figuring out the best way to mold it to our needs.
    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
    Hive Technology
    Hive is a bit different than Jira and Monday, which I used mostly. Overall does a great job managing project and helps with team communication. Removes dependency of asking team members for updates by going to conference rooms. With Hive, the team updates the status, and we can easily track it.
    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
    Hive Technology
    • Workflow Management will help you better move your projects along which saves time and money.
    • Time tracking will allow you to better manage the hours and keep your contractors accountable.
    • Overall visibility of projects allow you to keep your margins down and combat "bleeding" and hidden costs or surprises.
    Incentivized
    Read full review
    ScreenShots

    Hive Screenshots

    Screenshot of HIver Technology