Apache Hive
Online Apache Hive Training will make you an expert in controlling and managing Big data without hassles. Hive is also an extremely sought after course for people looking to develop expertise in Hadoop, as it imparts structuredness to big data when the implementation is done in hadoop. (Hadoop Hive)
Duration: 30hrs
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 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
