Installation and configuration
Configure Hive Metastore on MySQL
Start Hiveserver2, Connect Through Beeline and Run Hive Queries
Basic Concepts
Comparison of Storage formats in Hive – TEXTFILE vs ORC vs PARQUET
Managed and External Tables in Hive
Partitioning vs Bucketing in Hive
Some Configuration Properties in Hive
Data Types
Complex data type in Hive: Array
Complex data type in Hive: Struct
Complex data type in Hive: Map
Creating a Hive Table
Creating Hive table using TEXTFILE format and importing data
Creating Hive table using SEQUENCEFILE format and importing data
Creating Hive table using ORC format and importing data
Creating External Hive table and importing data
Creating Partitioned Hive table and importing data
Creating Hive Table Partitioned by Multiple Columns and Importing Data
Creating Bucketed Table in Hive and Inserting Data
Creating Bucketed and Sorted Table in Hive and Inserting Data
Inserting Data into Table
Different Approaches for Inserting Data into a Hive Table
Different Approaches for Inserting Data Using Static Partitioning into a Partitioned Hive Table
Different Approaches for Inserting Data Using Dynamic Partitioning into a Partitioned Hive Table
Hive Queries
Create, Use and Drop a Database in Hive
Select Query with Where clause in Hive
Select Query with Group by clause in Hive
Select Query with Joins in Hive
Hive Queries– Sort by, Order by, Cluster by, and Distribute By
Export and Import a Hive Table/Partition
Running Sampling Queries in Hive
Hive-JDBC
Java Code for Running HIVE queries through JDBC