--! 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; | |