Support Questions
Find answers, ask questions, and share your expertise

Merging multiple hive partitions into one Partition .

Hello Experts,

I have a hive table which has 2 level partition Date, Hour . The job which populates this table runs multiple times so it creates multiple hour partitions each day, this results in too many partitions, just wondering whether we have an hive command to merge a set of partitions .

example : before merge :

date = 2019-01-01

hour =1

hour = 6

hour = 11

hour = x

After merger :

date = 2019-01-01

Hour = 1 {This partition should contain all the files} .

Please let me know if something is not clear .