| --! 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; |
| |
| |