CCA 159 - Advance Hive Zero to Expert in Big Data Analytics

Publisher : Navdeep Kaur

Course Language : English

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