Support Questions

Find answers, ask questions, and share your expertise

Updating the bucketted Hive table

avatar

I have a external table which is created with partitions and buckets(256). Now if have to reduce the no of partitions. As it is an external table I have drop and recreate without affecting the data. Now the underlying HDFS location will have 256 files created under each partition. Is there any way that I change the 256 files equal to no of buckets which I have used in the new DDL? I know I can achieve this by re-processing the data again. But just wanted to know If I can achieve this by enabling any property?

1 ACCEPTED SOLUTION

avatar
Super Collaborator

That's not possible w/o rewriting data.

View solution in original post

1 REPLY 1

avatar
Super Collaborator

That's not possible w/o rewriting data.