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
Installing Apache Hive on Windows Machine using Docker Desktop
Installing Docker on Windows
Downloading Apache Hive Image on Docker
Running Apache Hive on Docker Desktop
Docker Hive Installation Commands
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 Hive can improve performance with ORC format tables?
How does bucketing help in the faster execution of queries?
How to enable bucketing in Hive?
How to enable dynamic partitioning in Hive?
How does partitioning help in the faster execution of queries?
When should we use SORT BY instead of ORDER BY?
Mention what is the difference between order by and sort by in Hive?
What is RegexSerDe?
How is SerDe different from File format in Hive?
How do you write your own custom SerDe?
How to Improve Hive Query Performance With Hadoop?
How Do You Optimize Joins in Hive with Large Datasets?
Difference between indexing and bucketing — which to use when?
Explain the use of CBO (Cost-Based Optimization) in Hive
What are common causes for Hive job slowness and how to debug them?
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?
What are ACID transactions in Hive and how do they work?
How does Hive handle schema evolution in ORC Parquet tables?
How do you handle Slowly Changing Dimensions (SCD) in Hive?
Explain LLAP (Live Long and Process) and its benefits in Hive?
Installing Apache Zeppelin on Ubuntu and Windows(using Docker) machine
Requirements
(Hands On) Installing JAVA
Steps for Installing JAVA
(Hands On) Setting JAVA environments
Steps for Setting JAVA environments
(Hands On) Apache Zeppelin Installation Steps on Ubuntu machine
Steps for Installing Apache Zeppelin on Ubuntu machine
(Hands On) Installing Docker Desktop on Windows 10/11
Steps for Installing Docker on Windows
(Hands On) Running Apache Zeppelin on Docker (Windows)
Steps for Running Apache Zeppelin on Docker
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