What users are saying about
19 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100

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 | TrustRadius Reviewer

Oracle Big Data Cloud Service

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.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Platform-as-a-Service

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

Pros

Apache Pig

  • 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."
Jordan Moore | TrustRadius Reviewer

Oracle Big Data Cloud Service

  • User friendly
  • Offers support and assistance
  • Worth the cost
  • Time efficient
  • Good reliability
  • Reliable support
Anonymous | TrustRadius Reviewer

Cons

Apache Pig

  • 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
Anonymous | TrustRadius Reviewer

Oracle Big Data Cloud Service

  • Less pricey
  • Customizable
  • A little more help in setting up/using the systems
  • Constant upgrades are always pricey
  • Some bugs noticable
Anonymous | TrustRadius Reviewer

Usability

Apache Pig

Apache Pig 10.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 | TrustRadius Reviewer

Oracle Big Data Cloud Service

No score
No answers yet
No answers on this topic

Support Rating

Apache Pig

Apache Pig 6.0
Based on 2 answers
The documentation is adequate. I'm not sure how large of an external community there is for support.
Jordan Moore | TrustRadius Reviewer

Oracle Big Data Cloud Service

No score
No answers yet
No answers on this topic

Alternatives Considered

Apache Pig

- Provided better ways for optimized hadoop jobs than Hive but not anymore.- Spark DSL is much more advanced and compute times are significantly less.
Anonymous | TrustRadius Reviewer

Oracle Big Data Cloud Service

Although new, Oracle has been exceptionally good speed wise and the customer service is top notch
Anonymous | TrustRadius Reviewer

Return on Investment

Apache Pig

  • 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 | TrustRadius Reviewer

Oracle Big Data Cloud Service

  • 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
Anonymous | TrustRadius Reviewer

Pricing Details

Apache Pig

General

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

Oracle Big Data Cloud Service

General

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

Rating Summary

Likelihood to Recommend

Apache Pig
8.0
Oracle Big Data Cloud Service
10.0

Usability

Apache Pig
10.0
Oracle Big Data Cloud Service

Support Rating

Apache Pig
6.0
Oracle Big Data Cloud Service

Add comparison