| set hive.archive.enabled = true; |
| -- Tests trying to archive outer partition group containing other partition inside. |
| -- 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='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 ARCHIVE PARTITION (ds='2008-04-08'); |
