Support Questions
Find answers, ask questions, and share your expertise
Announcements
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 .

Highlighted

Merging multiple hive partitions into one Partition .

New Contributor

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 .