/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
1explain 2select s.key2, s.value2 3from ( 4 select transform(key, value) using 'cat' as (key2, value2) 5 from src 6 union all 7 select key as key2, value as value2 from src) s 8order by s.key2, s.value2; 9 10select s.key2, s.value2 11from ( 12 select transform(key, value) using 'cat' as (key2, value2) 13 from src 14 union all 15 select key as key2, value as value2 from src) s 16order by s.key2, s.value2; 17