PageRenderTime 19ms CodeModel.GetById 16ms app.highlight 1ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.0.0-rc0/hive/external/ql/src/test/results/clientpositive/udf_case.q.out

#
text | 167 lines | 162 code | 5 blank | 0 comment | 0 complexity | 4a9a7272f77a3826c5ac8dec8fa46675 MD5 | raw file
  1PREHOOK: query: DESCRIBE FUNCTION case
  2PREHOOK: type: DESCFUNCTION
  3POSTHOOK: query: DESCRIBE FUNCTION case
  4POSTHOOK: type: DESCFUNCTION
  5There is no documentation for function 'case'
  6PREHOOK: query: DESCRIBE FUNCTION EXTENDED case
  7PREHOOK: type: DESCFUNCTION
  8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED case
  9POSTHOOK: type: DESCFUNCTION
 10There is no documentation for function 'case'
 11PREHOOK: query: EXPLAIN
 12SELECT CASE 1
 13        WHEN 1 THEN 2
 14        WHEN 3 THEN 4
 15        ELSE 5
 16       END,
 17       CASE 2
 18        WHEN 1 THEN 2
 19        ELSE 5
 20       END,
 21       CASE 14
 22        WHEN 12 THEN 13
 23        WHEN 14 THEN 15
 24       END,
 25       CASE 16
 26        WHEN 12 THEN 13
 27        WHEN 14 THEN 15
 28       END,
 29       CASE 17
 30        WHEN 18 THEN NULL
 31        WHEN 17 THEN 20
 32       END,
 33       CASE 21
 34        WHEN 22 THEN 23
 35        WHEN 21 THEN 24
 36       END
 37FROM src LIMIT 1
 38PREHOOK: type: QUERY
 39POSTHOOK: query: EXPLAIN
 40SELECT CASE 1
 41        WHEN 1 THEN 2
 42        WHEN 3 THEN 4
 43        ELSE 5
 44       END,
 45       CASE 2
 46        WHEN 1 THEN 2
 47        ELSE 5
 48       END,
 49       CASE 14
 50        WHEN 12 THEN 13
 51        WHEN 14 THEN 15
 52       END,
 53       CASE 16
 54        WHEN 12 THEN 13
 55        WHEN 14 THEN 15
 56       END,
 57       CASE 17
 58        WHEN 18 THEN NULL
 59        WHEN 17 THEN 20
 60       END,
 61       CASE 21
 62        WHEN 22 THEN 23
 63        WHEN 21 THEN 24
 64       END
 65FROM src LIMIT 1
 66POSTHOOK: type: QUERY
 67ABSTRACT SYNTAX TREE:
 68  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION CASE 1 1 2 3 4 5)) (TOK_SELEXPR (TOK_FUNCTION CASE 2 1 2 5)) (TOK_SELEXPR (TOK_FUNCTION CASE 14 12 13 14 15)) (TOK_SELEXPR (TOK_FUNCTION CASE 16 12 13 14 15)) (TOK_SELEXPR (TOK_FUNCTION CASE 17 18 TOK_NULL 17 20)) (TOK_SELEXPR (TOK_FUNCTION CASE 21 22 23 21 24))) (TOK_LIMIT 1)))
 69
 70STAGE DEPENDENCIES:
 71  Stage-1 is a root stage
 72  Stage-0 is a root stage
 73
 74STAGE PLANS:
 75  Stage: Stage-1
 76    Map Reduce
 77      Alias -> Map Operator Tree:
 78        src 
 79          TableScan
 80            alias: src
 81            Select Operator
 82              expressions:
 83                    expr: CASE (1) WHEN (1) THEN (2) WHEN (3) THEN (4) ELSE (5) END
 84                    type: int
 85                    expr: CASE (2) WHEN (1) THEN (2) ELSE (5) END
 86                    type: int
 87                    expr: CASE (14) WHEN (12) THEN (13) WHEN (14) THEN (15) END
 88                    type: int
 89                    expr: CASE (16) WHEN (12) THEN (13) WHEN (14) THEN (15) END
 90                    type: int
 91                    expr: CASE (17) WHEN (18) THEN (null) WHEN (17) THEN (20) END
 92                    type: int
 93                    expr: CASE (21) WHEN (22) THEN (23) WHEN (21) THEN (24) END
 94                    type: int
 95              outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5
 96              Limit
 97                File Output Operator
 98                  compressed: false
 99                  GlobalTableId: 0
100                  table:
101                      input format: org.apache.hadoop.mapred.TextInputFormat
102                      output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
103
104  Stage: Stage-0
105    Fetch Operator
106      limit: 1
107
108
109PREHOOK: query: SELECT CASE 1
110        WHEN 1 THEN 2
111        WHEN 3 THEN 4
112        ELSE 5
113       END,
114       CASE 2
115        WHEN 1 THEN 2
116        ELSE 5
117       END,
118       CASE 14
119        WHEN 12 THEN 13
120        WHEN 14 THEN 15
121       END,
122       CASE 16
123        WHEN 12 THEN 13
124        WHEN 14 THEN 15
125       END,
126       CASE 17
127        WHEN 18 THEN NULL
128        WHEN 17 THEN 20
129       END,
130       CASE 21
131        WHEN 22 THEN 23
132        WHEN 21 THEN 24
133       END
134FROM src LIMIT 1
135PREHOOK: type: QUERY
136PREHOOK: Input: default@src
137PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-31-04_518_6857103604327967113/-mr-10000
138POSTHOOK: query: SELECT CASE 1
139        WHEN 1 THEN 2
140        WHEN 3 THEN 4
141        ELSE 5
142       END,
143       CASE 2
144        WHEN 1 THEN 2
145        ELSE 5
146       END,
147       CASE 14
148        WHEN 12 THEN 13
149        WHEN 14 THEN 15
150       END,
151       CASE 16
152        WHEN 12 THEN 13
153        WHEN 14 THEN 15
154       END,
155       CASE 17
156        WHEN 18 THEN NULL
157        WHEN 17 THEN 20
158       END,
159       CASE 21
160        WHEN 22 THEN 23
161        WHEN 21 THEN 24
162       END
163FROM src LIMIT 1
164POSTHOOK: type: QUERY
165POSTHOOK: Input: default@src
166POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-31-04_518_6857103604327967113/-mr-10000
1672	5	15	NULL	20	24