blob: 73a684f2d8acf30fb15f8cb8403f7e67e45446df [file] [log] [blame]
--! qt:dataset:srcpart
set hive.archive.enabled = true;
-- Tests trying to unarchive outer partition group containing other partition inside.
CREATE TABLE tstsrcpart LIKE srcpart;
INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='11')
SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='11';
INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';
ALTER TABLE tstsrcpart ARCHIVE PARTITION (ds='2008-04-08', hr='12');
ALTER TABLE tstsrcpart UNARCHIVE PARTITION (ds='2008-04-08');