PREHOOK: query: -- 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
PREHOOK: type: CREATETABLE
POSTHOOK: query: -- 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
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@part_test
PREHOOK: query: ALTER TABLE part_test ADD PARTITION(ds='1')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@part_test
POSTHOOK: query: ALTER TABLE part_test ADD PARTITION(ds='1')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@part_test
POSTHOOK: Output: default@part_test@ds=1
PREHOOK: query: ALTER TABLE part_test SET FILEFORMAT RCFILE
PREHOOK: type: ALTERTABLE_FILEFORMAT
PREHOOK: Input: default@part_test
PREHOOK: Output: default@part_test
POSTHOOK: query: ALTER TABLE part_test SET FILEFORMAT RCFILE
POSTHOOK: type: ALTERTABLE_FILEFORMAT
POSTHOOK: Input: default@part_test
POSTHOOK: Output: default@part_test
PREHOOK: query: ALTER TABLE part_test ADD PARTITION(ds='2')
PREHOOK: type: ALTERTABLE_ADDPARTS
PREHOOK: Input: default@part_test
POSTHOOK: query: ALTER TABLE part_test ADD PARTITION(ds='2')
POSTHOOK: type: ALTERTABLE_ADDPARTS
POSTHOOK: Input: default@part_test
POSTHOOK: Output: default@part_test@ds=2
PREHOOK: query: SELECT count(1) FROM part_test WHERE ds='3'
PREHOOK: type: QUERY
PREHOOK: Output: file:/tmp/njain/hive_2010-08-16_23-43-20_804_4303139756059433128/-mr-10000
POSTHOOK: query: SELECT count(1) FROM part_test WHERE ds='3'
POSTHOOK: type: QUERY
POSTHOOK: Output: file:/tmp/njain/hive_2010-08-16_23-43-20_804_4303139756059433128/-mr-10000
0