union23.q | searchcode

/tags/release-0.0.0-rc0/hive/external/ql/src/test/queries/clientpositive/union23.q

#
text | 17 lines | 15 code | 2 blank | 0 comment | 0 complexity | 63cd2d40a22bec8914b7c677d3113a8f MD5 | raw file
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0


explain
select s.key2, s.value2
from (
  select transform(key, value) using 'cat' as (key2, value2)
  from src
  union all 
  select key as key2, value as value2 from src) s
order by s.key2, s.value2;

select s.key2, s.value2
from (
  select transform(key, value) using 'cat' as (key2, value2)
  from src
  union all 
  select key as key2, value as value2 from src) s
order by s.key2, s.value2;