--! qt:disabled:multi_insert_stuff HIVE-23565
--! qt:dataset:src
set hive.stats.column.autogather=false;
set hive.mapred.mode=nonstrict;
set hive.explain.user=false;
set hive.exec.dynamic.partition.mode=nonstrict;

drop table intermediate_n3_temp;

create temporary table intermediate_n3_temp(key int) partitioned by (p int) stored as orc;
insert into table intermediate_n3_temp partition(p='455') select distinct key from src where key >= 0 order by key desc limit 2;
insert into table intermediate_n3_temp partition(p='456') select distinct key from src where key is not null order by key asc limit 2;
insert into table intermediate_n3_temp partition(p='457') select distinct key from src where key >= 100 order by key asc limit 2;

drop table multi_partitioned_temp;

create temporary table multi_partitioned_temp (key int, key2 int) partitioned by (p int);

from intermediate_n3_temp
insert into table multi_partitioned_temp partition(p=1) select p, key
insert into table multi_partitioned_temp partition(p=2) select key, p;

select * from multi_partitioned_temp order by key, key2, p;
desc formatted multi_partitioned_temp;

from intermediate_n3_temp
insert overwrite table multi_partitioned_temp partition(p=2) select p, key
insert overwrite table multi_partitioned_temp partition(p=1) select key, p;

select * from multi_partitioned_temp order by key, key2, p;
desc formatted multi_partitioned_temp;

from intermediate_n3_temp
insert into table multi_partitioned_temp partition(p=2) select p, key
insert overwrite table multi_partitioned_temp partition(p=1) select key, p;

select * from multi_partitioned_temp order by key, key2, p;
desc formatted multi_partitioned_temp;

from intermediate_n3_temp
insert into table multi_partitioned_temp partition(p) select p, key, p
insert into table multi_partitioned_temp partition(p=1) select key, p;

select key, key2, p from multi_partitioned_temp order by key, key2, p;
desc formatted multi_partitioned_temp;

from intermediate_n3_temp
insert into table multi_partitioned_temp partition(p) select p, key, 1
insert into table multi_partitioned_temp partition(p=1) select key, p;

select key, key2, p from multi_partitioned_temp order by key, key2, p;
desc formatted multi_partitioned_temp;

drop table multi_partitioned_temp;

drop table intermediate_n3_temp;