ql/src/test/queries/clientpositive/optional_outer.q

--! qt:dataset:src
set hive.mapred.mode=nonstrict;
EXPLAIN SELECT * FROM src a LEFT OUTER JOIN src b on (a.key=b.key);
EXPLAIN SELECT * FROM src a LEFT JOIN src b on (a.key=b.key);

EXPLAIN SELECT * FROM src a RIGHT OUTER JOIN src b on (a.key=b.key);
EXPLAIN SELECT * FROM src a RIGHT JOIN src b on (a.key=b.key);

EXPLAIN SELECT * FROM src a FULL OUTER JOIN src b on (a.key=b.key);
EXPLAIN SELECT * FROM src a FULL JOIN src b on (a.key=b.key);