PageRenderTime 24ms CodeModel.GetById 15ms app.highlight 3ms RepoModel.GetById 2ms app.codeStats 0ms

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

#
text | 167 lines | 162 code | 5 blank | 0 comment | 0 complexity | 2227f902076aa575b81f58a4e53401f0 MD5 | raw file
  1PREHOOK: query: DESCRIBE FUNCTION when
  2PREHOOK: type: DESCFUNCTION
  3POSTHOOK: query: DESCRIBE FUNCTION when
  4POSTHOOK: type: DESCFUNCTION
  5There is no documentation for function 'when'
  6PREHOOK: query: DESCRIBE FUNCTION EXTENDED when
  7PREHOOK: type: DESCFUNCTION
  8POSTHOOK: query: DESCRIBE FUNCTION EXTENDED when
  9POSTHOOK: type: DESCFUNCTION
 10There is no documentation for function 'when'
 11PREHOOK: query: EXPLAIN
 12SELECT CASE
 13        WHEN 1=1 THEN 2
 14        WHEN 1=3 THEN 4
 15        ELSE 5
 16       END,
 17       CASE
 18        WHEN 6=7 THEN 8
 19        ELSE 9
 20       END,
 21       CASE
 22        WHEN 10=11 THEN 12
 23        WHEN 13=13 THEN 14
 24       END,
 25       CASE
 26        WHEN 15=16 THEN 17
 27        WHEN 18=19 THEN 20
 28       END,
 29       CASE
 30        WHEN 21=22 THEN NULL
 31        WHEN 23=23 THEN 24
 32       END,
 33       CASE
 34        WHEN 25=26 THEN 27
 35        WHEN 28=28 THEN NULL
 36       END
 37FROM src LIMIT 1
 38PREHOOK: type: QUERY
 39POSTHOOK: query: EXPLAIN
 40SELECT CASE
 41        WHEN 1=1 THEN 2
 42        WHEN 1=3 THEN 4
 43        ELSE 5
 44       END,
 45       CASE
 46        WHEN 6=7 THEN 8
 47        ELSE 9
 48       END,
 49       CASE
 50        WHEN 10=11 THEN 12
 51        WHEN 13=13 THEN 14
 52       END,
 53       CASE
 54        WHEN 15=16 THEN 17
 55        WHEN 18=19 THEN 20
 56       END,
 57       CASE
 58        WHEN 21=22 THEN NULL
 59        WHEN 23=23 THEN 24
 60       END,
 61       CASE
 62        WHEN 25=26 THEN 27
 63        WHEN 28=28 THEN NULL
 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 WHEN (= 1 1) 2 (= 1 3) 4 5)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 6 7) 8 9)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 10 11) 12 (= 13 13) 14)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 15 16) 17 (= 18 19) 20)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 21 22) TOK_NULL (= 23 23) 24)) (TOK_SELEXPR (TOK_FUNCTION WHEN (= 25 26) 27 (= 28 28) TOK_NULL))) (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 WHEN ((1 = 1)) THEN (2) WHEN ((1 = 3)) THEN (4) ELSE (5) END
 84                    type: int
 85                    expr: CASE WHEN ((6 = 7)) THEN (8) ELSE (9) END
 86                    type: int
 87                    expr: CASE WHEN ((10 = 11)) THEN (12) WHEN ((13 = 13)) THEN (14) END
 88                    type: int
 89                    expr: CASE WHEN ((15 = 16)) THEN (17) WHEN ((18 = 19)) THEN (20) END
 90                    type: int
 91                    expr: CASE WHEN ((21 = 22)) THEN (null) WHEN ((23 = 23)) THEN (24) END
 92                    type: int
 93                    expr: CASE WHEN ((25 = 26)) THEN (27) WHEN ((28 = 28)) THEN (null) 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
110        WHEN 1=1 THEN 2
111        WHEN 1=3 THEN 4
112        ELSE 5
113       END,
114       CASE
115        WHEN 6=7 THEN 8
116        ELSE 9
117       END,
118       CASE
119        WHEN 10=11 THEN 12
120        WHEN 13=13 THEN 14
121       END,
122       CASE
123        WHEN 15=16 THEN 17
124        WHEN 18=19 THEN 20
125       END,
126       CASE
127        WHEN 21=22 THEN NULL
128        WHEN 23=23 THEN 24
129       END,
130       CASE
131        WHEN 25=26 THEN 27
132        WHEN 28=28 THEN NULL
133       END
134FROM src LIMIT 1
135PREHOOK: type: QUERY
136PREHOOK: Input: default@src
137PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-43-24_591_7859730196061630515/-mr-10000
138POSTHOOK: query: SELECT CASE
139        WHEN 1=1 THEN 2
140        WHEN 1=3 THEN 4
141        ELSE 5
142       END,
143       CASE
144        WHEN 6=7 THEN 8
145        ELSE 9
146       END,
147       CASE
148        WHEN 10=11 THEN 12
149        WHEN 13=13 THEN 14
150       END,
151       CASE
152        WHEN 15=16 THEN 17
153        WHEN 18=19 THEN 20
154       END,
155       CASE
156        WHEN 21=22 THEN NULL
157        WHEN 23=23 THEN 24
158       END,
159       CASE
160        WHEN 25=26 THEN 27
161        WHEN 28=28 THEN NULL
162       END
163FROM src LIMIT 1
164POSTHOOK: type: QUERY
165POSTHOOK: Input: default@src
166POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_17-43-24_591_7859730196061630515/-mr-10000
1672	9	14	NULL	24	NULL