What are the relational operators available related to combining and splitting in pig language?



What are the relational operators available related to combining and splitting in pig language?..

Answer / Jwala Singh

Combining Operators:
1. UNION ALL: Concatenates two or more relations horizontally without removing duplicates.
2. JOIN: Connects two relations vertically based on a common key.
3. LEFT JOIN, RIGHT JOIN, FULL OUTER JOIN: Extend the result set of a join by including all records from one or both sides.nSplitting Operators:
1. DISTINCT: Removes duplicate rows from a relation.
2. GROUP BY: Divides a relation into sub-relations based on one or more grouping expressions.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Apache Pig Interview Questions

How will you explain COGROUP in Pig?

1 Answers  


Why should we use ‘orderby’ keyword in pig scripts?

1 Answers  


I have a relation r. How can I get the top 10 tuples from the relation r?

1 Answers  


Why do we need Pig?

1 Answers  


Explain about the bloommapfile?

1 Answers  


What are the different execution modes available in Pig?

1 Answers  


Explain the difference between COUNT_STAR and COUNT functions in Apache Pig?

1 Answers  


What is bag data type in Pig?

1 Answers  


What is the relationship between hdfs, hbase, pig, hive and azkaban?

1 Answers  


Tell me about the execution modes of Apache Pig?

1 Answers  


How should 'load' keyword is useful in pig scripts?

1 Answers  


What do you know about the case sensitivity of apache pig?

1 Answers  


Categories