Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
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
7 Hours
Testimonials (7)
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
Course - Data Analysis with Hive/HiveQL
Fulvio was able to grasp our companies business case and was able to correlate with the course material, almost instantly.
Samuel Peeters - Proximus Group
Course - Data Analysis with Hive/HiveQL
The high level principles about Hive, HDFS..
Geert Suys - Proximus Group
Course - Data Analysis with Hive/HiveQL
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
Course - Data Analysis with Hive/HiveQL
I was benefit from the competence and knowledge of the trainer.
Jonathan Puvilland
Course - Data Analysis with Hive/HiveQL
I enjoyed the dynamic interaction and “hands-on” the subject, thanks to the Virtual Machine, very stimulating!.
Philippe Job
Course - Data Analysis with Hive/HiveQL
Liked very much the interactive way of learning.
