Tutorialspoint
Subscription Includes
$ 130   9.99

Advance Big Data Analytics using Hive & Sqoop

Created by Navdeep Kaur, Last Updated 22-Dec-2020, Language:English

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

Created by Navdeep Kaur, Last Updated 22-Dec-2020, Language:English

What Will I Get ?

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

Requirements

  • Basic Knowledge of SQL

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

Course Content

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.