// this should drop all partitions except where c='US'alter table ptestfilter drop partition (c<>'US', d>'0');// alternatively you could also use NOT EQUALS operator to accomplish the same thingalter table ptestfilter drop partition (c != 'US', d>'0');