PageRenderTime 15ms CodeModel.GetById 12ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/contrib/src/test/results/clientpositive/udaf_example_avg.q.out

#
text | 92 lines | 87 code | 5 blank | 0 comment | 0 complexity | 9c958e8216cb447c048022e8c54ea11a MD5 | raw file
 1PREHOOK: query: CREATE TEMPORARY FUNCTION example_avg AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleAvg'
 2PREHOOK: type: CREATEFUNCTION
 3POSTHOOK: query: CREATE TEMPORARY FUNCTION example_avg AS 'org.apache.hadoop.hive.contrib.udaf.example.UDAFExampleAvg'
 4POSTHOOK: type: CREATEFUNCTION
 5PREHOOK: query: EXPLAIN
 6SELECT example_avg(substr(value,5)),
 7       example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
 8FROM src
 9PREHOOK: type: QUERY
10POSTHOOK: query: EXPLAIN
11SELECT example_avg(substr(value,5)),
12       example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
13FROM src
14POSTHOOK: type: QUERY
15ABSTRACT SYNTAX TREE:
16  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION example_avg (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5))) (TOK_SELEXPR (TOK_FUNCTION example_avg (TOK_FUNCTION IF (> (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5) 250) TOK_NULL (TOK_FUNCTION substr (TOK_TABLE_OR_COL value) 5)))))))
17
18STAGE DEPENDENCIES:
19  Stage-1 is a root stage
20  Stage-0 is a root stage
21
22STAGE PLANS:
23  Stage: Stage-1
24    Map Reduce
25      Alias -> Map Operator Tree:
26        src 
27          TableScan
28            alias: src
29            Select Operator
30              expressions:
31                    expr: value
32                    type: string
33              outputColumnNames: value
34              Group By Operator
35                aggregations:
36                      expr: example_avg(substr(value, 5))
37                      expr: example_avg(if((substr(value, 5) > 250), null, substr(value, 5)))
38                bucketGroup: false
39                mode: hash
40                outputColumnNames: _col0, _col1
41                Reduce Output Operator
42                  sort order: 
43                  tag: -1
44                  value expressions:
45                        expr: _col0
46                        type: struct<mcount:bigint,msum:double>
47                        expr: _col1
48                        type: struct<mcount:bigint,msum:double>
49      Reduce Operator Tree:
50        Group By Operator
51          aggregations:
52                expr: example_avg(VALUE._col0)
53                expr: example_avg(VALUE._col1)
54          bucketGroup: false
55          mode: mergepartial
56          outputColumnNames: _col0, _col1
57          Select Operator
58            expressions:
59                  expr: _col0
60                  type: double
61                  expr: _col1
62                  type: double
63            outputColumnNames: _col0, _col1
64            File Output Operator
65              compressed: false
66              GlobalTableId: 0
67              table:
68                  input format: org.apache.hadoop.mapred.TextInputFormat
69                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
70
71  Stage: Stage-0
72    Fetch Operator
73      limit: -1
74
75
76PREHOOK: query: SELECT example_avg(substr(value,5)),
77       example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
78FROM src
79PREHOOK: type: QUERY
80PREHOOK: Input: default@src
81PREHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-40_935_934094548612608112/-mr-10000
82POSTHOOK: query: SELECT example_avg(substr(value,5)),
83       example_avg(IF(substr(value,5) > 250, NULL, substr(value,5)))
84FROM src
85POSTHOOK: type: QUERY
86POSTHOOK: Input: default@src
87POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-16_20-10-40_935_934094548612608112/-mr-10000
88260.182	134.82926829268294
89PREHOOK: query: DROP TEMPORARY FUNCTION example_avg
90PREHOOK: type: DROPFUNCTION
91POSTHOOK: query: DROP TEMPORARY FUNCTION example_avg
92POSTHOOK: type: DROPFUNCTION