Duration: 3h 30m | Video: h264 1280x720 | Audio: AAC 48kHz 2Ch | 1.3 GB

Genre: eLearning | Language: English | 19 Aug 2019

Learn

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

About

This course will prepare you for advanced Hive and get you ready to take the CCA159 (Cloudera Big Data Analyst) certification

You will start by learning what Hadoop and its distributed file system are and you'll master the most common Hadoop commands you'll need to work with Hadoop file systems. Then we explore the Apache Hive [Advanced]:

Hive intro

External and managed tables

Insert and multi insert

Data types and complex data types

Collection function

Conditional function

Hive string functions

Hive date functions

Mathematical functions

Hive analysis

The Alter command

Joins, multi joins, and map Joins

Working with different files: Parquet and Avro

Compression

Partitioning

Bucketing

Views

Lateral Views/Explode

Windowing functions - Rank/Dense Rank/lead/lag/min/max

Window specification

All the codes and supporting files are available at:

Features

Master advanced Hive and Sqoop for big data analytics and ingestion

Master advanced Hive and prepare for the CCA159 (Cloudera Big Data Analyst) certification