CREATE TABLE B(id BIGINT)

COMMENT 'A bucketed copy of user_info'

CLUSTERED BY(id) INTO 10 BUCKETS;



CREATE TABLE B1(id BIGINT);

LOAD DATA local INPATH '/home/hadoop/1.txt' overwrite into table B1;

set hive.enforce.bucketing = true;  

INSERT OVERWRITE TABLE B SELECT * FROM B1;



dfs -ls /user/hive/warehouse/b;



set hive.enforce.bucketing = true;

Insert overwrite table B

select A.a as id from test1 A left outer join B on A.a= B.id where B.id is null

union all 

select id from B;