| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| set hive.auto.convert.join=true; |
| set hive.auto.convert.join.noconditionaltask=true; |
| set hive.auto.convert.join.noconditionaltask.size=10000; |
| |
| CREATE TABLE tab1_n0(key1 int, value string) CLUSTERED BY (key1) INTO 10 BUCKETS STORED AS TEXTFILE; |
| CREATE TABLE tab2_n0 (key1 int, value string) CLUSTERED BY (key1) INTO 10 BUCKETS STORED AS TEXTFILE; |
| |
| |
| -- HIVE-18721 : Make sure only certain buckets have data. |
| insert into tab1_n0 VALUES (1,"abc"),(4,"def"),(8, "ghi"); |
| insert into tab2_n0 VALUES (1, "abc"), (5, "aa"); |
| |
| set hive.convert.join.bucket.mapjoin.tez = true; |
| |
| explain select * from tab1_n0, tab2_n0 where tab1_n0.key1 = tab2_n0.key1; |
| select * from tab1_n0, tab2_n0 where tab1_n0.key1 = tab2_n0.key1; |