English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 30m | 1.27 GB
Great for CCA159 preparation – Big data certification for non-programmers, business analysts, testers, and SQL developers
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]:
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
Table of Contents
Hadoop Introduction
1 Hadoop Distributed File System & Commands
Hive
2 Hive Introduction
3 Hive Database
4 Hive Managed Tables
5 Hive External Tables
6 Hive Insert
7 Hive MultiInsert
8 Alter Command
Hive Data Types
9 DataTypes Introduction
10 Array DataType
11 Map DataType
12 Struct DataType
Hive Functions
13 Collection Functions
14 Conditional Functions
15 String Functions
16 Date Functions
17 Mathematical Functions
Hive Join
18 Join in Hive
19 Multi Joins in Hive
20 Map Side Joins
Working with Different File Formats & Compressions
21 Working with Parquet
22 Compressing Parquet
23 Working with Fixed File Format
Advance Hive
24 Hive Partitioning
25 Hive Bucketing
26 Views in Hive
27 Lateral ViewExplode
28 Hive Analytics
Hive Windows Function
29 RankDense Rank Windowing Function
30 LeadLag Windowing Function
31 MinMax Windowing Function
32 Windowing Specification
Sqoop Import
33 Sqoop Introduction
34 Managing Target Directory
35 Working with Different File Formats
36 Working with Different Compressions
37 Conditional Imports
38 Split-By and Boundary Queries
39 Field Delimiters
40 Incremental Appends
41 Sqoop Hive Import
42 Practice 1
43 Practice2
44 Practice3
Sqoop Import
45 Export from HDFS to MYSQL
46 Export from Hive to MYSQL
Resolve the captcha to access the links!