Answer Posted / 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.

What is the function of UNION and SPLIT operators? Give examples?

578