PageRenderTime 18ms CodeModel.GetById 14ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/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
 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;