Course Code

hivehiveql

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

Testimonials

★★★★★

Liked very much the interactive way of learning.

Luigi Loiacono

It was a very practical training, I liked the hands-on exercises.

Proximus

I was benefit from the good overview, good balance between theory and exercises.

Proximus

I enjoyed the dynamic interaction and “hands-on” the subject, thanks to the Virtual Machine, very stimulating!.

Philippe Job

I was benefit from the competence and knowledge of the trainer.

Jonathan Puvilland

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

Proximus Group

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

Related Categories

Related Courses

Course Discounts

No course discounts for now.

Some of our clients

is growing fast!

We are looking to expand our presence in Malta!

As a Business Development Manager you will:

expand business in Malta
recruit local talent (sales, agents, trainers, consultants)
recruit local trainers and consultants

We offer:

Artificial Intelligence and Big Data systems to support your local operation
high-tech automation
continuously upgraded course catalogue and content
good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!

Data Analysis with Hive/HiveQL Training Course