blob: 97715251b3d35201bbcc0a53458fbb3b51efb4e6 [file] [log] [blame]
create temporary table mp (a string) partitioned by (b string, c string);
alter table mp add partition (b='1', c='1');
alter table mp add partition (b='1', c='2');
alter table mp add partition (b='2', c='2');
show partitions mp;
set hive.exec.drop.ignorenonexistent=false;
-- Can't use DROP PARTITION if the partition doesn't exist and IF EXISTS isn't specified
alter table mp drop partition (b='3');