--! qt:dataset:src
set hive.mapred.mode=nonstrict;
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;