Saving all output to "!!{outputDirectory}!!/partition_wise_fileformat6.q.raw". Enter "record" with no arguments to stop it. >>> !run !!{qFileDirectory}!!/partition_wise_fileformat6.q >>> set hive.input.format = org.apache.hadoop.hive.ql.io.CombineHiveInputFormat; No rows affected >>> >>> create table partition_test_partitioned(key string, value string) partitioned by (dt string); No rows affected >>> >>> alter table partition_test_partitioned set fileformat rcfile; No rows affected >>> insert overwrite table partition_test_partitioned partition(dt=101) select * from src1; 'key','value' No rows selected >>> alter table partition_test_partitioned set fileformat Sequencefile; No rows affected >>> >>> insert overwrite table partition_test_partitioned partition(dt=102) select * from src1; 'key','value' No rows selected >>> >>> select count(1) from (select key, value from partition_test_partitioned where dt=101 and key < 100 union all select key, value from partition_test_partitioned where dt=101 and key < 20)s; '_c0' '2' 1 row selected >>> >>> select count(1) from (select key, value from partition_test_partitioned where dt=101 and key < 100 union all select key, value from partition_test_partitioned where dt=102 and key < 20)s; '_c0' '2' 1 row selected >>> !record