sql/hive/src/test/resources/ql/src/test/queries/clientnegative/archive_partspec5.q


1
2
3
4
5
6
7
8
9
10

set hive.archive.enabled = true;
-- Tests trying to archive a partition twice.
-- EXCLUDE_HADOOP_MAJOR_VERSIONS(0.17, 0.18, 0.19)

CREATE TABLE srcpart_archived (key string, value string) partitioned by (ds string, hr int, min int);

INSERT OVERWRITE TABLE srcpart_archived PARTITION (ds='2008-04-08', hr='12', min='00')
SELECT key, value FROM srcpart WHERE ds='2008-04-08' AND hr='12';

ALTER TABLE srcpart_archived ARCHIVE PARTITION (ds='2008-04-08', min='00');