7 hours (usually 1 day including breaks)
This course covers how to use Hive SQL language (AKA: Hive HQL, SQL on Hive, HiveQL) for people who extract data from Hive
- Architecture and design
- Aata types
- SQL support in Hive
- Creating Hive tables and querying
- 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
Liked very much the interactive way of learning.
It was a very practical training, I liked the hands-on exercises.
I was benefit from the good overview, good balance between theory and exercises.
I enjoyed the dynamic interaction and “hands-on” the subject, thanks to the Virtual Machine, very stimulating!.
I was benefit from the competence and knowledge of the trainer.
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 high level principles about Hive, HDFS..
Geert Suys - Proximus Group
The handson. The mix practice/theroy
Fulvio was able to grasp our companies business case and was able to correlate with the course material, almost instantly.
Samuel Peeters - Proximus Group
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