/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

  1. set hive.map.aggr = true;
  2. -- union case: 1 subquery is a map-reduce job, different inputs for sub-queries, followed by filesink
  3. create table tmptable(key string, value string);
  4. explain
  5. insert overwrite table tmptable
  6. select unionsrc.key, unionsrc.value FROM (select 'tst1' as key, cast(count(1) as string) as value from src s1
  7. UNION ALL
  8. select s2.key as key, s2.value as value from src1 s2) unionsrc;
  9. insert overwrite table tmptable
  10. select unionsrc.key, unionsrc.value FROM (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 src1 s2) unionsrc;
  13. select * from tmptable x sort by x.key, x.value;