[49/51] [partial] Add hive test files to repository. Remove download script.

[pw...@apache.org]

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv1_cc.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv1_cc.txt b/sql/hive/src/test/resources/data/files/kv1_cc.txt
new file mode 100644
index 0000000..f300770
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv1_cc.txt
@@ -0,0 +1,500 @@
+238val_238
+86val_86
+311val_311
+27val_27
+165val_165
+409val_409
+255val_255
+278val_278
+98val_98
+484val_484
+265val_265
+193val_193
+401val_401
+150val_150
+273val_273
+224val_224
+369val_369
+66val_66
+128val_128
+213val_213
+146val_146
+406val_406
+429val_429
+374val_374
+152val_152
+469val_469
+145val_145
+495val_495
+37val_37
+327val_327
+281val_281
+277val_277
+209val_209
+15val_15
+82val_82
+403val_403
+166val_166
+417val_417
+430val_430
+252val_252
+292val_292
+219val_219
+287val_287
+153val_153
+193val_193
+338val_338
+446val_446
+459val_459
+394val_394
+237val_237
+482val_482
+174val_174
+413val_413
+494val_494
+207val_207
+199val_199
+466val_466
+208val_208
+174val_174
+399val_399
+396val_396
+247val_247
+417val_417
+489val_489
+162val_162
+377val_377
+397val_397
+309val_309
+365val_365
+266val_266
+439val_439
+342val_342
+367val_367
+325val_325
+167val_167
+195val_195
+475val_475
+17val_17
+113val_113
+155val_155
+203val_203
+339val_339
+0val_0
+455val_455
+128val_128
+311val_311
+316val_316
+57val_57
+302val_302
+205val_205
+149val_149
+438val_438
+345val_345
+129val_129
+170val_170
+20val_20
+489val_489
+157val_157
+378val_378
+221val_221
+92val_92
+111val_111
+47val_47
+72val_72
+4val_4
+280val_280
+35val_35
+427val_427
+277val_277
+208val_208
+356val_356
+399val_399
+169val_169
+382val_382
+498val_498
+125val_125
+386val_386
+437val_437
+469val_469
+192val_192
+286val_286
+187val_187
+176val_176
+54val_54
+459val_459
+51val_51
+138val_138
+103val_103
+239val_239
+213val_213
+216val_216
+430val_430
+278val_278
+176val_176
+289val_289
+221val_221
+65val_65
+318val_318
+332val_332
+311val_311
+275val_275
+137val_137
+241val_241
+83val_83
+333val_333
+180val_180
+284val_284
+12val_12
+230val_230
+181val_181
+67val_67
+260val_260
+404val_404
+384val_384
+489val_489
+353val_353
+373val_373
+272val_272
+138val_138
+217val_217
+84val_84
+348val_348
+466val_466
+58val_58
+8val_8
+411val_411
+230val_230
+208val_208
+348val_348
+24val_24
+463val_463
+431val_431
+179val_179
+172val_172
+42val_42
+129val_129
+158val_158
+119val_119
+496val_496
+0val_0
+322val_322
+197val_197
+468val_468
+393val_393
+454val_454
+100val_100
+298val_298
+199val_199
+191val_191
+418val_418
+96val_96
+26val_26
+165val_165
+327val_327
+230val_230
+205val_205
+120val_120
+131val_131
+51val_51
+404val_404
+43val_43
+436val_436
+156val_156
+469val_469
+468val_468
+308val_308
+95val_95
+196val_196
+288val_288
+481val_481
+457val_457
+98val_98
+282val_282
+197val_197
+187val_187
+318val_318
+318val_318
+409val_409
+470val_470
+137val_137
+369val_369
+316val_316
+169val_169
+413val_413
+85val_85
+77val_77
+0val_0
+490val_490
+87val_87
+364val_364
+179val_179
+118val_118
+134val_134
+395val_395
+282val_282
+138val_138
+238val_238
+419val_419
+15val_15
+118val_118
+72val_72
+90val_90
+307val_307
+19val_19
+435val_435
+10val_10
+277val_277
+273val_273
+306val_306
+224val_224
+309val_309
+389val_389
+327val_327
+242val_242
+369val_369
+392val_392
+272val_272
+331val_331
+401val_401
+242val_242
+452val_452
+177val_177
+226val_226
+5val_5
+497val_497
+402val_402
+396val_396
+317val_317
+395val_395
+58val_58
+35val_35
+336val_336
+95val_95
+11val_11
+168val_168
+34val_34
+229val_229
+233val_233
+143val_143
+472val_472
+322val_322
+498val_498
+160val_160
+195val_195
+42val_42
+321val_321
+430val_430
+119val_119
+489val_489
+458val_458
+78val_78
+76val_76
+41val_41
+223val_223
+492val_492
+149val_149
+449val_449
+218val_218
+228val_228
+138val_138
+453val_453
+30val_30
+209val_209
+64val_64
+468val_468
+76val_76
+74val_74
+342val_342
+69val_69
+230val_230
+33val_33
+368val_368
+103val_103
+296val_296
+113val_113
+216val_216
+367val_367
+344val_344
+167val_167
+274val_274
+219val_219
+239val_239
+485val_485
+116val_116
+223val_223
+256val_256
+263val_263
+70val_70
+487val_487
+480val_480
+401val_401
+288val_288
+191val_191
+5val_5
+244val_244
+438val_438
+128val_128
+467val_467
+432val_432
+202val_202
+316val_316
+229val_229
+469val_469
+463val_463
+280val_280
+2val_2
+35val_35
+283val_283
+331val_331
+235val_235
+80val_80
+44val_44
+193val_193
+321val_321
+335val_335
+104val_104
+466val_466
+366val_366
+175val_175
+403val_403
+483val_483
+53val_53
+105val_105
+257val_257
+406val_406
+409val_409
+190val_190
+406val_406
+401val_401
+114val_114
+258val_258
+90val_90
+203val_203
+262val_262
+348val_348
+424val_424
+12val_12
+396val_396
+201val_201
+217val_217
+164val_164
+431val_431
+454val_454
+478val_478
+298val_298
+125val_125
+431val_431
+164val_164
+424val_424
+187val_187
+382val_382
+5val_5
+70val_70
+397val_397
+480val_480
+291val_291
+24val_24
+351val_351
+255val_255
+104val_104
+70val_70
+163val_163
+438val_438
+119val_119
+414val_414
+200val_200
+491val_491
+237val_237
+439val_439
+360val_360
+248val_248
+479val_479
+305val_305
+417val_417
+199val_199
+444val_444
+120val_120
+429val_429
+169val_169
+443val_443
+323val_323
+325val_325
+277val_277
+230val_230
+478val_478
+178val_178
+468val_468
+310val_310
+317val_317
+333val_333
+493val_493
+460val_460
+207val_207
+249val_249
+265val_265
+480val_480
+83val_83
+136val_136
+353val_353
+172val_172
+214val_214
+462val_462
+233val_233
+406val_406
+133val_133
+175val_175
+189val_189
+454val_454
+375val_375
+401val_401
+421val_421
+407val_407
+384val_384
+256val_256
+26val_26
+134val_134
+67val_67
+384val_384
+379val_379
+18val_18
+462val_462
+492val_492
+100val_100
+298val_298
+9val_9
+341val_341
+498val_498
+146val_146
+458val_458
+362val_362
+186val_186
+285val_285
+348val_348
+167val_167
+18val_18
+273val_273
+183val_183
+281val_281
+344val_344
+97val_97
+469val_469
+315val_315
+84val_84
+28val_28
+37val_37
+448val_448
+152val_152
+348val_348
+307val_307
+194val_194
+414val_414
+477val_477
+222val_222
+126val_126
+90val_90
+169val_169
+403val_403
+400val_400
+200val_200
+97val_97

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv1kv2.cogroup.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv1kv2.cogroup.txt b/sql/hive/src/test/resources/data/files/kv1kv2.cogroup.txt
new file mode 100644
index 0000000..8a98be3
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv1kv2.cogroup.txt
@@ -0,0 +1,1000 @@
+val_0
+val_0
+val_0
+0
+0
+1
+val_10
+10
+val_100
+val_100
+100
+100
+101
+102
+val_103
+val_103
+val_104
+val_104
+104
+104
+104
+val_105
+105
+105
+106
+val_11
+11
+11
+11
+110
+val_111
+val_113
+val_113
+val_114
+114
+114
+114
+val_116
+116
+117
+117
+val_118
+val_118
+118
+118
+118
+val_119
+val_119
+val_119
+119
+119
+119
+val_12
+val_12
+12
+val_120
+val_120
+120
+121
+121
+122
+122
+122
+123
+123
+val_125
+val_125
+125
+val_126
+126
+126
+val_128
+val_128
+val_128
+128
+128
+val_129
+val_129
+129
+129
+val_131
+132
+132
+val_133
+133
+val_134
+val_134
+134
+135
+135
+135
+val_136
+136
+val_137
+val_137
+137
+val_138
+val_138
+val_138
+val_138
+138
+138
+140
+val_143
+143
+144
+val_145
+val_146
+val_146
+147
+147
+val_149
+val_149
+149
+val_15
+val_15
+15
+15
+val_150
+151
+151
+val_152
+val_152
+152
+152
+152
+val_153
+153
+153
+val_155
+val_156
+156
+156
+val_157
+157
+157
+val_158
+16
+16
+val_160
+160
+161
+161
+161
+161
+val_162
+162
+val_163
+val_164
+val_164
+164
+164
+val_165
+val_165
+165
+val_166
+val_167
+val_167
+val_167
+167
+val_168
+168
+val_169
+val_169
+val_169
+val_169
+val_17
+val_170
+170
+val_172
+val_172
+172
+val_174
+val_174
+174
+174
+val_175
+val_175
+175
+175
+val_176
+val_176
+val_177
+177
+177
+val_178
+178
+178
+val_179
+val_179
+179
+val_18
+val_18
+val_180
+val_181
+182
+val_183
+183
+184
+185
+val_186
+val_187
+val_187
+val_187
+val_189
+189
+val_19
+19
+val_190
+val_191
+val_191
+191
+val_192
+192
+val_193
+val_193
+val_193
+val_194
+val_195
+val_195
+val_196
+196
+196
+196
+val_197
+val_197
+197
+val_199
+val_199
+val_199
+199
+val_2
+2
+val_20
+20
+20
+val_200
+val_200
+val_201
+val_202
+val_203
+val_203
+204
+val_205
+val_205
+205
+206
+206
+206
+val_207
+val_207
+val_208
+val_208
+val_208
+val_209
+val_209
+209
+209
+21
+21
+21
+21
+212
+val_213
+val_213
+213
+val_214
+215
+val_216
+val_216
+216
+val_217
+val_217
+217
+217
+val_218
+val_219
+val_219
+22
+val_221
+val_221
+val_222
+222
+val_223
+val_223
+val_224
+val_224
+224
+val_226
+226
+226
+226
+226
+227
+val_228
+228
+val_229
+val_229
+23
+val_230
+val_230
+val_230
+val_230
+val_230
+231
+val_233
+val_233
+val_235
+235
+val_237
+val_237
+val_238
+val_238
+238
+val_239
+val_239
+239
+239
+val_24
+val_24
+240
+val_241
+241
+241
+241
+241
+val_242
+val_242
+242
+243
+243
+val_244
+244
+244
+244
+245
+245
+246
+246
+val_247
+val_248
+248
+val_249
+249
+249
+val_252
+252
+254
+val_255
+val_255
+val_256
+val_256
+256
+val_257
+257
+257
+val_258
+258
+259
+259
+val_26
+val_26
+val_260
+260
+260
+261
+val_262
+262
+262
+val_263
+264
+264
+val_265
+val_265
+265
+val_266
+267
+268
+val_27
+271
+val_272
+val_272
+272
+val_273
+val_273
+val_273
+273
+val_274
+274
+val_275
+275
+275
+276
+val_277
+val_277
+val_277
+val_277
+277
+277
+val_278
+val_278
+278
+val_28
+val_280
+val_280
+val_281
+val_281
+281
+281
+281
+val_282
+val_282
+val_283
+val_284
+284
+284
+val_285
+285
+val_286
+286
+val_287
+287
+287
+val_288
+val_288
+val_289
+289
+29
+29
+val_291
+291
+291
+val_292
+292
+292
+293
+293
+295
+295
+val_296
+296
+val_298
+val_298
+val_298
+3
+val_30
+30
+300
+300
+val_302
+302
+303
+303
+304
+val_305
+305
+val_306
+306
+val_307
+val_307
+val_308
+308
+308
+val_309
+val_309
+309
+31
+val_310
+310
+310
+310
+val_311
+val_311
+val_311
+313
+314
+val_315
+val_316
+val_316
+val_316
+val_317
+val_317
+317
+val_318
+val_318
+val_318
+318
+32
+val_321
+val_321
+val_322
+val_322
+322
+val_323
+323
+324
+val_325
+val_325
+326
+val_327
+val_327
+val_327
+328
+328
+val_33
+33
+330
+val_331
+val_331
+331
+331
+val_332
+val_333
+val_333
+333
+334
+val_335
+335
+335
+val_336
+336
+337
+val_338
+338
+val_339
+val_34
+340
+val_341
+341
+341
+341
+val_342
+val_342
+342
+343
+val_344
+val_344
+344
+val_345
+347
+347
+val_348
+val_348
+val_348
+val_348
+val_348
+348
+349
+349
+349
+349
+val_35
+val_35
+val_35
+35
+35
+35
+val_351
+351
+351
+352
+352
+val_353
+val_353
+353
+355
+355
+val_356
+356
+356
+358
+val_360
+360
+val_362
+363
+363
+363
+val_364
+364
+val_365
+val_366
+val_367
+val_367
+367
+367
+val_368
+val_369
+val_369
+val_369
+369
+val_37
+val_37
+371
+371
+371
+371
+val_373
+373
+val_374
+374
+val_375
+375
+375
+375
+375
+375
+376
+val_377
+val_378
+378
+val_379
+379
+381
+val_382
+val_382
+382
+382
+val_384
+val_384
+val_384
+384
+384
+384
+385
+385
+val_386
+386
+386
+388
+val_389
+389
+389
+390
+390
+390
+391
+391
+val_392
+392
+392
+val_393
+393
+393
+val_394
+val_395
+val_395
+395
+395
+val_396
+val_396
+val_396
+val_397
+val_397
+398
+val_399
+val_399
+399
+399
+val_4
+4
+40
+40
+val_400
+val_401
+val_401
+val_401
+val_401
+val_401
+401
+val_402
+402
+402
+402
+val_403
+val_403
+val_403
+val_404
+val_404
+404
+404
+404
+405
+val_406
+val_406
+val_406
+val_406
+406
+val_407
+407
+407
+407
+408
+408
+val_409
+val_409
+val_409
+409
+409
+val_41
+410
+val_411
+411
+412
+412
+val_413
+val_413
+413
+val_414
+val_414
+414
+415
+416
+val_417
+val_417
+val_417
+val_418
+val_419
+val_42
+val_42
+42
+42
+42
+val_421
+421
+421
+423
+val_424
+val_424
+424
+425
+426
+val_427
+427
+427
+428
+val_429
+val_429
+429
+429
+val_43
+val_430
+val_430
+val_430
+430
+val_431
+val_431
+val_431
+431
+val_432
+432
+val_435
+435
+val_436
+436
+val_437
+437
+val_438
+val_438
+val_438
+438
+438
+val_439
+val_439
+439
+439
+val_44
+440
+440
+441
+442
+val_443
+443
+443
+443
+val_444
+val_446
+446
+446
+447
+val_448
+448
+val_449
+450
+450
+451
+val_452
+val_453
+453
+val_454
+val_454
+val_454
+454
+454
+val_455
+455
+455
+val_457
+457
+457
+val_458
+val_458
+val_459
+val_459
+459
+46
+val_460
+461
+val_462
+val_462
+462
+val_463
+val_463
+463
+val_466
+val_466
+val_466
+val_467
+467
+val_468
+val_468
+val_468
+val_468
+468
+468
+468
+val_469
+val_469
+val_469
+val_469
+val_469
+469
+val_47
+47
+val_470
+470
+val_472
+473
+474
+474
+val_475
+475
+476
+476
+val_477
+477
+val_478
+val_478
+478
+478
+val_479
+48
+48
+val_480
+val_480
+val_480
+480
+480
+val_481
+481
+val_482
+482
+val_483
+val_484
+484
+val_485
+485
+485
+486
+val_487
+487
+488
+val_489
+val_489
+val_489
+val_489
+489
+49
+49
+val_490
+490
+val_491
+491
+491
+val_492
+val_492
+492
+492
+val_493
+val_494
+494
+494
+val_495
+495
+val_496
+496
+val_497
+497
+497
+val_498
+val_498
+val_498
+val_5
+val_5
+val_5
+5
+50
+val_51
+val_51
+51
+52
+52
+52
+52
+val_53
+53
+val_54
+56
+val_57
+val_58
+val_58
+58
+58
+59
+6
+6
+60
+61
+62
+62
+63
+val_64
+val_65
+65
+65
+val_66
+val_67
+val_67
+68
+val_69
+69
+val_70
+val_70
+val_70
+70
+71
+val_72
+val_72
+val_74
+75
+val_76
+val_76
+76
+76
+76
+val_77
+77
+77
+val_78
+78
+val_8
+8
+val_80
+80
+val_82
+82
+82
+val_83
+val_83
+val_84
+val_84
+val_85
+85
+val_86
+86
+val_87
+87
+87
+89
+89
+89
+val_9
+val_90
+val_90
+val_90
+91
+val_92
+93
+93
+93
+94
+val_95
+val_95
+val_96
+val_97
+val_97
+97
+97
+val_98
+val_98
+99

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv2.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv2.txt b/sql/hive/src/test/resources/data/files/kv2.txt
new file mode 100644
index 0000000..e58f7e3
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv2.txt
@@ -0,0 +1,500 @@
+474
val_475
+281
val_282
+179
val_180
+291
val_292
+62
val_63
+271
val_272
+217
val_218
+135
val_136
+167
val_168
+468
val_469
+423
val_424
+413
val_414
+245
val_246
+455
val_456
+425
val_426
+241
val_242
+177
val_178
+272
val_273
+231
val_232
+448
val_449
+287
val_288
+246
val_247
+440
val_441
+31
val_32
+373
val_374
+447
val_448
+443
val_444
+175
val_176
+278
val_279
+296
val_297
+147
val_148
+428
val_429
+126
val_127
+249
val_250
+21
val_22
+273
val_274
+441
val_442
+106
val_107
+371
val_372
+153
val_154
+356
val_357
+217
val_218
+490
val_491
+33
val_34
+35
val_36
+421
val_422
+243
val_244
+402
val_403
+128
val_129
+10
val_11
+226
val_227
+133
val_134
+333
val_334
+15
val_16
+110
val_111
+391
val_392
+343
val_344
+275
val_276
+0
val_1
+485
val_486
+293
val_294
+240
val_241
+241
val_242
+286
val_287
+85
val_86
+408
val_409
+477
val_478
+455
val_456
+99
val_100
+335
val_336
+476
val_477
+482
val_483
+367
val_368
+59
val_60
+48
val_49
+424
val_425
+226
val_227
+494
val_495
+488
val_489
+94
val_95
+485
val_486
+393
val_394
+349
val_350
+11
val_12
+161
val_162
+123
val_124
+409
val_410
+50
val_51
+265
val_266
+402
val_403
+128
val_129
+468
val_469
+314
val_315
+497
val_498
+224
val_225
+63
val_64
+344
val_345
+4
val_5
+277
val_278
+135
val_136
+3
val_4
+206
val_207
+101
val_102
+331
val_332
+114
val_115
+209
val_210
+281
val_282
+56
val_57
+239
val_240
+389
val_390
+114
val_115
+254
val_255
+235
val_236
+390
val_391
+165
val_166
+304
val_305
+264
val_265
+196
val_197
+238
val_239
+20
val_21
+11
val_12
+492
val_493
+129
val_130
+257
val_258
+71
val_72
+289
val_290
+453
val_454
+421
val_422
+82
val_83
+58
val_59
+5
val_6
+86
val_87
+249
val_250
+438
val_439
+360
val_361
+323
val_324
+222
val_223
+42
val_43
+467
val_468
+411
val_412
+175
val_176
+429
val_430
+338
val_339
+281
val_282
+68
val_69
+185
val_186
+16
val_17
+147
val_148
+119
val_120
+492
val_493
+473
val_474
+376
val_377
+347
val_348
+120
val_121
+213
val_214
+306
val_307
+393
val_394
+427
val_428
+291
val_292
+426
val_427
+132
val_133
+446
val_447
+386
val_387
+65
val_66
+121
val_122
+388
val_389
+184
val_185
+375
val_376
+284
val_285
+191
val_192
+129
val_130
+246
val_247
+197
val_198
+491
val_492
+369
val_370
+262
val_263
+122
val_123
+438
val_439
+351
val_352
+390
val_391
+352
val_353
+23
val_24
+226
val_227
+328
val_329
+382
val_383
+342
val_343
+349
val_350
+480
val_481
+102
val_103
+497
val_498
+487
val_488
+480
val_481
+331
val_332
+409
val_410
+475
val_476
+463
val_464
+183
val_184
+177
val_178
+399
val_400
+15
val_16
+318
val_319
+149
val_150
+392
val_393
+77
val_78
+275
val_276
+476
val_477
+258
val_259
+174
val_175
+252
val_253
+114
val_115
+87
val_88
+161
val_162
+75
val_76
+264
val_265
+48
val_49
+336
val_337
+340
val_341
+390
val_391
+443
val_444
+484
val_485
+407
val_408
+189
val_190
+305
val_306
+367
val_368
+6
val_7
+260
val_261
+2
val_3
+349
val_350
+170
val_171
+51
val_52
+355
val_356
+363
val_364
+164
val_165
+118
val_119
+310
val_311
+104
val_105
+19
val_20
+80
val_81
+117
val_118
+326
val_327
+47
val_48
+121
val_122
+241
val_242
+450
val_451
+140
val_141
+212
val_213
+308
val_309
+30
val_31
+405
val_406
+239
val_240
+119
val_120
+358
val_359
+11
val_12
+49
val_50
+143
val_144
+153
val_154
+341
val_342
+21
val_22
+105
val_106
+157
val_158
+416
val_417
+199
val_200
+375
val_376
+42
val_43
+89
val_90
+363
val_364
+395
val_396
+347
val_348
+386
val_387
+77
val_78
+454
val_455
+293
val_294
+364
val_365
+20
val_21
+89
val_90
+461
val_462
+52
val_53
+40
val_41
+8
val_9
+168
val_169
+384
val_385
+313
val_314
+324
val_325
+310
val_311
+206
val_207
+381
val_382
+404
val_405
+206
val_207
+385
val_386
+259
val_260
+226
val_227
+262
val_263
+69
val_70
+303
val_304
+245
val_246
+260
val_261
+328
val_329
+322
val_323
+122
val_123
+241
val_242
+469
val_470
+404
val_405
+384
val_385
+76
val_77
+116
val_117
+42
val_43
+104
val_105
+481
val_482
+303
val_304
+93
val_94
+277
val_278
+406
val_407
+451
val_452
+53
val_54
+32
val_33
+132
val_133
+192
val_193
+58
val_59
+351
val_352
+70
val_71
+443
val_444
+356
val_357
+399
val_400
+205
val_206
+352
val_353
+52
val_53
+21
val_22
+317
val_318
+330
val_331
+209
val_210
+138
val_139
+429
val_430
+160
val_161
+267
val_268
+454
val_455
+257
val_258
+76
val_77
+174
val_175
+412
val_413
+16
val_17
+375
val_376
+489
val_490
+295
val_296
+105
val_106
+204
val_205
+126
val_127
+274
val_275
+439
val_440
+374
val_375
+494
val_495
+216
val_217
+457
val_458
+93
val_94
+470
val_471
+196
val_197
+302
val_303
+119
val_120
+375
val_376
+391
val_392
+287
val_288
+450
val_451
+375
val_376
+437
val_438
+12
val_13
+398
val_399
+35
val_36
+334
val_335
+384
val_385
+435
val_436
+60
val_61
+29
val_30
+442
val_443
+151
val_152
+52
val_53
+404
val_405
+446
val_447
+300
val_301
+0
val_1
+268
val_269
+491
val_492
+392
val_393
+21
val_22
+295
val_296
+93
val_94
+104
val_105
+436
val_437
+61
val_62
+407
val_408
+439
val_440
+156
val_157
+341
val_342
+118
val_119
+335
val_336
+172
val_173
+244
val_245
+6
val_7
+284
val_285
+164
val_165
+136
val_137
+349
val_350
+371
val_372
+462
val_463
+123
val_124
+432
val_433
+496
val_497
+355
val_356
+144
val_145
+87
val_88
+408
val_409
+152
val_153
+382
val_383
+348
val_349
+122
val_123
+427
val_428
+292
val_293
+182
val_183
+474
val_475
+353
val_354
+310
val_311
+52
val_53
+486
val_487
+152
val_153
+378
val_379
+414
val_415
+261
val_262
+65
val_66
+371
val_372
+256
val_257
+292
val_293
+412
val_413
+97
val_98
+495
val_496
+385
val_386
+40
val_41
+49
val_50
+389
val_390
+259
val_260
+97
val_98
+478
val_479
+125
val_126
+243
val_244
+151
val_152
+178
val_179
+100
val_101
+415
val_416
+401
val_402
+156
val_157
+228
val_229
+363
val_364
+117
val_118
+22
val_23
+248
val_249
+459
val_460
+402
val_403
+62
val_63
+137
val_138
+162
val_163
+244
val_245
+276
val_277
+46
val_47
+341
val_342
+78
val_79
+379
val_380
+215
val_216
+134
val_135
+196
val_197
+410
val_411
+157
val_158
+431
val_432
+82
val_83
+440
val_441
+100
val_101
+407
val_408
+371
val_372
+308
val_309
+430
val_431
+309
val_310
+135
val_136
+161
val_162
+468
val_469
+152
val_153
+138
val_139
+76
val_77
+161
val_162
+300
val_301
+337
val_338
+91
val_92
+478
val_479
+118
val_119
+1
val_2
+89
val_90
+178
val_179
+457
val_458
+29
val_30
+242
val_243
+285
val_286
+35
val_36
+227
val_228
+395
val_396
+244
val_245

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv3.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv3.txt b/sql/hive/src/test/resources/data/files/kv3.txt
new file mode 100644
index 0000000..ca48047
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv3.txt
@@ -0,0 +1,25 @@
+238
val_238
+

+311
val_311
+
val_27
+
val_165
+
val_409
+255
val_255
+278
val_278
+98
val_98
+
val_484
+
val_265
+
val_193
+401
val_401
+150
val_150
+273
val_273
+224

+369

+66
val_66
+128

+213
val_213
+146
val_146
+406
val_406
+

+

+


http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv4.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv4.txt b/sql/hive/src/test/resources/data/files/kv4.txt
new file mode 100644
index 0000000..f969221
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv4.txt
@@ -0,0 +1 @@
+邵铮
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv5.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv5.txt b/sql/hive/src/test/resources/data/files/kv5.txt
new file mode 100644
index 0000000..a6d2b79
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv5.txt
@@ -0,0 +1,24 @@
+238
val_238
+238
val_239
+86
val_86
+238
val_240
+311
val_311
+27
val_27
+165
val_165
+213
val_213
+409
val_409
+255
val_255
+278
val_278
+98
val_98
+484
val_484
+265
val_265
+213
val_214
+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

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv6.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv6.txt b/sql/hive/src/test/resources/data/files/kv6.txt
new file mode 100644
index 0000000..63de5c5
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv6.txt
@@ -0,0 +1,100 @@
+0
0
+0
1
+0
2
+0
3
+0
4
+0
5
+0
6
+0
7
+0
8
+0
9
+0
10
+0
11
+0
12
+0
13
+0
14
+0
15
+0
16
+0
17
+0
18
+0
19
+0
20
+0
21
+0
22
+0
23
+0
24
+0
25
+0
26
+0
27
+0
28
+0
29
+0
30
+0
31
+0
32
+0
33
+0
34
+0
35
+0
36
+0
37
+0
38
+0
39
+0
40
+0
41
+0
42
+0
43
+0
44
+0
45
+0
46
+0
47
+0
48
+0
49
+1
0
+1
1
+1
2
+1
3
+1
4
+1
5
+1
6
+1
7
+1
8
+1
9
+1
10
+1
11
+1
12
+1
13
+1
14
+1
15
+1
16
+1
17
+1
18
+1
19
+1
20
+1
21
+1
22
+1
23
+1
24
+1
25
+1
26
+1
27
+1
28
+1
29
+1
30
+1
31
+1
32
+1
33
+1
34
+1
35
+1
36
+1
37
+1
38
+1
39
+1
40
+1
41
+1
42
+1
43
+1
44
+1
45
+1
46
+1
47
+1
48
+1
49

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv7.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv7.txt b/sql/hive/src/test/resources/data/files/kv7.txt
new file mode 100644
index 0000000..b83c460
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv7.txt
@@ -0,0 +1,38 @@
+-4400 4400
+1E+99 0
+1E-99 0
+0 0
+100 100
+10 10
+1 1
+0.1 0
+0.01 0
+200 200
+20 20
+2 2
+0 0
+0.2 0
+0.02 0
+0.3 0
+0.33 0
+0.333 0
+-0.3 0
+-0.33 0
+-0.333 0
+1.0 1
+2 2
+3.14 3
+-1.12 -1
+-1.12 -1
+-1.122 -11
+1.12 1
+1.122 1
+124.00 124
+125.2 125
+-1255.49 -1255
+3.14 3
+3.14 3
+3.140 4
+0.9999999999999999999999999 1
+-1234567890.1234567890 -1234567890
+1234567890.1234567800 1234567890

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/kv8.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/kv8.txt b/sql/hive/src/test/resources/data/files/kv8.txt
new file mode 100644
index 0000000..29a28ac
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/kv8.txt
@@ -0,0 +1,75 @@
+123456789012345678901234567890123456789
+1.23456789012345678901234567890123456789
+12.3456789012345678901234567890123456789
+123.456789012345678901234567890123456789
+1234.56789012345678901234567890123456789
+12345678901234567890123456789012345678
+0.1234567890123456789012345678901234578
+1.2345678901234567890123456789012345678
+12.345678901234567890123456789012345678
+123.45678901234567890123456789012345678
+1234.5678901234567890123456789012345678
+12345.678901234567890123456789012345678
+123456.78901234567890123456789012345678
+1234567.8901234567890123456789012345678
+12345678.901234567890123456789012345678
+123456789.01234567890123456789012345678
+1234567890.1234567890123456789012345678
+12345678901.234567890123456789012345678
+123456789012.34567890123456789012345678
+1234567890123.4567890123456789012345678
+12345678901234.567890123456789012345678
+123456789012345.67890123456789012345678
+1234567890123456.7890123456789012345678
+12345678901234567.890123456789012345678
+123456789012345678.90123456789012345678
+1234567890123456789.0123456789012345678
+12345678901234567890.123456789012345678
+123456789012345678901.23456789012345678
+1234567890123456789012.3456789012345678
+12345678901234567890123.456789012345678
+123456789012345678901234.56789012345678
+1234567890123456789012345.6789012345678
+12345678901234567890123456.789012345678
+123456789012345678901234567.89012345678
+1234567890123456789012345678.9012345678
+12345678901234567890123456789.012345678
+123456789012345678901234567890.12345678
+1234567890123456789012345678901.2345678
+12345678901234567890123456789012.345678
+123456789012345678901234567890123.45678
+1234567890123456789012345678901234.5678
+12345678901234567890123456789012345.678
+123456789012345678901234567890123456.78
+12345678901234567890123456789012345.67.8
+12345678901234567890123456789012345678.0
+12345678901234567890123456789012345678.00
+12345678901234567890123456789012345678.000
+00012345678901234567890123456789012345678.000
+99999999999999999999999999999999999999
+999999999999999999999999999999999999
+99999999999999999999999999999999999
+-99999999999999999999999999999999999999
+-999999999999999999999999999999999999
+-99999999999999999999999999999999999
+000000000000000000000000000000000000000000000
+0.0000000000000000000000000000000000001
+-0.0000000000000000000000000000000000001
+0.00000000000000000000000000000000000001
+-0.00000000000000000000000000000000000001
+0.123456789012345
+1.234567890123456
+12.34567890123456
+123.4567890123456
+1234.567890123456
+12345.67890123456
+123456.7890123456
+1234567.890123456
+12345678.90123456
+123456789.0123456
+1234567890.123456
+12345678901.23456
+123456789012.3456
+1234567890123.456
+12345678901234.56
+123456789012345.6

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t1.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t1.txt b/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t1.txt
new file mode 100644
index 0000000..6ed281c
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t1.txt
@@ -0,0 +1,2 @@
+1
+1

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t2.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t2.txt b/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t2.txt
new file mode 100644
index 0000000..179ef0e
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/leftsemijoin_mr_t2.txt
@@ -0,0 +1,20 @@
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1
+1

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/lineitem.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/lineitem.txt b/sql/hive/src/test/resources/data/files/lineitem.txt
new file mode 100644
index 0000000..1e11d95
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/lineitem.txt
@@ -0,0 +1,100 @@
+1|155190|7706|1|17|21168.23|0.04|0.02|N|O|1996-03-13|1996-02-12|1996-03-22|DELIVER IN PERSON|TRUCK|egular courts above the|
+1|67310|7311|2|36|45983.16|0.09|0.06|N|O|1996-04-12|1996-02-28|1996-04-20|TAKE BACK RETURN|MAIL|ly final dependencies: slyly bold |
+1|63700|3701|3|8|13309.60|0.10|0.02|N|O|1996-01-29|1996-03-05|1996-01-31|TAKE BACK RETURN|REG AIR|riously. regular, express dep|
+1|2132|4633|4|28|28955.64|0.09|0.06|N|O|1996-04-21|1996-03-30|1996-05-16|NONE|AIR|lites. fluffily even de|
+1|24027|1534|5|24|22824.48|0.10|0.04|N|O|1996-03-30|1996-03-14|1996-04-01|NONE|FOB| pending foxes. slyly re|
+1|15635|638|6|32|49620.16|0.07|0.02|N|O|1996-01-30|1996-02-07|1996-02-03|DELIVER IN PERSON|MAIL|arefully slyly ex|
+2|106170|1191|1|38|44694.46|0.00|0.05|N|O|1997-01-28|1997-01-14|1997-02-02|TAKE BACK RETURN|RAIL|ven requests. deposits breach a|
+3|4297|1798|1|45|54058.05|0.06|0.00|R|F|1994-02-02|1994-01-04|1994-02-23|NONE|AIR|ongside of the furiously brave acco|
+3|19036|6540|2|49|46796.47|0.10|0.00|R|F|1993-11-09|1993-12-20|1993-11-24|TAKE BACK RETURN|RAIL| unusual accounts. eve|
+3|128449|3474|3|27|39890.88|0.06|0.07|A|F|1994-01-16|1993-11-22|1994-01-23|DELIVER IN PERSON|SHIP|nal foxes wake. |
+3|29380|1883|4|2|2618.76|0.01|0.06|A|F|1993-12-04|1994-01-07|1994-01-01|NONE|TRUCK|y. fluffily pending d|
+3|183095|650|5|28|32986.52|0.04|0.00|R|F|1993-12-14|1994-01-10|1994-01-01|TAKE BACK RETURN|FOB|ages nag slyly pending|
+3|62143|9662|6|26|28733.64|0.10|0.02|A|F|1993-10-29|1993-12-18|1993-11-04|TAKE BACK RETURN|RAIL|ges sleep after the caref|
+4|88035|5560|1|30|30690.90|0.03|0.08|N|O|1996-01-10|1995-12-14|1996-01-18|DELIVER IN PERSON|REG AIR|- quickly regular packages sleep. idly|
+5|108570|8571|1|15|23678.55|0.02|0.04|R|F|1994-10-31|1994-08-31|1994-11-20|NONE|AIR|ts wake furiously |
+5|123927|3928|2|26|50723.92|0.07|0.08|R|F|1994-10-16|1994-09-25|1994-10-19|NONE|FOB|sts use slyly quickly special instruc|
+5|37531|35|3|50|73426.50|0.08|0.03|A|F|1994-08-08|1994-10-13|1994-08-26|DELIVER IN PERSON|AIR|eodolites. fluffily unusual|
+6|139636|2150|1|37|61998.31|0.08|0.03|A|F|1992-04-27|1992-05-15|1992-05-02|TAKE BACK RETURN|TRUCK|p furiously special foxes|
+7|182052|9607|1|12|13608.60|0.07|0.03|N|O|1996-05-07|1996-03-13|1996-06-03|TAKE BACK RETURN|FOB|ss pinto beans wake against th|
+7|145243|7758|2|9|11594.16|0.08|0.08|N|O|1996-02-01|1996-03-02|1996-02-19|TAKE BACK RETURN|SHIP|es. instructions|
+7|94780|9799|3|46|81639.88|0.10|0.07|N|O|1996-01-15|1996-03-27|1996-02-03|COLLECT COD|MAIL| unusual reques|
+7|163073|3074|4|28|31809.96|0.03|0.04|N|O|1996-03-21|1996-04-08|1996-04-20|NONE|FOB|. slyly special requests haggl|
+7|151894|9440|5|38|73943.82|0.08|0.01|N|O|1996-02-11|1996-02-24|1996-02-18|DELIVER IN PERSON|TRUCK|ns haggle carefully ironic deposits. bl|
+7|79251|1759|6|35|43058.75|0.06|0.03|N|O|1996-01-16|1996-02-23|1996-01-22|TAKE BACK RETURN|FOB|jole. excuses wake carefully alongside of |
+7|157238|2269|7|5|6476.15|0.04|0.02|N|O|1996-02-10|1996-03-26|1996-02-13|NONE|FOB|ithely regula|
+32|82704|7721|1|28|47227.60|0.05|0.08|N|O|1995-10-23|1995-08-27|1995-10-26|TAKE BACK RETURN|TRUCK|sleep quickly. req|
+32|197921|441|2|32|64605.44|0.02|0.00|N|O|1995-08-14|1995-10-07|1995-08-27|COLLECT COD|AIR|lithely regular deposits. fluffily |
+32|44161|6666|3|2|2210.32|0.09|0.02|N|O|1995-08-07|1995-10-07|1995-08-23|DELIVER IN PERSON|AIR| express accounts wake according to the|
+32|2743|7744|4|4|6582.96|0.09|0.03|N|O|1995-08-04|1995-10-01|1995-09-03|NONE|REG AIR|e slyly final pac|
+32|85811|8320|5|44|79059.64|0.05|0.06|N|O|1995-08-28|1995-08-20|1995-09-14|DELIVER IN PERSON|AIR|symptotes nag according to the ironic depo|
+32|11615|4117|6|6|9159.66|0.04|0.03|N|O|1995-07-21|1995-09-23|1995-07-25|COLLECT COD|RAIL| gifts cajole carefully.|
+33|61336|8855|1|31|40217.23|0.09|0.04|A|F|1993-10-29|1993-12-19|1993-11-08|COLLECT COD|TRUCK|ng to the furiously ironic package|
+33|60519|5532|2|32|47344.32|0.02|0.05|A|F|1993-12-09|1994-01-04|1993-12-28|COLLECT COD|MAIL|gular theodolites|
+33|137469|9983|3|5|7532.30|0.05|0.03|A|F|1993-12-09|1993-12-25|1993-12-23|TAKE BACK RETURN|AIR|. stealthily bold exc|
+33|33918|3919|4|41|75928.31|0.09|0.00|R|F|1993-11-09|1994-01-24|1993-11-11|TAKE BACK RETURN|MAIL|unusual packages doubt caref|
+34|88362|871|1|13|17554.68|0.00|0.07|N|O|1998-10-23|1998-09-14|1998-11-06|NONE|REG AIR|nic accounts. deposits are alon|
+34|89414|1923|2|22|30875.02|0.08|0.06|N|O|1998-10-09|1998-10-16|1998-10-12|NONE|FOB|thely slyly p|
+34|169544|4577|3|6|9681.24|0.02|0.06|N|O|1998-10-30|1998-09-20|1998-11-05|NONE|FOB|ar foxes sleep |
+35|450|2951|1|24|32410.80|0.02|0.00|N|O|1996-02-21|1996-01-03|1996-03-18|TAKE BACK RETURN|FOB|, regular tithe|
+35|161940|4457|2|34|68065.96|0.06|0.08|N|O|1996-01-22|1996-01-06|1996-01-27|DELIVER IN PERSON|RAIL|s are carefully against the f|
+35|120896|8433|3|7|13418.23|0.06|0.04|N|O|1996-01-19|1995-12-22|1996-01-29|NONE|MAIL| the carefully regular |
+35|85175|7684|4|25|29004.25|0.06|0.05|N|O|1995-11-26|1995-12-25|1995-12-21|DELIVER IN PERSON|SHIP| quickly unti|
+35|119917|4940|5|34|65854.94|0.08|0.06|N|O|1995-11-08|1996-01-15|1995-11-26|COLLECT COD|MAIL|. silent, unusual deposits boost|
+35|30762|3266|6|28|47397.28|0.03|0.02|N|O|1996-02-01|1995-12-24|1996-02-28|COLLECT COD|RAIL|ly alongside of |
+36|119767|9768|1|42|75043.92|0.09|0.00|N|O|1996-02-03|1996-01-21|1996-02-23|COLLECT COD|SHIP| careful courts. special |
+37|22630|5133|1|40|62105.20|0.09|0.03|A|F|1992-07-21|1992-08-01|1992-08-15|NONE|REG AIR|luffily regular requests. slyly final acco|
+37|126782|1807|2|39|70542.42|0.05|0.02|A|F|1992-07-02|1992-08-18|1992-07-28|TAKE BACK RETURN|RAIL|the final requests. ca|
+37|12903|5405|3|43|78083.70|0.05|0.08|A|F|1992-07-10|1992-07-06|1992-08-02|DELIVER IN PERSON|TRUCK|iously ste|
+38|175839|874|1|44|84252.52|0.04|0.02|N|O|1996-09-29|1996-11-17|1996-09-30|COLLECT COD|MAIL|s. blithely unusual theodolites am|
+39|2320|9821|1|44|53782.08|0.09|0.06|N|O|1996-11-14|1996-12-15|1996-12-12|COLLECT COD|RAIL|eodolites. careful|
+39|186582|4137|2|26|43383.08|0.08|0.04|N|O|1996-11-04|1996-10-20|1996-11-20|NONE|FOB|ckages across the slyly silent|
+39|67831|5350|3|46|82746.18|0.06|0.08|N|O|1996-09-26|1996-12-19|1996-10-26|DELIVER IN PERSON|AIR|he carefully e|
+39|20590|3093|4|32|48338.88|0.07|0.05|N|O|1996-10-02|1996-12-19|1996-10-14|COLLECT COD|MAIL|heodolites sleep silently pending foxes. ac|
+39|54519|9530|5|43|63360.93|0.01|0.01|N|O|1996-10-17|1996-11-14|1996-10-26|COLLECT COD|MAIL|yly regular i|
+39|94368|6878|6|40|54494.40|0.06|0.05|N|O|1996-12-08|1996-10-22|1997-01-01|COLLECT COD|AIR|quickly ironic fox|
+64|85951|5952|1|21|40675.95|0.05|0.02|R|F|1994-09-30|1994-09-18|1994-10-26|DELIVER IN PERSON|REG AIR|ch slyly final, thin platelets.|
+65|59694|4705|1|26|42995.94|0.03|0.03|A|F|1995-04-20|1995-04-25|1995-05-13|NONE|TRUCK|pending deposits nag even packages. ca|
+65|73815|8830|2|22|39353.82|0.00|0.05|N|O|1995-07-17|1995-06-04|1995-07-19|COLLECT COD|FOB| ideas. special, r|
+65|1388|3889|3|21|27076.98|0.09|0.07|N|O|1995-07-06|1995-05-14|1995-07-31|DELIVER IN PERSON|RAIL|bove the even packages. accounts nag carefu|
+66|115118|7630|1|31|35126.41|0.00|0.08|R|F|1994-02-19|1994-03-11|1994-02-20|TAKE BACK RETURN|RAIL|ut the unusual accounts sleep at the bo|
+66|173489|3490|2|41|64061.68|0.04|0.07|A|F|1994-02-21|1994-03-01|1994-03-18|COLLECT COD|AIR| regular de|
+67|21636|9143|1|4|6230.52|0.09|0.04|N|O|1997-04-17|1997-01-31|1997-04-20|NONE|SHIP| cajole thinly expres|
+67|20193|5198|2|12|13358.28|0.09|0.05|N|O|1997-01-27|1997-02-21|1997-02-22|NONE|REG AIR| even packages cajole|
+67|173600|6118|3|5|8368.00|0.03|0.07|N|O|1997-02-20|1997-02-12|1997-02-21|DELIVER IN PERSON|TRUCK|y unusual packages thrash pinto |
+67|87514|7515|4|44|66066.44|0.08|0.06|N|O|1997-03-18|1997-01-29|1997-04-13|DELIVER IN PERSON|RAIL|se quickly above the even, express reques|
+67|40613|8126|5|23|35733.03|0.05|0.07|N|O|1997-04-19|1997-02-14|1997-05-06|DELIVER IN PERSON|REG AIR|ly regular deposit|
+67|178306|824|6|29|40144.70|0.02|0.05|N|O|1997-01-25|1997-01-27|1997-01-27|DELIVER IN PERSON|FOB|ultipliers |
+68|7068|9569|1|3|2925.18|0.05|0.02|N|O|1998-07-04|1998-06-05|1998-07-21|NONE|RAIL|fully special instructions cajole. furious|
+68|175180|2732|2|46|57738.28|0.02|0.05|N|O|1998-06-26|1998-06-07|1998-07-05|NONE|MAIL| requests are unusual, regular pinto |
+68|34980|7484|3|46|88089.08|0.04|0.05|N|O|1998-08-13|1998-07-08|1998-08-29|NONE|RAIL|egular dependencies affix ironically along |
+68|94728|2256|4|20|34454.40|0.07|0.01|N|O|1998-06-27|1998-05-23|1998-07-02|NONE|REG AIR| excuses integrate fluffily |
+68|82758|5267|5|27|47000.25|0.03|0.06|N|O|1998-06-19|1998-06-25|1998-06-29|DELIVER IN PERSON|SHIP|ccounts. deposits use. furiously|
+68|102561|5072|6|30|46906.80|0.05|0.06|N|O|1998-08-11|1998-07-11|1998-08-14|NONE|RAIL|oxes are slyly blithely fin|
+68|139247|1761|7|41|52735.84|0.09|0.08|N|O|1998-06-24|1998-06-27|1998-07-06|NONE|SHIP|eposits nag special ideas. furiousl|
+69|115209|7721|1|48|58761.60|0.01|0.07|A|F|1994-08-17|1994-08-11|1994-09-08|NONE|TRUCK|regular epitaphs. carefully even ideas hag|
+69|104180|9201|2|32|37893.76|0.08|0.06|A|F|1994-08-24|1994-08-17|1994-08-31|NONE|REG AIR|s sleep carefully bold, |
+69|137267|4807|3|17|22172.42|0.09|0.00|A|F|1994-07-02|1994-07-07|1994-07-03|TAKE BACK RETURN|AIR|final, pending instr|
+69|37502|2509|4|3|4318.50|0.09|0.04|R|F|1994-06-06|1994-07-27|1994-06-15|NONE|MAIL| blithely final d|
+69|92070|7089|5|42|44606.94|0.07|0.04|R|F|1994-07-31|1994-07-26|1994-08-28|DELIVER IN PERSON|REG AIR|tect regular, speci|
+69|18504|1006|6|23|32717.50|0.05|0.00|A|F|1994-10-03|1994-08-06|1994-10-24|NONE|SHIP|nding accounts ca|
+70|64128|9141|1|8|8736.96|0.03|0.08|R|F|1994-01-12|1994-02-27|1994-01-14|TAKE BACK RETURN|FOB|ggle. carefully pending dependenc|
+70|196156|1195|2|13|16277.95|0.06|0.06|A|F|1994-03-03|1994-02-13|1994-03-26|COLLECT COD|AIR|lyly special packag|
+70|179809|7361|3|1|1888.80|0.03|0.05|R|F|1994-01-26|1994-03-05|1994-01-28|TAKE BACK RETURN|RAIL|quickly. fluffily unusual theodolites c|
+70|45734|743|4|11|18477.03|0.01|0.05|A|F|1994-03-17|1994-03-17|1994-03-27|NONE|MAIL|alongside of the deposits. fur|
+70|37131|2138|5|37|39520.81|0.09|0.04|R|F|1994-02-13|1994-03-16|1994-02-21|COLLECT COD|MAIL|n accounts are. q|
+70|55655|3171|6|19|30602.35|0.06|0.03|A|F|1994-01-26|1994-02-17|1994-02-06|TAKE BACK RETURN|SHIP| packages wake pending accounts.|
+71|61931|1932|1|25|47323.25|0.09|0.07|N|O|1998-04-10|1998-04-22|1998-04-11|COLLECT COD|FOB|ckly. slyly|
+71|65916|3435|2|3|5645.73|0.09|0.07|N|O|1998-05-23|1998-04-03|1998-06-02|COLLECT COD|SHIP|y. pinto beans haggle after the|
+71|34432|1942|3|45|61489.35|0.00|0.07|N|O|1998-02-23|1998-03-20|1998-03-24|DELIVER IN PERSON|SHIP| ironic packages believe blithely a|
+71|96645|9155|4|33|54174.12|0.00|0.01|N|O|1998-04-12|1998-03-20|1998-04-15|NONE|FOB| serve quickly fluffily bold deposi|
+71|103255|5766|5|39|49071.75|0.08|0.06|N|O|1998-01-29|1998-04-07|1998-02-18|DELIVER IN PERSON|RAIL|l accounts sleep across the pack|
+71|195635|674|6|34|58841.42|0.04|0.01|N|O|1998-03-05|1998-04-22|1998-03-30|DELIVER IN PERSON|TRUCK|s cajole. |
+96|123076|613|1|23|25278.61|0.10|0.06|A|F|1994-07-19|1994-06-29|1994-07-25|DELIVER IN PERSON|TRUCK|ep-- carefully reg|
+96|135390|5391|2|30|42761.70|0.01|0.06|R|F|1994-06-03|1994-05-29|1994-06-22|DELIVER IN PERSON|TRUCK|e quickly even ideas. furiou|
+97|119477|1989|1|13|19454.11|0.00|0.02|R|F|1993-04-01|1993-04-04|1993-04-08|NONE|TRUCK|ayers cajole against the furiously|
+97|49568|2073|2|37|56149.72|0.02|0.06|A|F|1993-04-13|1993-03-30|1993-04-14|DELIVER IN PERSON|SHIP|ic requests boost carefully quic|
+97|77699|5221|3|19|31857.11|0.06|0.08|R|F|1993-05-14|1993-03-05|1993-05-25|TAKE BACK RETURN|RAIL|gifts. furiously ironic packages cajole. |
+98|40216|217|1|28|32373.88|0.06|0.07|A|F|1994-12-24|1994-10-25|1995-01-16|COLLECT COD|REG AIR| pending, regular accounts s|
+98|109743|7274|2|1|1752.74|0.00|0.00|A|F|1994-12-01|1994-12-12|1994-12-15|DELIVER IN PERSON|TRUCK|. unusual instructions against|
+98|44706|4707|3|14|23109.80|0.05|0.02|A|F|1994-12-30|1994-11-22|1995-01-27|COLLECT COD|AIR| cajole furiously. blithely ironic ideas |

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/lt100.sorted.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/lt100.sorted.txt b/sql/hive/src/test/resources/data/files/lt100.sorted.txt
new file mode 100644
index 0000000..0935135
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/lt100.sorted.txt
@@ -0,0 +1,84 @@
+0
val_0
+0
val_0
+0
val_0
+10
val_10
+11
val_11
+12
val_12
+12
val_12
+15
val_15
+15
val_15
+17
val_17
+18
val_18
+18
val_18
+19
val_19
+2
val_2
+20
val_20
+24
val_24
+24
val_24
+26
val_26
+26
val_26
+27
val_27
+28
val_28
+30
val_30
+33
val_33
+34
val_34
+35
val_35
+35
val_35
+35
val_35
+37
val_37
+37
val_37
+4
val_4
+41
val_41
+42
val_42
+42
val_42
+43
val_43
+44
val_44
+47
val_47
+5
val_5
+5
val_5
+5
val_5
+51
val_51
+51
val_51
+53
val_53
+54
val_54
+57
val_57
+58
val_58
+58
val_58
+64
val_64
+65
val_65
+66
val_66
+67
val_67
+67
val_67
+69
val_69
+70
val_70
+70
val_70
+70
val_70
+72
val_72
+72
val_72
+74
val_74
+76
val_76
+76
val_76
+77
val_77
+78
val_78
+8
val_8
+80
val_80
+82
val_82
+83
val_83
+83
val_83
+84
val_84
+84
val_84
+85
val_85
+86
val_86
+87
val_87
+9
val_9
+90
val_90
+90
val_90
+90
val_90
+92
val_92
+95
val_95
+95
val_95
+96
val_96
+97
val_97
+97
val_97
+98
val_98
+98
val_98

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/lt100.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/lt100.txt b/sql/hive/src/test/resources/data/files/lt100.txt
new file mode 100644
index 0000000..3f36729
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/lt100.txt
@@ -0,0 +1,84 @@
+86
val_86
+27
val_27
+98
val_98
+66
val_66
+37
val_37
+15
val_15
+82
val_82
+17
val_17
+0
val_0
+57
val_57
+20
val_20
+92
val_92
+47
val_47
+72
val_72
+4
val_4
+35
val_35
+54
val_54
+51
val_51
+65
val_65
+83
val_83
+12
val_12
+67
val_67
+84
val_84
+58
val_58
+8
val_8
+24
val_24
+42
val_42
+0
val_0
+96
val_96
+26
val_26
+51
val_51
+43
val_43
+95
val_95
+98
val_98
+85
val_85
+77
val_77
+0
val_0
+87
val_87
+15
val_15
+72
val_72
+90
val_90
+19
val_19
+10
val_10
+5
val_5
+58
val_58
+35
val_35
+95
val_95
+11
val_11
+34
val_34
+42
val_42
+78
val_78
+76
val_76
+41
val_41
+30
val_30
+64
val_64
+76
val_76
+74
val_74
+69
val_69
+33
val_33
+70
val_70
+5
val_5
+2
val_2
+35
val_35
+80
val_80
+44
val_44
+53
val_53
+90
val_90
+12
val_12
+5
val_5
+70
val_70
+24
val_24
+70
val_70
+83
val_83
+26
val_26
+67
val_67
+18
val_18
+9
val_9
+18
val_18
+97
val_97
+84
val_84
+28
val_28
+37
val_37
+90
val_90
+97
val_97

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/lt100.txt.deflate
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/lt100.txt.deflate b/sql/hive/src/test/resources/data/files/lt100.txt.deflate
new file mode 100644
index 0000000..7ad780a
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/lt100.txt.deflate
@@ -0,0 +1,3 @@
+x�MR;nDASZ�f���D�S��=�.�!��*��~~�+��D��z�.�0f-!��d��\�0+����N(!]hַ™�D˃���mlB۱�� ��3�8� �!�`�H�u�t�
+ʜ:�L׏��>�`�qMw�tCSG�k[E�6�:r�QD���xo���4�
!&g�9���J���/��B�W�?β� 7��Kb����qfHrstr�^*�5��3���ö����^�}�6���\k~@�Y
+��7ª�?E�պ�}�
�?���
\ No newline at end of file

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/map_table.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/map_table.txt b/sql/hive/src/test/resources/data/files/map_table.txt
new file mode 100644
index 0000000..f3a01d8
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/map_table.txt
@@ -0,0 +1,2 @@
+foo1	k1:v1,k2:v2,k3:v3
+foo2	k21:v21,k22:v22,k31:v31

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/nested_complex.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/nested_complex.txt b/sql/hive/src/test/resources/data/files/nested_complex.txt
new file mode 100644
index 0000000..fee462c
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/nested_complex.txt
@@ -0,0 +1,2 @@
+3
012
k1v1k2v2
a10
2
+2
032
k1v1k3v3
b10
2

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/null.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/null.txt b/sql/hive/src/test/resources/data/files/null.txt
new file mode 100644
index 0000000..7014a64
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/null.txt
@@ -0,0 +1,10 @@
+1.0
1
same
0
+1.0
1
same
1
+1.0
1
same
2
+1.0
1
same
3
+1.0
1
same
4
+\N
1
same
5
+\N
\N
same
6
+1.0
\N
same
7
+1.0
1
same
8
+1.0
1
same
9

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/nullfile.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/nullfile.txt b/sql/hive/src/test/resources/data/files/nullfile.txt
new file mode 100644
index 0000000..e69de29

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/nulls.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/nulls.txt b/sql/hive/src/test/resources/data/files/nulls.txt
new file mode 100644
index 0000000..21cb1b5
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/nulls.txt
@@ -0,0 +1,1002 @@
+1
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N
+\N

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/orc_create.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/orc_create.txt b/sql/hive/src/test/resources/data/files/orc_create.txt
new file mode 100644
index 0000000..211e047
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/orc_create.txt
@@ -0,0 +1,3 @@
+line1|key11:value11,key12:value12,key13:value13|a,b,c|one,two
+line2|key21:value21,key22:value22,key23:value23|d,e,f|three,four
+line3|key31:value31,key32:value32,key33:value33|g,h,i|five,six

http://git-wip-us.apache.org/repos/asf/spark/blob/7e17fe69/sql/hive/src/test/resources/data/files/orc_create_people.txt
----------------------------------------------------------------------
diff --git a/sql/hive/src/test/resources/data/files/orc_create_people.txt b/sql/hive/src/test/resources/data/files/orc_create_people.txt
new file mode 100644
index 0000000..8845989
--- /dev/null
+++ b/sql/hive/src/test/resources/data/files/orc_create_people.txt
@@ -0,0 +1,100 @@
+1
Celeste
Browning
959-3763 Nec, Av.
Ca
+2
Risa
Yang
P.O. Box 292, 8229 Porttitor Road
Or
+3
Venus
Sutton
Ap #962-8021 Egestas Rd.
Ca
+4
Gretchen
Harrison
P.O. Box 636, 8734 Magna Avenue
Or
+5
Lani
Irwin
Ap #441-5911 Iaculis, Ave
Ca
+6
Vera
George
409-1555 Vel, Ave
Or
+7
Jessica
Malone
286-9779 Aliquam Road
Ca
+8
Ann
Chapman
Ap #504-3915 Placerat Road
Or
+9
Nigel
Bartlett
Ap #185-385 Diam Street
Ca
+10
Azalia
Jennings
5772 Diam St.
Or
+11
Preston
Cannon
Ap #527-8769 Nunc Avenue
Ca
+12
Allistair
Vasquez
2562 Odio. St.
Or
+13
Reed
Hayes
5190 Elit Street
Ca
+14
Elaine
Barron
P.O. Box 840, 8860 Sodales Av.
Or
+15
Lydia
Hood
P.O. Box 698, 5666 Semper Road
Ca
+16
Vance
Maxwell
298-3313 Malesuada Road
Or
+17
Keiko
Deleon
P.O. Box 732, 5921 Massa. Av.
Ca
+18
Dolan
Kane
Ap #906-3606 Ut Rd.
Or
+19
Merritt
Perkins
P.O. Box 228, 7090 Egestas Street
Ca
+20
Casey
Salazar
506-5065 Ut St.
Or
+21
Samson
Noel
1370 Ultrices, Road
Ca
+22
Byron
Walker
P.O. Box 386, 8324 Tellus Ave
Or
+23
Piper
Singleton
Ap #500-3561 Primis St.
Ca
+24
Ria
Mckinney
3080 Dui Rd.
Or
+25
Rahim
Stanley
559-9016 Nascetur Street
Ca
+26
Chloe
Steele
P.O. Box 766, 1628 Elit Street
Or
+27
Paloma
Ward
Ap #390-3042 Ipsum Rd.
Ca
+28
Roary
Sherman
Ap #409-6549 Metus St.
Or
+29
Calvin
Buckner
6378 Diam Avenue
Ca
+30
Camille
Good
Ap #113-8659 Suspendisse St.
Or
+31
Steel
Ayala
5518 Justo St.
Ca
+32
Josiah
Gilbert
Ap #149-6651 At, Av.
Or
+33
Hamilton
Cruz
4620 Tellus. Ave
Ca
+34
Scarlet
Santos
586-1785 Velit. Av.
Or
+35
Lewis
Mcintyre
629-6419 Ac Rd.
Ca
+36
Arsenio
Mejia
P.O. Box 767, 8625 Justo Rd.
Or
+37
Velma
Haley
1377 At Rd.
Ca
+38
Tatum
Jennings
829-7432 Posuere, Road
Or
+39
Britanni
Eaton
8811 Morbi Street
Ca
+40
Aileen
Jacobson
P.O. Box 469, 2266 Dui, Rd.
Or
+41
Kareem
Ayala
2706 Ridiculus Street
Ca
+42
Maite
Rush
7592 Neque Road
Or
+43
Signe
Velasquez
Ap #868-3039 Eget St.
Ca
+44
Zorita
Camacho
P.O. Box 651, 3340 Quis Av.
Or
+45
Glenna
Curtis
953-7965 Enim Ave
Ca
+46
Quin
Cortez
4898 Ridiculus St.
Or
+47
Talon
Dalton
P.O. Box 408, 7597 Integer Rd.
Ca
+48
Darryl
Blankenship
P.O. Box 771, 1471 Non Rd.
Or
+49
Vernon
Reyes
P.O. Box 971, 7009 Vulputate Street
Ca
+50
Tallulah
Heath
P.O. Box 865, 3697 Dis Ave
Or
+51
Ciaran
Olson
2721 Et St.
Ca
+52
Orlando
Witt
P.O. Box 717, 1102 Nulla. Rd.
Or
+53
Quinn
Rice
Ap #647-6627 Tristique Avenue
Ca
+54
Wyatt
Pickett
Ap #128-3130 Vel, Rd.
Or
+55
Emerald
Copeland
857-5119 Turpis Rd.
Ca
+56
Jonas
Quinn
Ap #441-7183 Ligula. Street
Or
+57
Willa
Berg
6672 Velit Ave
Ca
+58
Malik
Lee
998-9208 In Street
Or
+59
Callie
Medina
1620 Dui. Rd.
Ca
+60
Luke
Mason
P.O. Box 143, 2070 Augue Rd.
Or
+61
Shafira
Estrada
8824 Ante Street
Ca
+62
Elizabeth
Rutledge
315-6510 Sit St.
Or
+63
Pandora
Levine
357-3596 Nibh. Ave
Ca
+64
Hilel
Prince
845-1229 Sociosqu Rd.
Or
+65
Rinah
Torres
Ap #492-9328 At St.
Ca
+66
Yael
Hobbs
P.O. Box 477, 3896 In Street
Or
+67
Nevada
Nash
P.O. Box 251, 1914 Tincidunt Road
Ca
+68
Marny
Huff
P.O. Box 818, 6086 Ultricies St.
Or
+69
Kimberley
Miles
Ap #893-3685 In Road
Ca
+70
Duncan
Fuller
Ap #197-5216 Iaculis Street
Or
+71
Yardley
Leblanc
P.O. Box 938, 1278 Sit Ave
Ca
+72
Hamish
Brewer
Ap #854-781 Quisque St.
Or
+73
Petra
Moon
453-6609 Curabitur Street
Ca
+74
Reese
Estrada
Ap #382-3313 Malesuada St.
Or
+75
Gage
Higgins
7443 Eu Street
Ca
+76
Zachery
Camacho
Ap #795-4143 Quam. St.
Or
+77
Kelly
Garner
P.O. Box 895, 2843 Cras Rd.
Ca
+78
Hanae
Carr
9440 Amet St.
Or
+79
Ann
Alston
884-7948 Dictum Road
Ca
+80
Chancellor
Cobb
P.O. Box 889, 5978 Ac Avenue
Or
+81
Dorothy
Harrell
6974 Tristique Ave
Ca
+82
Vaughan
Leon
1610 Luctus Av.
Or
+83
Wynne
Jimenez
321-9171 Felis. Avenue
Ca
+84
Willa
Mendoza
489-182 Sed Av.
Or
+85
Camden
Goodwin
4579 Ante St.
Ca
+86
Ifeoma
French
P.O. Box 160, 8769 Integer Road
Or
+87
Ramona
Strong
1666 Ridiculus Avenue
Ca
+88
Brett
Ramos
Ap #579-9879 Et, Road
Or
+89
Ulla
Gray
595-7066 Malesuada Road
Ca
+90
Kevyn
Mccall
P.O. Box 968, 1420 Aenean Avenue
Or
+91
Genevieve
Wilkins
908 Turpis. Street
Ca
+92
Thane
Oneil
6766 Lectus St.
Or
+93
Mariko
Cline
P.O. Box 329, 5375 Ac St.
Ca
+94
Lael
Mclean
500-7010 Sit St.
Or
+95
Winifred
Hopper
Ap #140-8982 Velit Avenue
Ca
+96
Rafael
England
P.O. Box 405, 7857 Eget Av.
Or
+97
Dana
Carter
814-601 Purus. Av.
Ca
+98
Juliet
Battle
Ap #535-1965 Cursus St.
Or
+99
Wynter
Vincent
626-8492 Mollis Avenue
Ca
+100
Wang
Mitchell
4023 Lacinia. Ave
Or