Let us help you find the training program you are looking for.

If you can't find what you are looking for, contact us, we'll help you find it. We have over 800 training programs to choose from.


Course Skill Level:


Course Duration:

2 day/s

  • Course Delivery Format:

    Live, instructor-led.

  • Course Category:


  • Course Code:


Who should attend & recommended skills:

Business analysts, software developers, managers with exposure to SQL and ability to navigate Linux command line

Who should attend & recommended skills

  • Business analysts, software developers, managers
  • SQL: Exposure
  • Linux: Ability to navigate command line

About this course

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.

Skills acquired & topics covered

  • Why Hadoop?
  • The Hadoop platform
  • Erasure Coding vs 3x replication
  • Hive Basics
  • New in Hive 3
  • How to run a good query?
  • How to trouble shoot queries?
  • HBase
  • Sqoop
  • Spark
  • The big picture

Course breakdown / modules

  • The motivation for Hadoop
  • Use cases and case studies about Hadoop

  • MapReduce, HDFS, YARN
  • New in Hadoop 3
  • Defining Hive Tables
  • SQL Queries over Structured Data
  • Filtering / Search
  • Aggregations / Ordering
  • Partitions
  • Joins
  • Text Analytics (Semi Structured Data)

  • ACID tables
  • Hive Query Language (HQL)

  • Basics
  • HBase tables – design and use
  • Phoenix driver for HBase tables

  • Tool
  • Architecture
  • Use

  • Overview
  • Spark SQL

  • How Hadoop fits into your architecture
  • Hive vs HBase with Phoenix vs Excel