| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| |
| |
| |
| |
| create table dest30(a int); |
| create table tst_dest30(a int); |
| |
| set hive.test.mode=true; |
| set hive.test.mode.prefix=tst_; |
| |
| explain |
| insert overwrite table dest30 |
| select count(1) from src; |
| |
| insert overwrite table dest30 |
| select count(1) from src; |
| |
| set hive.test.mode=false; |
| |
| select * from tst_dest30; |
| |
| set hive.cbo.returnpath.hiveop=true; |
| |
| explain |
| insert overwrite table dest30 |
| select count(1) from src; |
| |
| insert overwrite table dest30 |
| select count(1) from src; |
| |
| set hive.test.mode=false; |
| |
| select * from tst_dest30; |
| |
| set hive.cbo.returnpath.hiveop=false; |
| |
| |