/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 

    

  1. explain
    2. 

  2. select s.key2, s.value2
    3. 

  3. from (
    4. 

  4.   select transform(key, value) using 'cat' as (key2, value2)
    5. 

  5.   from src
    6. 

  6.   union all 
    7. 

  7.   select key as key2, value as value2 from src) s
    8. 

  8. order by s.key2, s.value2;
    9. 

  9. 

  10. select s.key2, s.value2
    11. 

  11. from (
    12. 

  12.   select transform(key, value) using 'cat' as (key2, value2)
    13. 

  13.   from src
    14. 

  14.   union all 
    15. 

  15.   select key as key2, value as value2 from src) s
    16. 

  16. order by s.key2, s.value2;
    17.