Apache Hive Training

Apache Hive Syllabus

Introduction

  • Hadoop
  • What is Hive?
  • Features of Hive
  • Architecture of Hive
  • Working of Hive

HIVE Installation

  • Verifying JAVA Installation
  • Verifying Hadoop Installation
  • Downloading Hive
  • Installing Hive
  • Configuring Hive
  • Downloading and Installing Apache
  • Derby
  • Configuring Metastore of Hive
  • Verifying Hive Installation

HIVE Data Types

  • Column Types
  • Literals
  • Null Value
  • Complex Types
  • Apache Hive

Create Database

  • Create Dat
  • abase Statement

DROP Database

  • Drop Database Statement

CREATE Table

  • Create Table Statement
  • Load Data Statement

ALTER Table

  • Alter Table Statement
  • Rename To... Statement
  • Change Statement
  • Add Columns Statement
  • Replace Statement

DROP Table

  • Drop Table Statement

Partitioning

  • Adding a Partition
  • Renaming a Partition
  • Dropping a Partition

BUILt-IN OPERATORS

  • Relational Operators
  • Arithmetic Operators
  • Logical Operators
  • Complex Operators

BUILT-IN FUNCTIONS

  • Apache Hive
  • Built-In Functions
  • Aggregate Functions

Views And Indexes

  • Creating a View
  • Example
  • Dropping a View
  • Creating an Index
  • Example
  • Dropping an Index

HIVE QL SELECT...WHERE

  • Syntax
  • Example

HIVEQL SELECT...ORDER BY

  • Syntax
  • Example

HIVEQL GROUP BY

  • Syntax
  • Example

HIVEQL JOINS

  • Syntax
  • Example
  • JOIN
  • LEFT OUTER JOIN
  • RIGHT OUTER JOIN
  • FULL OUTER JOIN
Quick Enroll