Amazon Athena vs Pig: What are the differences?
What is Amazon Athena? Query S3 Using SQL. Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run.
What is Pig? Platform for analyzing large data sets. Pig is a dataflow programming environment for processing very large files. Pig's language is called Pig Latin. A Pig Latin program consists of a directed acyclic graph where each node represents an operation that transforms data Operations are of two flavors: (1) relational-algebra style operations such as join, filter, project; (2) functional-programming style operators such as map, reduce. .
Amazon Athena and Pig can be categorized as "Big Data" tools.
Pig is an open source tool with 583 GitHub stars and 449 GitHub forks. Here's a link to Pig's open source repository on GitHub.
According to the StackShare community, Amazon Athena has a broader approval, being mentioned in 50 company stacks & 18 developers stacks; compared to Pig, which is listed in 9 company stacks and 4 developer stacks.