/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/union15.q
text | 18 lines | 13 code | 5 blank | 0 comment | 0 complexity | 8e6843eb5811d7ff349a068455b0aee5 MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
- set hive.map.aggr = true;
- -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by reducesink
- explain
- select unionsrc.key, count(1) 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
- UNION ALL
- select s3.key as key, s3.value as value from src1 s3) unionsrc group by unionsrc.key;
- select unionsrc.key, count(1) 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
- UNION ALL
- select s3.key as key, s3.value as value from src1 s3) unionsrc group by unionsrc.key;