PREHOOK: query: create table dest_sp (cnt int)
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table dest_sp (cnt int)
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@dest_sp
PREHOOK: query: insert overwrite table dest_sp
select * from 
  (select count(1) as cnt from src 
    union all
   select count(1) as cnt from srcpart where ds = '2009-08-09'
  )x
PREHOOK: type: QUERY
PREHOOK: Input: default@src
PREHOOK: Output: default@dest_sp
POSTHOOK: query: insert overwrite table dest_sp
select * from 
  (select count(1) as cnt from src 
    union all
   select count(1) as cnt from srcpart where ds = '2009-08-09'
  )x
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Output: default@dest_sp
POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
PREHOOK: query: select * from dest_sp x order by x.cnt limit 2
PREHOOK: type: QUERY
PREHOOK: Input: default@dest_sp
PREHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-40_207_9006053612393059372/10000
POSTHOOK: query: select * from dest_sp x order by x.cnt limit 2
POSTHOOK: type: QUERY
POSTHOOK: Input: default@dest_sp
POSTHOOK: Output: file:/data/users/athusoo/apache_workspaces/hive_trunk_ws1/.ptest_1/build/ql/scratchdir/hive_2010-04-05_18-15-40_207_9006053612393059372/10000
POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]
0
500
PREHOOK: query: drop table dest_sp
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table dest_sp
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@dest_sp
POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ]