| --! qt:dataset:src |
| create table sc as select * |
| from (select '2011-01-11', '2011-01-11+14:18:26' from src tablesample (1 rows) |
| union all |
| select '2011-01-11', '2011-01-11+15:18:26' from src tablesample (1 rows) |
| union all |
| select '2011-01-11', '2011-01-11+16:18:26' from src tablesample (1 rows) ) s; |
| |
| create table sc_part (key string) partitioned by (ts string) stored as rcfile; |
| |
| set hive.exec.dynamic.partition=true; |
| |
| insert overwrite table sc_part partition(ts) select * from sc; |
| show partitions sc_part; |
| select count(*) from sc_part where ts is not null; |
| |
| insert overwrite table sc_part partition(ts) select * from sc; |
| show partitions sc_part; |
| select count(*) from sc_part where ts is not null; |
