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

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