| --! qt:dataset:srcpart |
| set hive.mapred.mode=nonstrict; |
| set hive.exec.dynamic.partition=true; |
| |
| -- SORT_QUERY_RESULTS |
| |
| create table nzhang_t1 like srcpart; |
| create table nzhang_t2 like srcpart; |
| |
| FROM srcpart |
| INSERT OVERWRITE TABLE nzhang_t1 PARTITION (ds, hr) |
| SELECT key, value, ds, hr |
| WHERE ds = '2008-04-08' AND hr = '11' |
| INSERT OVERWRITE TABLE nzhang_t2 PARTITION (ds, hr) |
| SELECT key, value, ds, hr |
| WHERE ds = '2008-04-08' and hr = '12' |
| GROUP BY key, value, ds, hr; |
| |
| show partitions nzhang_t1; |
| show partitions nzhang_t2; |
| |
| select * from nzhang_t1; |
| select * from nzhang_t2; |
| |
| |