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