PageRenderTime 21ms CodeModel.GetById 9ms app.highlight 6ms RepoModel.GetById 1ms app.codeStats 0ms

/tags/release-0.2.0-rc0/hive/external/ql/src/test/results/clientpositive/nullgroup.q.out

#
text | 296 lines | 275 code | 21 blank | 0 comment | 0 complexity | 1dfc528b09395da7a1419a51f370c435 MD5 | raw file
  1PREHOOK: query: explain
  2select count(1) from src x where x.key > 9999
  3PREHOOK: type: QUERY
  4POSTHOOK: query: explain
  5select count(1) from src x where x.key > 9999
  6POSTHOOK: type: QUERY
  7ABSTRACT SYNTAX TREE:
  8  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL x) key) 9999))))
  9
 10STAGE DEPENDENCIES:
 11  Stage-1 is a root stage
 12  Stage-0 is a root stage
 13
 14STAGE PLANS:
 15  Stage: Stage-1
 16    Map Reduce
 17      Alias -> Map Operator Tree:
 18        x 
 19          TableScan
 20            alias: x
 21            Filter Operator
 22              predicate:
 23                  expr: (key > 9999)
 24                  type: boolean
 25              Select Operator
 26                Group By Operator
 27                  aggregations:
 28                        expr: count(1)
 29                  bucketGroup: false
 30                  mode: hash
 31                  outputColumnNames: _col0
 32                  Reduce Output Operator
 33                    sort order: 
 34                    tag: -1
 35                    value expressions:
 36                          expr: _col0
 37                          type: bigint
 38      Reduce Operator Tree:
 39        Group By Operator
 40          aggregations:
 41                expr: count(VALUE._col0)
 42          bucketGroup: false
 43          mode: final
 44          outputColumnNames: _col0
 45          Select Operator
 46            expressions:
 47                  expr: _col0
 48                  type: bigint
 49            outputColumnNames: _col0
 50            File Output Operator
 51              compressed: false
 52              GlobalTableId: 0
 53              table:
 54                  input format: org.apache.hadoop.mapred.TextInputFormat
 55                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 56
 57  Stage: Stage-0
 58    Fetch Operator
 59      limit: -1
 60
 61
 62PREHOOK: query: select count(1) from src x where x.key > 9999
 63PREHOOK: type: QUERY
 64PREHOOK: Input: default@src
 65PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-05_987_7125324557383069718/-mr-10000
 66POSTHOOK: query: select count(1) from src x where x.key > 9999
 67POSTHOOK: type: QUERY
 68POSTHOOK: Input: default@src
 69POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-05_987_7125324557383069718/-mr-10000
 700
 71PREHOOK: query: explain
 72select count(1) from src x where x.key > 9999
 73PREHOOK: type: QUERY
 74POSTHOOK: query: explain
 75select count(1) from src x where x.key > 9999
 76POSTHOOK: type: QUERY
 77ABSTRACT SYNTAX TREE:
 78  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL x) key) 9999))))
 79
 80STAGE DEPENDENCIES:
 81  Stage-1 is a root stage
 82  Stage-0 is a root stage
 83
 84STAGE PLANS:
 85  Stage: Stage-1
 86    Map Reduce
 87      Alias -> Map Operator Tree:
 88        x 
 89          TableScan
 90            alias: x
 91            Filter Operator
 92              predicate:
 93                  expr: (key > 9999)
 94                  type: boolean
 95              Select Operator
 96                Group By Operator
 97                  aggregations:
 98                        expr: count(1)
 99                  bucketGroup: false
100                  mode: hash
101                  outputColumnNames: _col0
102                  Reduce Output Operator
103                    sort order: 
104                    tag: -1
105                    value expressions:
106                          expr: _col0
107                          type: bigint
108      Reduce Operator Tree:
109        Group By Operator
110          aggregations:
111                expr: count(VALUE._col0)
112          bucketGroup: false
113          mode: mergepartial
114          outputColumnNames: _col0
115          Select Operator
116            expressions:
117                  expr: _col0
118                  type: bigint
119            outputColumnNames: _col0
120            File Output Operator
121              compressed: false
122              GlobalTableId: 0
123              table:
124                  input format: org.apache.hadoop.mapred.TextInputFormat
125                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
126
127  Stage: Stage-0
128    Fetch Operator
129      limit: -1
130
131
132PREHOOK: query: select count(1) from src x where x.key > 9999
133PREHOOK: type: QUERY
134PREHOOK: Input: default@src
135PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-09_467_3203831239428624173/-mr-10000
136POSTHOOK: query: select count(1) from src x where x.key > 9999
137POSTHOOK: type: QUERY
138POSTHOOK: Input: default@src
139POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-09_467_3203831239428624173/-mr-10000
1400
141PREHOOK: query: explain
142select count(1) from src x where x.key > 9999
143PREHOOK: type: QUERY
144POSTHOOK: query: explain
145select count(1) from src x where x.key > 9999
146POSTHOOK: type: QUERY
147ABSTRACT SYNTAX TREE:
148  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL x) key) 9999))))
149
150STAGE DEPENDENCIES:
151  Stage-1 is a root stage
152  Stage-2 depends on stages: Stage-1
153  Stage-0 is a root stage
154
155STAGE PLANS:
156  Stage: Stage-1
157    Map Reduce
158      Alias -> Map Operator Tree:
159        x 
160          TableScan
161            alias: x
162            Filter Operator
163              predicate:
164                  expr: (key > 9999)
165                  type: boolean
166              Select Operator
167                Reduce Output Operator
168                  sort order: 
169                  Map-reduce partition columns:
170                        expr: rand()
171                        type: double
172                  tag: -1
173                  value expressions:
174                        expr: 1
175                        type: int
176      Reduce Operator Tree:
177        Group By Operator
178          aggregations:
179                expr: count(VALUE._col0)
180          bucketGroup: false
181          mode: partial1
182          outputColumnNames: _col0
183          File Output Operator
184            compressed: false
185            GlobalTableId: 0
186            table:
187                input format: org.apache.hadoop.mapred.SequenceFileInputFormat
188                output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat
189
190  Stage: Stage-2
191    Map Reduce
192      Alias -> Map Operator Tree:
193        file:/tmp/sdong/hive_2011-02-10_16-47-12_863_4013349726685139826/-mr-10002 
194            Reduce Output Operator
195              sort order: 
196              tag: -1
197              value expressions:
198                    expr: _col0
199                    type: bigint
200      Reduce Operator Tree:
201        Group By Operator
202          aggregations:
203                expr: count(VALUE._col0)
204          bucketGroup: false
205          mode: final
206          outputColumnNames: _col0
207          Select Operator
208            expressions:
209                  expr: _col0
210                  type: bigint
211            outputColumnNames: _col0
212            File Output Operator
213              compressed: false
214              GlobalTableId: 0
215              table:
216                  input format: org.apache.hadoop.mapred.TextInputFormat
217                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
218
219  Stage: Stage-0
220    Fetch Operator
221      limit: -1
222
223
224PREHOOK: query: select count(1) from src x where x.key > 9999
225PREHOOK: type: QUERY
226PREHOOK: Input: default@src
227PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-12_945_380649354162948794/-mr-10000
228POSTHOOK: query: select count(1) from src x where x.key > 9999
229POSTHOOK: type: QUERY
230POSTHOOK: Input: default@src
231POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-12_945_380649354162948794/-mr-10000
2320
233PREHOOK: query: explain
234select count(1) from src x where x.key > 9999
235PREHOOK: type: QUERY
236POSTHOOK: query: explain
237select count(1) from src x where x.key > 9999
238POSTHOOK: type: QUERY
239ABSTRACT SYNTAX TREE:
240  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME src) x)) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1))) (TOK_WHERE (> (. (TOK_TABLE_OR_COL x) key) 9999))))
241
242STAGE DEPENDENCIES:
243  Stage-1 is a root stage
244  Stage-0 is a root stage
245
246STAGE PLANS:
247  Stage: Stage-1
248    Map Reduce
249      Alias -> Map Operator Tree:
250        x 
251          TableScan
252            alias: x
253            Filter Operator
254              predicate:
255                  expr: (key > 9999)
256                  type: boolean
257              Select Operator
258                Reduce Output Operator
259                  sort order: 
260                  tag: -1
261                  value expressions:
262                        expr: 1
263                        type: int
264      Reduce Operator Tree:
265        Group By Operator
266          aggregations:
267                expr: count(VALUE._col0)
268          bucketGroup: false
269          mode: complete
270          outputColumnNames: _col0
271          Select Operator
272            expressions:
273                  expr: _col0
274                  type: bigint
275            outputColumnNames: _col0
276            File Output Operator
277              compressed: false
278              GlobalTableId: 0
279              table:
280                  input format: org.apache.hadoop.mapred.TextInputFormat
281                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
282
283  Stage: Stage-0
284    Fetch Operator
285      limit: -1
286
287
288PREHOOK: query: select count(1) from src x where x.key > 9999
289PREHOOK: type: QUERY
290PREHOOK: Input: default@src
291PREHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-19_535_5224359427851170423/-mr-10000
292POSTHOOK: query: select count(1) from src x where x.key > 9999
293POSTHOOK: type: QUERY
294POSTHOOK: Input: default@src
295POSTHOOK: Output: file:/tmp/sdong/hive_2011-02-10_16-47-19_535_5224359427851170423/-mr-10000
2960