Created 09-21-2016 08:18 AM
Hi
Can anyone tell me if i can use not in clause in partition , I want to delete all the partitions except one,
alter table <tablename> drop partition(partion_name<>partition_val) doesnt work.
Regards
Suresh
Created 09-26-2016 06:32 AM
Created 09-27-2016 10:09 AM
Created 09-27-2016 12:38 PM
Hi Naveen,
Thanks for your response, however i need know if drop partition not in clause exist, may be my example is confusing .
I have partitions like
load_id ='A'
load_id='B'
load_id='C'
load_id='D'
load_id='E'
load_id='F' and i want to drop all but partitions D&E
Regards
Suresh
Created 09-28-2016 09:52 AM
Created 12-14-2016 09:40 AM
Naveen,
Sorry for the looooooooong delay in response, currently there is no way i guess except listing all partitions that need to be removed manually .
but it would be cool to have "drop partition not in "option when there are huge number of partitions to be purged