| --! qt:dataset:src1 |
| --! qt:dataset:src |
| set hive.mapred.mode=nonstrict; |
| CREATE TABLE dest1_n17(c1 INT, c2 STRING, c3 INT, c4 STRING, c5 INT, c6 STRING) STORED AS TEXTFILE; |
| |
| -- SORT_QUERY_RESULTS |
| |
| EXPLAIN |
| FROM ( |
| FROM |
| ( |
| FROM src src1 SELECT src1.key AS c1, src1.value AS c2 WHERE src1.key > 10 and src1.key < 20 |
| ) a |
| FULL OUTER JOIN |
| ( |
| FROM src src2 SELECT src2.key AS c3, src2.value AS c4 WHERE src2.key > 15 and src2.key < 25 |
| ) b |
| ON (a.c1 = b.c3) |
| LEFT OUTER JOIN |
| ( |
| FROM src src3 SELECT src3.key AS c5, src3.value AS c6 WHERE src3.key > 20 and src3.key < 25 |
| ) c |
| ON (a.c1 = c.c5) |
| SELECT a.c1 AS c1, a.c2 AS c2, b.c3 AS c3, b.c4 AS c4, c.c5 AS c5, c.c6 AS c6 |
| ) c |
| INSERT OVERWRITE TABLE dest1_n17 SELECT c.c1, c.c2, c.c3, c.c4, c.c5, c.c6; |
| |
| FROM ( |
| FROM |
| ( |
| FROM src src1 SELECT src1.key AS c1, src1.value AS c2 WHERE src1.key > 10 and src1.key < 20 |
| ) a |
| FULL OUTER JOIN |
| ( |
| FROM src src2 SELECT src2.key AS c3, src2.value AS c4 WHERE src2.key > 15 and src2.key < 25 |
| ) b |
| ON (a.c1 = b.c3) |
| LEFT OUTER JOIN |
| ( |
| FROM src src3 SELECT src3.key AS c5, src3.value AS c6 WHERE src3.key > 20 and src3.key < 25 |
| ) c |
| ON (a.c1 = c.c5) |
| SELECT a.c1 AS c1, a.c2 AS c2, b.c3 AS c3, b.c4 AS c4, c.c5 AS c5, c.c6 AS c6 |
| ) c |
| INSERT OVERWRITE TABLE dest1_n17 SELECT c.c1, c.c2, c.c3, c.c4, c.c5, c.c6; |
| |
| SELECT dest1_n17.* FROM dest1_n17; |