Advance Big Data Analytics using Hive & Sqoop

person icon Navdeep Kaur

Advance Big Data Analytics using Hive & Sqoop

Become Big data Analyst using Hive and Sqoop.Great course for business Analyst,Testers and Sql Developers.CCA159

updated on icon Updated on Sep, 2023

language icon Language - English

person icon Navdeep Kaur

architecture icon Development,Big Data


30-days Money-Back Guarantee

Training 5 or more people ?

Get your team access to 19,000+ top Tutorialspoint courses anytime, anywhere.

Course Description

You will start by learning what is Hadoop &  Hadoop distributed file system and most common hadoop commands required to work with Hadoop File system

Then you will be introduced to Sqoop Import

  • Understand lifecycle of sqoop command.

  • Use sqoop import command to migrate data from Mysql to HDFS.

  • Use sqoop import command to migrate data from Mysql to Hive.

  • Use various file formats, compressions, file delimeter,where clause and queries while importing the data.

  • Understand split-by and boundary queries.

  • Use incremental mode to migrate the data from Mysql to HDFS.

Further, you will learn Sqoop Export to migrate data.

  • What is sqoop export

  • Using sqoop export, migrate data from HDFS to Mysql.

  • Using sqoop export, migrate data from Hive to Mysql.

Finally, we will start with Apache Hive [Advance]

  • Hive Intro

  • External & Managed Tables

  • Insert & Multi Insert

  • Data Types & Complex Data Types

  • Collection Function

  • Conditional Function

  • Hive String Functions

  • Hive Date Functions

  • Mathematical Function

  • Hive Analysis

  • Alter Command

  • Joins, Multi Joins & Map Joins

  • Working with Different Files - Parquet,Avro

  • Compressions

  • Partitioning

  • Bucketing

  • Views

  • Lateral Views/Explode

  • Windowing Functions - Rank/Dense Rank/lead/lag/min/max

  • Window Specification

Who this course is for:

  • Who are preparing for CCA159 Cloudera Big Data Analytics Certification or who wants to learn Advance Hive & Sqoop


What will you learn in this course:

  • Students will learn Advance Hive and Sqoop for Big Data Analytics and Ingestion.


What are the prerequisites for this course?

  • Basic Knowledge of SQL
Advance Big Data Analytics using Hive & Sqoop


Check out the detailed breakdown of what’s inside the course

Hadoop Introduction
5 Lectures
  • play icon Big Data Intro 05:24 05:24
  • play icon Hadoop Distributed File System & Commands 09:16 09:16
  • play icon Cloudera vm setup
  • play icon Cluster Setup on Google Cloud 19:13 19:13
  • play icon MapReduce Overview 07:41 07:41
6 Lectures
Hive Data Types
4 Lectures
Hive Functions
5 Lectures
Hive Join
3 Lectures
Working with Different File Formats & Compressions
3 Lectures
Advance Hive
5 Lectures
Hive Windows Function
4 Lectures
Sqoop Import
13 Lectures
Sqoop Export
2 Lectures

Instructor Details

Navdeep Kaur

Navdeep Kaur

TechnoAvengers.com (Founder)

I am a big data architect with 11 years of industry experience in different technologies and domains. I have keen interest in providing training in new technologies. I have received CCA175 Hadoop and Spark developer certification and  AWS solution architect certification. I love guiding people and helping them achieve new goals.

Course Certificate

User your certification to make a career change or to advance in your current career. Salaries are among the highest in the world.

sample Tutorialspoint certificate

Our students work
with the Best



Rajeev Sharma

Excellent course material with demos


Ashir Ahmed

Video is missing for HIVE PARTITIONING in Advance hive section. It is the same as VIEWS IN HIVE. Please fix this and kindly reply... I have already wrote couple of emails but no response.

Related Video Courses

View More

Annual Membership

Become a valued member of Tutorials Point and enjoy unlimited access to our vast library of top-rated Video Courses

Subscribe now
People having fun around a laptop

Online Certifications

Master prominent technologies at full length and become a valued certified professional.

Explore Now
People having fun around a laptop

Talk to us