| --! qt:dataset:src1 |
| set hive.mapred.mode=nonstrict; |
| |
| |
| create table partition_test_partitioned_n1(key string, value string) partitioned by (dt string); |
| |
| insert overwrite table partition_test_partitioned_n1 partition(dt=100) select * from src1; |
| show table extended like partition_test_partitioned_n1; |
| show table extended like partition_test_partitioned_n1 partition(dt=100); |
| select key from partition_test_partitioned_n1 where dt=100; |
| select key from partition_test_partitioned_n1; |
| |
| alter table partition_test_partitioned_n1 set fileformat rcfile; |
| insert overwrite table partition_test_partitioned_n1 partition(dt=101) select * from src1; |
| show table extended like partition_test_partitioned_n1; |
| show table extended like partition_test_partitioned_n1 partition(dt=100); |
| show table extended like partition_test_partitioned_n1 partition(dt=101); |
| select key from partition_test_partitioned_n1 where dt=100; |
| select key from partition_test_partitioned_n1 where dt=101; |
| select key from partition_test_partitioned_n1; |
| |
| alter table partition_test_partitioned_n1 set fileformat Sequencefile; |
| insert overwrite table partition_test_partitioned_n1 partition(dt=102) select * from src1; |
| show table extended like partition_test_partitioned_n1; |
| show table extended like partition_test_partitioned_n1 partition(dt=100); |
| show table extended like partition_test_partitioned_n1 partition(dt=101); |
| show table extended like partition_test_partitioned_n1 partition(dt=102); |
| select key from partition_test_partitioned_n1 where dt=100; |
| select key from partition_test_partitioned_n1 where dt=101; |
| select key from partition_test_partitioned_n1 where dt=102; |
| select key from partition_test_partitioned_n1; |
| |
| select key from partition_test_partitioned_n1 where dt >=100 and dt <= 102; |
| |