Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Advanced Analytical Queries in Hive
You, Us & This Course
You, Us & This Course
Introducing Hive
Hive: An Open-Source Data Warehouse
Hive and Hadoop
Hive vs Traditional Relational DBMS
HiveQL and SQL
Built-in Functions
Three types of Hive functions
The Case-When statement, the Size function, the Cast function
The Explode function
Code-Along : Hive Built - in functions
Sub-Queries
Quirky Sub-Queries
More on subqueries: Exists and In
Inserting via subqueries
Code-Along : Use Subqueries to work with Collection Datatypes
Views
Partitioning
Indices
Partitioning Introduced
The Rationale for Partitioning
How Tables are Partitioned
Using Partitioned Tables
Dynamic Partitioning: Inserting data into partitioned tables
Code-Along : Partitioning
Bucketing
Introducing Bucketing
The Advantages of Bucketing
How Tables are Bucketed
Using Bucketed Tables
Sampling
Windowing
Windowing Introduced
Windowing - A Simple Example: Cumulative Sum
Windowing - A More Involved Example: Partitioning
Windowing - Special Aggregation Functions
Understanding MapReduce
The basic philosophy underlying MapReduce
MapReduce - Visualized and Explained
MapReduce - Digging a little deeper at every step
MapReduce logic for queries: Behind the scenes
MapReduce Overview: Basic Select-From-Where
MapReduce Overview: Group-By and Having
MapReduce Overview: Joins
Join Optimizations in Hive
Improving Join performance with tables of different sizes
The Where clause in Joins
The Left Semi Join
Map Side Joins: The Inner Join
Map Side Joins: The Left, Right and Full Outer Joins
Map Side Joins: The Bucketed Map Join and the Sorted Merge Join
Hadoop and Hive Install
Hadoop Install Modes
Hadoop Install Step 1 : Standalone Mode
Hadoop Install Step 2 : Pseudo-Distributed Mode
Hive install
Code-Along: Getting started
Appendix
[For Linux/Mac OS Shell Newbies] Path and other Environment Variables
Setting up a Virtual Linux Instance - For Windows Users
Windowing - A Simple Example: Cumulative Sum
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock