what is difference between pig and sql?



what is difference between pig and sql?..

Answer / Sumant Kumar

Pig Latin and SQL are both high-level data query languages, but they have some differences: 1) Pig Latin is designed specifically for working with large datasets stored in Hadoop Distributed File System (HDFS), while SQL can be used with various databases. 2) Pig Latin provides a higher level of abstraction, allowing users to work with data using procedural and functional operations, whereas SQL follows a more traditional declarative approach. 3) Pig Latin supports UDFs (User Defined Functions), which can help extend the functionality of the platform, while SQL has limited support for custom functions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Pig Interview Questions

What is the difference between Apache Pig and Hive?

1 Answers  


Explain about the execution plans of a pig script?<Br> or<br> differentiate between the logical and physical plan of an apache pig script?

1 Answers  


How to write 'foreach' statement for map datatype in pig scripts?

1 Answers  


What are the different pig data types?

1 Answers  


Mention the common features in Pig and Hive?

1 Answers  


Explain count_star?

1 Answers  


What co-group does in Pig?

1 Answers  


You have a file employee.txt in the hdfs directory with 100 records. You want to see only the first 10 records from the employee.txt file. How will you do this?

1 Answers  


Why Do We Need Apache Pig?

1 Answers  


what is pig?

1 Answers  


Can you join multiple fields in apache pig scripts?

1 Answers  


What are the different Eval functions available in Pig?

1 Answers  


Categories