Q14Big Data Analytics
Question
4 marks
Compare Pig Latin with SQL.
Answer
Pig Latin is a procedural data flow language, whereas SQL is a declarative query language.
SQL focuses on what data to retrieve without specifying how to retrieve it, making it ideal for structured data and analytical queries. Pig Latin is procedural; the programmer defines a series of steps (data flow) to transform data. Pig is better suited for unstructured data preparation, ETL processes, and complex sequential processing where intermediate states are important.