/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/partition_wise_fileformat2.q
text | 12 lines | 7 code | 5 blank | 0 comment | 0 complexity | f44d351efe2e767d9fab10c5753ce4ec MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- create table partition_test_partitioned(key string, value string) partitioned by (dt string);
- insert overwrite table partition_test_partitioned partition(dt=100) select * from src1;
- alter table partition_test_partitioned set fileformat rcfile;
- insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
- alter table partition_test_partitioned set fileformat Sequencefile;
- insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
- select * from partition_test_partitioned where dt >=100 and dt <= 102;