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
Testimonials
I thought he did a great job of tailoring the experience to the audience. This class is mostly designed to cover data analysis with HIVE, but me and my co-worker are doing HIVE administration with no real data analytics responsibilities.
ian reif - Franchise Tax Board
Fulvio was able to grasp our companies business case and was able to correlate with the course material, almost instantly.
Samuel Peeters - Proximus Group
The handson. The mix practice/theroy
- Proximus Group
The high level principles about Hive, HDFS..
Geert Suys - Proximus Group
The trainer was fantastic and really knew his stuff. I learned a lot about the software I didn't know previously which will help a lot at my job!
Steve McPhail - Alberta Health Services - Information Technology
The competence and knowledge of the trainer
Jonathan Puvilland
Dynamic interaction and "hands on" the subject, thanks to the Virtual Machine, very stimulating!
Philippe Job
good overview, good balance between theory and exercises
Proximus
It was a very practical training, I liked the hands-on exercises.
Proximus
Liked very much the interactive way of learning.