| --! qt:dataset:src1 |
| --! qt:dataset:src |
| --! qt:disabled:HIVE-26138 Fix mapjoin_memcheck |
| set hive.mapred.mode=nonstrict; |
| |
| set hive.auto.convert.join = true; |
| |
| -- SORT_QUERY_RESULTS |
| |
| create table src0 like src; |
| insert into table src0 select * from src where src.key < 10; |
| |
| set hive.mapjoin.check.memory.rows=1; |
| |
| explain |
| select src1.key as k1, src1.value as v1, src2.key, src2.value |
| from src0 src1 inner join src0 src2 on src1.key = src2.key; |
| |
| select src1.key as k1, src1.value as v1, src2.key, src2.value |
| from src0 src1 inner join src0 src2 on src1.key = src2.key; |
| |
| drop table src0; |