Advance Big Data Analytics using Hive & Sqoop

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

Then you will be introduced to Sqoop Import:

• Understand the lifecycle of the sqoop command.

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

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

• Use various file formats, compressions, file delimiters, where clauses, 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 is preparing for CCA159 Cloudera Big Data Analytics Certification or who wants to learn Advance Hive & Sqoop?