| --! qt:dataset:src1 | |
| set hive.cbo.enable=false; | |
| -- SORT_QUERY_RESULTS | |
| CREATE TABLE mytable_n1(val1 INT, val2 INT, val3 INT); | |
| EXPLAIN | |
| SELECT * | |
| FROM mytable_n1 src1, mytable_n1 src2 | |
| WHERE src1.val1=src2.val1 | |
| AND src1.val2 between 2450816 and 2451500 | |
| AND src2.val2 between 2450816 and 2451500; |