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

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

#
text | 17 lines | 11 code | 6 blank | 0 comment | 0 complexity | 189b71860b03c409206ce0466d1b7a06 MD5 | raw file
 1CREATE TABLE dest_j1(key STRING, value STRING, val2 STRING) STORED AS TEXTFILE;
 2
 3EXPLAIN EXTENDED
 4INSERT OVERWRITE TABLE dest_j1
 5SELECT /*+ MAPJOIN(x) */ x.key, z.value, y.value
 6FROM src1 x JOIN src y ON (x.key = y.key) 
 7JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
 8
 9INSERT OVERWRITE TABLE dest_j1
10SELECT /*+ MAPJOIN(x) */ x.key, z.value, y.value
11FROM src1 x JOIN src y ON (x.key = y.key) 
12JOIN srcpart z ON (x.value = z.value and z.ds='2008-04-08' and z.hr=11);
13
14select * from dest_j1 x order by x.key;
15
16
17