CCA159 Advance Hive & Sqoop – Big Data Analytics & ingestion

CCA159 Advance Hive & Sqoop – Big Data Analytics & ingestion

Great for CCA 159 Preparation – Big Data Certification for Non Programmers,Business Analyst,Testers and Sql Developers.

What you’ll learn

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


  • Basic Knowledge of SQL


This course will prepare you for Advance Hive and prepare you to undergo CCA159 (Cloudera Big Data Analyst Certification),

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

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