| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| create table union_subq_union(key int, value string); |
| |
| explain |
| insert overwrite table union_subq_union |
| select * from ( |
| select key, value from src |
| union all |
| select key, value from |
| ( |
| select key, value, count(1) from src group by key, value |
| union all |
| select key, value, count(1) from src group by key, value |
| ) subq |
| ) a |
| ; |
| |
| insert overwrite table union_subq_union |
| select * from ( |
| select key, value from src |
| union all |
| select key, value from |
| ( |
| select key, value, count(1) from src group by key, value |
| union all |
| select key, value, count(1) from src group by key, value |
| ) subq |
| ) a |
| ; |
| |
| select * from union_subq_union order by key, value limit 20; |