/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
1PREHOOK: query: create table dest_sp (cnt int) 2PREHOOK: type: CREATETABLE 3POSTHOOK: query: create table dest_sp (cnt int) 4POSTHOOK: type: CREATETABLE 5POSTHOOK: Output: default@dest_sp 6PREHOOK: query: insert overwrite table dest_sp 7select * 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 12PREHOOK: type: QUERY 13PREHOOK: Input: default@src 14PREHOOK: Output: default@dest_sp 15POSTHOOK: query: insert overwrite table dest_sp 16select * 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 21POSTHOOK: type: QUERY 22POSTHOOK: Input: default@src 23POSTHOOK: Output: default@dest_sp 24POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ] 25PREHOOK: query: select * from dest_sp x order by x.cnt limit 2 26PREHOOK: type: QUERY 27PREHOOK: Input: default@dest_sp 28PREHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000 29POSTHOOK: query: select * from dest_sp x order by x.cnt limit 2 30POSTHOOK: type: QUERY 31POSTHOOK: Input: default@dest_sp 32POSTHOOK: Output: file:/tmp/jssarma/hive_2010-07-21_11-28-55_506_7975559281496695000/10000 33POSTHOOK: Lineage: dest_sp.cnt EXPRESSION [(src)src.null, (srcpart)srcpart.null, ] 340 35500