| CREATE TABLE dest_j1(key STRING, value STRING, val2 STRING) STORED AS TEXTFILE; | |
| -- Mapjoin followed by Mapjoin is not supported. | |
| -- The same query would work without the hint | |
| -- Note that there is a positive test with the same name in clientpositive | |
| EXPLAIN EXTENDED | |
| INSERT OVERWRITE TABLE dest_j1 | |
| SELECT /*+ MAPJOIN(x,z) */ x.key, z.value, y.value | |
| FROM src1 x JOIN src y ON (x.key = y.key) | |
| JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11); | |