MSCK Repair – Fixing Partitions in Hive Table
We will learn how to add multiple partitions to hive table using msck repair table command in hive.
Inserting Data In Hive Partitioned tables
In this blog, we will learn how to insert data in partitions in hive table. We will write queries to insert data in static as well as dynamic partitions.
Alter Table Partitions in Hive
We have created partitioned tables, inserted data into them. Now, we will learn how to drop some partition or add a new partition to the table in hive.
Static vs Dynamic Partitioning in Hive
Hive supports Static and Dynamic Partitions. Let us understand what is difference between them and their use cases.
Partitioning in Hive
Using Partitioning, We can increase hive query performance. But if we do not choose partitioning column correctly it can create small file issue.