Posted On: Jan 07, 2021
Some major differences between Apache Pig and SQL are listed below:
|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.|
Never Miss an Articles from us.