/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/union11.q
# · text · 20 lines · 13 code · 7 blank · 0 comment · 0 complexity · de78d32be58be77c0f7ce6eb69bc9664 MD5 · raw file
- set hive.map.aggr = true;
- -- union case: all subqueries are a map-reduce jobs, 3 way union, same input for all sub-queries, followed by reducesink
- explain
- select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
- UNION ALL
- select 'tst2' as key, count(1) as value from src s2
- UNION ALL
- select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key;
- select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1
- UNION ALL
- select 'tst2' as key, count(1) as value from src s2
- UNION ALL
- select 'tst3' as key, count(1) as value from src s3) unionsrc group by unionsrc.key;