Hive-分桶与排序

创建带分桶的表

建表语句

 CREATE TABLE user_info_bucketed(user_id BIGINT, firstname STRING, lastname STRING)
  COMMENT 'A bucketed copy of user_info'
  PARTITIONED BY(ds STRING)
  CLUSTERED BY(user_id) INTO 256 BUCKETS;

以上分桶表以字段user_id进行分桶，以下说明如何在分桶的表中导入分桶数据

插入数据

• 方法1：设置hive.enforce.bucketing = true
  set hive.enforce.bucketing = true;

 FROM user_id
 INSERT OVERWR