Pig Interview Questions

Introduction To Pig interview Question and Answers

Apache Pig is a high-level platform for which is used to create programs that run on the Hadoop. The Language of Pig is known as Pig Latin. Pig is written in Java and it was developed by Yahoo research and Apache software foundation. Its initial release happened on 11 September 2008.

Preparing for a job interview in Pig. I am sure you want to know the most common Pig Interview Questions and answers that will help you crack the Pig Interview with ease.

Below is the list of top Pig Interview Questions and answers at your rescue. these interview questions are divided into two parts are as follows:

• Part 1 – Pig Interview Questions (Basic)
• Part 2 – Pig Interview Questions (Advanced)

Part 1 – Pig Interview Questions (Basic)

This first part covers basic Pig interview questions and answers

Q1.What is the difference between Map Reduce and Pig?

Answer:
Map Reduce is a compiled language and code efficiency of Map-reduce is high and Pig is a scripting language with less code efficiency.

Q2.What do you mean by the bag in Pig?

Answer:
Collection of tuples is known as a bag in a pig.

Q3.What are the complex data types in Pig?

Answer:
Map, Tuples, and Bag are the complex data types of Pig.

Q4.What is flatten in Pig?

Answer:
When we want to remove the nesting from the data in tuple or bag then we use Flatten.

Q5.Suppose we have a file name with abc.csv and having the attribute like id, name, year, rating, duration. How will you upload this file to a pig?

Answer:
movies= LOAD ‘path of abc.csv’ USING Pig Storage(‘,’) as (id,name,year,rating,duration);

Q6.What is the difference between PigLatin and HIVEQL?

Answer:
HIVEQL is a declarative language and PigLatin is a procedural mail.

Let us move to the next Pig Interview Questions.

Q7.What do you mean by an inner bag and outer bag in pig?

Answer:
The relation inside the bag is referred to the inner bag and the normal relationship is known as an Outer bag.

Q8.What is the difference between Group and COGROUP?

Answer:
GROUP operator is used to grouping the data in a single relation and COGROUP is used for making the relation in GROUP and JOIN.

Q9.What is the difference between COUNT and COUNT_STAR?

Answer:
COUNT function doesn’t work with a NULL value when we are counting an element in a bag but COUNT_STAR will consider the NULL value.

Q10. What are the diagnostic operators available in Apache Pig?

Answer:
Dump Operator, Describe Operator, Explain Operator, Illustrate operator.

Q11.What do you mean by UNION and SPLIT operator?

Answer:
By using a UNION operator we can merge the contents of two or more relations and a SPILT operator is used to divide the single relation into two or more relations.

Q12.How to get the top 10 tuples from the relation R?

Answer:
By using the TOP () function.

Let us move to the next Pig Interview Questions.

Q13.What are the similarities between Pig and Hive?

Answer:
Pig use PigLatin and Hive use HiveQL both converts the commands into MapReduce jobs.

Q14.what are the different types of UDF’s functions of JAVA which are supported by Apache Pig?

Answer:
Algebraic, Eval, Filter functions are the types of UDF functions.

Q15.You have a file movies.txt in the HDFS directory with 1000 records. You want to see only the first 10 records from the movies.txt file. How will you do this?

Answer:
First, you have to load the movies.txt with the relation name movie:
movies= LOAD ‘path of movies.txt’ USING Pig Storage(‘,’) as (attributes);
Result= limit employee 10

Part 2 – Pig Interview Questions (Advanced)

Let us now have a look at the advanced Pig Interview Questions.

Q16.How do users interact with Hadoop in Pig?

Answer:
By using grunt shell

Q17.Is Pig support multi-line commands?

Answer:
Yes

Q18.What are all stats classes in a pigstats package?

Answer:
PigStats, JobStats, OutputStats, InputStats.

Q19.What is UDF?

Answer:
The function which is not built in operator but can programmatically create a function to bring up the functionality.

Q20.Explain is the case sensitivity in Pig Latin?

Answer:
The functions and names of relations are cases sensitive in Pig Latin but a name or keyword and parameter are case insensitive.

Q21.What is Grunt in Pig?

Answer:
Grunt is a command terminal which is an interactive shell where we give the command of Pig.

Q22.What is the requirement of MapReduce in Pig programming?

Answer:
MapReduce is an execution engine.

Let us move to the next Pig Interview Questions.

Q23.What is Pig engine?

Answer:
Pig engine provides the execution environment to run the pig programs. It converts the pig operations into MapReduce jobs.

Q24.What are the execution modes of Pig?

Answer:
Local Mode: Pig operation will be executed in single JVM.
MapReduce Mode: Execution will be done of the Hadoop cluster.

Q25.What are the different Eval functions available in pig?

Answer:
AVG, CONCAT, MAX, MIN, SM, SIZE, COUNT are different EVAL pig functions.

Q26.What do you mean by LOAD and STORE in Pig?

Answer:
These are the operator for Loading and storing the data in hdfs.

Let us move to the next Pig Interview Questions.

Q27.Which Math function available in Pig?

Answer:
ABS, ACOS, LOG, ROUND, CBRT, SORT are the math functions available in Pig.

Q28.What did the distinct keyword do in Pig?

Answer:
Distinct keywords remove the duplicate keywords from the records. For eg:
movies= LOAD ‘path of abc.csv’ USING Pig Storage(‘,’) as (id,name,year,rating,duration);
New_movies= distinct(id,name,year,rating,duration) ;

Q29.What do you mean by primitive Data type in Pig?

Answer:
Int, Long, Float, Double, Char array, Byte array are the primitive data types in Pig.

Q30.What do you mean by a tuple in Pig?

Answer:
An ordered set of field of a data is called Tuple.

Conclusion

If you are preparing for the Hadoop related jobs then You must prepare the Pig for that because this topic will play the major role to secure good remarks in the interview. The Pig Interview Questions which are shared above will help you to prepare the basics and theoretically of the Pig but you must have the hands on the pig. It will help you to build up the confidence and advanced knowledge.

Recommended Article

This has been a guide to List Of Pig Interview Questions and Answers so that the candidate can crackdown these Pig Interview Questions easily. Here we covered both –basic as well as advanced Pig Interview Questions. You may also look at the following articles to learn more –

1. Useful Apache PIG Interview Questions
2. C++ Interview Questions
3. Spark Interview Questions You Should Know
4. Cucumber Interview Questions