List some major differences between Apache pig and sql?
Mounika
Posted On: Jan 07, 2021
Some major differences between Apache Pig and SQL are listed below:
| Pig | SQL |
|---|---|
| Pig Latin is a procedural language used in Apache PIg. | SQL is a declarative language. |
| Pig Latin data model is fully nested and can treat both atomic like integer, float, and non-atomic complex data types such as Map and tuple. | SQL data models are database dependent. |
| Apache Pig provides limited opportunity for Query optimization. | SQL provides more opportunities for query optimization. |
Related Questions
Subscribe Our NewsLetter
Never Miss an Articles from us.
Recent Articles
Featured Categories
- Common Interview Questions
- Python Flask Interview Questions
- NoSQL Interview Questions
- jQuery Interview Questions
- C Programming Interview Questions
- AngularJs Interview Questions
- Node JS Interview Questions
- JavaScript Interview Questions
- Core Java Interview Questions
- HTML Interview Questions
- Laravel Interview Questions
- Wordpress Interview Questions
- PHP Interview Questions
Apache Pig Interview Questions
Explain what is Apache Pig?
Apache Pig is a platform for creating programs that run on Apache Hadoop. It uses the Pig Latin language. It also executes its Hadoop jobs in MapReduce, Apache Tez, or Apache Spark....
Apache Pig Interview Questions
What is difference between Apache Pig and Hadoop?
The difference between Apache Pig and Hadoop are as follows: Topics Apache Pig HadoopData Processing It is used to analyze large sets of data representing them as data flows. A...
Apache Pig Interview Questions
What is BloomMapFile in Apache Pig?
BloomMapFile in Apache Pig is a class that is used to provide a quick membership test for the keys using dynamic bloom filters. It extends the MapFile class....