select_transform_hint.q

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/select_transform_hint.q

#
text | 24 lines | 18 code | 6 blank | 0 comment | 0 complexity | 31216f6baa61d6e6595941b014e81004 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0


EXPLAIN
SELECT /*+MAPJOIN(a)*/ 
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;


SELECT /*+MAPJOIN(a)*/ 
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;


EXPLAIN
SELECT /*+STREAMTABLE(a)*/ 
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;


SELECT /*+STREAMTABLE(a)*/ 
TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
FROM src a join src b
on a.key = b.key;