--! qt:dataset:srcpart | |
-- scanning partitioned data | |
create table tmptable_n1(key string, value string, hr string, ds string); | |
explain extended | |
insert overwrite table tmptable_n1 | |
select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08'; | |
insert overwrite table tmptable_n1 | |
select a.* from srcpart a where rand(1) < 0.1 and a.ds = '2008-04-08'; | |
select * from tmptable_n1 x sort by x.key,x.value,x.ds,x.hr; | |