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/union19.q

#
text | 26 lines | 16 code | 10 blank | 0 comment | 0 complexity | dbff4368f6b1a86866641dcf16cdf5f8 MD5 | raw file
 1
 2
 3
 4CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE;
 5CREATE TABLE DEST2(key STRING, val1 STRING, val2 STRING) STORED AS TEXTFILE;
 6
 7-- union case:map-reduce sub-queries followed by multi-table insert
 8
 9explain 
10FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
11                         UNION  ALL  
12      select s2.key as key, s2.value as value from src s2) unionsrc
13INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, count(unionsrc.value) group by unionsrc.key
14INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, unionsrc.value;
15
16FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
17                         UNION  ALL  
18      select s2.key as key, s2.value as value from src s2) unionsrc
19INSERT OVERWRITE TABLE DEST1 SELECT unionsrc.key, count(unionsrc.value) group by unionsrc.key
20INSERT OVERWRITE TABLE DEST2 SELECT unionsrc.key, unionsrc.value, unionsrc.value;
21
22SELECT DEST1.* FROM DEST1 SORT BY DEST1.key, DEST1.value;
23SELECT DEST2.* FROM DEST2 SORT BY DEST2.key, DEST2.val1, DEST2.val2;
24
25
26