Skip to content
Analyticshut
  • Home
  • AWSExpand
    • IAM
    • S3
  • Big DataExpand
    • Spark
    • Hive
    • Sqoop
    • HDFS
  • Kafka
Analyticshut

Partition

MSCK Repair – Fixing Partitions in Hive Table
Hive

MSCK Repair – Fixing Partitions in Hive Table

ByMahesh Mogal August 29, 2020February 12, 2021

We will learn how to add multiple partitions to hive table using msck repair table command in hive.

msck repair hive

Read More MSCK Repair – Fixing Partitions in Hive TableContinue

Inserting Data In Hive Partitioned tables
Hive

Inserting Data In Hive Partitioned tables

ByMahesh Mogal August 27, 2020February 12, 2021

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.

inserting data to hive partition

Read More Inserting Data In Hive Partitioned tablesContinue

Alter Table Partitions in Hive
Hive

Alter Table Partitions in Hive

ByMahesh Mogal August 19, 2020February 12, 2021

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.

altering hive table partition

Read More Alter Table Partitions in HiveContinue

Static vs Dynamic Partitioning in Hive
Hive

Static vs Dynamic Partitioning in Hive

ByMahesh Mogal August 17, 2020February 12, 2021

Hive supports Static and Dynamic Partitions. Let us understand what is difference between them and their use cases.

static vs dynamic

Read More Static vs Dynamic Partitioning in HiveContinue

Partitioning in Hive
Hive

Partitioning in Hive

ByMahesh Mogal August 15, 2020February 12, 2021

Using Partitioning, We can increase hive query performance. But if we do not choose partitioning column correctly it can create small file issue.

Partitioning in Hive

Read More Partitioning in HiveContinue

  • Contact
  • About Me
  • Privacy Policy
  • Sitemap

© 2023 Analyticshut

  • Home
  • AWS
    • IAM
    • S3
  • Big Data
    • Spark
    • Hive
    • Sqoop
    • HDFS
  • Kafka