--! qt:dataset:src | |
create table src_part_serde (key int, value string) partitioned by (ds string) stored as sequencefile; | |
insert overwrite table src_part_serde partition (ds='2011') select * from src; | |
alter table src_part_serde set serde 'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe' with SERDEPROPERTIES ('serialization.format'='\t'); | |
select key, value from src_part_serde where ds='2011' order by key, value limit 20; |