What users are saying about
18 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 7.3 out of 101
1 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 10 out of 101

Add comparison

Likelihood to Recommend

Apache Pig

It is one great option in terms of database pipelining. It is highly effective for unstructured datasets to work with. Also, Apache Pig being a procedural language, unlike SQL, it is also easy to learn compared to other alternatives. But other alternatives like Apache Spark would be my recommendation due to the high availability of advanced libraries, which will reduce our extra efforts of writing from scratch
Kartik Chavan profile photo

Oracle Big Data Cloud

We use it only when we need to and we have found that the software does what it needs to, it's user friendly and us also really helpful in many other ways as well. Like I mentioned before, we love the security and the speed we receive.
No photo available

Feature Rating Comparison

Platform-as-a-Service

Apache Pig
Oracle Big Data Cloud
8.1
Ease of building user interfaces
Apache Pig
Oracle Big Data Cloud
9.0
Scalability
Apache Pig
Oracle Big Data Cloud
7.0
Platform management overhead
Apache Pig
Oracle Big Data Cloud
9.0
Workflow engine capability
Apache Pig
Oracle Big Data Cloud
8.0
Platform access control
Apache Pig
Oracle Big Data Cloud
8.0
Services-enabled integration
Apache Pig
Oracle Big Data Cloud
8.0
Development environment creation
Apache Pig
Oracle Big Data Cloud
9.0
Issue recovery
Apache Pig
Oracle Big Data Cloud
7.0

Pros

  • Apache pig DSL provides a better alternative to Java map reduce code and the instruction set is very easy to learn and master.
  • It has many advanced features built-in such as joins, secondary sort, many optimizations, predicate push-down, etc.
  • When Hive was not very advanced (extremely slow) few years ago, pig has always been the go to solution. Now with Spark and Hive (after significant updates), the need to learn apache pig may be questionable.
No photo available
  • User friendly
  • Offers support and assistance
  • Worth the cost
  • Time efficient
  • Good reliability
  • Reliable support
No photo available

Cons

  • 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.
Kartik Chavan profile photo
  • Less pricey
  • Customizable
  • A little more help in setting up/using the systems
  • Constant upgrades are always pricey
  • Some bugs noticable
No photo available

Usability

Apache Pig10.0
Based on 1 answer
It is quick, fast and easy to implement Apache Pig which makes is quite popular to be used.
Subhadipto Poddar profile photo
No score
No answers yet
No answers on this topic

Alternatives Considered

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 to Map Reduce. It is also a good option for working with unstructured datasets. Moreover, in certain cases, Apache Pig is much faster than Hive & Spark.
Kartik Chavan profile photo
Although new, Oracle has been exceptionally good speed wise and the customer service is top notch
No photo available

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.
Kartik Chavan profile photo
  • It has had a good impact we are able to complete our projects in time
  • We can save all our data in a safe and secure location
  • Our data analysis is now faster than ever
No photo available

Pricing Details

Apache Pig

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Oracle Big Data Cloud

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details