| set hive.exec.dynamic.partition.mode=nonstrict; |
| set hive.load.dynamic.partitions.scan.specific.partitions=true; |
| |
| CREATE EXTERNAL TABLE test_part_ext_1(i int) PARTITIONED BY (j string, k int); |
| |
| CREATE TABLE test_part(i int,j string); |
| |
| insert into test_part values(1, "test1"), (2, "test2"), (3, "test3"), |
| (4, "test4"), (5, "test5"), (6, "test6"), (7, "test7"), (8, "test8"), (9, "test9"), (10, "test10"); |
| |
| insert overwrite table test_part_ext_1 partition(j, k) select i,j,i from test_part; |
| |
| insert overwrite table test_part_ext_1 partition(j, k) select i,j,i from test_part; |