diff_part_input_formats.q

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0


-- 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';