CCA 159: Expert in Big Data Analytics - Advance Hive and Sqoop

Video description

Great for CCA159 preparation - Big data certification for non-programmers, business analysts, testers, and SQL developers

About This Video

  • Get to grips with Hive and Sqoop for big data analytics and ingestion
  • Become well-versed with the essential topics and concepts and achieve CCA159 (Cloudera Big Data Analyst) certification
  • Get to grips with data types and complex data types

In Detail

This course will help you understand Hive, along with preparing you to achieve CCA159 (Cloudera Big Data Analyst) certification.

You will start by delving into Hadoop and its distributed file system. Next, you'll become well-versed with the most common Hadoop commands you'll need to work with Hadoop file systems. Later, you'll explore the Apache Hive, starting with an introduction to it, before moving on to understanding external and managed tables. The next few sections will take you through insert and multi-insert. As you progress, the course will provide insights into different functions such as collection, conditional, Hive string functions, Hive date functions, and mathematical functions. In addition to this, you'll learn to work with different file formats and compressions.

By the end of this course, you'll have comprehensive knowledge of Hive and Sqoop and gained the skills you need to pass the CCA Data Analyst Exam.

Publisher resources

Download Example Code

Table of contents

  1. Chapter 1 : Hadoop Introduction
    1. Hadoop Distributed File System & Commands 00:09:16
  2. Chapter 2 : Hive
    1. Hive Introduction 00:03:42
    2. Hive Database 00:03:05
    3. Hive Managed Tables 00:06:24
    4. Hive External Tables 00:02:27
    5. Hive Insert 00:05:31
    6. Hive MultiInsert 00:03:12
    7. Alter Command 00:06:13
  3. Chapter 3 : Hive Data Types
    1. DataTypes Introduction 00:03:09
    2. Array DataType 00:03:05
    3. Map DataType 00:04:35
    4. Struct DataType 00:03:37
  4. Chapter 4 : Hive Functions
    1. Collection Functions 00:03:47
    2. Conditional Functions 00:04:46
    3. String Functions 00:06:22
    4. Date Functions 00:05:41
    5. Mathematical Functions 00:02:08
  5. Chapter 5 : Hive Join
    1. Join in Hive 00:07:42
    2. Multi Joins in Hive 00:05:02
    3. Map Side Joins 00:02:33
  6. Chapter 6 : Working with Different File Formats & Compressions
    1. Working with Parquet 00:03:31
    2. Compressing Parquet 00:04:27
    3. Working with Fixed File Format 00:03:04
  7. Chapter 7 : Advance Hive
    1. Hive Partitioning 00:07:26
    2. Hive Bucketing 00:03:45
    3. Views in Hive 00:03:34
    4. Lateral View/Explode 00:03:23
    5. Hive Analytics 00:04:22
  8. Chapter 8 : Hive Windows Function
    1. Rank/Dense Rank Windowing Function 00:08:26
    2. Lead/Lag Windowing Function 00:05:16
    3. Min/Max Windowing Function 00:03:04
    4. Windowing Specification 00:09:43
  9. Chapter 9 : Sqoop Import
    1. Sqoop Introduction 00:08:07
    2. Managing Target Directory 00:02:38
    3. Working with Different File Formats 00:04:26
    4. Working with Different Compressions 00:06:17
    5. Conditional Imports 00:04:26
    6. Split-By and Boundary Queries 00:08:27
    7. Field Delimiters 00:03:18
    8. Incremental Appends 00:03:14
    9. Sqoop Hive Import 00:03:32
    10. Practice 1 00:04:57
    11. Practice2 00:04:17
    12. Practice3 00:03:32
  10. Chapter 10 : Sqoop Import
    1. Export from HDFS to MYSQL 00:03:39
    2. Export from Hive to MYSQL 00:02:30

Product information

  • Title: CCA 159: Expert in Big Data Analytics - Advance Hive and Sqoop
  • Author(s): Navdeep Kaur
  • Release date: July 2019
  • Publisher(s): Packt Publishing
  • ISBN: 9781839218934