blob: d744f2487694c81e07b7c6e802aaaa336f0c70e9 [file] [log] [blame]
set hive.archive.enabled = true;
-- Tests trying to insert into archived partition.
-- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)
CREATE TABLE tstsrcpart LIKE srcpart;
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');
INSERT OVERWRITE TABLE tstsrcpart PARTITION (ds='2008-04-08', hr='12')
SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';