List some major differences between Apache pig and sql?

Mounika
Mounika

Posted On: Jan 07, 2021

 

Some major differences between Apache Pig and SQL are listed below:

PigSQL
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

    Please Login or Register to leave a response.

    Related 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....