PageRenderTime 29ms CodeModel.GetById 10ms RepoModel.GetById 0ms app.codeStats 0ms

/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
Possible License(s): Apache-2.0, BSD-3-Clause, JSON, CPL-1.0
  1. PREHOOK: query: create table dest_sp (cnt int)
  2. PREHOOK: type: CREATETABLE
  3. POSTHOOK: query: create table dest_sp (cnt int)
  4. POSTHOOK: type: CREATETABLE
  5. POSTHOOK: Output: default@dest_sp
  6. PREHOOK: query: insert overwrite table dest_sp
  7. select * from
  8. (select count(1) as cnt from src
  9. union all
  10. select count(1) as cnt from srcpart where ds = '2009-08-09'
  11. )x
  12. PREHOOK: type: QUERY
  13. PREHOOK: Input: default@src
  14. PREHOOK: Output: default@dest_sp
  15. POSTHOOK: query: insert overwrite table dest_sp
  16. select * from
  17. (select count(1) as cnt from src
  18. union all
  19. select count(1) as cnt from srcpart where ds = '2009-08-09'
  20. )x
  21. POSTHOOK: type: QUERY
  22. POSTHOOK: Input: default@src
  23. POSTHOOK: Output: default@dest_sp
  24. POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
  25. PREHOOK: query: select * from dest_sp x order by x.cnt limit 2
  26. PREHOOK: type: QUERY
  27. PREHOOK: Input: default@dest_sp
  28. PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000
  29. POSTHOOK: query: select * from dest_sp x order by x.cnt limit 2
  30. POSTHOOK: type: QUERY
  31. POSTHOOK: Input: default@dest_sp
  32. POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000
  33. POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
  34. 0
  35. 500