/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/input41.q.out

# · text · 35 lines · 35 code · 0 blank · 0 comment · 0 complexity · ad5cabc45a80fef87a53ba742c2249e5 MD5 · raw file 

    

  1. PREHOOK: query: create table dest_sp (cnt int)
    2. 

  2. PREHOOK: type: CREATETABLE
    3. 

  3. POSTHOOK: query: create table dest_sp (cnt int)
    4. 

  4. POSTHOOK: type: CREATETABLE
    5. 

  5. POSTHOOK: Output: default@dest_sp
    6. 

  6. PREHOOK: query: insert overwrite table dest_sp
    7. 

  7. select * from 
    8. 

  8.   (select count(1) as cnt from src 
    9. 

  9.     union all
    10. 

  10.    select count(1) as cnt from srcpart where ds = '2009-08-09'
    11. 

  11.   )x
    12. 

  12. PREHOOK: type: QUERY
    13. 

  13. PREHOOK: Input: default@src
    14. 

  14. PREHOOK: Output: default@dest_sp
    15. 

  15. POSTHOOK: query: insert overwrite table dest_sp
    16. 

  16. select * from 
    17. 

  17.   (select count(1) as cnt from src 
    18. 

  18.     union all
    19. 

  19.    select count(1) as cnt from srcpart where ds = '2009-08-09'
    20. 

  20.   )x
    21. 

  21. POSTHOOK: type: QUERY
    22. 

  22. POSTHOOK: Input: default@src
    23. 

  23. POSTHOOK: Output: default@dest_sp
    24. 

  24. POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
    25. 

  25. PREHOOK: query: select * from dest_sp x order by x.cnt limit 2
    26. 

  26. PREHOOK: type: QUERY
    27. 

  27. PREHOOK: Input: default@dest_sp
    28. 

  28. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000
    29. 

  29. POSTHOOK: query: select * from dest_sp x order by x.cnt limit 2
    30. 

  30. POSTHOOK: type: QUERY
    31. 

  31. POSTHOOK: Input: default@dest_sp
    32. 

  32. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000
    33. 

  33. POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
    34. 

  34. 0
    35. 

  35. 500
    36.