CCA 159: Expert in Big Data Analytics – Advance Hive & Sqoop 1st Edition – PDF/EPUB Version Downloadable

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: github.com/PacktPublishing/CCA-159-Expert-in-Big-Data-Analytics—Advance-Hive-Sqoop