https://community.cloudera.com/t5/Archives-of-Support-Questions/Updating-the-bucketted-Hive-table/m-p/190449#M70898 <P>That's not possible w/o rewriting data.</P> Wed, 08 Nov 2017 01:53:46 GMT ekoifman 2017-11-08T01:53:46Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Updating-the-bucketted-Hive-table/m-p/190448#M70897 <P>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?</P> Tue, 07 Nov 2017 20:35:48 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Updating-the-bucketted-Hive-table/m-p/190448#M70897 balavignesh_nag 2017-11-07T20:35:48Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Updating-the-bucketted-Hive-table/m-p/190449#M70898 <P>That's not possible w/o rewriting data.</P> Wed, 08 Nov 2017 01:53:46 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Updating-the-bucketted-Hive-table/m-p/190449#M70898 ekoifman 2017-11-08T01:53:46Z