Introduction
Welcome
()
What you should know before watching this course
()
Using the exercise files
()
1. Hive Concepts and Setup
Why use Hive
()
How Hive works
()
Setting up our demo environment
()
2. Working with Data in Hive
Understanding table structures in Hive
()
Creating tables in Hive
()
Handling CSV files in Hive
()
Partitioning tables
()
3. Retrieving Data from Hive
Simple SELECT statement
()
Retrieving data from complex structures
()
4. Aggregating Data
Simple aggregations
()
Enhanced aggregations with grouping sets
()
Using CUBE and ROLLUP
()
5. Filtering Results
Simple filter with the WHERE clause
()
Filtering aggregates with HAVING clause
()
Finding similar values with LIKE
()
6. Joining Tables
Combining tables with JOIN
()
When to use SEMI JOIN
()
Joining multiple tables together
()
7. Manipulating Data
Types of data manipulation functions
()
String functions
()
Math functions
()
Date functions
()
Conditional functions
()
Ex_Files_BigData_Hive.zip
(4.3 MB)