blob: 51b09fedad8193f03478b6c464cf990c61a5e836 [file] [log] [blame]
--! qt:dataset:src1
set hive.input.format = org.apache.hadoop.hive.ql.io.CombineHiveInputFormat;
create table partition_test_partitioned_n3(key string, value string) partitioned by (dt string);
alter table partition_test_partitioned_n3 set fileformat rcfile;
insert overwrite table partition_test_partitioned_n3 partition(dt=101) select * from src1;
alter table partition_test_partitioned_n3 set fileformat Sequencefile;
insert overwrite table partition_test_partitioned_n3 partition(dt=102) select * from src1;
select dt, count(1) from partition_test_partitioned_n3 where dt is not null group by dt;
insert overwrite table partition_test_partitioned_n3 partition(dt=103) select * from src1;
select dt, count(1) from partition_test_partitioned_n3 where dt is not null group by dt;