| --! qt:dataset:src1 |
| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| set hive.optimize.ppd=true; |
| set hive.ppd.remove.duplicatefilters=false; |
| |
| -- SORT_QUERY_RESULTS |
| |
| EXPLAIN |
| SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < '400' |
| JOIN |
| (SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3 |
| ON src1.c2 = src3.c6 |
| WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13); |
| |
| SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < '400' |
| JOIN |
| (SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3 |
| ON src1.c2 = src3.c6 |
| WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13); |
| |
| set hive.ppd.remove.duplicatefilters=true; |
| |
| EXPLAIN |
| SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < '400' |
| JOIN |
| (SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3 |
| ON src1.c2 = src3.c6 |
| WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13); |
| |
| SELECT src1.c1, src2.c4 |
| FROM |
| (SELECT src.key as c1, src.value as c2 from src where src.key <> '302' ) src1 |
| JOIN |
| (SELECT src.key as c3, src.value as c4 from src where src.key <> '305' ) src2 |
| ON src1.c1 = src2.c3 AND src1.c1 < '400' |
| JOIN |
| (SELECT src.key as c5, src.value as c6 from src where src.key <> '306' ) src3 |
| ON src1.c2 = src3.c6 |
| WHERE src1.c1 <> '311' and (src1.c2 <> 'val_50' or src1.c1 > '1') and (src2.c3 <> '10' or src1.c1 <> '10') and (src2.c3 <> '14') and (sqrt(src3.c5) <> 13); |