Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Analytical Queries in Hive
You, Us & This Course
You, Us & This Course (1:58)
Introducing Hive
Hive: An Open-Source Data Warehouse (12:59)
Hive and Hadoop (9:19)
Hive vs Traditional Relational DBMS (13:52)
HiveQL and SQL (7:20)
Built-in Functions
Three types of Hive functions (6:45)
The Case-When statement, the Size function, the Cast function (10:09)
The Explode function (13:07)
Code-Along : Hive Built - in functions (4:28)
Sub-Queries
Quirky Sub-Queries (7:13)
More on subqueries: Exists and In (15:13)
Inserting via subqueries (5:23)
Code-Along : Use Subqueries to work with Collection Datatypes (5:57)
Views (12:18)
Partitioning
Indices (6:40)
Partitioning Introduced (6:36)
The Rationale for Partitioning (6:16)
How Tables are Partitioned (9:52)
Using Partitioned Tables (5:27)
Dynamic Partitioning: Inserting data into partitioned tables (12:44)
Code-Along : Partitioning (4:03)
Bucketing
Introducing Bucketing (11:56)
The Advantages of Bucketing (4:54)
How Tables are Bucketed
Using Bucketed Tables (7:22)
Sampling (11:13)
Windowing
Windowing Introduced (12:59)
Windowing - A Simple Example: Cumulative Sum (9:39)
Windowing - A More Involved Example: Partitioning (11:55)
Windowing - Special Aggregation Functions (15:08)
Understanding MapReduce
The basic philosophy underlying MapReduce (8:49)
MapReduce - Visualized and Explained (9:03)
MapReduce - Digging a little deeper at every step (10:21)
MapReduce logic for queries: Behind the scenes
MapReduce Overview: Basic Select-From-Where (11:33)
MapReduce Overview: Group-By and Having (9:12)
MapReduce Overview: Joins (14:17)
Join Optimizations in Hive
Improving Join performance with tables of different sizes (13:12)
The Where clause in Joins (4:52)
The Left Semi Join (12:11)
Map Side Joins: The Inner Join (9:41)
Map Side Joins: The Left, Right and Full Outer Joins (11:36)
Map Side Joins: The Bucketed Map Join and the Sorted Merge Join (7:52)
Hadoop and Hive Install
Hadoop Install Modes (8:32)
Hadoop Install Step 1 : Standalone Mode (15:46)
Hadoop Install Step 2 : Pseudo-Distributed Mode (11:44)
Hive install (12:05)
Code-Along: Getting started (6:24)
Appendix
[For Linux/Mac OS Shell Newbies] Path and other Environment Variables (8:25)
Setting up a Virtual Linux Instance - For Windows Users (15:58)
Hadoop Install Modes
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock