Member since
04-23-2019
5
Posts
0
Kudos Received
0
Solutions
11-30-2022
06:40 AM
In this solution, we are able to change position of a single column. Is it possible to change positions of 2 or more consecutive columns in the same way ?
... View more
05-07-2019
09:15 PM
1 Kudo
I don't see super easy way, but below might help: 1. if this table is not external, make it external first: ALTER TABLE <table> SET TBLPROPERTIES('EXTERNAL'='TRUE') 2. drop the table 3. create a new table and define same partition column 4. manually move files in another 4 partition directories into the 6 partition directories that you want to keep evenly 5. remove the empty directories under the table 6. msck repair table to recover the 6 current partitions Hope above can help. Eric
... View more