/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/louter_join_ppr.q
# · text · 71 lines · 61 code · 10 blank · 0 comment · 0 complexity · 4dc90cc35c9c371cee49853a6f050281 MD5 · raw file
- set hive.optimize.ppd=true;
- EXPLAIN EXTENDED
- FROM
- src a
- LEFT OUTER JOIN
- srcpart b
- ON (a.key = b.key AND b.ds = '2008-04-08')
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
- FROM
- src a
- LEFT OUTER JOIN
- srcpart b
- ON (a.key = b.key AND b.ds = '2008-04-08')
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
- EXPLAIN EXTENDED
- FROM
- srcpart a
- LEFT OUTER JOIN
- src b
- ON (a.key = b.key AND a.ds = '2008-04-08')
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
- FROM
- srcpart a
- LEFT OUTER JOIN
- src b
- ON (a.key = b.key AND a.ds = '2008-04-08')
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25;
- EXPLAIN EXTENDED
- FROM
- src a
- LEFT OUTER JOIN
- srcpart b
- ON (a.key = b.key)
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08';
- FROM
- src a
- LEFT OUTER JOIN
- srcpart b
- ON (a.key = b.key)
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND b.ds = '2008-04-08';
- EXPLAIN EXTENDED
- FROM
- srcpart a
- LEFT OUTER JOIN
- src b
- ON (a.key = b.key)
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08';
- FROM
- srcpart a
- LEFT OUTER JOIN
- src b
- ON (a.key = b.key)
- SELECT a.key, a.value, b.key, b.value
- WHERE a.key > 10 AND a.key < 20 AND b.key > 15 AND b.key < 25 AND a.ds = '2008-04-08';