hadoop-hive-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From zs...@apache.org
Subject svn commit: r815455 - in /hadoop/hive/trunk: CHANGES.txt ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java ql/src/test/queries/clientpositive/input40.q ql/src/test/results/clientpositive/input40.q.out
Date Tue, 15 Sep 2009 19:15:51 GMT
Author: zshao
Date: Tue Sep 15 19:15:50 2009
New Revision: 815455

URL: http://svn.apache.org/viewvc?rev=815455&view=rev
Log:
HIVE-718. Fix Loading data inpath into a new partition. (Namit Jain via zshao)

Added:
    hadoop/hive/trunk/ql/src/test/queries/clientpositive/input40.q
    hadoop/hive/trunk/ql/src/test/results/clientpositive/input40.q.out
Modified:
    hadoop/hive/trunk/CHANGES.txt
    hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java

Modified: hadoop/hive/trunk/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/CHANGES.txt?rev=815455&r1=815454&r2=815455&view=diff
==============================================================================
--- hadoop/hive/trunk/CHANGES.txt (original)
+++ hadoop/hive/trunk/CHANGES.txt Tue Sep 15 19:15:50 2009
@@ -634,6 +634,9 @@
     HIVE-799. final.name should not include hadoop version.
     (Todd Lipcon via zshao)
 
+    HIVE-718. Fix Loading data inpath into a new partition.
+    (Namit Jain via zshao)
+
 Release 0.3.1 - Unreleased
 
   INCOMPATIBLE CHANGES

Modified: hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java?rev=815455&r1=815454&r2=815455&view=diff
==============================================================================
--- hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java (original)
+++ hadoop/hive/trunk/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java Tue Sep 15
19:15:50 2009
@@ -674,8 +674,8 @@
                                             items[j].toString());
                 }
                 Path tmpDest = new Path(destf, items[j].getPath().getName());
-                if(!replace && fs.exists(tmpDest)) {
-                    throw new HiveException("checkPaths: " + tmpDest + " already exists");
+                if (!replace && fs.exists(tmpDest)) {
+                  throw new HiveException("checkPaths: " + tmpDest + " already exists");
                 }
             }
         }
@@ -685,6 +685,14 @@
 }
 
   static protected void copyFiles(Path srcf, Path destf, FileSystem fs) throws HiveException
{
+    try {
+      // create the destination if it does not exist
+      if (!fs.exists(destf))
+        fs.mkdirs(destf);
+    } catch (IOException e) {
+      throw new HiveException("copyFiles: error while checking/creating destination directory!!!",
e);
+    }
+
     FileStatus[] srcs;
     try {
       srcs = fs.globStatus(srcf);
@@ -709,7 +717,7 @@
         }
       }
     } catch (IOException e) {
-      throw new HiveException("addFiles: error while moving files!!!", e);
+      throw new HiveException("copyFiles: error while moving files!!!", e);
     }
   }
 

Added: hadoop/hive/trunk/ql/src/test/queries/clientpositive/input40.q
URL: http://svn.apache.org/viewvc/hadoop/hive/trunk/ql/src/test/queries/clientpositive/input40.q?rev=815455&view=auto
==============================================================================
--- hadoop/hive/trunk/ql/src/test/queries/clientpositive/input40.q (added)
+++ hadoop/hive/trunk/ql/src/test/queries/clientpositive/input40.q Tue Sep 15 19:15:50 2009
@@ -0,0 +1,18 @@
+drop table tmp_insert_test;
+drop table tmp_insert_test_p;
+
+create table tmp_insert_test (key string, value string) stored as textfile;
+load data local inpath '../data/files/kv1.txt' into table tmp_insert_test;
+select * from tmp_insert_test;
+
+create table tmp_insert_test_p (key string, value string) partitioned by (ds string) stored
as textfile;
+
+load data local inpath '../data/files/kv1.txt' into table tmp_insert_test_p partition (ds
= '2009-08-01');
+select * from tmp_insert_test_p where ds= '2009-08-01';
+
+load data local inpath '../data/files/kv2.txt' into table tmp_insert_test_p partition (ds
= '2009-08-01');
+select * from tmp_insert_test_p where ds= '2009-08-01';
+
+
+drop table tmp_insert_test;
+drop table tmp_insert_test_p;

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



Mime
View raw message