Hive course content

Introduction

⚪ What is Hive? ⚪ Features of Hive ⚪ Architecture of Hive ⚪ Working of Hive

HIVE Installation

⚪ Downloading Hive ⚪ Installing Hive ⚪ Configuring Hive ⚪ Configuring Meta store of Hive ⚪ Verifying Hive Installation

HIVE Data Types

⚪ Column Types ⚪ Literals ⚪ Null Value ⚪ Complex Types

Create Database

⚪ Create Database ⚪ Database 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

HIVE QL SELECT...ORDER BY

 

⚪ Syntax ⚪ Example

HIVE QL GROUP BY

⚪ Syntax ⚪ Example

HIVE QL JOINS

⚪ Syntax ⚪ Example ⚪ JOIN ⚪ LEFT OUTER JOIN ⚪ RIGHT OUTER JOIN ⚪ FULL OUTER JOIN

Our services

Advanced  Analytics

Data Science

Internet of Things

Digital Transformation

Artificial Intelligence

Application Development

Reach Us

Athena AI Solutions Pvt.Ltd
55, Planters Road, ATT Colony,
Coimbatore -641018
Phone no :9655310475

EMAIL: contact@athena-io.com