| --! qt:dataset:part |
| --! qt:dataset:alltypesorc |
| set hive.merge.nway.joins=false; |
| |
| drop table foo_n1; |
| |
| create table foo_n1 (i int) partitioned by (s string); |
| insert overwrite table foo_n1 partition(s='foo_n1') select cint from alltypesorc limit 10; |
| insert overwrite table foo_n1 partition(s='bar') select cint from alltypesorc limit 10; |
| |
| explain |
| select * |
| from foo_n1 f1 |
| join part p1 on (p1.p_partkey = f1.i) |
| join foo_n1 f2 on (f1.i = f2.i) |
| where f1.s='foo_n1' and f2.s='bar'; |
| |
| explain |
| select * |
| from foo_n1 f1 |
| join part p1 on (p1.p_partkey = f1.i) |
| join foo_n1 f2 on (f1.i = f2.i) |
| where f1.s='foo_n1' and f2.s='foo_n1'; |
| |
| drop table foo_n1; |