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

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

#
text | 549 lines | 544 code | 5 blank | 0 comment | 0 complexity | c2a533e8a584f62996aec9f997c56c98 MD5 | raw file
  1PREHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
  2PREHOOK: type: CREATETABLE
  3POSTHOOK: query: CREATE TABLE INPUT4(KEY STRING, VALUE STRING) STORED AS TEXTFILE
  4POSTHOOK: type: CREATETABLE
  5POSTHOOK: Output: default@INPUT4
  6PREHOOK: query: EXPLAIN
  7LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
  8PREHOOK: type: LOAD
  9POSTHOOK: query: EXPLAIN
 10LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
 11POSTHOOK: type: LOAD
 12ABSTRACT SYNTAX TREE:
 13  (TOK_LOAD '../data/files/kv1.txt' (TOK_TAB (TOK_TABNAME INPUT4)) LOCAL)
 14
 15STAGE DEPENDENCIES:
 16  Stage-0 is a root stage
 17  Stage-1 depends on stages: Stage-0
 18
 19STAGE PLANS:
 20  Stage: Stage-0
 21    Copy
 22      source: file:/Users/krishnak/Projects/hdp/sources/hive-git-apache/data/files/kv1.txt
 23      destination: pfile:/Users/krishnak/Projects/hdp/sources/hive-git-apache/build/ql/scratchdir/hive_2011-03-20_23-49-16_008_2588436210508896099/-ext-10000
 24
 25  Stage: Stage-1
 26    Move Operator
 27      tables:
 28          replace: false
 29          table:
 30              input format: org.apache.hadoop.mapred.TextInputFormat
 31              output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat
 32              serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe
 33              name: default.input4
 34
 35
 36PREHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
 37PREHOOK: type: LOAD
 38PREHOOK: Output: default@input4
 39POSTHOOK: query: LOAD DATA LOCAL INPATH '../data/files/kv1.txt' INTO TABLE INPUT4
 40POSTHOOK: type: LOAD
 41POSTHOOK: Output: default@input4
 42PREHOOK: query: SELECT INPUT4.VALUE, INPUT4.KEY FROM INPUT4
 43PREHOOK: type: QUERY
 44PREHOOK: Input: default@input4
 45PREHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-49-17_477_5960644229997823855/-mr-10000
 46POSTHOOK: query: SELECT INPUT4.VALUE, INPUT4.KEY FROM INPUT4
 47POSTHOOK: type: QUERY
 48POSTHOOK: Input: default@input4
 49POSTHOOK: Output: file:/var/folders/67/67R3POPtF90VG63KSmCbcU++F0U/-Tmp-/krishnak/hive_2011-03-20_23-49-17_477_5960644229997823855/-mr-10000
 50val_238	238
 51val_86	86
 52val_311	311
 53val_27	27
 54val_165	165
 55val_409	409
 56val_255	255
 57val_278	278
 58val_98	98
 59val_484	484
 60val_265	265
 61val_193	193
 62val_401	401
 63val_150	150
 64val_273	273
 65val_224	224
 66val_369	369
 67val_66	66
 68val_128	128
 69val_213	213
 70val_146	146
 71val_406	406
 72val_429	429
 73val_374	374
 74val_152	152
 75val_469	469
 76val_145	145
 77val_495	495
 78val_37	37
 79val_327	327
 80val_281	281
 81val_277	277
 82val_209	209
 83val_15	15
 84val_82	82
 85val_403	403
 86val_166	166
 87val_417	417
 88val_430	430
 89val_252	252
 90val_292	292
 91val_219	219
 92val_287	287
 93val_153	153
 94val_193	193
 95val_338	338
 96val_446	446
 97val_459	459
 98val_394	394
 99val_237	237
100val_482	482
101val_174	174
102val_413	413
103val_494	494
104val_207	207
105val_199	199
106val_466	466
107val_208	208
108val_174	174
109val_399	399
110val_396	396
111val_247	247
112val_417	417
113val_489	489
114val_162	162
115val_377	377
116val_397	397
117val_309	309
118val_365	365
119val_266	266
120val_439	439
121val_342	342
122val_367	367
123val_325	325
124val_167	167
125val_195	195
126val_475	475
127val_17	17
128val_113	113
129val_155	155
130val_203	203
131val_339	339
132val_0	0
133val_455	455
134val_128	128
135val_311	311
136val_316	316
137val_57	57
138val_302	302
139val_205	205
140val_149	149
141val_438	438
142val_345	345
143val_129	129
144val_170	170
145val_20	20
146val_489	489
147val_157	157
148val_378	378
149val_221	221
150val_92	92
151val_111	111
152val_47	47
153val_72	72
154val_4	4
155val_280	280
156val_35	35
157val_427	427
158val_277	277
159val_208	208
160val_356	356
161val_399	399
162val_169	169
163val_382	382
164val_498	498
165val_125	125
166val_386	386
167val_437	437
168val_469	469
169val_192	192
170val_286	286
171val_187	187
172val_176	176
173val_54	54
174val_459	459
175val_51	51
176val_138	138
177val_103	103
178val_239	239
179val_213	213
180val_216	216
181val_430	430
182val_278	278
183val_176	176
184val_289	289
185val_221	221
186val_65	65
187val_318	318
188val_332	332
189val_311	311
190val_275	275
191val_137	137
192val_241	241
193val_83	83
194val_333	333
195val_180	180
196val_284	284
197val_12	12
198val_230	230
199val_181	181
200val_67	67
201val_260	260
202val_404	404
203val_384	384
204val_489	489
205val_353	353
206val_373	373
207val_272	272
208val_138	138
209val_217	217
210val_84	84
211val_348	348
212val_466	466
213val_58	58
214val_8	8
215val_411	411
216val_230	230
217val_208	208
218val_348	348
219val_24	24
220val_463	463
221val_431	431
222val_179	179
223val_172	172
224val_42	42
225val_129	129
226val_158	158
227val_119	119
228val_496	496
229val_0	0
230val_322	322
231val_197	197
232val_468	468
233val_393	393
234val_454	454
235val_100	100
236val_298	298
237val_199	199
238val_191	191
239val_418	418
240val_96	96
241val_26	26
242val_165	165
243val_327	327
244val_230	230
245val_205	205
246val_120	120
247val_131	131
248val_51	51
249val_404	404
250val_43	43
251val_436	436
252val_156	156
253val_469	469
254val_468	468
255val_308	308
256val_95	95
257val_196	196
258val_288	288
259val_481	481
260val_457	457
261val_98	98
262val_282	282
263val_197	197
264val_187	187
265val_318	318
266val_318	318
267val_409	409
268val_470	470
269val_137	137
270val_369	369
271val_316	316
272val_169	169
273val_413	413
274val_85	85
275val_77	77
276val_0	0
277val_490	490
278val_87	87
279val_364	364
280val_179	179
281val_118	118
282val_134	134
283val_395	395
284val_282	282
285val_138	138
286val_238	238
287val_419	419
288val_15	15
289val_118	118
290val_72	72
291val_90	90
292val_307	307
293val_19	19
294val_435	435
295val_10	10
296val_277	277
297val_273	273
298val_306	306
299val_224	224
300val_309	309
301val_389	389
302val_327	327
303val_242	242
304val_369	369
305val_392	392
306val_272	272
307val_331	331
308val_401	401
309val_242	242
310val_452	452
311val_177	177
312val_226	226
313val_5	5
314val_497	497
315val_402	402
316val_396	396
317val_317	317
318val_395	395
319val_58	58
320val_35	35
321val_336	336
322val_95	95
323val_11	11
324val_168	168
325val_34	34
326val_229	229
327val_233	233
328val_143	143
329val_472	472
330val_322	322
331val_498	498
332val_160	160
333val_195	195
334val_42	42
335val_321	321
336val_430	430
337val_119	119
338val_489	489
339val_458	458
340val_78	78
341val_76	76
342val_41	41
343val_223	223
344val_492	492
345val_149	149
346val_449	449
347val_218	218
348val_228	228
349val_138	138
350val_453	453
351val_30	30
352val_209	209
353val_64	64
354val_468	468
355val_76	76
356val_74	74
357val_342	342
358val_69	69
359val_230	230
360val_33	33
361val_368	368
362val_103	103
363val_296	296
364val_113	113
365val_216	216
366val_367	367
367val_344	344
368val_167	167
369val_274	274
370val_219	219
371val_239	239
372val_485	485
373val_116	116
374val_223	223
375val_256	256
376val_263	263
377val_70	70
378val_487	487
379val_480	480
380val_401	401
381val_288	288
382val_191	191
383val_5	5
384val_244	244
385val_438	438
386val_128	128
387val_467	467
388val_432	432
389val_202	202
390val_316	316
391val_229	229
392val_469	469
393val_463	463
394val_280	280
395val_2	2
396val_35	35
397val_283	283
398val_331	331
399val_235	235
400val_80	80
401val_44	44
402val_193	193
403val_321	321
404val_335	335
405val_104	104
406val_466	466
407val_366	366
408val_175	175
409val_403	403
410val_483	483
411val_53	53
412val_105	105
413val_257	257
414val_406	406
415val_409	409
416val_190	190
417val_406	406
418val_401	401
419val_114	114
420val_258	258
421val_90	90
422val_203	203
423val_262	262
424val_348	348
425val_424	424
426val_12	12
427val_396	396
428val_201	201
429val_217	217
430val_164	164
431val_431	431
432val_454	454
433val_478	478
434val_298	298
435val_125	125
436val_431	431
437val_164	164
438val_424	424
439val_187	187
440val_382	382
441val_5	5
442val_70	70
443val_397	397
444val_480	480
445val_291	291
446val_24	24
447val_351	351
448val_255	255
449val_104	104
450val_70	70
451val_163	163
452val_438	438
453val_119	119
454val_414	414
455val_200	200
456val_491	491
457val_237	237
458val_439	439
459val_360	360
460val_248	248
461val_479	479
462val_305	305
463val_417	417
464val_199	199
465val_444	444
466val_120	120
467val_429	429
468val_169	169
469val_443	443
470val_323	323
471val_325	325
472val_277	277
473val_230	230
474val_478	478
475val_178	178
476val_468	468
477val_310	310
478val_317	317
479val_333	333
480val_493	493
481val_460	460
482val_207	207
483val_249	249
484val_265	265
485val_480	480
486val_83	83
487val_136	136
488val_353	353
489val_172	172
490val_214	214
491val_462	462
492val_233	233
493val_406	406
494val_133	133
495val_175	175
496val_189	189
497val_454	454
498val_375	375
499val_401	401
500val_421	421
501val_407	407
502val_384	384
503val_256	256
504val_26	26
505val_134	134
506val_67	67
507val_384	384
508val_379	379
509val_18	18
510val_462	462
511val_492	492
512val_100	100
513val_298	298
514val_9	9
515val_341	341
516val_498	498
517val_146	146
518val_458	458
519val_362	362
520val_186	186
521val_285	285
522val_348	348
523val_167	167
524val_18	18
525val_273	273
526val_183	183
527val_281	281
528val_344	344
529val_97	97
530val_469	469
531val_315	315
532val_84	84
533val_28	28
534val_37	37
535val_448	448
536val_152	152
537val_348	348
538val_307	307
539val_194	194
540val_414	414
541val_477	477
542val_222	222
543val_126	126
544val_90	90
545val_169	169
546val_403	403
547val_400	400
548val_200	200
549val_97	97