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