Apache Hive Training

Apache Hive Training

Course Length:
Delivery Methods:
Course Topics
  • Learn to get started using Hive.
Course Overview

Hive is de-facto standard the SQL interface into Big Data. Today, it offers ACID tables, storage requirements reduction by the factor of 2 with erasure coding, HBase integration with Phoenix, and much more.

However, in order to achieve efficiency, one must be familiar with the best practices of the HQL language, compare different tools for looking at your data, whether it be Hive, Phoenix HBase, or plan Excel.

This course will explain the capabilities of Hive, HQL dialects, and best practices.

Course Outline
  1. Why Hadoop?
    1. The motivation for Hadoop
    2. Use cases and case studies about Hadoop
  2. The Hadoop platform
    1. MapReduce, HDFS, YARN
    2. New in Hadoop 3
      1. Erasure Coding vs 3x replication
  3. Hive Basics
    1. Defining Hive Tables
    2. SQL Queries over Structured Data
    3. Filtering / Search
    4. Aggregations / Ordering
    5. Partitions
    6. Joins
    7. Text Analytics (Semi Structured Data)
  4. Hive Advanced
    1. Transformation, Aggregation
    2. Working with Dates, Timestamps, and Arrays
    3. Converting Strings to Date, Time, and Numbers
    4. Create new Attributes, Mathematical Calculations, Windowing Functions
    5. Use Character and String Functions
    6. Binning and Smoothing
    7. Processing JSON Data
    8. Different Engines
      1. Tez Engine
      2. MapReduce
  5. New in Hive 3
    1. ACID tables
    2. Hive Query Language (HQL)
      1. How to run a good query?
      2. How to trouble shoot queries?
  6. HBase
    1. Basics
    2. HBase tables - design and use
    3. Phoenix driver for HBase tables
  7. Sqoop
    1. Tool
    2. Architecture
    3. Use
  8. Spark
    1. Overview
    2. Spark SQL
  9. The big picture
    1. How Hadoop fits into your architecture
    2. Hive vs HBase with Phoenix vs Excel
Class Materials

Each student in our Live Online and our Onsite classes receives a comprehensive set of materials, including course notes and all the class examples.

Class Prerequisites

Experience in the following is required for this Hadoop class:

  • Exposure to SQl
  • Ability to navigate the Linux command line.

Request a Private Class
  • Private Class for your Team
  • Online or On-location
  • Customizable
  • Expert Instructors
Request Pricing