/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/union6.q
# · text · 21 lines · 13 code · 8 blank · 0 comment · 0 complexity · cb2b915ccedd190e37a4842c564c9526 MD5 · raw file
- set hive.map.aggr = true;
- -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by filesink
- create table tmptable(key string, value string);
- explain
- insert overwrite table tmptable
- select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
- UNION ALL
- select s2.key as key, s2.value as value from src1 s2) unionsrc;
- insert overwrite table tmptable
- select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
- UNION ALL
- select s2.key as key, s2.value as value from src1 s2) unionsrc;
- select * from tmptable x sort by x.key, x.value;