Hadoop Hive and Pig

Have Queries? Ask us +91 72592 22234

Course Overview

In Hadoop Hive and Pig training course, you will receive an overview of Apache Hadoop Hive and Pig and discover how it can help meet your business goals. You will learn the different Apache Hadoop Hive and Pig technologies, including MapReduce, Hadoop, Pig Distributed File System (HDFS), Hive, Pig, HBase, Sqoop, Flume, and Hue, and how these fit into your existing technology environment.

Course Content

What is Big Data & Why Hadoop Hive and Pig?

  • Big Data Characteristics, Challenges with traditional system

Hadoop Hive and Pig Overview & it's Ecosystem

  • Anatomy of Hadoop Hive and Pig Cluster, Installing and Configuring Hadoop Hive and Pig
  • Hands On Exercise - Build a pseudo - distributed cluster

HDFS - Hadoop Hive and Pig Distributed File System and Map Reduce Anatomy

  • HDFS Architecture, Name Nodes, Data Nodes and Secondary Name Node
  • How Map Reduce Works?
  • Hands On Exercise - Basic HDFS operations and Running map reduce programs

Monitoring & Management of Hadoop Hive and Pig

  • Managing HDFS with Tools like fsck and dfsadmin
  • Using HDFS & Job Tracker Web UI

Hive Basics

  • Hive Architecture, Hive Variables Creating Internal & External Tables,Partitioning Data, Configuring Shared Meta Store
  • Loading Data into Hive, Storing Query Output
  • Writing queries - Joining Table, Union, Filtering, Grouping, Sorting etc.and advanced queries

Advanced Hive

  • Sampling, Buckets and Clusters
  • TRANSFORM, Creating User Defined Functions and SerDes
  • Debugging & Troubleshooting Hive Queries
  • Hive Best Practices
  • Hands on Exercise - Configuring Hive and shared meta store,Creating tables and partitions, Structured data analysis.
  • Hands on Exercise - Writing UDFs and SerDes.

Sqoop & Flume

  • Importing and Exporting data from using RDBMS and Log Files.
  • Hands on Exercise - Import and Export data from MySQL to Hive using Sqoop.
  • Hands on Exercise - Importing logs from applications using Flume.

Pig Basics

  • Pig Basics, Loading data files, dumping and storing results
  • Writing queries - Filter, Group, Join and Sort, FOREACH, SPLIT,SAMPLE etc.

Pig Advanced

  • UDFs and Macros
  • Diagnostic operators, debugging and collecting statistics
  • Performance Optimizations, Multi Query Execution
  • Hands on Exercise - Semi - structured Data Analysis(Tweets and Log Analysis)
  • Hands on Exercise - Writing UDFs

Customer Reviews

Thanks to Xpertised and the tutor who walked me through all the topics with Practical exposure which is helping me in my current project.

Course was quite helpful in terms of understanding of concepts and practicality. Its really a very friendly environment to learn. The timing were mutually chosen, as we both are working professional. I am quite satisfied with the course.


For Batch Details
Call us at: +91 7259222234

Not sure? Consult Our Experts

Looking for a Training for


My Team/Organization

I agree to be contacted over mail or phone

Call us at: +91 7259222234