Support Questions
Find answers, ask questions, and share your expertise
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Merging multiple hive partitions into one Partition .

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 .

Don't have an account?
Coming from Hortonworks? Activate your account here