Hive3创建分桶表并加载数据

创建分桶表

create table stu_buk(
id int,
name string
) clustered by (id) into 4 buckets
row format delimited fields terminated by '\t';

数据插入

load data local inpath '/opt/module/hive/datas/student.txt' into table stu_buk;