From 0 to 1: Hive for Processing Big Data

Course Curriculum

Chapter 1: You, Us & This Course

Lecture 1: You, Us & This Course

Chapter 2: Introducing Hive

Lecture 1: Hive: An Open-Source Data Warehouse

Lecture 2: Hive and Hadoop

Lecture 3: Hive vs Traditional Relational DBMS

Lecture 4: HiveQL and SQL

Chapter 3: Hadoop and Hive Install

Lecture 1: Hadoop Install Modes

Lecture 2: Hadoop Install Step 1 : Standalone Mode

Lecture 3: Hadoop Install Step 2 : Pseudo-Distributed Mode

Lecture 4: Hive install

Lecture 5: Code-Along: Getting started

Chapter 4: Hadoop and HDFS Overview

Lecture 1: What is Hadoop?

Lecture 2: HDFS or the Hadoop Distributed File System

Chapter 5: Hive Basics

Lecture 1: Primitive Datatypes

Lecture 2: Collections_Arrays_Maps

Lecture 3: Structs and Unions

Lecture 4: Create Table

Lecture 5: Insert Into Table

Lecture 6: Insert into Table 2

Lecture 7: Alter Table

Lecture 8: HDFS

Lecture 9: HDFS CLI – Interacting with HDFS

Lecture 10: Code-Along: Create Table

Lecture 11: Code-Along : Hive CLI

Chapter 6: Built-in Functions

Lecture 1: Three types of Hive functions

Lecture 2: The Case-When statement, the Size function, the Cast function

Lecture 3: The Explode function

Lecture 4: Code-Along : Hive Built – in functions

Chapter 7: Sub-Queries

Lecture 1: Quirky Sub-Queries

Lecture 2: More on subqueries: Exists and In

Lecture 3: Inserting via subqueries

Lecture 4: Code-Along : Use Subqueries to work with Collection Datatypes

Lecture 5: Views

Chapter 8: Partitioning

Lecture 1: Indices

Lecture 2: Partitioning Introduced

Lecture 3: The Rationale for Partitioning

Lecture 4: How Tables are Partitioned

Lecture 5: Using Partitioned Tables

Lecture 6: Dynamic Partitioning: Inserting data into partitioned tables

Lecture 7: Code-Along : Partitioning

Chapter 9: Bucketing

Lecture 1: Introducing Bucketing

Lecture 2: The Advantages of Bucketing

Lecture 3: How Tables are Bucketed

Lecture 4: Using Bucketed Tables

Lecture 5: Sampling

Chapter 10: Windowing

Lecture 1: Windowing Introduced

Lecture 2: Windowing – A Simple Example: Cumulative Sum

Lecture 3: Windowing – A More Involved Example: Partitioning

Lecture 4: Windowing – Special Aggregation Functions

Chapter 11: Understanding MapReduce

Lecture 1: The basic philosophy underlying MapReduce

Lecture 2: MapReduce – Visualized and Explained

Lecture 3: MapReduce – Digging a little deeper at every step

Chapter 12: MapReduce logic for queries: Behind the scenes

Lecture 1: MapReduce Overview: Basic Select-From-Where

Lecture 2: MapReduce Overview: Group-By and Having

Lecture 3: MapReduce Overview: Joins

Chapter 13: Join Optimizations in Hive

Lecture 1: Improving Join performance with tables of different sizes

Lecture 2: The Where clause in Joins

Lecture 3: The Left Semi Join

Lecture 4: Map Side Joins: The Inner Join

Lecture 5: Map Side Joins: The Left, Right and Full Outer Joins

Lecture 6: Map Side Joins: The Bucketed Map Join and the Sorted Merge Join

Chapter 14: Custom Functions in Python

Lecture 1: Custom functions in Python

Lecture 2: Code-Along : Custom Function in Python

Chapter 15: Custom functions in Java

Lecture 1: Introducing UDFs – you're not limited by what Hive offers

Lecture 2: The Simple UDF: The standard function for primitive types

Lecture 3: The Simple UDF: Java implementation for replacetext()

Lecture 4: Generic UDFs, the Object Inspector and DeferredObjects

Lecture 5: The Generic UDF: Java implementation for containsstring()

Lecture 6: The UDAF: Custom aggregate functions can get pretty complex

Lecture 7: The UDAF: Java implementation for max()

Lecture 8: The UDAF: Java implementation for Standard Deviation

Lecture 9: The Generic UDTF: Custom table generating functions

Lecture 10: The Generic UDTF: Java implementation for namesplit()

Chapter 16: SQL Primer – Select Statemets

Lecture 1: Select Statements

Lecture 2: Select Statements 2

Lecture 3: Operator Functions

Chapter 17: SQL Primer – Group By, Order By and Having

Lecture 1: Aggregation Operators Introduced

Lecture 2: The Group By Clause

Lecture 3: More Group By Examples

Lecture 4: Order By

Lecture 5: Having

Chapter 18: SQL Primer – Joins

Lecture 1: Introduction to SQL Joins

Lecture 2: Cross Joins aka Cartesian Joins