| --! qt:dataset:src1 |
| set hive.mapred.mode=nonstrict; |
| -- SORT_QUERY_RESULTS |
| |
| CREATE TABLE filter_join_breaktask(key int, value string) partitioned by (ds string); |
| |
| INSERT OVERWRITE TABLE filter_join_breaktask PARTITION(ds='2008-04-08') |
| SELECT key, value from src1; |
| |
| |
| EXPLAIN EXTENDED |
| SELECT f.key, g.value |
| FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null) |
| JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !=''); |
| |
| SELECT f.key, g.value |
| FROM filter_join_breaktask f JOIN filter_join_breaktask m ON( f.key = m.key AND f.ds='2008-04-08' AND m.ds='2008-04-08' AND f.key is not null) |
| JOIN filter_join_breaktask g ON(g.value = m.value AND g.ds='2008-04-08' AND m.ds='2008-04-08' AND m.value is not null AND m.value !=''); |
| |