| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| create table src_multi1_n2 like src; |
| create table src_multi2_n3 like src; |
| create table src_multi3 like src; |
| set hive.stats.dbclass=fs; |
| -- Testing the case where a map work contains both shuffling (ReduceSinkOperator) |
| -- and inserting to output table (FileSinkOperator). |
| |
| explain |
| from src |
| insert overwrite table src_multi1_n2 select key, count(1) group by key order by key |
| insert overwrite table src_multi2_n3 select value, count(1) group by value order by value |
| insert overwrite table src_multi3 select * where key < 10; |
| |
| from src |
| insert overwrite table src_multi1_n2 select key, count(1) group by key order by key |
| insert overwrite table src_multi2_n3 select value, count(1) group by value order by value |
| insert overwrite table src_multi3 select * where key < 10; |
| |
| select * from src_multi1_n2; |
| select * from src_multi2_n3; |
| select * from src_multi3; |