PageRenderTime 23ms CodeModel.GetById 18ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

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

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