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

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/diff_part_input_formats.q

#
text | 9 lines | 8 code | 1 blank | 0 comment | 0 complexity | c7479db221f254593ee71c97715e37f0 MD5 | raw file
1-- Tests the case where a table is changed from sequence file to a RC file,
2-- resulting in partitions in both file formats. If no valid partitions are
3-- selected, then it should still use RC file for reading the dummy partition.
4CREATE TABLE part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) STORED AS SEQUENCEFILE;
5ALTER TABLE part_test ADD PARTITION(ds='1');
6ALTER TABLE part_test SET FILEFORMAT RCFILE;
7ALTER TABLE part_test ADD PARTITION(ds='2');
8SELECT count(1) FROM part_test WHERE ds='3';
9