You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by zs...@apache.org on 2009/09/15 21:12:14 UTC
svn commit: r815453 - in /hadoop/hive/branches/branch-0.4: 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
Author: zshao
Date: Tue Sep 15 19:12:13 2009
New Revision: 815453
URL: http://svn.apache.org/viewvc?rev=815453&view=rev
Log:
HIVE-718. Fix Loading data inpath into a new partition. (Namit Jain via zshao)
Added:
hadoop/hive/branches/branch-0.4/ql/src/test/queries/clientpositive/input40.q
hadoop/hive/branches/branch-0.4/ql/src/test/results/clientpositive/input40.q.out
Modified:
hadoop/hive/branches/branch-0.4/CHANGES.txt
hadoop/hive/branches/branch-0.4/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
Modified: hadoop/hive/branches/branch-0.4/CHANGES.txt
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.4/CHANGES.txt?rev=815453&r1=815452&r2=815453&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.4/CHANGES.txt (original)
+++ hadoop/hive/branches/branch-0.4/CHANGES.txt Tue Sep 15 19:12:13 2009
@@ -556,6 +556,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/branches/branch-0.4/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.4/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java?rev=815453&r1=815452&r2=815453&view=diff
==============================================================================
--- hadoop/hive/branches/branch-0.4/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java (original)
+++ hadoop/hive/branches/branch-0.4/ql/src/java/org/apache/hadoop/hive/ql/metadata/Hive.java Tue Sep 15 19:12:13 2009
@@ -662,8 +662,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");
}
}
}
@@ -673,6 +673,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);
@@ -697,7 +705,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/branches/branch-0.4/ql/src/test/queries/clientpositive/input40.q
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.4/ql/src/test/queries/clientpositive/input40.q?rev=815453&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.4/ql/src/test/queries/clientpositive/input40.q (added)
+++ hadoop/hive/branches/branch-0.4/ql/src/test/queries/clientpositive/input40.q Tue Sep 15 19:12:13 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/branches/branch-0.4/ql/src/test/results/clientpositive/input40.q.out
URL: http://svn.apache.org/viewvc/hadoop/hive/branches/branch-0.4/ql/src/test/results/clientpositive/input40.q.out?rev=815453&view=auto
==============================================================================
--- hadoop/hive/branches/branch-0.4/ql/src/test/results/clientpositive/input40.q.out (added)
+++ hadoop/hive/branches/branch-0.4/ql/src/test/results/clientpositive/input40.q.out Tue Sep 15 19:12:13 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