Added: hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_table_missing2.q URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_table_missing2.q?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_table_missing2.q (added) +++ hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_table_missing2.q Thu Apr 25 12:24:28 2013 @@ -0,0 +1,8 @@ +CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING); +SHOW PARTITIONS exchange_part_test1; + +ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05'); +SHOW PARTITIONS exchange_part_test1; + +-- exchange_part_test2 table does not exist thus this query will fail +alter table exchange_part_test1 exchange partition (ds='2013-04-05') with table exchange_part_test2;
Added: hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_test.q URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_test.q?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_test.q (added) +++ hive/trunk/ql/src/test/queries/clientnegative/exchange_partition_neg_test.q Thu Apr 25 12:24:28 2013 @@ -0,0 +1,11 @@ +CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING); +CREATE TABLE exchange_part_test2 (f1 string, f2 string) PARTITIONED BY (ds STRING); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05'); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +-- exchange_part_test1 and exchange_part_test2 do not have the same scheme and thus they fail +ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2; Added: hive/trunk/ql/src/test/queries/clientpositive/exchange_partition.q URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exchange_partition.q?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/queries/clientpositive/exchange_partition.q (added) +++ hive/trunk/ql/src/test/queries/clientpositive/exchange_partition.q Thu Apr 25 12:24:28 2013 @@ -0,0 +1,12 @@ +CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING); +CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05'); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2; +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; Added: hive/trunk/ql/src/test/queries/clientpositive/exchange_partition2.q URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exchange_partition2.q?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/queries/clientpositive/exchange_partition2.q (added) +++ hive/trunk/ql/src/test/queries/clientpositive/exchange_partition2.q Thu Apr 25 12:24:28 2013 @@ -0,0 +1,12 @@ +CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING); +CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1'); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05', hr='1') WITH TABLE exchange_part_test2; +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; Added: hive/trunk/ql/src/test/queries/clientpositive/exchange_partition3.q URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/queries/clientpositive/exchange_partition3.q?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/queries/clientpositive/exchange_partition3.q (added) +++ hive/trunk/ql/src/test/queries/clientpositive/exchange_partition3.q Thu Apr 25 12:24:28 2013 @@ -0,0 +1,14 @@ +CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING); +CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1'); +ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2'); +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; + +-- This will exchange both partitions hr=1 and hr=2 +ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2; +SHOW PARTITIONS exchange_part_test1; +SHOW PARTITIONS exchange_part_test2; Modified: hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out?rev=1475722&r1=1475721&r2=1475722&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out (original) +++ hive/trunk/ql/src/test/results/clientnegative/alter_view_as_select_with_partition.q.out Thu Apr 25 12:24:28 2013 @@ -61,5 +61,5 @@ WHERE key=86 View Expanded Text: SELECT `src`.`key`, `src`.`value` FROM `default`.`src` WHERE `src`.`key`=86 -FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has paritions +FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has partitions The following view has partition, it could not be replaced: testViewPart Modified: hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out?rev=1475722&r1=1475721&r2=1475722&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out (original) +++ hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view1.q.out Thu Apr 25 12:24:28 2013 @@ -20,5 +20,5 @@ POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@v POSTHOOK: Output: default@v@ds=1/hr=2 -FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has paritions +FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has partitions The following view has partition, it could not be replaced: v Modified: hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out?rev=1475722&r1=1475721&r2=1475722&view=diff ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out (original) +++ hive/trunk/ql/src/test/results/clientnegative/create_or_replace_view2.q.out Thu Apr 25 12:24:28 2013 @@ -20,5 +20,5 @@ POSTHOOK: type: ALTERTABLE_ADDPARTS POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@v POSTHOOK: Output: default@v@ds=1/hr=2 -FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has paritions +FAILED: SemanticException [Error 10217]: Cannot replace a view with CREATE VIEW or REPLACE VIEW or ALTER VIEW AS SELECT if the view has partitions The following view has partition, it could not be replaced: v Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_incomplete_partition.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_incomplete_partition.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_incomplete_partition.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_incomplete_partition.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,43 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='h1') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='h1') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=h1 +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='h2') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='h2') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=h2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=h1 +ds=2013-04-05/hr=h2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +FAILED: SemanticException [Error 10234]: Parition values specifed are not continuous. A subpartition value is specified without specififying the parent partition's value {hr=h1} Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,43 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05 +PREHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test2 +POSTHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test2 +POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05 +FAILED: SemanticException [Error 10118]: Partition already exists [exchange_part_test2(ds=2013-04-05)] Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists2.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists2.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists2.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,51 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=1 +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=2 +PREHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05', hr='3') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test2 +POSTHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05', hr='3') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test2 +POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05/hr=3 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 +ds=2013-04-05/hr=2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=3 +FAILED: SemanticException [Error 10118]: Partition already exists [exchange_part_test2(ds=2013-04-05/hr=3)] Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists3.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists3.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists3.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_exists3.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,51 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=1 +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=2 +PREHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05', hr='1') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test2 +POSTHOOK: query: ALTER TABLE exchange_part_test2 ADD PARTITION (ds='2013-04-05', hr='1') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test2 +POSTHOOK: Output: default@exchange_part_test2@ds=2013-04-05/hr=1 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 +ds=2013-04-05/hr=2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 +FAILED: SemanticException [Error 10118]: Partition already exists [exchange_part_test2(ds=2013-04-05/hr=1)] Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_missing.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_missing.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_missing.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_partition_missing.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,15 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +FAILED: SemanticException [Error 10006]: Partition not found {ds=2013-04-05} Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1 @@ +FAILED: SemanticException [Error 10001]: Table not found t1 Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing2.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing2.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_table_missing2.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,22 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05 +FAILED: SemanticException [Error 10001]: Table not found exchange_part_test2 Added: hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_test.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_test.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_test.q.out (added) +++ hive/trunk/ql/src/test/results/clientnegative/exchange_partition_neg_test.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,35 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string, f2 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string, f2 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +FAILED: SemanticException [Error 10235]: Tables have incompatible schemas and their partitions cannot be exchanged. Added: hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/exchange_partition.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,47 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2 +PREHOOK: type: null +POSTHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2 +POSTHOOK: type: null +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05 Added: hive/trunk/ql/src/test/results/clientpositive/exchange_partition2.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exchange_partition2.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/exchange_partition2.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/exchange_partition2.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,47 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=1 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05', hr='1') WITH TABLE exchange_part_test2 +PREHOOK: type: null +POSTHOOK: query: ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05', hr='1') WITH TABLE exchange_part_test2 +POSTHOOK: type: null +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 Added: hive/trunk/ql/src/test/results/clientpositive/exchange_partition3.q.out URL: http://svn.apache.org/viewvc/hive/trunk/ql/src/test/results/clientpositive/exchange_partition3.q.out?rev=1475722&view=auto ============================================================================== --- hive/trunk/ql/src/test/results/clientpositive/exchange_partition3.q.out (added) +++ hive/trunk/ql/src/test/results/clientpositive/exchange_partition3.q.out Thu Apr 25 12:24:28 2013 @@ -0,0 +1,58 @@ +PREHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test1 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test1 +PREHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +PREHOOK: type: CREATETABLE +POSTHOOK: query: CREATE TABLE exchange_part_test2 (f1 string) PARTITIONED BY (ds STRING, hr STRING) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: default@exchange_part_test2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='1') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=1 +PREHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2') +PREHOOK: type: ALTERTABLE_ADDPARTS +PREHOOK: Input: default@exchange_part_test1 +POSTHOOK: query: ALTER TABLE exchange_part_test1 ADD PARTITION (ds='2013-04-05', hr='2') +POSTHOOK: type: ALTERTABLE_ADDPARTS +POSTHOOK: Input: default@exchange_part_test1 +POSTHOOK: Output: default@exchange_part_test1@ds=2013-04-05/hr=2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 +ds=2013-04-05/hr=2 +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: -- This will exchange both partitions hr=1 and hr=2 +ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2 +PREHOOK: type: null +POSTHOOK: query: -- This will exchange both partitions hr=1 and hr=2 +ALTER TABLE exchange_part_test1 EXCHANGE PARTITION (ds='2013-04-05') WITH TABLE exchange_part_test2 +POSTHOOK: type: null +PREHOOK: query: SHOW PARTITIONS exchange_part_test1 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test1 +POSTHOOK: type: SHOWPARTITIONS +PREHOOK: query: SHOW PARTITIONS exchange_part_test2 +PREHOOK: type: SHOWPARTITIONS +POSTHOOK: query: SHOW PARTITIONS exchange_part_test2 +POSTHOOK: type: SHOWPARTITIONS +ds=2013-04-05/hr=1 +ds=2013-04-05/hr=2
