Pig
latin is procedural version of SQl.pig has certainly similarities,more
difference from sql.sql is a query language for user asking question in query
form.sql makes answer for given but dont tell how to answer the given
question.suppose ,if user want to do multiple operations on tables,we have
write multiple queries and also use temporary table for storing,sql is support
for subqueries but intermediate we have to use temporary tables,SQL users find
subqueries confusing and difficult to form properly.using sub-queries creates
an inside-out design where the first step in the data pipeline is the innermost
query .pig is designed with a long series of data operations in mind, so there
is no need to write the data pipeline in an inverted set of subqueries or to
worry about storing data in temporary tables.
