| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| CREATE TABLE npe_test_n0 (key STRING, value STRING) PARTITIONED BY (ds STRING); |
| |
| INSERT OVERWRITE TABLE npe_test_n0 PARTITION(ds='2012-12-11') |
| SELECT src.key, src.value FROM src WHERE key < '200'; |
| |
| INSERT OVERWRITE TABLE npe_test_n0 PARTITION(ds='2012-12-12') |
| SELECT src.key, src.value FROM src WHERE key > '200'; |
| |
| SELECT count(*) FROM npe_test_n0; |
| |
| EXPLAIN SELECT * FROM npe_test_n0 WHERE ds > 2012-11-31 AND ds < 2012-12-15; |
| |
| SELECT count(*) FROM npe_test_n0 WHERE ds > 2012-11-31 AND ds < 2012-12-15; |
| |
| DROP TABLE npe_test_n0; |