Apache Pig Tutorial

This page combines all Apache Pig related posts into a single to make it more helpful and beneficial to learners. It is presented in a hierarchical manner, beginning with the basics and progressing to more advanced topics.

Apache Pig

• An Introduction

Versions & Connectivity

• Get the Version
• Connecting Apache Pig – Pig Running Modes

Relations in Apache Pig

• Creating Relations

Loading Data

• Loading Data into Relations
• Loading Comma Separated Data
• Loading Tab Delimited Data

Sample Datasets

• Sample Datasets (Emp & Dept)

Querying & Storing Data

• Sampling Data
• Filtering Data (Where, Where..And.., Where..Or..)
• Selecting Data
• Selecting Specific Columns Data
• Storing Data
• Removing Duplicates
• Sorting

Merging & Combining Data

• GROUP BY Clause
• UNION Operator
• COGROUP Operator
• Normal / Natural / Equi Joins
• Self Joins
• Outer Joins
• Cross Joins

Shell & CLI Commands in Apache Pig

• Utility Commands
• Sessions History
• Clearing Screen

Complex Types

• Tuples & Bag
• Map

Diagnostic Operators

• Dump
• Describe
• Explain
• Illustrate

Arithmetic Operations

• COUNT
• SUM
• AVERAGE

String Operations

• Upper
• Lower
• Substring
• Trim
• Ltrim
• Rtrim
• Replace

Sample Programs

• Query: SQL vs Apache Pig
• Word Count Program