arrow_back
Introduction
Introduction to Course
Introduction to Apache Hive
Hive Architecture
How a Hive query flows through the system.
(Optional) Introduction to Big Data
(Optional) What is Hadoop
Hive Features
Hive Limitation
Installing Apache Hive on Ubuntu (Linux) Machine
Installation Steps of Hadoop
Installation Steps of Apache Hive
Hive Data Model
Hive Data Model Diagram
Tables
Partitions
Buckets or Clusters
Hive Data Types
Hive Data Types
Primitive Type
Complex Type
HIVE Data Definition Language.
Create Database
Drop Database
Alter Database
Use Database
Show Databases
Descbribe Databases
Create Table
Create Table (Hands On)
Create Table (Hands On) with all Primitive Datatype
Downloadable materials
Create Table (Hands On) with all Complex Datatype
Downloadable materials for Table
Managed and External Tables
Managed and External Tables (Hands On)
Storage Formats
Show Tables
Describe Tables
Drop Table
Alter Table
Truncate Table
HIVE Data Manipulation Language
LOAD
SELECT
INSERT
UPDATE
Downloadable materials for Update
DELETE
Hive View, Metastore, Partitions, and Bucketing
View
View (Hands On)
Metastore
Partitions
Partitions (Hands On)
Bucketing
Bucketing (Hands On)
Hive Interactive Shell Commands
Execute Hive Queries in “One Shot” Commands
Executing Hive Queries from Files
Hive Variable
Hive Built-In Functions
Date Functions
Mathematical Functions
String Functions
Built-in Operators
Relational Operators
Arithmatic Operators
Logical Operators
String Operators
Hive Join
Joins
Inner Join (Hands On)
Left Outer Join (Hands On)
Right Outer Join (Hands On)
Full Outer Join (Hands On)
Working with XML and JSON
Loading XML in Hive
Loading JSON in Hive
XML
JSON
Frequently Asked Interview Question and Answers
How to create HIVE Table with multi character delimiter?
How to load Data from a .txt file to Table Stored as ORC in Hive?
How to skip header rows from a table in Hive?
Create single Hive table for small files without degrading performance in Hive?
How will you consume this CSV file into the Hive warehouse using built SerDe?
Is it possible to change the default location of a managed table?
Can hive queries be executed from script files? How?
Can we run unix shell commands from hive? Give example?
Hands On Projects (2 Projects)
Installing Apache Zeppelin (0.10.1)
(Hands On) Downloading files
Data Files for the Project
(Hands On) Configure Hive Interpreter in Apache Zeppelin
Configure Hive Interpreter in Apache Zeppelin
Hadoop Configuration Setting
Download Source Code for Project
Source Code
Starting Hadoop,Hive, Zeppelin and Uploading Source Code
Project 1 Part 1
Project 1 Part 2
Project 1 Part 3
Project 1 Part 4
Project 1 Part 5
Project 2 Part 1
Project 2 Part 2
Project 2 Part 3
Project 2 Part 4
Project 2 Part 5
Project 2 Part 6