| --! qt:dataset:srcpart | |
| --! qt:dataset:src | |
| set hive.mapred.mode=strict; | |
| create table dest_sp (cnt int); | |
| insert overwrite table dest_sp | |
| select * from | |
| (select count(1) as cnt from src | |
| union all | |
| select count(1) as cnt from srcpart where ds = '2009-08-09' | |
| )x; | |
| select * from dest_sp x order by x.cnt limit 2; | |