PageRenderTime 13ms CodeModel.GetById 10ms app.highlight 1ms RepoModel.GetById 1ms 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
 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