Apache Drill vs Pig: What are the differences?
Developers describe Apache Drill as "Schema-Free SQL Query Engine for Hadoop and NoSQL". Apache Drill is a distributed MPP query layer that supports SQL and alternative query languages against NoSQL and Hadoop data storage systems. It was inspired in part by Google's Dremel. On the other hand, Pig is detailed as "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. .
Apache Drill belongs to "Database Tools" category of the tech stack, while Pig can be primarily classified under "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.