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

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

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