| --! qt:disabled:disabled by 38f7a7f3839e in 2018 |
| --! qt:dataset:src |
| explain extended create table t as select * from src union all select * from src; |
| |
| create table t as select * from src union all select * from src; |
| |
| select count(1) from t; |
| |
| desc formatted t; |
| |
| create table tt as select * from t union all select * from src; |
| |
| desc formatted tt; |
| |
| drop table tt; |
| |
| create table tt as select * from src union all select * from t; |
| |
| desc formatted tt; |
| |
| create table t1 like src; |
| create table t2 like src; |
| create table t3 like src; |
| |
| set hive.explain.user=true; |
| explain from (select * from src union all select * from src)s |
| insert overwrite table t1 select * |
| insert overwrite table t2 select * |
| insert overwrite table t3 select *; |
| |
| from (select * from src union all select * from src)s |
| insert overwrite table t1 select * |
| insert overwrite table t2 select * |
| insert overwrite table t3 select *; |
| |
| desc formatted t1; |
| desc formatted t2; |
| |
| select count(1) from t1; |