PageRenderTime 25ms CodeModel.GetById 10ms app.highlight 8ms RepoModel.GetById 1ms app.codeStats 0ms

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

#
text | 364 lines | 344 code | 20 blank | 0 comment | 0 complexity | 2190e9f9b2969f8a4371ed714b559c0f MD5 | raw file
  1PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@tstparttbl
  6PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09')
  7PREHOOK: type: LOAD
  8PREHOOK: Output: default@tstparttbl
  9POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09')
 10POSTHOOK: type: LOAD
 11POSTHOOK: Output: default@tstparttbl
 12POSTHOOK: Output: default@tstparttbl@ds=2008-04-09
 13PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08')
 14PREHOOK: type: LOAD
 15PREHOOK: Output: default@tstparttbl
 16POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08')
 17POSTHOOK: type: LOAD
 18POSTHOOK: Output: default@tstparttbl
 19POSTHOOK: Output: default@tstparttbl@ds=2008-04-08
 20PREHOOK: query: explain
 21select count(1) from tstparttbl
 22PREHOOK: type: QUERY
 23POSTHOOK: query: explain
 24select count(1) from tstparttbl
 25POSTHOOK: type: QUERY
 26ABSTRACT SYNTAX TREE:
 27  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME tstparttbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
 28
 29STAGE DEPENDENCIES:
 30  Stage-1 is a root stage
 31  Stage-0 is a root stage
 32
 33STAGE PLANS:
 34  Stage: Stage-1
 35    Map Reduce
 36      Alias -> Map Operator Tree:
 37        tstparttbl 
 38          TableScan
 39            alias: tstparttbl
 40            Select Operator
 41              Group By Operator
 42                aggregations:
 43                      expr: count(1)
 44                bucketGroup: false
 45                mode: hash
 46                outputColumnNames: _col0
 47                Reduce Output Operator
 48                  sort order: 
 49                  tag: -1
 50                  value expressions:
 51                        expr: _col0
 52                        type: bigint
 53      Reduce Operator Tree:
 54        Group By Operator
 55          aggregations:
 56                expr: count(VALUE._col0)
 57          bucketGroup: false
 58          mode: mergepartial
 59          outputColumnNames: _col0
 60          Select Operator
 61            expressions:
 62                  expr: _col0
 63                  type: bigint
 64            outputColumnNames: _col0
 65            File Output Operator
 66              compressed: false
 67              GlobalTableId: 0
 68              table:
 69                  input format: org.apache.hadoop.mapred.TextInputFormat
 70                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 71
 72  Stage: Stage-0
 73    Fetch Operator
 74      limit: -1
 75
 76
 77PREHOOK: query: select count(1) from tstparttbl
 78PREHOOK: type: QUERY
 79PREHOOK: Input: default@tstparttbl@ds=2008-04-08
 80PREHOOK: Input: default@tstparttbl@ds=2008-04-09
 81PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-07_266_530503210743564414/-mr-10000
 82POSTHOOK: query: select count(1) from tstparttbl
 83POSTHOOK: type: QUERY
 84POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
 85POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
 86POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-07_266_530503210743564414/-mr-10000
 87500
 88PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
 89PREHOOK: type: CREATETABLE
 90POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
 91POSTHOOK: type: CREATETABLE
 92POSTHOOK: Output: default@tstparttbl2
 93PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09')
 94PREHOOK: type: LOAD
 95PREHOOK: Output: default@tstparttbl2
 96POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09')
 97POSTHOOK: type: LOAD
 98POSTHOOK: Output: default@tstparttbl2
 99POSTHOOK: Output: default@tstparttbl2@ds=2008-04-09
100PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08')
101PREHOOK: type: LOAD
102PREHOOK: Output: default@tstparttbl2
103POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08')
104POSTHOOK: type: LOAD
105POSTHOOK: Output: default@tstparttbl2
106POSTHOOK: Output: default@tstparttbl2@ds=2008-04-08
107PREHOOK: query: explain
108select count(1) from tstparttbl2
109PREHOOK: type: QUERY
110POSTHOOK: query: explain
111select count(1) from tstparttbl2
112POSTHOOK: type: QUERY
113ABSTRACT SYNTAX TREE:
114  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME tstparttbl2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
115
116STAGE DEPENDENCIES:
117  Stage-1 is a root stage
118  Stage-0 is a root stage
119
120STAGE PLANS:
121  Stage: Stage-1
122    Map Reduce
123      Alias -> Map Operator Tree:
124        tstparttbl2 
125          TableScan
126            alias: tstparttbl2
127            Select Operator
128              Group By Operator
129                aggregations:
130                      expr: count(1)
131                bucketGroup: false
132                mode: hash
133                outputColumnNames: _col0
134                Reduce Output Operator
135                  sort order: 
136                  tag: -1
137                  value expressions:
138                        expr: _col0
139                        type: bigint
140      Reduce Operator Tree:
141        Group By Operator
142          aggregations:
143                expr: count(VALUE._col0)
144          bucketGroup: false
145          mode: mergepartial
146          outputColumnNames: _col0
147          Select Operator
148            expressions:
149                  expr: _col0
150                  type: bigint
151            outputColumnNames: _col0
152            File Output Operator
153              compressed: false
154              GlobalTableId: 0
155              table:
156                  input format: org.apache.hadoop.mapred.TextInputFormat
157                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
158
159  Stage: Stage-0
160    Fetch Operator
161      limit: -1
162
163
164PREHOOK: query: select count(1) from tstparttbl2
165PREHOOK: type: QUERY
166PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
167PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
168PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-10_685_2521681953062502433/-mr-10000
169POSTHOOK: query: select count(1) from tstparttbl2
170POSTHOOK: type: QUERY
171POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
172POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
173POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-10_685_2521681953062502433/-mr-10000
1740
175PREHOOK: query: DROP TABLE tstparttbl
176PREHOOK: type: DROPTABLE
177PREHOOK: Input: default@tstparttbl
178PREHOOK: Output: default@tstparttbl
179POSTHOOK: query: DROP TABLE tstparttbl
180POSTHOOK: type: DROPTABLE
181POSTHOOK: Input: default@tstparttbl
182POSTHOOK: Output: default@tstparttbl
183PREHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
184PREHOOK: type: CREATETABLE
185POSTHOOK: query: CREATE TABLE tstparttbl(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
186POSTHOOK: type: CREATETABLE
187POSTHOOK: Output: default@tstparttbl
188PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09')
189PREHOOK: type: LOAD
190PREHOOK: Output: default@tstparttbl
191POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-09')
192POSTHOOK: type: LOAD
193POSTHOOK: Output: default@tstparttbl
194POSTHOOK: Output: default@tstparttbl@ds=2008-04-09
195PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08')
196PREHOOK: type: LOAD
197PREHOOK: Output: default@tstparttbl
198POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl PARTITION (ds='2008-04-08')
199POSTHOOK: type: LOAD
200POSTHOOK: Output: default@tstparttbl
201POSTHOOK: Output: default@tstparttbl@ds=2008-04-08
202PREHOOK: query: explain
203select count(1) from tstparttbl
204PREHOOK: type: QUERY
205POSTHOOK: query: explain
206select count(1) from tstparttbl
207POSTHOOK: type: QUERY
208ABSTRACT SYNTAX TREE:
209  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME tstparttbl))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
210
211STAGE DEPENDENCIES:
212  Stage-1 is a root stage
213  Stage-0 is a root stage
214
215STAGE PLANS:
216  Stage: Stage-1
217    Map Reduce
218      Alias -> Map Operator Tree:
219        tstparttbl 
220          TableScan
221            alias: tstparttbl
222            Select Operator
223              Group By Operator
224                aggregations:
225                      expr: count(1)
226                bucketGroup: false
227                mode: hash
228                outputColumnNames: _col0
229                Reduce Output Operator
230                  sort order: 
231                  tag: -1
232                  value expressions:
233                        expr: _col0
234                        type: bigint
235      Reduce Operator Tree:
236        Group By Operator
237          aggregations:
238                expr: count(VALUE._col0)
239          bucketGroup: false
240          mode: mergepartial
241          outputColumnNames: _col0
242          Select Operator
243            expressions:
244                  expr: _col0
245                  type: bigint
246            outputColumnNames: _col0
247            File Output Operator
248              compressed: false
249              GlobalTableId: 0
250              table:
251                  input format: org.apache.hadoop.mapred.TextInputFormat
252                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
253
254  Stage: Stage-0
255    Fetch Operator
256      limit: -1
257
258
259PREHOOK: query: select count(1) from tstparttbl
260PREHOOK: type: QUERY
261PREHOOK: Input: default@tstparttbl@ds=2008-04-08
262PREHOOK: Input: default@tstparttbl@ds=2008-04-09
263PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-14_214_6605372656284457620/-mr-10000
264POSTHOOK: query: select count(1) from tstparttbl
265POSTHOOK: type: QUERY
266POSTHOOK: Input: default@tstparttbl@ds=2008-04-08
267POSTHOOK: Input: default@tstparttbl@ds=2008-04-09
268POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-14_214_6605372656284457620/-mr-10000
269500
270PREHOOK: query: DROP TABLE tstparttbl2
271PREHOOK: type: DROPTABLE
272PREHOOK: Input: default@tstparttbl2
273PREHOOK: Output: default@tstparttbl2
274POSTHOOK: query: DROP TABLE tstparttbl2
275POSTHOOK: type: DROPTABLE
276POSTHOOK: Input: default@tstparttbl2
277POSTHOOK: Output: default@tstparttbl2
278PREHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
279PREHOOK: type: CREATETABLE
280POSTHOOK: query: CREATE TABLE tstparttbl2(KEY STRING, VALUE STRING) PARTITIONED BY(ds string) STORED AS TEXTFILE
281POSTHOOK: type: CREATETABLE
282POSTHOOK: Output: default@tstparttbl2
283PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09')
284PREHOOK: type: LOAD
285PREHOOK: Output: default@tstparttbl2
286POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-09')
287POSTHOOK: type: LOAD
288POSTHOOK: Output: default@tstparttbl2
289POSTHOOK: Output: default@tstparttbl2@ds=2008-04-09
290PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08')
291PREHOOK: type: LOAD
292PREHOOK: Output: default@tstparttbl2
293POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/nullfile.txt' INTO TABLE tstparttbl2 PARTITION (ds='2008-04-08')
294POSTHOOK: type: LOAD
295POSTHOOK: Output: default@tstparttbl2
296POSTHOOK: Output: default@tstparttbl2@ds=2008-04-08
297PREHOOK: query: explain
298select count(1) from tstparttbl2
299PREHOOK: type: QUERY
300POSTHOOK: query: explain
301select count(1) from tstparttbl2
302POSTHOOK: type: QUERY
303ABSTRACT SYNTAX TREE:
304  (TOK_QUERY (TOK_FROM (TOK_TABREF (TOK_TABNAME tstparttbl2))) (TOK_INSERT (TOK_DESTINATION (TOK_DIR TOK_TMP_FILE)) (TOK_SELECT (TOK_SELEXPR (TOK_FUNCTION count 1)))))
305
306STAGE DEPENDENCIES:
307  Stage-1 is a root stage
308  Stage-0 is a root stage
309
310STAGE PLANS:
311  Stage: Stage-1
312    Map Reduce
313      Alias -> Map Operator Tree:
314        tstparttbl2 
315          TableScan
316            alias: tstparttbl2
317            Select Operator
318              Group By Operator
319                aggregations:
320                      expr: count(1)
321                bucketGroup: false
322                mode: hash
323                outputColumnNames: _col0
324                Reduce Output Operator
325                  sort order: 
326                  tag: -1
327                  value expressions:
328                        expr: _col0
329                        type: bigint
330      Reduce Operator Tree:
331        Group By Operator
332          aggregations:
333                expr: count(VALUE._col0)
334          bucketGroup: false
335          mode: mergepartial
336          outputColumnNames: _col0
337          Select Operator
338            expressions:
339                  expr: _col0
340                  type: bigint
341            outputColumnNames: _col0
342            File Output Operator
343              compressed: false
344              GlobalTableId: 0
345              table:
346                  input format: org.apache.hadoop.mapred.TextInputFormat
347                  output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
348
349  Stage: Stage-0
350    Fetch Operator
351      limit: -1
352
353
354PREHOOK: query: select count(1) from tstparttbl2
355PREHOOK: type: QUERY
356PREHOOK: Input: default@tstparttbl2@ds=2008-04-08
357PREHOOK: Input: default@tstparttbl2@ds=2008-04-09
358PREHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-17_713_2865331384408810906/-mr-10000
359POSTHOOK: query: select count(1) from tstparttbl2
360POSTHOOK: type: QUERY
361POSTHOOK: Input: default@tstparttbl2@ds=2008-04-08
362POSTHOOK: Input: default@tstparttbl2@ds=2008-04-09
363POSTHOOK: Output: file:/tmp/krishnak/hive_2011-03-21_04-13-17_713_2865331384408810906/-mr-10000
3640