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.

Updating the bucketted Hive table

Solved Go to solution
Highlighted

Updating the bucketted Hive table

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

Accepted Solutions

Re: Updating the bucketted Hive table

Expert Contributor

That's not possible w/o rewriting data.

1 REPLY 1

Re: Updating the bucketted Hive table

Expert Contributor

That's not possible w/o rewriting data.