关于hive分桶中的抽样调查

我的数据

01 jj01 
02 jj02 
03 jj03 
04 jj04 
05 jj05 
06 jj06 
07 jj07 
08 jj08 
09 jj09 
10 jj10 
11 jj11 
12 jj12 
13 jj13 
14 jj14 
15 jj15 
16 jj16 
17 jj17 
18 jj18 

创建一张临时表并添加数据

create table if not exists stu_temp(
uid int,
uname string,
)
row format delimited fields terminated by ' '
;
load data local inpath '/root/hivetest/stu.txt' into table stu_temp;

创建分桶表

create table if not exists dy_buc(
uid int,uname string
)
clustered by (uid) into 4 buckets
row format delimited fields terminated by ' '
;

设置reduce个数为4个（与分桶数相同）

set mapreduce.job.reduces=4;

插入数据

insert  into  dy_buc 
select uid,uname from stu_temp 
cluster by (uid)
;

分桶表中的数据

hive (db1)> select * from dy_buc;
OK
4       jj04
8       jj08
12<