-- Tests the case where a table is changed from sequence file to a RC file,
-- resulting in partitions in both file formats. If no valid partitions are
-- selected, then it should still use RC file for reading the dummy partition.
CREATE TABLE part_test (key STRING, value STRING) PARTITIONED BY (ds STRING) STORED AS SEQUENCEFILE;
ALTER TABLE part_test ADD PARTITION(ds='1');
ALTER TABLE part_test SET FILEFORMAT RCFILE;
ALTER TABLE part_test ADD PARTITION(ds='2');
SELECT count(1) FROM part_test WHERE ds='3';
DROP TABLE part_test;