PageRenderTime 18ms CodeModel.GetById 16ms app.highlight 0ms RepoModel.GetById 1ms app.codeStats 0ms

/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
 1
 2
 3create table partition_test_partitioned(key string, value string) partitioned by (dt string);
 4
 5insert overwrite table partition_test_partitioned partition(dt=100) select * from src1;
 6alter table partition_test_partitioned set fileformat rcfile;
 7insert overwrite table partition_test_partitioned partition(dt=101) select * from src1;
 8alter table partition_test_partitioned set fileformat Sequencefile;
 9insert overwrite table partition_test_partitioned partition(dt=102) select * from src1;
10
11select * from partition_test_partitioned where dt >=100 and dt <= 102;
12