DROP TABLE smb_input; CREATE TABLE smb_input(key int, value int) CLUSTERED BY (key) SORTED BY (key) INTO 1 BUCKETS; LOAD DATA LOCAL INPATH '../data/files/in.txt' overwrite into table smb_input; SET hive.optimize.bucketmapJOIN = true; SET hive.optimize.bucketmapJOIN.sortedmerge = true; SELECT /*+ MAPJOIN(a) */ * FROM smb_input a JOIN smb_input b ON a.key = b.key; SELECT /*+ MAPJOIN(b) */ * FROM smb_input a JOIN smb_input b ON a.key = b.key; SELECT /*+ MAPJOIN(b) */ * FROM smb_input a LEFT OUTER JOIN smb_input b ON a.key = b.key; SELECT /*+ MAPJOIN(a) */ * FROM smb_input a RIGHT OUTER JOIN smb_input b ON a.key = b.key; DROP TABLE smb_input;