Course Code: hivehiveql
Duration: 7 hours
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
Sites Published:

United Arab Emirates - Data Analysis with Hive/HiveQL

Qatar - Data Analysis with Hive/HiveQL

Egypt - Data Analysis with Hive/HiveQL

Saudi Arabia - Data Analysis with Hive/HiveQL

South Africa - Data Analysis with Hive/HiveQL

Brasil - Curso Análise de dados Hive/HiveQL

Canada - Data Analysis with Hive/HiveQL

中国 - Data Analysis with Hive/HiveQL

香港 - Data Analysis with Hive/HiveQL

澳門 - Data Analysis with Hive/HiveQL

台灣 - Data Analysis with Hive/HiveQL

USA - Data Analysis with Hive/HiveQL

Österreich - Data Analysis with Hive/HiveQL

Schweiz - Data Analysis with Hive/HiveQL

Deutschland - Data Analysis with Hive/HiveQL

Czech Republic - Data Analysis with Hive/HiveQL

Denmark - Data Analysis with Hive/HiveQL

Estonia - Data Analysis with Hive/HiveQL

Finland - Data Analysis with Hive/HiveQL

Greece - Data Analysis with Hive/HiveQL

Magyarország - Data Analysis with Hive/HiveQL

Ireland - Data Analysis with Hive/HiveQL

Luxembourg - Data Analysis with Hive/HiveQL

Latvia - Data Analysis with Hive/HiveQL

España - Análisis de Datos con Hive / HiveQL

Italia - Data Analysis with Hive/HiveQL

Lithuania - Data Analysis with Hive/HiveQL

Nederland - Data Analysis with Hive/HiveQL

Norway - Data Analysis with Hive/HiveQL

Portugal - Curso Análise de dados Hive/HiveQL

România - Data Analysis with Hive/HiveQL

Sverige - Data Analysis with Hive/HiveQL

Türkiye - Data Analysis with Hive/HiveQL

Malta - Data Analysis with Hive/HiveQL

Belgique - Data Analysis with Hive/HiveQL

France - Data Analysis with Hive/HiveQL

日本 - Data Analysis with Hive/HiveQL

Australia - Data Analysis with Hive/HiveQL

Malaysia - Data Analysis with Hive/HiveQL

New Zealand - Data Analysis with Hive/HiveQL

Philippines - Data Analysis with Hive/HiveQL

Singapore - Data Analysis with Hive/HiveQL

Thailand - Data Analysis with Hive/HiveQL

Vietnam - Data Analysis with Hive/HiveQL

India - Data Analysis with Hive/HiveQL

Argentina - Análisis de Datos con Hive / HiveQL

Chile - Análisis de Datos con Hive / HiveQL

Costa Rica - Análisis de Datos con Hive / HiveQL

Ecuador - Análisis de Datos con Hive / HiveQL

Guatemala - Análisis de Datos con Hive / HiveQL

Colombia - Análisis de Datos con Hive / HiveQL

México - Análisis de Datos con Hive / HiveQL

Panama - Análisis de Datos con Hive / HiveQL

Peru - Análisis de Datos con Hive / HiveQL

Uruguay - Análisis de Datos con Hive / HiveQL

Venezuela - Análisis de Datos con Hive / HiveQL

Polska - Data Analysis with Hive/HiveQL

United Kingdom - Data Analysis with Hive/HiveQL

South Korea - Data Analysis with Hive/HiveQL

Pakistan - Data Analysis with Hive/HiveQL

Sri Lanka - Data Analysis with Hive/HiveQL

Bulgaria - Data Analysis with Hive/HiveQL

Bolivia - Análisis de Datos con Hive / HiveQL

Indonesia - Data Analysis with Hive/HiveQL

Kazakhstan - Data Analysis with Hive/HiveQL

Moldova - Data Analysis with Hive/HiveQL

Morocco - Data Analysis with Hive/HiveQL

Tunisia - Data Analysis with Hive/HiveQL

Kuwait - Data Analysis with Hive/HiveQL

Oman - Data Analysis with Hive/HiveQL

Slovakia - Data Analysis with Hive/HiveQL

Kenya - Data Analysis with Hive/HiveQL

Nigeria - Data Analysis with Hive/HiveQL

Botswana - Data Analysis with Hive/HiveQL

Slovenia - Data Analysis with Hive/HiveQL

Croatia - Data Analysis with Hive/HiveQL

Serbia - Data Analysis with Hive/HiveQL

Bhutan - Data Analysis with Hive/HiveQL

Nepal - Data Analysis with Hive/HiveQL

Uzbekistan - Data Analysis with Hive/HiveQL