Big Data Analyst -using Sqoop and Advance Hive (CCA159)




Big Data Analyst -using Sqoop and Advance Hive (CCA159)

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

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

Url: View Details

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

Rating: 4.36364

Level: All Levels

Duration: 5 hours

Instructor: Navdeep Kaur


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of hugecourses.com.


© 2021 hugecourses.com. All rights reserved.
View Sitemap