PREHOOK: query: drop table tmp_insert_test
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tmp_insert_test
POSTHOOK: type: DROPTABLE
PREHOOK: query: drop table tmp_insert_test_p
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tmp_insert_test_p
POSTHOOK: type: DROPTABLE
PREHOOK: query: create table tmp_insert_test (key string, value string) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tmp_insert_test (key string, value string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tmp_insert_test
PREHOOK: query: load data local inpath '../data/files/kv1.txt' into table tmp_insert_test
PREHOOK: type: LOAD
POSTHOOK: query: load data local inpath '../data/files/kv1.txt' into table tmp_insert_test
POSTHOOK: type: LOAD
POSTHOOK: Output: default@tmp_insert_test
PREHOOK: query: select * from tmp_insert_test
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_insert_test
PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1950785675/10000
POSTHOOK: query: select * from tmp_insert_test
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_insert_test
POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1950785675/10000
238	val_238
86	val_86
311	val_311
27	val_27
165	val_165
409	val_409
255	val_255
278	val_278
98	val_98
484	val_484
265	val_265
193	val_193
401	val_401
150	val_150
273	val_273
224	val_224
369	val_369
66	val_66
128	val_128
213	val_213
146	val_146
406	val_406
429	val_429
374	val_374
152	val_152
469	val_469
145	val_145
495	val_495
37	val_37
327	val_327
281	val_281
277	val_277
209	val_209
15	val_15
82	val_82
403	val_403
166	val_166
417	val_417
430	val_430
252	val_252
292	val_292
219	val_219
287	val_287
153	val_153
193	val_193
338	val_338
446	val_446
459	val_459
394	val_394
237	val_237
482	val_482
174	val_174
413	val_413
494	val_494
207	val_207
199	val_199
466	val_466
208	val_208
174	val_174
399	val_399
396	val_396
247	val_247
417	val_417
489	val_489
162	val_162
377	val_377
397	val_397
309	val_309
365	val_365
266	val_266
439	val_439
342	val_342
367	val_367
325	val_325
167	val_167
195	val_195
475	val_475
17	val_17
113	val_113
155	val_155
203	val_203
339	val_339
0	val_0
455	val_455
128	val_128
311	val_311
316	val_316
57	val_57
302	val_302
205	val_205
149	val_149
438	val_438
345	val_345
129	val_129
170	val_170
20	val_20
489	val_489
157	val_157
378	val_378
221	val_221
92	val_92
111	val_111
47	val_47
72	val_72
4	val_4
280	val_280
35	val_35
427	val_427
277	val_277
208	val_208
356	val_356
399	val_399
169	val_169
382	val_382
498	val_498
125	val_125
386	val_386
437	val_437
469	val_469
192	val_192
286	val_286
187	val_187
176	val_176
54	val_54
459	val_459
51	val_51
138	val_138
103	val_103
239	val_239
213	val_213
216	val_216
430	val_430
278	val_278
176	val_176
289	val_289
221	val_221
65	val_65
318	val_318
332	val_332
311	val_311
275	val_275
137	val_137
241	val_241
83	val_83
333	val_333
180	val_180
284	val_284
12	val_12
230	val_230
181	val_181
67	val_67
260	val_260
404	val_404
384	val_384
489	val_489
353	val_353
373	val_373
272	val_272
138	val_138
217	val_217
84	val_84
348	val_348
466	val_466
58	val_58
8	val_8
411	val_411
230	val_230
208	val_208
348	val_348
24	val_24
463	val_463
431	val_431
179	val_179
172	val_172
42	val_42
129	val_129
158	val_158
119	val_119
496	val_496
0	val_0
322	val_322
197	val_197
468	val_468
393	val_393
454	val_454
100	val_100
298	val_298
199	val_199
191	val_191
418	val_418
96	val_96
26	val_26
165	val_165
327	val_327
230	val_230
205	val_205
120	val_120
131	val_131
51	val_51
404	val_404
43	val_43
436	val_436
156	val_156
469	val_469
468	val_468
308	val_308
95	val_95
196	val_196
288	val_288
481	val_481
457	val_457
98	val_98
282	val_282
197	val_197
187	val_187
318	val_318
318	val_318
409	val_409
470	val_470
137	val_137
369	val_369
316	val_316
169	val_169
413	val_413
85	val_85
77	val_77
0	val_0
490	val_490
87	val_87
364	val_364
179	val_179
118	val_118
134	val_134
395	val_395
282	val_282
138	val_138
238	val_238
419	val_419
15	val_15
118	val_118
72	val_72
90	val_90
307	val_307
19	val_19
435	val_435
10	val_10
277	val_277
273	val_273
306	val_306
224	val_224
309	val_309
389	val_389
327	val_327
242	val_242
369	val_369
392	val_392
272	val_272
331	val_331
401	val_401
242	val_242
452	val_452
177	val_177
226	val_226
5	val_5
497	val_497
402	val_402
396	val_396
317	val_317
395	val_395
58	val_58
35	val_35
336	val_336
95	val_95
11	val_11
168	val_168
34	val_34
229	val_229
233	val_233
143	val_143
472	val_472
322	val_322
498	val_498
160	val_160
195	val_195
42	val_42
321	val_321
430	val_430
119	val_119
489	val_489
458	val_458
78	val_78
76	val_76
41	val_41
223	val_223
492	val_492
149	val_149
449	val_449
218	val_218
228	val_228
138	val_138
453	val_453
30	val_30
209	val_209
64	val_64
468	val_468
76	val_76
74	val_74
342	val_342
69	val_69
230	val_230
33	val_33
368	val_368
103	val_103
296	val_296
113	val_113
216	val_216
367	val_367
344	val_344
167	val_167
274	val_274
219	val_219
239	val_239
485	val_485
116	val_116
223	val_223
256	val_256
263	val_263
70	val_70
487	val_487
480	val_480
401	val_401
288	val_288
191	val_191
5	val_5
244	val_244
438	val_438
128	val_128
467	val_467
432	val_432
202	val_202
316	val_316
229	val_229
469	val_469
463	val_463
280	val_280
2	val_2
35	val_35
283	val_283
331	val_331
235	val_235
80	val_80
44	val_44
193	val_193
321	val_321
335	val_335
104	val_104
466	val_466
366	val_366
175	val_175
403	val_403
483	val_483
53	val_53
105	val_105
257	val_257
406	val_406
409	val_409
190	val_190
406	val_406
401	val_401
114	val_114
258	val_258
90	val_90
203	val_203
262	val_262
348	val_348
424	val_424
12	val_12
396	val_396
201	val_201
217	val_217
164	val_164
431	val_431
454	val_454
478	val_478
298	val_298
125	val_125
431	val_431
164	val_164
424	val_424
187	val_187
382	val_382
5	val_5
70	val_70
397	val_397
480	val_480
291	val_291
24	val_24
351	val_351
255	val_255
104	val_104
70	val_70
163	val_163
438	val_438
119	val_119
414	val_414
200	val_200
491	val_491
237	val_237
439	val_439
360	val_360
248	val_248
479	val_479
305	val_305
417	val_417
199	val_199
444	val_444
120	val_120
429	val_429
169	val_169
443	val_443
323	val_323
325	val_325
277	val_277
230	val_230
478	val_478
178	val_178
468	val_468
310	val_310
317	val_317
333	val_333
493	val_493
460	val_460
207	val_207
249	val_249
265	val_265
480	val_480
83	val_83
136	val_136
353	val_353
172	val_172
214	val_214
462	val_462
233	val_233
406	val_406
133	val_133
175	val_175
189	val_189
454	val_454
375	val_375
401	val_401
421	val_421
407	val_407
384	val_384
256	val_256
26	val_26
134	val_134
67	val_67
384	val_384
379	val_379
18	val_18
462	val_462
492	val_492
100	val_100
298	val_298
9	val_9
341	val_341
498	val_498
146	val_146
458	val_458
362	val_362
186	val_186
285	val_285
348	val_348
167	val_167
18	val_18
273	val_273
183	val_183
281	val_281
344	val_344
97	val_97
469	val_469
315	val_315
84	val_84
28	val_28
37	val_37
448	val_448
152	val_152
348	val_348
307	val_307
194	val_194
414	val_414
477	val_477
222	val_222
126	val_126
90	val_90
169	val_169
403	val_403
400	val_400
200	val_200
97	val_97
PREHOOK: query: create table tmp_insert_test_p (key string, value string) partitioned by (ds string) stored as textfile
PREHOOK: type: CREATETABLE
POSTHOOK: query: create table tmp_insert_test_p (key string, value string) partitioned by (ds string) stored as textfile
POSTHOOK: type: CREATETABLE
POSTHOOK: Output: default@tmp_insert_test_p
PREHOOK: query: load data local inpath '../data/files/kv1.txt' into table tmp_insert_test_p partition (ds = '2009-08-01')
PREHOOK: type: LOAD
POSTHOOK: query: load data local inpath '../data/files/kv1.txt' into table tmp_insert_test_p partition (ds = '2009-08-01')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@tmp_insert_test_p@ds=2009-08-01
PREHOOK: query: select * from tmp_insert_test_p where ds= '2009-08-01'
order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/237111013/10000
POSTHOOK: query: select * from tmp_insert_test_p where ds= '2009-08-01'
order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/237111013/10000
0	val_0	2009-08-01
0	val_0	2009-08-01
0	val_0	2009-08-01
10	val_10	2009-08-01
100	val_100	2009-08-01
100	val_100	2009-08-01
103	val_103	2009-08-01
103	val_103	2009-08-01
104	val_104	2009-08-01
104	val_104	2009-08-01
105	val_105	2009-08-01
11	val_11	2009-08-01
111	val_111	2009-08-01
113	val_113	2009-08-01
113	val_113	2009-08-01
114	val_114	2009-08-01
116	val_116	2009-08-01
118	val_118	2009-08-01
118	val_118	2009-08-01
119	val_119	2009-08-01
119	val_119	2009-08-01
119	val_119	2009-08-01
12	val_12	2009-08-01
12	val_12	2009-08-01
120	val_120	2009-08-01
120	val_120	2009-08-01
125	val_125	2009-08-01
125	val_125	2009-08-01
126	val_126	2009-08-01
128	val_128	2009-08-01
128	val_128	2009-08-01
128	val_128	2009-08-01
129	val_129	2009-08-01
129	val_129	2009-08-01
131	val_131	2009-08-01
133	val_133	2009-08-01
134	val_134	2009-08-01
134	val_134	2009-08-01
136	val_136	2009-08-01
137	val_137	2009-08-01
137	val_137	2009-08-01
138	val_138	2009-08-01
138	val_138	2009-08-01
138	val_138	2009-08-01
138	val_138	2009-08-01
143	val_143	2009-08-01
145	val_145	2009-08-01
146	val_146	2009-08-01
146	val_146	2009-08-01
149	val_149	2009-08-01
149	val_149	2009-08-01
15	val_15	2009-08-01
15	val_15	2009-08-01
150	val_150	2009-08-01
152	val_152	2009-08-01
152	val_152	2009-08-01
153	val_153	2009-08-01
155	val_155	2009-08-01
156	val_156	2009-08-01
157	val_157	2009-08-01
158	val_158	2009-08-01
160	val_160	2009-08-01
162	val_162	2009-08-01
163	val_163	2009-08-01
164	val_164	2009-08-01
164	val_164	2009-08-01
165	val_165	2009-08-01
165	val_165	2009-08-01
166	val_166	2009-08-01
167	val_167	2009-08-01
167	val_167	2009-08-01
167	val_167	2009-08-01
168	val_168	2009-08-01
169	val_169	2009-08-01
169	val_169	2009-08-01
169	val_169	2009-08-01
169	val_169	2009-08-01
17	val_17	2009-08-01
170	val_170	2009-08-01
172	val_172	2009-08-01
172	val_172	2009-08-01
174	val_174	2009-08-01
174	val_174	2009-08-01
175	val_175	2009-08-01
175	val_175	2009-08-01
176	val_176	2009-08-01
176	val_176	2009-08-01
177	val_177	2009-08-01
178	val_178	2009-08-01
179	val_179	2009-08-01
179	val_179	2009-08-01
18	val_18	2009-08-01
18	val_18	2009-08-01
180	val_180	2009-08-01
181	val_181	2009-08-01
183	val_183	2009-08-01
186	val_186	2009-08-01
187	val_187	2009-08-01
187	val_187	2009-08-01
187	val_187	2009-08-01
189	val_189	2009-08-01
19	val_19	2009-08-01
190	val_190	2009-08-01
191	val_191	2009-08-01
191	val_191	2009-08-01
192	val_192	2009-08-01
193	val_193	2009-08-01
193	val_193	2009-08-01
193	val_193	2009-08-01
194	val_194	2009-08-01
195	val_195	2009-08-01
195	val_195	2009-08-01
196	val_196	2009-08-01
197	val_197	2009-08-01
197	val_197	2009-08-01
199	val_199	2009-08-01
199	val_199	2009-08-01
199	val_199	2009-08-01
2	val_2	2009-08-01
20	val_20	2009-08-01
200	val_200	2009-08-01
200	val_200	2009-08-01
201	val_201	2009-08-01
202	val_202	2009-08-01
203	val_203	2009-08-01
203	val_203	2009-08-01
205	val_205	2009-08-01
205	val_205	2009-08-01
207	val_207	2009-08-01
207	val_207	2009-08-01
208	val_208	2009-08-01
208	val_208	2009-08-01
208	val_208	2009-08-01
209	val_209	2009-08-01
209	val_209	2009-08-01
213	val_213	2009-08-01
213	val_213	2009-08-01
214	val_214	2009-08-01
216	val_216	2009-08-01
216	val_216	2009-08-01
217	val_217	2009-08-01
217	val_217	2009-08-01
218	val_218	2009-08-01
219	val_219	2009-08-01
219	val_219	2009-08-01
221	val_221	2009-08-01
221	val_221	2009-08-01
222	val_222	2009-08-01
223	val_223	2009-08-01
223	val_223	2009-08-01
224	val_224	2009-08-01
224	val_224	2009-08-01
226	val_226	2009-08-01
228	val_228	2009-08-01
229	val_229	2009-08-01
229	val_229	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
233	val_233	2009-08-01
233	val_233	2009-08-01
235	val_235	2009-08-01
237	val_237	2009-08-01
237	val_237	2009-08-01
238	val_238	2009-08-01
238	val_238	2009-08-01
239	val_239	2009-08-01
239	val_239	2009-08-01
24	val_24	2009-08-01
24	val_24	2009-08-01
241	val_241	2009-08-01
242	val_242	2009-08-01
242	val_242	2009-08-01
244	val_244	2009-08-01
247	val_247	2009-08-01
248	val_248	2009-08-01
249	val_249	2009-08-01
252	val_252	2009-08-01
255	val_255	2009-08-01
255	val_255	2009-08-01
256	val_256	2009-08-01
256	val_256	2009-08-01
257	val_257	2009-08-01
258	val_258	2009-08-01
26	val_26	2009-08-01
26	val_26	2009-08-01
260	val_260	2009-08-01
262	val_262	2009-08-01
263	val_263	2009-08-01
265	val_265	2009-08-01
265	val_265	2009-08-01
266	val_266	2009-08-01
27	val_27	2009-08-01
272	val_272	2009-08-01
272	val_272	2009-08-01
273	val_273	2009-08-01
273	val_273	2009-08-01
273	val_273	2009-08-01
274	val_274	2009-08-01
275	val_275	2009-08-01
277	val_277	2009-08-01
277	val_277	2009-08-01
277	val_277	2009-08-01
277	val_277	2009-08-01
278	val_278	2009-08-01
278	val_278	2009-08-01
28	val_28	2009-08-01
280	val_280	2009-08-01
280	val_280	2009-08-01
281	val_281	2009-08-01
281	val_281	2009-08-01
282	val_282	2009-08-01
282	val_282	2009-08-01
283	val_283	2009-08-01
284	val_284	2009-08-01
285	val_285	2009-08-01
286	val_286	2009-08-01
287	val_287	2009-08-01
288	val_288	2009-08-01
288	val_288	2009-08-01
289	val_289	2009-08-01
291	val_291	2009-08-01
292	val_292	2009-08-01
296	val_296	2009-08-01
298	val_298	2009-08-01
298	val_298	2009-08-01
298	val_298	2009-08-01
30	val_30	2009-08-01
302	val_302	2009-08-01
305	val_305	2009-08-01
306	val_306	2009-08-01
307	val_307	2009-08-01
307	val_307	2009-08-01
308	val_308	2009-08-01
309	val_309	2009-08-01
309	val_309	2009-08-01
310	val_310	2009-08-01
311	val_311	2009-08-01
311	val_311	2009-08-01
311	val_311	2009-08-01
315	val_315	2009-08-01
316	val_316	2009-08-01
316	val_316	2009-08-01
316	val_316	2009-08-01
317	val_317	2009-08-01
317	val_317	2009-08-01
318	val_318	2009-08-01
318	val_318	2009-08-01
318	val_318	2009-08-01
321	val_321	2009-08-01
321	val_321	2009-08-01
322	val_322	2009-08-01
322	val_322	2009-08-01
323	val_323	2009-08-01
325	val_325	2009-08-01
325	val_325	2009-08-01
327	val_327	2009-08-01
327	val_327	2009-08-01
327	val_327	2009-08-01
33	val_33	2009-08-01
331	val_331	2009-08-01
331	val_331	2009-08-01
332	val_332	2009-08-01
333	val_333	2009-08-01
333	val_333	2009-08-01
335	val_335	2009-08-01
336	val_336	2009-08-01
338	val_338	2009-08-01
339	val_339	2009-08-01
34	val_34	2009-08-01
341	val_341	2009-08-01
342	val_342	2009-08-01
342	val_342	2009-08-01
344	val_344	2009-08-01
344	val_344	2009-08-01
345	val_345	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
35	val_35	2009-08-01
35	val_35	2009-08-01
35	val_35	2009-08-01
351	val_351	2009-08-01
353	val_353	2009-08-01
353	val_353	2009-08-01
356	val_356	2009-08-01
360	val_360	2009-08-01
362	val_362	2009-08-01
364	val_364	2009-08-01
365	val_365	2009-08-01
366	val_366	2009-08-01
367	val_367	2009-08-01
367	val_367	2009-08-01
368	val_368	2009-08-01
369	val_369	2009-08-01
369	val_369	2009-08-01
369	val_369	2009-08-01
37	val_37	2009-08-01
37	val_37	2009-08-01
373	val_373	2009-08-01
374	val_374	2009-08-01
375	val_375	2009-08-01
377	val_377	2009-08-01
378	val_378	2009-08-01
379	val_379	2009-08-01
382	val_382	2009-08-01
382	val_382	2009-08-01
384	val_384	2009-08-01
384	val_384	2009-08-01
384	val_384	2009-08-01
386	val_386	2009-08-01
389	val_389	2009-08-01
392	val_392	2009-08-01
393	val_393	2009-08-01
394	val_394	2009-08-01
395	val_395	2009-08-01
395	val_395	2009-08-01
396	val_396	2009-08-01
396	val_396	2009-08-01
396	val_396	2009-08-01
397	val_397	2009-08-01
397	val_397	2009-08-01
399	val_399	2009-08-01
399	val_399	2009-08-01
4	val_4	2009-08-01
400	val_400	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
402	val_402	2009-08-01
403	val_403	2009-08-01
403	val_403	2009-08-01
403	val_403	2009-08-01
404	val_404	2009-08-01
404	val_404	2009-08-01
406	val_406	2009-08-01
406	val_406	2009-08-01
406	val_406	2009-08-01
406	val_406	2009-08-01
407	val_407	2009-08-01
409	val_409	2009-08-01
409	val_409	2009-08-01
409	val_409	2009-08-01
41	val_41	2009-08-01
411	val_411	2009-08-01
413	val_413	2009-08-01
413	val_413	2009-08-01
414	val_414	2009-08-01
414	val_414	2009-08-01
417	val_417	2009-08-01
417	val_417	2009-08-01
417	val_417	2009-08-01
418	val_418	2009-08-01
419	val_419	2009-08-01
42	val_42	2009-08-01
42	val_42	2009-08-01
421	val_421	2009-08-01
424	val_424	2009-08-01
424	val_424	2009-08-01
427	val_427	2009-08-01
429	val_429	2009-08-01
429	val_429	2009-08-01
43	val_43	2009-08-01
430	val_430	2009-08-01
430	val_430	2009-08-01
430	val_430	2009-08-01
431	val_431	2009-08-01
431	val_431	2009-08-01
431	val_431	2009-08-01
432	val_432	2009-08-01
435	val_435	2009-08-01
436	val_436	2009-08-01
437	val_437	2009-08-01
438	val_438	2009-08-01
438	val_438	2009-08-01
438	val_438	2009-08-01
439	val_439	2009-08-01
439	val_439	2009-08-01
44	val_44	2009-08-01
443	val_443	2009-08-01
444	val_444	2009-08-01
446	val_446	2009-08-01
448	val_448	2009-08-01
449	val_449	2009-08-01
452	val_452	2009-08-01
453	val_453	2009-08-01
454	val_454	2009-08-01
454	val_454	2009-08-01
454	val_454	2009-08-01
455	val_455	2009-08-01
457	val_457	2009-08-01
458	val_458	2009-08-01
458	val_458	2009-08-01
459	val_459	2009-08-01
459	val_459	2009-08-01
460	val_460	2009-08-01
462	val_462	2009-08-01
462	val_462	2009-08-01
463	val_463	2009-08-01
463	val_463	2009-08-01
466	val_466	2009-08-01
466	val_466	2009-08-01
466	val_466	2009-08-01
467	val_467	2009-08-01
468	val_468	2009-08-01
468	val_468	2009-08-01
468	val_468	2009-08-01
468	val_468	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
47	val_47	2009-08-01
470	val_470	2009-08-01
472	val_472	2009-08-01
475	val_475	2009-08-01
477	val_477	2009-08-01
478	val_478	2009-08-01
478	val_478	2009-08-01
479	val_479	2009-08-01
480	val_480	2009-08-01
480	val_480	2009-08-01
480	val_480	2009-08-01
481	val_481	2009-08-01
482	val_482	2009-08-01
483	val_483	2009-08-01
484	val_484	2009-08-01
485	val_485	2009-08-01
487	val_487	2009-08-01
489	val_489	2009-08-01
489	val_489	2009-08-01
489	val_489	2009-08-01
489	val_489	2009-08-01
490	val_490	2009-08-01
491	val_491	2009-08-01
492	val_492	2009-08-01
492	val_492	2009-08-01
493	val_493	2009-08-01
494	val_494	2009-08-01
495	val_495	2009-08-01
496	val_496	2009-08-01
497	val_497	2009-08-01
498	val_498	2009-08-01
498	val_498	2009-08-01
498	val_498	2009-08-01
5	val_5	2009-08-01
5	val_5	2009-08-01
5	val_5	2009-08-01
51	val_51	2009-08-01
51	val_51	2009-08-01
53	val_53	2009-08-01
54	val_54	2009-08-01
57	val_57	2009-08-01
58	val_58	2009-08-01
58	val_58	2009-08-01
64	val_64	2009-08-01
65	val_65	2009-08-01
66	val_66	2009-08-01
67	val_67	2009-08-01
67	val_67	2009-08-01
69	val_69	2009-08-01
70	val_70	2009-08-01
70	val_70	2009-08-01
70	val_70	2009-08-01
72	val_72	2009-08-01
72	val_72	2009-08-01
74	val_74	2009-08-01
76	val_76	2009-08-01
76	val_76	2009-08-01
77	val_77	2009-08-01
78	val_78	2009-08-01
8	val_8	2009-08-01
80	val_80	2009-08-01
82	val_82	2009-08-01
83	val_83	2009-08-01
83	val_83	2009-08-01
84	val_84	2009-08-01
84	val_84	2009-08-01
85	val_85	2009-08-01
86	val_86	2009-08-01
87	val_87	2009-08-01
9	val_9	2009-08-01
90	val_90	2009-08-01
90	val_90	2009-08-01
90	val_90	2009-08-01
92	val_92	2009-08-01
95	val_95	2009-08-01
95	val_95	2009-08-01
96	val_96	2009-08-01
97	val_97	2009-08-01
97	val_97	2009-08-01
98	val_98	2009-08-01
98	val_98	2009-08-01
PREHOOK: query: load data local inpath '../data/files/kv2.txt' into table tmp_insert_test_p partition (ds = '2009-08-01')
PREHOOK: type: LOAD
POSTHOOK: query: load data local inpath '../data/files/kv2.txt' into table tmp_insert_test_p partition (ds = '2009-08-01')
POSTHOOK: type: LOAD
POSTHOOK: Output: default@tmp_insert_test_p@ds=2009-08-01
PREHOOK: query: select * from tmp_insert_test_p where ds= '2009-08-01'
order by key
PREHOOK: type: QUERY
PREHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
PREHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1350476431/10000
POSTHOOK: query: select * from tmp_insert_test_p where ds= '2009-08-01'
order by key
POSTHOOK: type: QUERY
POSTHOOK: Input: default@tmp_insert_test_p@ds=2009-08-01
POSTHOOK: Output: file:/data/users/jsichi/open/hive-trunk/build/ql/tmp/1350476431/10000
0	val_1	2009-08-01
0	val_1	2009-08-01
0	val_0	2009-08-01
0	val_0	2009-08-01
0	val_0	2009-08-01
1	val_2	2009-08-01
10	val_11	2009-08-01
10	val_10	2009-08-01
100	val_100	2009-08-01
100	val_100	2009-08-01
100	val_101	2009-08-01
100	val_101	2009-08-01
101	val_102	2009-08-01
102	val_103	2009-08-01
103	val_103	2009-08-01
103	val_103	2009-08-01
104	val_104	2009-08-01
104	val_104	2009-08-01
104	val_105	2009-08-01
104	val_105	2009-08-01
104	val_105	2009-08-01
105	val_106	2009-08-01
105	val_106	2009-08-01
105	val_105	2009-08-01
106	val_107	2009-08-01
11	val_12	2009-08-01
11	val_12	2009-08-01
11	val_12	2009-08-01
11	val_11	2009-08-01
110	val_111	2009-08-01
111	val_111	2009-08-01
113	val_113	2009-08-01
113	val_113	2009-08-01
114	val_114	2009-08-01
114	val_115	2009-08-01
114	val_115	2009-08-01
114	val_115	2009-08-01
116	val_117	2009-08-01
116	val_116	2009-08-01
117	val_118	2009-08-01
117	val_118	2009-08-01
118	val_119	2009-08-01
118	val_119	2009-08-01
118	val_119	2009-08-01
118	val_118	2009-08-01
118	val_118	2009-08-01
119	val_119	2009-08-01
119	val_119	2009-08-01
119	val_119	2009-08-01
119	val_120	2009-08-01
119	val_120	2009-08-01
119	val_120	2009-08-01
12	val_13	2009-08-01
12	val_12	2009-08-01
12	val_12	2009-08-01
120	val_120	2009-08-01
120	val_120	2009-08-01
120	val_121	2009-08-01
121	val_122	2009-08-01
121	val_122	2009-08-01
122	val_123	2009-08-01
122	val_123	2009-08-01
122	val_123	2009-08-01
123	val_124	2009-08-01
123	val_124	2009-08-01
125	val_126	2009-08-01
125	val_125	2009-08-01
125	val_125	2009-08-01
126	val_126	2009-08-01
126	val_127	2009-08-01
126	val_127	2009-08-01
128	val_129	2009-08-01
128	val_129	2009-08-01
128	val_128	2009-08-01
128	val_128	2009-08-01
128	val_128	2009-08-01
129	val_129	2009-08-01
129	val_129	2009-08-01
129	val_130	2009-08-01
129	val_130	2009-08-01
131	val_131	2009-08-01
132	val_133	2009-08-01
132	val_133	2009-08-01
133	val_134	2009-08-01
133	val_133	2009-08-01
134	val_134	2009-08-01
134	val_134	2009-08-01
134	val_135	2009-08-01
135	val_136	2009-08-01
135	val_136	2009-08-01
135	val_136	2009-08-01
136	val_137	2009-08-01
136	val_136	2009-08-01
137	val_137	2009-08-01
137	val_137	2009-08-01
137	val_138	2009-08-01
138	val_139	2009-08-01
138	val_139	2009-08-01
138	val_138	2009-08-01
138	val_138	2009-08-01
138	val_138	2009-08-01
138	val_138	2009-08-01
140	val_141	2009-08-01
143	val_144	2009-08-01
143	val_143	2009-08-01
144	val_145	2009-08-01
145	val_145	2009-08-01
146	val_146	2009-08-01
146	val_146	2009-08-01
147	val_148	2009-08-01
147	val_148	2009-08-01
149	val_150	2009-08-01
149	val_149	2009-08-01
149	val_149	2009-08-01
15	val_15	2009-08-01
15	val_15	2009-08-01
15	val_16	2009-08-01
15	val_16	2009-08-01
150	val_150	2009-08-01
151	val_152	2009-08-01
151	val_152	2009-08-01
152	val_153	2009-08-01
152	val_153	2009-08-01
152	val_153	2009-08-01
152	val_152	2009-08-01
152	val_152	2009-08-01
153	val_153	2009-08-01
153	val_154	2009-08-01
153	val_154	2009-08-01
155	val_155	2009-08-01
156	val_156	2009-08-01
156	val_157	2009-08-01
156	val_157	2009-08-01
157	val_158	2009-08-01
157	val_158	2009-08-01
157	val_157	2009-08-01
158	val_158	2009-08-01
16	val_17	2009-08-01
16	val_17	2009-08-01
160	val_161	2009-08-01
160	val_160	2009-08-01
161	val_162	2009-08-01
161	val_162	2009-08-01
161	val_162	2009-08-01
161	val_162	2009-08-01
162	val_163	2009-08-01
162	val_162	2009-08-01
163	val_163	2009-08-01
164	val_164	2009-08-01
164	val_164	2009-08-01
164	val_165	2009-08-01
164	val_165	2009-08-01
165	val_166	2009-08-01
165	val_165	2009-08-01
165	val_165	2009-08-01
166	val_166	2009-08-01
167	val_167	2009-08-01
167	val_167	2009-08-01
167	val_167	2009-08-01
167	val_168	2009-08-01
168	val_169	2009-08-01
168	val_168	2009-08-01
169	val_169	2009-08-01
169	val_169	2009-08-01
169	val_169	2009-08-01
169	val_169	2009-08-01
17	val_17	2009-08-01
170	val_170	2009-08-01
170	val_171	2009-08-01
172	val_173	2009-08-01
172	val_172	2009-08-01
172	val_172	2009-08-01
174	val_174	2009-08-01
174	val_174	2009-08-01
174	val_175	2009-08-01
174	val_175	2009-08-01
175	val_176	2009-08-01
175	val_176	2009-08-01
175	val_175	2009-08-01
175	val_175	2009-08-01
176	val_176	2009-08-01
176	val_176	2009-08-01
177	val_177	2009-08-01
177	val_178	2009-08-01
177	val_178	2009-08-01
178	val_179	2009-08-01
178	val_179	2009-08-01
178	val_178	2009-08-01
179	val_179	2009-08-01
179	val_179	2009-08-01
179	val_180	2009-08-01
18	val_18	2009-08-01
18	val_18	2009-08-01
180	val_180	2009-08-01
181	val_181	2009-08-01
182	val_183	2009-08-01
183	val_184	2009-08-01
183	val_183	2009-08-01
184	val_185	2009-08-01
185	val_186	2009-08-01
186	val_186	2009-08-01
187	val_187	2009-08-01
187	val_187	2009-08-01
187	val_187	2009-08-01
189	val_189	2009-08-01
189	val_190	2009-08-01
19	val_20	2009-08-01
19	val_19	2009-08-01
190	val_190	2009-08-01
191	val_191	2009-08-01
191	val_191	2009-08-01
191	val_192	2009-08-01
192	val_193	2009-08-01
192	val_192	2009-08-01
193	val_193	2009-08-01
193	val_193	2009-08-01
193	val_193	2009-08-01
194	val_194	2009-08-01
195	val_195	2009-08-01
195	val_195	2009-08-01
196	val_196	2009-08-01
196	val_197	2009-08-01
196	val_197	2009-08-01
196	val_197	2009-08-01
197	val_198	2009-08-01
197	val_197	2009-08-01
197	val_197	2009-08-01
199	val_199	2009-08-01
199	val_199	2009-08-01
199	val_199	2009-08-01
199	val_200	2009-08-01
2	val_3	2009-08-01
2	val_2	2009-08-01
20	val_20	2009-08-01
20	val_21	2009-08-01
20	val_21	2009-08-01
200	val_200	2009-08-01
200	val_200	2009-08-01
201	val_201	2009-08-01
202	val_202	2009-08-01
203	val_203	2009-08-01
203	val_203	2009-08-01
204	val_205	2009-08-01
205	val_206	2009-08-01
205	val_205	2009-08-01
205	val_205	2009-08-01
206	val_207	2009-08-01
206	val_207	2009-08-01
206	val_207	2009-08-01
207	val_207	2009-08-01
207	val_207	2009-08-01
208	val_208	2009-08-01
208	val_208	2009-08-01
208	val_208	2009-08-01
209	val_209	2009-08-01
209	val_209	2009-08-01
209	val_210	2009-08-01
209	val_210	2009-08-01
21	val_22	2009-08-01
21	val_22	2009-08-01
21	val_22	2009-08-01
21	val_22	2009-08-01
212	val_213	2009-08-01
213	val_214	2009-08-01
213	val_213	2009-08-01
213	val_213	2009-08-01
214	val_214	2009-08-01
215	val_216	2009-08-01
216	val_217	2009-08-01
216	val_216	2009-08-01
216	val_216	2009-08-01
217	val_217	2009-08-01
217	val_217	2009-08-01
217	val_218	2009-08-01
217	val_218	2009-08-01
218	val_218	2009-08-01
219	val_219	2009-08-01
219	val_219	2009-08-01
22	val_23	2009-08-01
221	val_221	2009-08-01
221	val_221	2009-08-01
222	val_222	2009-08-01
222	val_223	2009-08-01
223	val_223	2009-08-01
223	val_223	2009-08-01
224	val_224	2009-08-01
224	val_224	2009-08-01
224	val_225	2009-08-01
226	val_227	2009-08-01
226	val_227	2009-08-01
226	val_227	2009-08-01
226	val_227	2009-08-01
226	val_226	2009-08-01
227	val_228	2009-08-01
228	val_229	2009-08-01
228	val_228	2009-08-01
229	val_229	2009-08-01
229	val_229	2009-08-01
23	val_24	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
230	val_230	2009-08-01
231	val_232	2009-08-01
233	val_233	2009-08-01
233	val_233	2009-08-01
235	val_235	2009-08-01
235	val_236	2009-08-01
237	val_237	2009-08-01
237	val_237	2009-08-01
238	val_238	2009-08-01
238	val_238	2009-08-01
238	val_239	2009-08-01
239	val_240	2009-08-01
239	val_240	2009-08-01
239	val_239	2009-08-01
239	val_239	2009-08-01
24	val_24	2009-08-01
24	val_24	2009-08-01
240	val_241	2009-08-01
241	val_242	2009-08-01
241	val_242	2009-08-01
241	val_242	2009-08-01
241	val_242	2009-08-01
241	val_241	2009-08-01
242	val_242	2009-08-01
242	val_242	2009-08-01
242	val_243	2009-08-01
243	val_244	2009-08-01
243	val_244	2009-08-01
244	val_245	2009-08-01
244	val_245	2009-08-01
244	val_245	2009-08-01
244	val_244	2009-08-01
245	val_246	2009-08-01
245	val_246	2009-08-01
246	val_247	2009-08-01
246	val_247	2009-08-01
247	val_247	2009-08-01
248	val_248	2009-08-01
248	val_249	2009-08-01
249	val_250	2009-08-01
249	val_250	2009-08-01
249	val_249	2009-08-01
252	val_252	2009-08-01
252	val_253	2009-08-01
254	val_255	2009-08-01
255	val_255	2009-08-01
255	val_255	2009-08-01
256	val_256	2009-08-01
256	val_256	2009-08-01
256	val_257	2009-08-01
257	val_258	2009-08-01
257	val_258	2009-08-01
257	val_257	2009-08-01
258	val_258	2009-08-01
258	val_259	2009-08-01
259	val_260	2009-08-01
259	val_260	2009-08-01
26	val_26	2009-08-01
26	val_26	2009-08-01
260	val_260	2009-08-01
260	val_261	2009-08-01
260	val_261	2009-08-01
261	val_262	2009-08-01
262	val_263	2009-08-01
262	val_263	2009-08-01
262	val_262	2009-08-01
263	val_263	2009-08-01
264	val_265	2009-08-01
264	val_265	2009-08-01
265	val_266	2009-08-01
265	val_265	2009-08-01
265	val_265	2009-08-01
266	val_266	2009-08-01
267	val_268	2009-08-01
268	val_269	2009-08-01
27	val_27	2009-08-01
271	val_272	2009-08-01
272	val_273	2009-08-01
272	val_272	2009-08-01
272	val_272	2009-08-01
273	val_273	2009-08-01
273	val_273	2009-08-01
273	val_273	2009-08-01
273	val_274	2009-08-01
274	val_275	2009-08-01
274	val_274	2009-08-01
275	val_275	2009-08-01
275	val_276	2009-08-01
275	val_276	2009-08-01
276	val_277	2009-08-01
277	val_278	2009-08-01
277	val_278	2009-08-01
277	val_277	2009-08-01
277	val_277	2009-08-01
277	val_277	2009-08-01
277	val_277	2009-08-01
278	val_278	2009-08-01
278	val_278	2009-08-01
278	val_279	2009-08-01
28	val_28	2009-08-01
280	val_280	2009-08-01
280	val_280	2009-08-01
281	val_281	2009-08-01
281	val_281	2009-08-01
281	val_282	2009-08-01
281	val_282	2009-08-01
281	val_282	2009-08-01
282	val_282	2009-08-01
282	val_282	2009-08-01
283	val_283	2009-08-01
284	val_284	2009-08-01
284	val_285	2009-08-01
284	val_285	2009-08-01
285	val_286	2009-08-01
285	val_285	2009-08-01
286	val_286	2009-08-01
286	val_287	2009-08-01
287	val_288	2009-08-01
287	val_288	2009-08-01
287	val_287	2009-08-01
288	val_288	2009-08-01
288	val_288	2009-08-01
289	val_289	2009-08-01
289	val_290	2009-08-01
29	val_30	2009-08-01
29	val_30	2009-08-01
291	val_292	2009-08-01
291	val_292	2009-08-01
291	val_291	2009-08-01
292	val_292	2009-08-01
292	val_293	2009-08-01
292	val_293	2009-08-01
293	val_294	2009-08-01
293	val_294	2009-08-01
295	val_296	2009-08-01
295	val_296	2009-08-01
296	val_297	2009-08-01
296	val_296	2009-08-01
298	val_298	2009-08-01
298	val_298	2009-08-01
298	val_298	2009-08-01
3	val_4	2009-08-01
30	val_31	2009-08-01
30	val_30	2009-08-01
300	val_301	2009-08-01
300	val_301	2009-08-01
302	val_303	2009-08-01
302	val_302	2009-08-01
303	val_304	2009-08-01
303	val_304	2009-08-01
304	val_305	2009-08-01
305	val_306	2009-08-01
305	val_305	2009-08-01
306	val_306	2009-08-01
306	val_307	2009-08-01
307	val_307	2009-08-01
307	val_307	2009-08-01
308	val_308	2009-08-01
308	val_309	2009-08-01
308	val_309	2009-08-01
309	val_310	2009-08-01
309	val_309	2009-08-01
309	val_309	2009-08-01
31	val_32	2009-08-01
310	val_311	2009-08-01
310	val_311	2009-08-01
310	val_311	2009-08-01
310	val_310	2009-08-01
311	val_311	2009-08-01
311	val_311	2009-08-01
311	val_311	2009-08-01
313	val_314	2009-08-01
314	val_315	2009-08-01
315	val_315	2009-08-01
316	val_316	2009-08-01
316	val_316	2009-08-01
316	val_316	2009-08-01
317	val_317	2009-08-01
317	val_317	2009-08-01
317	val_318	2009-08-01
318	val_319	2009-08-01
318	val_318	2009-08-01
318	val_318	2009-08-01
318	val_318	2009-08-01
32	val_33	2009-08-01
321	val_321	2009-08-01
321	val_321	2009-08-01
322	val_322	2009-08-01
322	val_322	2009-08-01
322	val_323	2009-08-01
323	val_324	2009-08-01
323	val_323	2009-08-01
324	val_325	2009-08-01
325	val_325	2009-08-01
325	val_325	2009-08-01
326	val_327	2009-08-01
327	val_327	2009-08-01
327	val_327	2009-08-01
327	val_327	2009-08-01
328	val_329	2009-08-01
328	val_329	2009-08-01
33	val_34	2009-08-01
33	val_33	2009-08-01
330	val_331	2009-08-01
331	val_332	2009-08-01
331	val_332	2009-08-01
331	val_331	2009-08-01
331	val_331	2009-08-01
332	val_332	2009-08-01
333	val_333	2009-08-01
333	val_333	2009-08-01
333	val_334	2009-08-01
334	val_335	2009-08-01
335	val_336	2009-08-01
335	val_336	2009-08-01
335	val_335	2009-08-01
336	val_336	2009-08-01
336	val_337	2009-08-01
337	val_338	2009-08-01
338	val_339	2009-08-01
338	val_338	2009-08-01
339	val_339	2009-08-01
34	val_34	2009-08-01
340	val_341	2009-08-01
341	val_342	2009-08-01
341	val_342	2009-08-01
341	val_342	2009-08-01
341	val_341	2009-08-01
342	val_342	2009-08-01
342	val_342	2009-08-01
342	val_343	2009-08-01
343	val_344	2009-08-01
344	val_345	2009-08-01
344	val_344	2009-08-01
344	val_344	2009-08-01
345	val_345	2009-08-01
347	val_348	2009-08-01
347	val_348	2009-08-01
348	val_349	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
348	val_348	2009-08-01
349	val_350	2009-08-01
349	val_350	2009-08-01
349	val_350	2009-08-01
349	val_350	2009-08-01
35	val_36	2009-08-01
35	val_36	2009-08-01
35	val_36	2009-08-01
35	val_35	2009-08-01
35	val_35	2009-08-01
35	val_35	2009-08-01
351	val_351	2009-08-01
351	val_352	2009-08-01
351	val_352	2009-08-01
352	val_353	2009-08-01
352	val_353	2009-08-01
353	val_354	2009-08-01
353	val_353	2009-08-01
353	val_353	2009-08-01
355	val_356	2009-08-01
355	val_356	2009-08-01
356	val_357	2009-08-01
356	val_357	2009-08-01
356	val_356	2009-08-01
358	val_359	2009-08-01
360	val_361	2009-08-01
360	val_360	2009-08-01
362	val_362	2009-08-01
363	val_364	2009-08-01
363	val_364	2009-08-01
363	val_364	2009-08-01
364	val_365	2009-08-01
364	val_364	2009-08-01
365	val_365	2009-08-01
366	val_366	2009-08-01
367	val_367	2009-08-01
367	val_367	2009-08-01
367	val_368	2009-08-01
367	val_368	2009-08-01
368	val_368	2009-08-01
369	val_369	2009-08-01
369	val_369	2009-08-01
369	val_369	2009-08-01
369	val_370	2009-08-01
37	val_37	2009-08-01
37	val_37	2009-08-01
371	val_372	2009-08-01
371	val_372	2009-08-01
371	val_372	2009-08-01
371	val_372	2009-08-01
373	val_374	2009-08-01
373	val_373	2009-08-01
374	val_374	2009-08-01
374	val_375	2009-08-01
375	val_376	2009-08-01
375	val_376	2009-08-01
375	val_376	2009-08-01
375	val_376	2009-08-01
375	val_376	2009-08-01
375	val_375	2009-08-01
376	val_377	2009-08-01
377	val_377	2009-08-01
378	val_378	2009-08-01
378	val_379	2009-08-01
379	val_380	2009-08-01
379	val_379	2009-08-01
381	val_382	2009-08-01
382	val_383	2009-08-01
382	val_383	2009-08-01
382	val_382	2009-08-01
382	val_382	2009-08-01
384	val_384	2009-08-01
384	val_384	2009-08-01
384	val_384	2009-08-01
384	val_385	2009-08-01
384	val_385	2009-08-01
384	val_385	2009-08-01
385	val_386	2009-08-01
385	val_386	2009-08-01
386	val_387	2009-08-01
386	val_387	2009-08-01
386	val_386	2009-08-01
388	val_389	2009-08-01
389	val_390	2009-08-01
389	val_390	2009-08-01
389	val_389	2009-08-01
390	val_391	2009-08-01
390	val_391	2009-08-01
390	val_391	2009-08-01
391	val_392	2009-08-01
391	val_392	2009-08-01
392	val_393	2009-08-01
392	val_393	2009-08-01
392	val_392	2009-08-01
393	val_393	2009-08-01
393	val_394	2009-08-01
393	val_394	2009-08-01
394	val_394	2009-08-01
395	val_395	2009-08-01
395	val_395	2009-08-01
395	val_396	2009-08-01
395	val_396	2009-08-01
396	val_396	2009-08-01
396	val_396	2009-08-01
396	val_396	2009-08-01
397	val_397	2009-08-01
397	val_397	2009-08-01
398	val_399	2009-08-01
399	val_400	2009-08-01
399	val_400	2009-08-01
399	val_399	2009-08-01
399	val_399	2009-08-01
4	val_4	2009-08-01
4	val_5	2009-08-01
40	val_41	2009-08-01
40	val_41	2009-08-01
400	val_400	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_401	2009-08-01
401	val_402	2009-08-01
402	val_403	2009-08-01
402	val_403	2009-08-01
402	val_403	2009-08-01
402	val_402	2009-08-01
403	val_403	2009-08-01
403	val_403	2009-08-01
403	val_403	2009-08-01
404	val_404	2009-08-01
404	val_404	2009-08-01
404	val_405	2009-08-01
404	val_405	2009-08-01
404	val_405	2009-08-01
405	val_406	2009-08-01
406	val_407	2009-08-01
406	val_406	2009-08-01
406	val_406	2009-08-01
406	val_406	2009-08-01
406	val_406	2009-08-01
407	val_407	2009-08-01
407	val_408	2009-08-01
407	val_408	2009-08-01
407	val_408	2009-08-01
408	val_409	2009-08-01
408	val_409	2009-08-01
409	val_410	2009-08-01
409	val_410	2009-08-01
409	val_409	2009-08-01
409	val_409	2009-08-01
409	val_409	2009-08-01
41	val_41	2009-08-01
410	val_411	2009-08-01
411	val_412	2009-08-01
411	val_411	2009-08-01
412	val_413	2009-08-01
412	val_413	2009-08-01
413	val_414	2009-08-01
413	val_413	2009-08-01
413	val_413	2009-08-01
414	val_414	2009-08-01
414	val_414	2009-08-01
414	val_415	2009-08-01
415	val_416	2009-08-01
416	val_417	2009-08-01
417	val_417	2009-08-01
417	val_417	2009-08-01
417	val_417	2009-08-01
418	val_418	2009-08-01
419	val_419	2009-08-01
42	val_42	2009-08-01
42	val_42	2009-08-01
42	val_43	2009-08-01
42	val_43	2009-08-01
42	val_43	2009-08-01
421	val_422	2009-08-01
421	val_422	2009-08-01
421	val_421	2009-08-01
423	val_424	2009-08-01
424	val_425	2009-08-01
424	val_424	2009-08-01
424	val_424	2009-08-01
425	val_426	2009-08-01
426	val_427	2009-08-01
427	val_428	2009-08-01
427	val_428	2009-08-01
427	val_427	2009-08-01
428	val_429	2009-08-01
429	val_430	2009-08-01
429	val_430	2009-08-01
429	val_429	2009-08-01
429	val_429	2009-08-01
43	val_43	2009-08-01
430	val_430	2009-08-01
430	val_430	2009-08-01
430	val_430	2009-08-01
430	val_431	2009-08-01
431	val_432	2009-08-01
431	val_431	2009-08-01
431	val_431	2009-08-01
431	val_431	2009-08-01
432	val_432	2009-08-01
432	val_433	2009-08-01
435	val_436	2009-08-01
435	val_435	2009-08-01
436	val_436	2009-08-01
436	val_437	2009-08-01
437	val_438	2009-08-01
437	val_437	2009-08-01
438	val_438	2009-08-01
438	val_438	2009-08-01
438	val_438	2009-08-01
438	val_439	2009-08-01
438	val_439	2009-08-01
439	val_440	2009-08-01
439	val_440	2009-08-01
439	val_439	2009-08-01
439	val_439	2009-08-01
44	val_44	2009-08-01
440	val_441	2009-08-01
440	val_441	2009-08-01
441	val_442	2009-08-01
442	val_443	2009-08-01
443	val_444	2009-08-01
443	val_444	2009-08-01
443	val_444	2009-08-01
443	val_443	2009-08-01
444	val_444	2009-08-01
446	val_446	2009-08-01
446	val_447	2009-08-01
446	val_447	2009-08-01
447	val_448	2009-08-01
448	val_449	2009-08-01
448	val_448	2009-08-01
449	val_449	2009-08-01
450	val_451	2009-08-01
450	val_451	2009-08-01
451	val_452	2009-08-01
452	val_452	2009-08-01
453	val_453	2009-08-01
453	val_454	2009-08-01
454	val_455	2009-08-01
454	val_455	2009-08-01
454	val_454	2009-08-01
454	val_454	2009-08-01
454	val_454	2009-08-01
455	val_455	2009-08-01
455	val_456	2009-08-01
455	val_456	2009-08-01
457	val_458	2009-08-01
457	val_458	2009-08-01
457	val_457	2009-08-01
458	val_458	2009-08-01
458	val_458	2009-08-01
459	val_459	2009-08-01
459	val_459	2009-08-01
459	val_460	2009-08-01
46	val_47	2009-08-01
460	val_460	2009-08-01
461	val_462	2009-08-01
462	val_463	2009-08-01
462	val_462	2009-08-01
462	val_462	2009-08-01
463	val_463	2009-08-01
463	val_463	2009-08-01
463	val_464	2009-08-01
466	val_466	2009-08-01
466	val_466	2009-08-01
466	val_466	2009-08-01
467	val_467	2009-08-01
467	val_468	2009-08-01
468	val_469	2009-08-01
468	val_469	2009-08-01
468	val_469	2009-08-01
468	val_468	2009-08-01
468	val_468	2009-08-01
468	val_468	2009-08-01
468	val_468	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_469	2009-08-01
469	val_470	2009-08-01
47	val_48	2009-08-01
47	val_47	2009-08-01
470	val_470	2009-08-01
470	val_471	2009-08-01
472	val_472	2009-08-01
473	val_474	2009-08-01
474	val_475	2009-08-01
474	val_475	2009-08-01
475	val_476	2009-08-01
475	val_475	2009-08-01
476	val_477	2009-08-01
476	val_477	2009-08-01
477	val_478	2009-08-01
477	val_477	2009-08-01
478	val_478	2009-08-01
478	val_478	2009-08-01
478	val_479	2009-08-01
478	val_479	2009-08-01
479	val_479	2009-08-01
48	val_49	2009-08-01
48	val_49	2009-08-01
480	val_481	2009-08-01
480	val_481	2009-08-01
480	val_480	2009-08-01
480	val_480	2009-08-01
480	val_480	2009-08-01
481	val_481	2009-08-01
481	val_482	2009-08-01
482	val_483	2009-08-01
482	val_482	2009-08-01
483	val_483	2009-08-01
484	val_484	2009-08-01
484	val_485	2009-08-01
485	val_486	2009-08-01
485	val_486	2009-08-01
485	val_485	2009-08-01
486	val_487	2009-08-01
487	val_488	2009-08-01
487	val_487	2009-08-01
488	val_489	2009-08-01
489	val_490	2009-08-01
489	val_489	2009-08-01
489	val_489	2009-08-01
489	val_489	2009-08-01
489	val_489	2009-08-01
49	val_50	2009-08-01
49	val_50	2009-08-01
490	val_491	2009-08-01
490	val_490	2009-08-01
491	val_491	2009-08-01
491	val_492	2009-08-01
491	val_492	2009-08-01
492	val_493	2009-08-01
492	val_493	2009-08-01
492	val_492	2009-08-01
492	val_492	2009-08-01
493	val_493	2009-08-01
494	val_494	2009-08-01
494	val_495	2009-08-01
494	val_495	2009-08-01
495	val_496	2009-08-01
495	val_495	2009-08-01
496	val_496	2009-08-01
496	val_497	2009-08-01
497	val_498	2009-08-01
497	val_498	2009-08-01
497	val_497	2009-08-01
498	val_498	2009-08-01
498	val_498	2009-08-01
498	val_498	2009-08-01
5	val_5	2009-08-01
5	val_5	2009-08-01
5	val_5	2009-08-01
5	val_6	2009-08-01
50	val_51	2009-08-01
51	val_52	2009-08-01
51	val_51	2009-08-01
51	val_51	2009-08-01
52	val_53	2009-08-01
52	val_53	2009-08-01
52	val_53	2009-08-01
52	val_53	2009-08-01
53	val_54	2009-08-01
53	val_53	2009-08-01
54	val_54	2009-08-01
56	val_57	2009-08-01
57	val_57	2009-08-01
58	val_58	2009-08-01
58	val_58	2009-08-01
58	val_59	2009-08-01
58	val_59	2009-08-01
59	val_60	2009-08-01
6	val_7	2009-08-01
6	val_7	2009-08-01
60	val_61	2009-08-01
61	val_62	2009-08-01
62	val_63	2009-08-01
62	val_63	2009-08-01
63	val_64	2009-08-01
64	val_64	2009-08-01
65	val_65	2009-08-01
65	val_66	2009-08-01
65	val_66	2009-08-01
66	val_66	2009-08-01
67	val_67	2009-08-01
67	val_67	2009-08-01
68	val_69	2009-08-01
69	val_70	2009-08-01
69	val_69	2009-08-01
70	val_70	2009-08-01
70	val_70	2009-08-01
70	val_70	2009-08-01
70	val_71	2009-08-01
71	val_72	2009-08-01
72	val_72	2009-08-01
72	val_72	2009-08-01
74	val_74	2009-08-01
75	val_76	2009-08-01
76	val_77	2009-08-01
76	val_77	2009-08-01
76	val_77	2009-08-01
76	val_76	2009-08-01
76	val_76	2009-08-01
77	val_77	2009-08-01
77	val_78	2009-08-01
77	val_78	2009-08-01
78	val_79	2009-08-01
78	val_78	2009-08-01
8	val_8	2009-08-01
8	val_9	2009-08-01
80	val_81	2009-08-01
80	val_80	2009-08-01
82	val_82	2009-08-01
82	val_83	2009-08-01
82	val_83	2009-08-01
83	val_83	2009-08-01
83	val_83	2009-08-01
84	val_84	2009-08-01
84	val_84	2009-08-01
85	val_85	2009-08-01
85	val_86	2009-08-01
86	val_87	2009-08-01
86	val_86	2009-08-01
87	val_87	2009-08-01
87	val_88	2009-08-01
87	val_88	2009-08-01
89	val_90	2009-08-01
89	val_90	2009-08-01
89	val_90	2009-08-01
9	val_9	2009-08-01
90	val_90	2009-08-01
90	val_90	2009-08-01
90	val_90	2009-08-01
91	val_92	2009-08-01
92	val_92	2009-08-01
93	val_94	2009-08-01
93	val_94	2009-08-01
93	val_94	2009-08-01
94	val_95	2009-08-01
95	val_95	2009-08-01
95	val_95	2009-08-01
96	val_96	2009-08-01
97	val_97	2009-08-01
97	val_97	2009-08-01
97	val_98	2009-08-01
97	val_98	2009-08-01
98	val_98	2009-08-01
98	val_98	2009-08-01
99	val_100	2009-08-01
PREHOOK: query: drop table tmp_insert_test
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tmp_insert_test
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@tmp_insert_test
PREHOOK: query: drop table tmp_insert_test_p
PREHOOK: type: DROPTABLE
POSTHOOK: query: drop table tmp_insert_test_p
POSTHOOK: type: DROPTABLE
POSTHOOK: Output: default@tmp_insert_test_p