| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.explain.user=false; |
| |
| |
| set hive.optimize.bucketingsorting=false; |
| set hive.auto.convert.join.noconditionaltask.size=10000; |
| |
| create table test_n1 (key int, value string) partitioned by (p int) clustered by (key) into 2 buckets stored as textfile; |
| create table test1 (key int, value string) stored as textfile; |
| |
| insert into table test_n1 partition (p=1) select * from src; |
| |
| alter table test_n1 set fileformat orc; |
| |
| insert into table test_n1 partition (p=2) select * from src; |
| insert into table test1 select * from src; |
| |
| describe test_n1; |
| set hive.auto.convert.join = true; |
| set hive.convert.join.bucket.mapjoin.tez = true; |
| |
| explain select test_n1.key, test_n1.value from test_n1 join test1 on (test_n1.key = test1.key) order by test_n1.key; |
| |
| select test_n1.key, test_n1.value from test_n1 join test1 on (test_n1.key = test1.key) order by test_n1.key; |
| |
