Duration
7 hours (usually 1 day including breaks)
Overview
This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
Course Outline
Hive Overview
- Architecture and design
- Aata types
- SQL support in Hive
- Creating Hive tables and querying
- Partitions
- Joins
- Text processing
- labs : various labs on processing data with Hive
DQL (Data Query Language) in Detail
- SELECT clause
- Column aliases
- Table aliases
- Date types and Date functions
- Group function
- Table joins
- JOIN clause
- UNION operator
- Nested queries
- Correlated subqueries