Hadoop Basic PIG Commands with Examples

  • date 5th March, 2019 |
  • by Prwatech |
  • 2 Comments

 

Hadoop Basic PIG Commands with Examples

 

Hadoop Basic PIG Commands with Examples, are you looking for a list of Top Rated Pig commands in Hadoop examples? Or the one who is casually glancing for the best platform which is listing the Top-rated Hadoop pig script commands with examples for beginners? Then you’ve landed on the Right Platform which is packed with Tons of Tutorials of Pig commands for Hadoop. Follow the below mentioned Pig commands in Hadoop which were originally designed by the world-class Trainers of Big Data Training institute Professionals.

 

If you are the one who is a hunger to become the certified Pro Hadoop Developer? Or the one who is looking for the best Hadoop Training institute which offering advanced tutorials and Hadoop certification course to all the Tech Enthusiasts who are eager to learn the technology from 0 Level to Advanced Level.

 

Basic PIG commands in Hadoop

 

 Hadoop Basic PIG Commands with Examples

 

  • Create the following input file (text format)

Database 1: studb

pig commands in hadoop

 

Database 2: empdb

pig commands in hadoop

 

Database 3: detaildb

pig commands in hadoop

 

Database 4: stu2db

pig commands in hadoop

 

Move the created file from LFS to HDFS

 

 Hadoop Basic PIG Commands with Examples

 

Run PIG command from console (cluster mode)

 

Hadoop Basic PIG Commands with Examples

 

 

Data Input using pig: Load data from hdfs to Pig

 

Hadoop Basic PIG Commands with Examples

 

 

Dump Command: This command is used to display all data loaded.

 

Hadoop Basic PIG Commands with Examples

 

Foreach: This command is used to generate data transformation based on columns of data

Hadoop Basic PIG Commands with Examples

Hadoop Basic PIG Commands with Examples

 

Filter: Select particular tuples from a relation based on a condition.

Hadoop Basic PIG Commands with Examples

 

Order By: Sort a relation based on one or more fields

Hadoop Basic PIG Commands with Examples

 

Store: Save results to the local file system or HDFS

 

Hadoop Basic PIG Commands with Examples

 

Cogroup: This operator is used to group two databases using a particular column.

 

Hadoop Basic PIG Commands with Examples

 

Pig commands in Hadoop with examples

 

 

Join: This operator is used to join two or more table.

 

Inner Join: Joining two table having a common column

Hadoop Basic PIG Commands with Examples

 

Left Outer: The left outer Join operation returns all rows from the left table, even if there are no matches in the right relation

 

Hadoop Basic PIG Commands with Examples

Right Outer: The right outer join operation returns all rows from the right table, even if there are no matches in the left table.

Hadoop Basic PIG Commands with Examples

 

Cross: The CROSS operator computes the cross-product of two or more relations.

Hadoop Basic PIG Commands with Examples

 

Union: The UNION operator of Pig Latin is used to merge the content of two relations.

Hadoop Basic PIG Commands with Examples

Split: The split operator is used to split a relation into two or more relations.

Hadoop Basic PIG Commands with Examples

 

PIG Commands with Examples

 

GROUP OPERATOR:

 

The simpler of these operators is GROUP. Continuing with the same set of relations

grunt> Emp_grouped = GROUP Emp BY salary;

 

Hadoop Basic PIG Commands with Examples


grunt> DUMP Emp_grouped;

 

Hadoop Basic PIG Commands with Examples

 

Group Output:

 

Hadoop Basic PIG Commands with Examples

 

FOREACH OPERATOR:

One of the key uses of Pig is data transformation. You can define a new relation based on the fields of an existing relation using the FOREACH command

grunt> foreach_Emp = FOREACH Emp GENERATE id,name;

 

Hadoop Basic PIG Commands with Examples

 

grunt> dump foreach_Emp;

 

Hadoop Basic PIG Commands with Examples

 

Foreach Output:

 

Hadoop Basic PIG Commands with Examples

 

 

JOIN OPERATOR:

 

which groups together tuples from multiple relations . It functions much like a join. For example, let’s Join Emp and Customer on the first column.
grunt> Emp_self = join Emp by id, Customer by id;

 

Hadoop Basic PIG Commands with Examples

 

grunt> DUMP Emp_self;

Hadoop Basic PIG Commands with Examples

 

Self Join Output:

Hadoop Basic PIG Commands with Examples

 

 

By default behavior of join as an outer join, and the join keyword can modify it to be left outer join, right outer join, or inner join.Another way to do inner join in Pig is to use the JOIN operator. Empcust_left = join Emp by id left outer, Customer by id;

Hadoop Basic PIG Commands with Examples

 

grunt> dump Empcust_left;

Hadoop Basic PIG Commands with Examples

 

Left Outer Join Output:

Hadoop Basic PIG Commands with Examples

 

Empcust_right = join Emp by id right outer, Customer by id;

Hadoop Basic PIG Commands with Examples

 

grunt> dump Empcust_right;

 Hadoop Basic PIG Commands with Examples

 

Right Outer Join Output:

Hadoop Basic PIG Commands with Examples

 

Empcust_full = join Emp by id full outer, Customer by id;

Hadoop Basic PIG Commands with Examples

 

grunt> dump Empcust_full;

Hadoop Basic PIG Commands with Examples

 

Full Outer Join Output:

Hadoop Basic PIG Commands with Examples

 

DISTINCT OPERATOR:

 

 grunt> Emp2_dist = DISTINCT Emp2;

Hadoop Basic PIG Commands with Examples

 

grunt> dump Emp2_dist;

 

Hadoop Basic PIG Commands with Examples

 

DISTINCT Output:

Hadoop Basic PIG Commands with Examples

 

 

LIMIT OPERATOR:

 

grunt> limit_data = LIMIT Emp 3;

Hadoop Basic PIG Commands with Examples

 

grunt> dump limit_data;

 

Hadoop Basic PIG Commands with Examples

 

LIMIT Output:

 

Hadoop Basic PIG Commands with Examples

 

 

2 thoughts on “Hadoop Basic PIG Commands with Examples”

  1. Excellent web site. Lots of helpful info here. I am sending it to some pals ans also sharing in delicious. And certainly, thanks on your effort!

Leave a Reply

Your email address will not be published. Required fields are marked *

Quick Support

image image