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

 1EXPLAIN
 2SELECT /*+MAPJOIN(a)*/ 
 3TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
 4FROM src a join src b
 5on a.key = b.key;
 6
 7
 8SELECT /*+MAPJOIN(a)*/ 
 9TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
10FROM src a join src b
11on a.key = b.key;
12
13
14EXPLAIN
15SELECT /*+STREAMTABLE(a)*/ 
16TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
17FROM src a join src b
18on a.key = b.key;
19
20
21SELECT /*+STREAMTABLE(a)*/ 
22TRANSFORM(a.key, a.value) USING '/bin/cat' AS (tkey, tvalue)
23FROM src a join src b
24on a.key = b.key;