Apache Hive

Course Overview:

In this training you'll learn how to make querying your data much easier. First created at Facebook, Hive is a data warehouse system for Hadoop that facilitates easy data summarization, ad-hoc queries, and the analysis of large datasets stored in Hadoop compatible file systems. Hive is designed to enable easy data summarization, ad-hoc querying and analysis of large volumes of data.

Course Content:

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 Data

♦ 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.

We can assure a 100% job guarantee and Placement. Contact us for Free - Demo.