You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by se...@apache.org on 2017/04/20 19:34:39 UTC
[4/6] hive git commit: HIVE-16296 : use LLAP executor count to
configure reducer auto-parallelism (Sergey Shelukhin, Gopal Vijayaraghavan,
reviewed by Gopal Vijayaraghavan, Sergey Shelukhin, Gunther Hagleitner)
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/except_distinct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/except_distinct.q.out b/ql/src/test/results/clientpositive/llap/except_distinct.q.out
index 94125b5..4c32ebc 100644
--- a/ql/src/test/results/clientpositive/llap/except_distinct.q.out
+++ b/ql/src/test/results/clientpositive/llap/except_distinct.q.out
@@ -190,9 +190,9 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
2 20
+1 2
PREHOOK: query: explain select * from src except distinct select * from src
PREHOOK: type: QUERY
POSTHOOK: query: explain select * from src except distinct select * from src
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out b/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
index 023627e..99db828 100644
--- a/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
+++ b/ql/src/test/results/clientpositive/llap/explainuser_4.q.out
@@ -232,10 +232,10 @@ order by c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
--13036 1
-8915 1
-3799 1
10782 1
+-13036 1
NULL 6
PREHOOK: query: explain
select
@@ -471,10 +471,10 @@ order by c1
POSTHOOK: type: QUERY
POSTHOOK: Input: default@alltypesorc
#### A masked pattern was here ####
--13036 1
-8915 1
-3799 1
10782 1
+-13036 1
NULL 6
Warning: Shuffle Join MERGEJOIN[9][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
index ee9930f..a59188a 100644
--- a/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
+++ b/ql/src/test/results/clientpositive/llap/hybridgrace_hashjoin_2.q.out
@@ -850,8 +850,8 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
#### A masked pattern was here ####
-428
452
+428
PREHOOK: query: EXPLAIN
SELECT COUNT(*)
FROM src1 x JOIN srcpart z ON (x.key = z.key)
@@ -1100,8 +1100,8 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=11
POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12
#### A masked pattern was here ####
-428
452
+428
PREHOOK: query: SELECT 1
PREHOOK: type: QUERY
PREHOOK: Input: _dummy_database@_dummy_table
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/intersect_all.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/intersect_all.q.out b/ql/src/test/results/clientpositive/llap/intersect_all.q.out
index 4dac8a2..2422090 100644
--- a/ql/src/test/results/clientpositive/llap/intersect_all.q.out
+++ b/ql/src/test/results/clientpositive/llap/intersect_all.q.out
@@ -38,9 +38,9 @@ POSTHOOK: query: select key, value, count(1) as c from a group by key, value
POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
#### A masked pattern was here ####
+2 3 1
1 2 2
1 3 1
-2 3 1
PREHOOK: query: select * from a intersect all select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -51,8 +51,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from b intersect all select * from a intersect all select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -63,8 +63,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from a intersect all select * from b union all select * from a intersect all select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -75,8 +75,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from a intersect all select * from b union select * from a intersect all select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -87,8 +87,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from a intersect all select * from b intersect all select * from a intersect all select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -99,8 +99,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from (select a.key, b.value from a join b on a.key=b.key)sub1
intersect all
select * from (select a.key, b.value from a join b on a.key=b.key)sub2
@@ -115,10 +115,10 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
+2 3
1 2
1 2
1 2
-2 3
PREHOOK: query: select * from (select a.key, b.value from a join b on a.key=b.key)sub1
intersect all
select * from (select b.value as key, a.key as value from a join b on a.key=b.key)sub2
@@ -289,501 +289,501 @@ POSTHOOK: Input: default@src
0 val_0
0 val_0
0 val_0
-10 val_10
-100 val_100
-100 val_100
103 val_103
103 val_103
-104 val_104
-104 val_104
105 val_105
-11 val_11
-111 val_111
-113 val_113
-113 val_113
-114 val_114
116 val_116
-118 val_118
-118 val_118
-119 val_119
-119 val_119
-119 val_119
-12 val_12
-12 val_12
120 val_120
120 val_120
-125 val_125
-125 val_125
-126 val_126
-128 val_128
-128 val_128
-128 val_128
129 val_129
129 val_129
131 val_131
-133 val_133
-134 val_134
-134 val_134
136 val_136
-137 val_137
-137 val_137
-138 val_138
-138 val_138
-138 val_138
-138 val_138
-143 val_143
-145 val_145
-146 val_146
-146 val_146
-149 val_149
-149 val_149
-15 val_15
-15 val_15
-150 val_150
-152 val_152
-152 val_152
-153 val_153
155 val_155
-156 val_156
157 val_157
-158 val_158
160 val_160
-162 val_162
-163 val_163
-164 val_164
-164 val_164
-165 val_165
-165 val_165
-166 val_166
-167 val_167
-167 val_167
-167 val_167
-168 val_168
-169 val_169
-169 val_169
-169 val_169
-169 val_169
-17 val_17
-170 val_170
-172 val_172
-172 val_172
-174 val_174
-174 val_174
-175 val_175
-175 val_175
-176 val_176
-176 val_176
-177 val_177
-178 val_178
-179 val_179
-179 val_179
-18 val_18
-18 val_18
180 val_180
-181 val_181
183 val_183
-186 val_186
-187 val_187
-187 val_187
-187 val_187
-189 val_189
-19 val_19
190 val_190
191 val_191
191 val_191
-192 val_192
193 val_193
193 val_193
193 val_193
-194 val_194
-195 val_195
-195 val_195
-196 val_196
-197 val_197
-197 val_197
-199 val_199
-199 val_199
-199 val_199
-2 val_2
-20 val_20
-200 val_200
-200 val_200
-201 val_201
-202 val_202
-203 val_203
-203 val_203
205 val_205
205 val_205
207 val_207
207 val_207
-208 val_208
-208 val_208
-208 val_208
-209 val_209
-209 val_209
213 val_213
213 val_213
-214 val_214
-216 val_216
-216 val_216
-217 val_217
-217 val_217
-218 val_218
-219 val_219
-219 val_219
-221 val_221
-221 val_221
-222 val_222
223 val_223
223 val_223
-224 val_224
-224 val_224
-226 val_226
-228 val_228
-229 val_229
-229 val_229
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-233 val_233
-233 val_233
235 val_235
-237 val_237
-237 val_237
238 val_238
238 val_238
239 val_239
239 val_239
24 val_24
24 val_24
-241 val_241
-242 val_242
-242 val_242
-244 val_244
-247 val_247
248 val_248
-249 val_249
-252 val_252
-255 val_255
-255 val_255
-256 val_256
-256 val_256
-257 val_257
-258 val_258
-26 val_26
-26 val_26
260 val_260
-262 val_262
-263 val_263
-265 val_265
-265 val_265
-266 val_266
-27 val_27
-272 val_272
-272 val_272
-273 val_273
-273 val_273
-273 val_273
-274 val_274
-275 val_275
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-278 val_278
-278 val_278
28 val_28
-280 val_280
-280 val_280
-281 val_281
-281 val_281
-282 val_282
-282 val_282
-283 val_283
-284 val_284
-285 val_285
286 val_286
-287 val_287
-288 val_288
-288 val_288
-289 val_289
-291 val_291
-292 val_292
-296 val_296
298 val_298
298 val_298
298 val_298
-30 val_30
-302 val_302
305 val_305
306 val_306
307 val_307
307 val_307
308 val_308
-309 val_309
-309 val_309
-310 val_310
-311 val_311
-311 val_311
-311 val_311
315 val_315
-316 val_316
-316 val_316
-316 val_316
317 val_317
317 val_317
-318 val_318
-318 val_318
-318 val_318
321 val_321
321 val_321
-322 val_322
-322 val_322
-323 val_323
-325 val_325
-325 val_325
-327 val_327
-327 val_327
-327 val_327
33 val_33
331 val_331
331 val_331
-332 val_332
-333 val_333
-333 val_333
-335 val_335
-336 val_336
-338 val_338
-339 val_339
-34 val_34
-341 val_341
-342 val_342
-342 val_342
-344 val_344
-344 val_344
-345 val_345
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-35 val_35
-35 val_35
-35 val_35
-351 val_351
-353 val_353
-353 val_353
356 val_356
360 val_360
-362 val_362
-364 val_364
-365 val_365
366 val_366
367 val_367
367 val_367
368 val_368
-369 val_369
-369 val_369
-369 val_369
37 val_37
37 val_37
-373 val_373
-374 val_374
-375 val_375
-377 val_377
378 val_378
379 val_379
382 val_382
382 val_382
-384 val_384
-384 val_384
-384 val_384
-386 val_386
389 val_389
-392 val_392
-393 val_393
-394 val_394
395 val_395
395 val_395
-396 val_396
-396 val_396
-396 val_396
-397 val_397
-397 val_397
-399 val_399
-399 val_399
-4 val_4
400 val_400
-401 val_401
-401 val_401
-401 val_401
-401 val_401
-401 val_401
402 val_402
-403 val_403
-403 val_403
-403 val_403
-404 val_404
-404 val_404
406 val_406
406 val_406
406 val_406
406 val_406
407 val_407
-409 val_409
-409 val_409
-409 val_409
-41 val_41
-411 val_411
-413 val_413
-413 val_413
-414 val_414
-414 val_414
-417 val_417
-417 val_417
-417 val_417
-418 val_418
-419 val_419
42 val_42
42 val_42
-421 val_421
-424 val_424
-424 val_424
-427 val_427
-429 val_429
-429 val_429
-43 val_43
430 val_430
430 val_430
430 val_430
-431 val_431
-431 val_431
-431 val_431
-432 val_432
-435 val_435
436 val_436
+44 val_44
+452 val_452
+466 val_466
+466 val_466
+466 val_466
+467 val_467
+472 val_472
+480 val_480
+480 val_480
+480 val_480
+484 val_484
+485 val_485
+487 val_487
+495 val_495
+496 val_496
+498 val_498
+498 val_498
+498 val_498
+51 val_51
+51 val_51
+57 val_57
+58 val_58
+58 val_58
+65 val_65
+66 val_66
+69 val_69
+70 val_70
+70 val_70
+70 val_70
+78 val_78
+8 val_8
+92 val_92
+96 val_96
+104 val_104
+104 val_104
+111 val_111
+114 val_114
+118 val_118
+118 val_118
+12 val_12
+12 val_12
+133 val_133
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+153 val_153
+156 val_156
+162 val_162
+168 val_168
+174 val_174
+174 val_174
+176 val_176
+176 val_176
+178 val_178
+181 val_181
+186 val_186
+187 val_187
+187 val_187
+187 val_187
+192 val_192
+197 val_197
+197 val_197
+199 val_199
+199 val_199
+199 val_199
+2 val_2
+201 val_201
+203 val_203
+203 val_203
+208 val_208
+208 val_208
+208 val_208
+214 val_214
+218 val_218
+219 val_219
+219 val_219
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+237 val_237
+237 val_237
+249 val_249
+256 val_256
+256 val_256
+257 val_257
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+278 val_278
+278 val_278
+284 val_284
+285 val_285
+310 val_310
+322 val_322
+322 val_322
+327 val_327
+327 val_327
+327 val_327
+333 val_333
+333 val_333
+336 val_336
+338 val_338
+341 val_341
+344 val_344
+344 val_344
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+351 val_351
+362 val_362
+364 val_364
+374 val_374
+392 val_392
+397 val_397
+397 val_397
+4 val_4
+403 val_403
+403 val_403
+403 val_403
+404 val_404
+404 val_404
+419 val_419
+421 val_421
+427 val_427
+429 val_429
+429 val_429
437 val_437
438 val_438
438 val_438
438 val_438
439 val_439
439 val_439
-44 val_44
-443 val_443
-444 val_444
-446 val_446
-448 val_448
-449 val_449
-452 val_452
-453 val_453
454 val_454
454 val_454
454 val_454
455 val_455
-457 val_457
-458 val_458
-458 val_458
-459 val_459
-459 val_459
460 val_460
-462 val_462
-462 val_462
463 val_463
463 val_463
-466 val_466
-466 val_466
-466 val_466
-467 val_467
-468 val_468
-468 val_468
-468 val_468
-468 val_468
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-47 val_47
470 val_470
-472 val_472
-475 val_475
-477 val_477
478 val_478
478 val_478
479 val_479
-480 val_480
-480 val_480
-480 val_480
-481 val_481
-482 val_482
-483 val_483
-484 val_484
-485 val_485
-487 val_487
489 val_489
489 val_489
489 val_489
489 val_489
-490 val_490
491 val_491
492 val_492
492 val_492
+53 val_53
+67 val_67
+67 val_67
+82 val_82
+90 val_90
+90 val_90
+90 val_90
+97 val_97
+97 val_97
+10 val_10
+125 val_125
+125 val_125
+134 val_134
+134 val_134
+143 val_143
+145 val_145
+149 val_149
+149 val_149
+150 val_150
+158 val_158
+163 val_163
+164 val_164
+164 val_164
+166 val_166
+17 val_17
+170 val_170
+172 val_172
+172 val_172
+189 val_189
+19 val_19
+195 val_195
+195 val_195
+196 val_196
+20 val_20
+209 val_209
+209 val_209
+216 val_216
+216 val_216
+217 val_217
+217 val_217
+224 val_224
+224 val_224
+228 val_228
+229 val_229
+229 val_229
+233 val_233
+233 val_233
+241 val_241
+244 val_244
+247 val_247
+255 val_255
+255 val_255
+258 val_258
+26 val_26
+26 val_26
+263 val_263
+265 val_265
+265 val_265
+266 val_266
+272 val_272
+272 val_272
+273 val_273
+273 val_273
+273 val_273
+274 val_274
+281 val_281
+281 val_281
+291 val_291
+296 val_296
+30 val_30
+302 val_302
+309 val_309
+309 val_309
+316 val_316
+316 val_316
+316 val_316
+318 val_318
+318 val_318
+318 val_318
+325 val_325
+325 val_325
+332 val_332
+335 val_335
+339 val_339
+342 val_342
+342 val_342
+345 val_345
+353 val_353
+353 val_353
+369 val_369
+369 val_369
+369 val_369
+373 val_373
+375 val_375
+377 val_377
+384 val_384
+384 val_384
+384 val_384
+386 val_386
+394 val_394
+396 val_396
+396 val_396
+396 val_396
+399 val_399
+399 val_399
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+401 val_401
+41 val_41
+413 val_413
+413 val_413
+414 val_414
+414 val_414
+431 val_431
+431 val_431
+431 val_431
+446 val_446
+448 val_448
+449 val_449
+459 val_459
+459 val_459
+462 val_462
+462 val_462
+468 val_468
+468 val_468
+468 val_468
+468 val_468
+47 val_47
+482 val_482
+490 val_490
493 val_493
494 val_494
-495 val_495
-496 val_496
497 val_497
-498 val_498
-498 val_498
-498 val_498
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
+74 val_74
+77 val_77
+80 val_80
+84 val_84
+84 val_84
+85 val_85
+87 val_87
+9 val_9
+95 val_95
+95 val_95
+100 val_100
+100 val_100
+11 val_11
+113 val_113
+113 val_113
+119 val_119
+119 val_119
+119 val_119
+126 val_126
+128 val_128
+128 val_128
+128 val_128
+137 val_137
+137 val_137
+146 val_146
+146 val_146
+15 val_15
+15 val_15
+152 val_152
+152 val_152
+165 val_165
+165 val_165
+167 val_167
+167 val_167
+167 val_167
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+175 val_175
+175 val_175
+177 val_177
+179 val_179
+179 val_179
+18 val_18
+18 val_18
+194 val_194
+200 val_200
+200 val_200
+202 val_202
+221 val_221
+221 val_221
+222 val_222
+226 val_226
+242 val_242
+242 val_242
+252 val_252
+262 val_262
+27 val_27
+275 val_275
+280 val_280
+280 val_280
+282 val_282
+282 val_282
+283 val_283
+287 val_287
+288 val_288
+288 val_288
+289 val_289
+292 val_292
+311 val_311
+311 val_311
+311 val_311
+323 val_323
+34 val_34
+35 val_35
+35 val_35
+35 val_35
+365 val_365
+393 val_393
+409 val_409
+409 val_409
+409 val_409
+411 val_411
+417 val_417
+417 val_417
+417 val_417
+418 val_418
+424 val_424
+424 val_424
+43 val_43
+432 val_432
+435 val_435
+443 val_443
+444 val_444
+453 val_453
+457 val_457
+458 val_458
+458 val_458
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+475 val_475
+477 val_477
+481 val_481
+483 val_483
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
PREHOOK: query: explain select * from src intersect all select * from src intersect all select * from src intersect all select * from src
@@ -1032,501 +1032,501 @@ POSTHOOK: Input: default@src
0 val_0
0 val_0
0 val_0
+103 val_103
+103 val_103
+105 val_105
+116 val_116
+120 val_120
+120 val_120
+129 val_129
+129 val_129
+131 val_131
+136 val_136
+155 val_155
+157 val_157
+160 val_160
+180 val_180
+183 val_183
+190 val_190
+191 val_191
+191 val_191
+193 val_193
+193 val_193
+193 val_193
+205 val_205
+205 val_205
+207 val_207
+207 val_207
+213 val_213
+213 val_213
+223 val_223
+223 val_223
+235 val_235
+238 val_238
+238 val_238
+239 val_239
+239 val_239
+24 val_24
+24 val_24
+248 val_248
+260 val_260
+28 val_28
+286 val_286
+298 val_298
+298 val_298
+298 val_298
+305 val_305
+306 val_306
+307 val_307
+307 val_307
+308 val_308
+315 val_315
+317 val_317
+317 val_317
+321 val_321
+321 val_321
+33 val_33
+331 val_331
+331 val_331
+356 val_356
+360 val_360
+366 val_366
+367 val_367
+367 val_367
+368 val_368
+37 val_37
+37 val_37
+378 val_378
+379 val_379
+382 val_382
+382 val_382
+389 val_389
+395 val_395
+395 val_395
+400 val_400
+402 val_402
+406 val_406
+406 val_406
+406 val_406
+406 val_406
+407 val_407
+42 val_42
+42 val_42
+430 val_430
+430 val_430
+430 val_430
+436 val_436
+44 val_44
+452 val_452
+466 val_466
+466 val_466
+466 val_466
+467 val_467
+472 val_472
+480 val_480
+480 val_480
+480 val_480
+484 val_484
+485 val_485
+487 val_487
+495 val_495
+496 val_496
+498 val_498
+498 val_498
+498 val_498
+51 val_51
+51 val_51
+57 val_57
+58 val_58
+58 val_58
+65 val_65
+66 val_66
+69 val_69
+70 val_70
+70 val_70
+70 val_70
+78 val_78
+8 val_8
+92 val_92
+96 val_96
+104 val_104
+104 val_104
+111 val_111
+114 val_114
+118 val_118
+118 val_118
+12 val_12
+12 val_12
+133 val_133
+138 val_138
+138 val_138
+138 val_138
+138 val_138
+153 val_153
+156 val_156
+162 val_162
+168 val_168
+174 val_174
+174 val_174
+176 val_176
+176 val_176
+178 val_178
+181 val_181
+186 val_186
+187 val_187
+187 val_187
+187 val_187
+192 val_192
+197 val_197
+197 val_197
+199 val_199
+199 val_199
+199 val_199
+2 val_2
+201 val_201
+203 val_203
+203 val_203
+208 val_208
+208 val_208
+208 val_208
+214 val_214
+218 val_218
+219 val_219
+219 val_219
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+230 val_230
+237 val_237
+237 val_237
+249 val_249
+256 val_256
+256 val_256
+257 val_257
+277 val_277
+277 val_277
+277 val_277
+277 val_277
+278 val_278
+278 val_278
+284 val_284
+285 val_285
+310 val_310
+322 val_322
+322 val_322
+327 val_327
+327 val_327
+327 val_327
+333 val_333
+333 val_333
+336 val_336
+338 val_338
+341 val_341
+344 val_344
+344 val_344
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+348 val_348
+351 val_351
+362 val_362
+364 val_364
+374 val_374
+392 val_392
+397 val_397
+397 val_397
+4 val_4
+403 val_403
+403 val_403
+403 val_403
+404 val_404
+404 val_404
+419 val_419
+421 val_421
+427 val_427
+429 val_429
+429 val_429
+437 val_437
+438 val_438
+438 val_438
+438 val_438
+439 val_439
+439 val_439
+454 val_454
+454 val_454
+454 val_454
+455 val_455
+460 val_460
+463 val_463
+463 val_463
+470 val_470
+478 val_478
+478 val_478
+479 val_479
+489 val_489
+489 val_489
+489 val_489
+489 val_489
+491 val_491
+492 val_492
+492 val_492
+53 val_53
+67 val_67
+67 val_67
+82 val_82
+90 val_90
+90 val_90
+90 val_90
+97 val_97
+97 val_97
10 val_10
-100 val_100
-100 val_100
-103 val_103
-103 val_103
-104 val_104
-104 val_104
-105 val_105
-11 val_11
-111 val_111
-113 val_113
-113 val_113
-114 val_114
-116 val_116
-118 val_118
-118 val_118
-119 val_119
-119 val_119
-119 val_119
-12 val_12
-12 val_12
-120 val_120
-120 val_120
125 val_125
125 val_125
-126 val_126
-128 val_128
-128 val_128
-128 val_128
-129 val_129
-129 val_129
-131 val_131
-133 val_133
134 val_134
134 val_134
-136 val_136
-137 val_137
-137 val_137
-138 val_138
-138 val_138
-138 val_138
-138 val_138
143 val_143
145 val_145
-146 val_146
-146 val_146
149 val_149
149 val_149
-15 val_15
-15 val_15
150 val_150
-152 val_152
-152 val_152
-153 val_153
-155 val_155
-156 val_156
-157 val_157
158 val_158
-160 val_160
-162 val_162
163 val_163
164 val_164
164 val_164
-165 val_165
-165 val_165
166 val_166
-167 val_167
-167 val_167
-167 val_167
-168 val_168
-169 val_169
-169 val_169
-169 val_169
-169 val_169
17 val_17
170 val_170
172 val_172
172 val_172
-174 val_174
-174 val_174
-175 val_175
-175 val_175
-176 val_176
-176 val_176
-177 val_177
-178 val_178
-179 val_179
-179 val_179
-18 val_18
-18 val_18
-180 val_180
-181 val_181
-183 val_183
-186 val_186
-187 val_187
-187 val_187
-187 val_187
189 val_189
19 val_19
-190 val_190
-191 val_191
-191 val_191
-192 val_192
-193 val_193
-193 val_193
-193 val_193
-194 val_194
195 val_195
195 val_195
196 val_196
-197 val_197
-197 val_197
-199 val_199
-199 val_199
-199 val_199
-2 val_2
20 val_20
-200 val_200
-200 val_200
-201 val_201
-202 val_202
-203 val_203
-203 val_203
-205 val_205
-205 val_205
-207 val_207
-207 val_207
-208 val_208
-208 val_208
-208 val_208
209 val_209
209 val_209
-213 val_213
-213 val_213
-214 val_214
216 val_216
216 val_216
217 val_217
217 val_217
-218 val_218
-219 val_219
-219 val_219
-221 val_221
-221 val_221
-222 val_222
-223 val_223
-223 val_223
224 val_224
224 val_224
-226 val_226
228 val_228
229 val_229
229 val_229
-230 val_230
-230 val_230
-230 val_230
-230 val_230
-230 val_230
233 val_233
233 val_233
-235 val_235
-237 val_237
-237 val_237
-238 val_238
-238 val_238
-239 val_239
-239 val_239
-24 val_24
-24 val_24
241 val_241
-242 val_242
-242 val_242
244 val_244
247 val_247
-248 val_248
-249 val_249
-252 val_252
255 val_255
255 val_255
-256 val_256
-256 val_256
-257 val_257
258 val_258
26 val_26
26 val_26
-260 val_260
-262 val_262
263 val_263
265 val_265
265 val_265
266 val_266
-27 val_27
272 val_272
272 val_272
273 val_273
273 val_273
273 val_273
274 val_274
-275 val_275
-277 val_277
-277 val_277
-277 val_277
-277 val_277
-278 val_278
-278 val_278
-28 val_28
-280 val_280
-280 val_280
281 val_281
281 val_281
-282 val_282
-282 val_282
-283 val_283
-284 val_284
-285 val_285
-286 val_286
-287 val_287
-288 val_288
-288 val_288
-289 val_289
291 val_291
-292 val_292
296 val_296
-298 val_298
-298 val_298
-298 val_298
30 val_30
302 val_302
-305 val_305
-306 val_306
-307 val_307
-307 val_307
-308 val_308
309 val_309
309 val_309
-310 val_310
-311 val_311
-311 val_311
-311 val_311
-315 val_315
316 val_316
316 val_316
316 val_316
-317 val_317
-317 val_317
318 val_318
318 val_318
318 val_318
-321 val_321
-321 val_321
-322 val_322
-322 val_322
-323 val_323
325 val_325
325 val_325
-327 val_327
-327 val_327
-327 val_327
-33 val_33
-331 val_331
-331 val_331
332 val_332
-333 val_333
-333 val_333
335 val_335
-336 val_336
-338 val_338
339 val_339
-34 val_34
-341 val_341
342 val_342
342 val_342
-344 val_344
-344 val_344
-345 val_345
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-348 val_348
-35 val_35
-35 val_35
-35 val_35
-351 val_351
+345 val_345
353 val_353
353 val_353
-356 val_356
-360 val_360
-362 val_362
-364 val_364
-365 val_365
-366 val_366
-367 val_367
-367 val_367
-368 val_368
369 val_369
369 val_369
369 val_369
-37 val_37
-37 val_37
373 val_373
-374 val_374
375 val_375
377 val_377
-378 val_378
-379 val_379
-382 val_382
-382 val_382
384 val_384
384 val_384
384 val_384
386 val_386
-389 val_389
-392 val_392
-393 val_393
394 val_394
-395 val_395
-395 val_395
396 val_396
396 val_396
396 val_396
-397 val_397
-397 val_397
399 val_399
399 val_399
-4 val_4
-400 val_400
401 val_401
401 val_401
401 val_401
401 val_401
401 val_401
-402 val_402
-403 val_403
-403 val_403
-403 val_403
-404 val_404
-404 val_404
-406 val_406
-406 val_406
-406 val_406
-406 val_406
-407 val_407
-409 val_409
-409 val_409
-409 val_409
41 val_41
-411 val_411
413 val_413
413 val_413
414 val_414
414 val_414
-417 val_417
-417 val_417
-417 val_417
-418 val_418
-419 val_419
-42 val_42
-42 val_42
-421 val_421
-424 val_424
-424 val_424
-427 val_427
-429 val_429
-429 val_429
-43 val_43
-430 val_430
-430 val_430
-430 val_430
431 val_431
431 val_431
431 val_431
-432 val_432
-435 val_435
-436 val_436
-437 val_437
-438 val_438
-438 val_438
-438 val_438
-439 val_439
-439 val_439
-44 val_44
-443 val_443
-444 val_444
446 val_446
448 val_448
449 val_449
-452 val_452
-453 val_453
-454 val_454
-454 val_454
-454 val_454
-455 val_455
-457 val_457
-458 val_458
-458 val_458
459 val_459
459 val_459
-460 val_460
462 val_462
462 val_462
-463 val_463
-463 val_463
-466 val_466
-466 val_466
-466 val_466
-467 val_467
468 val_468
468 val_468
468 val_468
468 val_468
-469 val_469
-469 val_469
-469 val_469
-469 val_469
-469 val_469
47 val_47
-470 val_470
-472 val_472
-475 val_475
-477 val_477
-478 val_478
-478 val_478
-479 val_479
-480 val_480
-480 val_480
-480 val_480
-481 val_481
482 val_482
-483 val_483
-484 val_484
-485 val_485
-487 val_487
-489 val_489
-489 val_489
-489 val_489
-489 val_489
490 val_490
-491 val_491
-492 val_492
-492 val_492
493 val_493
494 val_494
-495 val_495
-496 val_496
497 val_497
-498 val_498
-498 val_498
-498 val_498
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
+100 val_100
+100 val_100
+11 val_11
+113 val_113
+113 val_113
+119 val_119
+119 val_119
+119 val_119
+126 val_126
+128 val_128
+128 val_128
+128 val_128
+137 val_137
+137 val_137
+146 val_146
+146 val_146
+15 val_15
+15 val_15
+152 val_152
+152 val_152
+165 val_165
+165 val_165
+167 val_167
+167 val_167
+167 val_167
+169 val_169
+169 val_169
+169 val_169
+169 val_169
+175 val_175
+175 val_175
+177 val_177
+179 val_179
+179 val_179
+18 val_18
+18 val_18
+194 val_194
+200 val_200
+200 val_200
+202 val_202
+221 val_221
+221 val_221
+222 val_222
+226 val_226
+242 val_242
+242 val_242
+252 val_252
+262 val_262
+27 val_27
+275 val_275
+280 val_280
+280 val_280
+282 val_282
+282 val_282
+283 val_283
+287 val_287
+288 val_288
+288 val_288
+289 val_289
+292 val_292
+311 val_311
+311 val_311
+311 val_311
+323 val_323
+34 val_34
+35 val_35
+35 val_35
+35 val_35
+365 val_365
+393 val_393
+409 val_409
+409 val_409
+409 val_409
+411 val_411
+417 val_417
+417 val_417
+417 val_417
+418 val_418
+424 val_424
+424 val_424
+43 val_43
+432 val_432
+435 val_435
+443 val_443
+444 val_444
+453 val_453
+457 val_457
+458 val_458
+458 val_458
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+469 val_469
+475 val_475
+477 val_477
+481 val_481
+483 val_483
+64 val_64
+72 val_72
+72 val_72
+76 val_76
+76 val_76
+83 val_83
+83 val_83
+86 val_86
98 val_98
98 val_98
PREHOOK: query: explain select value from a group by value intersect all select key from b group by key
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out b/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
index 3698f03..6921d53 100644
--- a/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
+++ b/ql/src/test/results/clientpositive/llap/intersect_distinct.q.out
@@ -51,8 +51,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from b intersect distinct select * from a intersect distinct select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -63,8 +63,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from a intersect distinct select * from b union all select * from a intersect distinct select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -75,8 +75,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from a intersect distinct select * from b union select * from a intersect distinct select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -87,8 +87,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from a intersect distinct select * from b intersect distinct select * from a intersect distinct select * from b
PREHOOK: type: QUERY
PREHOOK: Input: default@a
@@ -99,8 +99,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from (select a.key, b.value from a join b on a.key=b.key)sub1
intersect distinct
select * from (select a.key, b.value from a join b on a.key=b.key)sub2
@@ -115,8 +115,8 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@a
POSTHOOK: Input: default@b
#### A masked pattern was here ####
-1 2
2 3
+1 2
PREHOOK: query: select * from (select a.key, b.value from a join b on a.key=b.key)sub1
intersect distinct
select * from (select b.value as key, a.key as value from a join b on a.key=b.key)sub2
@@ -278,328 +278,328 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0 val_0
-10 val_10
-100 val_100
103 val_103
-104 val_104
105 val_105
-11 val_11
-111 val_111
-113 val_113
-114 val_114
116 val_116
-118 val_118
-119 val_119
-12 val_12
120 val_120
-125 val_125
-126 val_126
-128 val_128
129 val_129
131 val_131
-133 val_133
-134 val_134
136 val_136
-137 val_137
-138 val_138
-143 val_143
-145 val_145
-146 val_146
-149 val_149
-15 val_15
-150 val_150
-152 val_152
-153 val_153
155 val_155
-156 val_156
157 val_157
-158 val_158
160 val_160
-162 val_162
-163 val_163
-164 val_164
-165 val_165
-166 val_166
-167 val_167
-168 val_168
-169 val_169
-17 val_17
-170 val_170
-172 val_172
-174 val_174
-175 val_175
-176 val_176
-177 val_177
-178 val_178
-179 val_179
-18 val_18
180 val_180
-181 val_181
183 val_183
-186 val_186
-187 val_187
-189 val_189
-19 val_19
190 val_190
191 val_191
-192 val_192
193 val_193
-194 val_194
-195 val_195
-196 val_196
-197 val_197
-199 val_199
-2 val_2
-20 val_20
-200 val_200
-201 val_201
-202 val_202
-203 val_203
205 val_205
207 val_207
-208 val_208
-209 val_209
213 val_213
-214 val_214
-216 val_216
-217 val_217
-218 val_218
-219 val_219
-221 val_221
-222 val_222
223 val_223
-224 val_224
-226 val_226
-228 val_228
-229 val_229
-230 val_230
-233 val_233
235 val_235
-237 val_237
238 val_238
239 val_239
24 val_24
-241 val_241
-242 val_242
-244 val_244
-247 val_247
248 val_248
-249 val_249
-252 val_252
-255 val_255
-256 val_256
-257 val_257
-258 val_258
-26 val_26
260 val_260
-262 val_262
-263 val_263
-265 val_265
-266 val_266
-27 val_27
-272 val_272
-273 val_273
-274 val_274
-275 val_275
-277 val_277
-278 val_278
28 val_28
-280 val_280
-281 val_281
-282 val_282
-283 val_283
-284 val_284
-285 val_285
286 val_286
-287 val_287
-288 val_288
-289 val_289
-291 val_291
-292 val_292
-296 val_296
298 val_298
-30 val_30
-302 val_302
305 val_305
306 val_306
307 val_307
308 val_308
-309 val_309
-310 val_310
-311 val_311
315 val_315
-316 val_316
317 val_317
-318 val_318
321 val_321
-322 val_322
-323 val_323
-325 val_325
-327 val_327
33 val_33
331 val_331
-332 val_332
-333 val_333
-335 val_335
-336 val_336
-338 val_338
-339 val_339
-34 val_34
-341 val_341
-342 val_342
-344 val_344
-345 val_345
-348 val_348
-35 val_35
-351 val_351
-353 val_353
356 val_356
360 val_360
-362 val_362
-364 val_364
-365 val_365
366 val_366
367 val_367
368 val_368
-369 val_369
37 val_37
-373 val_373
-374 val_374
-375 val_375
-377 val_377
378 val_378
379 val_379
382 val_382
-384 val_384
-386 val_386
389 val_389
-392 val_392
-393 val_393
-394 val_394
395 val_395
-396 val_396
-397 val_397
-399 val_399
-4 val_4
400 val_400
-401 val_401
402 val_402
-403 val_403
-404 val_404
406 val_406
407 val_407
-409 val_409
-41 val_41
-411 val_411
-413 val_413
-414 val_414
-417 val_417
-418 val_418
-419 val_419
42 val_42
-421 val_421
-424 val_424
-427 val_427
-429 val_429
-43 val_43
430 val_430
-431 val_431
-432 val_432
-435 val_435
436 val_436
-437 val_437
-438 val_438
-439 val_439
44 val_44
-443 val_443
-444 val_444
-446 val_446
-448 val_448
-449 val_449
452 val_452
-453 val_453
-454 val_454
-455 val_455
-457 val_457
-458 val_458
-459 val_459
-460 val_460
-462 val_462
-463 val_463
466 val_466
467 val_467
-468 val_468
-469 val_469
-47 val_47
-470 val_470
472 val_472
-475 val_475
-477 val_477
-478 val_478
-479 val_479
480 val_480
-481 val_481
-482 val_482
-483 val_483
484 val_484
485 val_485
487 val_487
-489 val_489
-490 val_490
-491 val_491
-492 val_492
-493 val_493
-494 val_494
495 val_495
496 val_496
-497 val_497
498 val_498
-5 val_5
51 val_51
-53 val_53
-54 val_54
57 val_57
58 val_58
-64 val_64
65 val_65
66 val_66
-67 val_67
69 val_69
70 val_70
-72 val_72
-74 val_74
-76 val_76
-77 val_77
78 val_78
8 val_8
-80 val_80
-82 val_82
-83 val_83
-84 val_84
-85 val_85
-86 val_86
-87 val_87
-9 val_9
-90 val_90
92 val_92
-95 val_95
96 val_96
-97 val_97
-98 val_98
-PREHOOK: query: explain select * from src intersect distinct select * from src intersect distinct select * from src intersect distinct select * from src
-PREHOOK: type: QUERY
-POSTHOOK: query: explain select * from src intersect distinct select * from src intersect distinct select * from src intersect distinct select * from src
-POSTHOOK: type: QUERY
-STAGE DEPENDENCIES:
- Stage-1 is a root stage
- Stage-0 depends on stages: Stage-1
-
-STAGE PLANS:
- Stage: Stage-1
- Tez
-#### A masked pattern was here ####
- Edges:
- Reducer 10 <- Map 9 (SIMPLE_EDGE), Union 3 (CONTAINS)
+104 val_104
+111 val_111
+114 val_114
+118 val_118
+12 val_12
+133 val_133
+138 val_138
+153 val_153
+156 val_156
+162 val_162
+168 val_168
+174 val_174
+176 val_176
+178 val_178
+181 val_181
+186 val_186
+187 val_187
+192 val_192
+197 val_197
+199 val_199
+2 val_2
+201 val_201
+203 val_203
+208 val_208
+214 val_214
+218 val_218
+219 val_219
+230 val_230
+237 val_237
+249 val_249
+256 val_256
+257 val_257
+277 val_277
+278 val_278
+284 val_284
+285 val_285
+310 val_310
+322 val_322
+327 val_327
+333 val_333
+336 val_336
+338 val_338
+341 val_341
+344 val_344
+348 val_348
+351 val_351
+362 val_362
+364 val_364
+374 val_374
+392 val_392
+397 val_397
+4 val_4
+403 val_403
+404 val_404
+419 val_419
+421 val_421
+427 val_427
+429 val_429
+437 val_437
+438 val_438
+439 val_439
+454 val_454
+455 val_455
+460 val_460
+463 val_463
+470 val_470
+478 val_478
+479 val_479
+489 val_489
+491 val_491
+492 val_492
+53 val_53
+67 val_67
+82 val_82
+90 val_90
+97 val_97
+10 val_10
+125 val_125
+134 val_134
+143 val_143
+145 val_145
+149 val_149
+150 val_150
+158 val_158
+163 val_163
+164 val_164
+166 val_166
+17 val_17
+170 val_170
+172 val_172
+189 val_189
+19 val_19
+195 val_195
+196 val_196
+20 val_20
+209 val_209
+216 val_216
+217 val_217
+224 val_224
+228 val_228
+229 val_229
+233 val_233
+241 val_241
+244 val_244
+247 val_247
+255 val_255
+258 val_258
+26 val_26
+263 val_263
+265 val_265
+266 val_266
+272 val_272
+273 val_273
+274 val_274
+281 val_281
+291 val_291
+296 val_296
+30 val_30
+302 val_302
+309 val_309
+316 val_316
+318 val_318
+325 val_325
+332 val_332
+335 val_335
+339 val_339
+342 val_342
+345 val_345
+353 val_353
+369 val_369
+373 val_373
+375 val_375
+377 val_377
+384 val_384
+386 val_386
+394 val_394
+396 val_396
+399 val_399
+401 val_401
+41 val_41
+413 val_413
+414 val_414
+431 val_431
+446 val_446
+448 val_448
+449 val_449
+459 val_459
+462 val_462
+468 val_468
+47 val_47
+482 val_482
+490 val_490
+493 val_493
+494 val_494
+497 val_497
+5 val_5
+54 val_54
+74 val_74
+77 val_77
+80 val_80
+84 val_84
+85 val_85
+87 val_87
+9 val_9
+95 val_95
+100 val_100
+11 val_11
+113 val_113
+119 val_119
+126 val_126
+128 val_128
+137 val_137
+146 val_146
+15 val_15
+152 val_152
+165 val_165
+167 val_167
+169 val_169
+175 val_175
+177 val_177
+179 val_179
+18 val_18
+194 val_194
+200 val_200
+202 val_202
+221 val_221
+222 val_222
+226 val_226
+242 val_242
+252 val_252
+262 val_262
+27 val_27
+275 val_275
+280 val_280
+282 val_282
+283 val_283
+287 val_287
+288 val_288
+289 val_289
+292 val_292
+311 val_311
+323 val_323
+34 val_34
+35 val_35
+365 val_365
+393 val_393
+409 val_409
+411 val_411
+417 val_417
+418 val_418
+424 val_424
+43 val_43
+432 val_432
+435 val_435
+443 val_443
+444 val_444
+453 val_453
+457 val_457
+458 val_458
+469 val_469
+475 val_475
+477 val_477
+481 val_481
+483 val_483
+64 val_64
+72 val_72
+76 val_76
+83 val_83
+86 val_86
+98 val_98
+PREHOOK: query: explain select * from src intersect distinct select * from src intersect distinct select * from src intersect distinct select * from src
+PREHOOK: type: QUERY
+POSTHOOK: query: explain select * from src intersect distinct select * from src intersect distinct select * from src intersect distinct select * from src
+POSTHOOK: type: QUERY
+STAGE DEPENDENCIES:
+ Stage-1 is a root stage
+ Stage-0 depends on stages: Stage-1
+
+STAGE PLANS:
+ Stage: Stage-1
+ Tez
+#### A masked pattern was here ####
+ Edges:
+ Reducer 10 <- Map 9 (SIMPLE_EDGE), Union 3 (CONTAINS)
Reducer 2 <- Map 1 (SIMPLE_EDGE), Union 3 (CONTAINS)
Reducer 4 <- Union 3 (SIMPLE_EDGE)
Reducer 6 <- Map 5 (SIMPLE_EDGE), Union 3 (CONTAINS)
@@ -823,313 +823,313 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
0 val_0
-10 val_10
-100 val_100
103 val_103
-104 val_104
105 val_105
-11 val_11
-111 val_111
-113 val_113
-114 val_114
116 val_116
-118 val_118
-119 val_119
-12 val_12
120 val_120
-125 val_125
-126 val_126
-128 val_128
129 val_129
131 val_131
-133 val_133
-134 val_134
136 val_136
-137 val_137
-138 val_138
-143 val_143
-145 val_145
-146 val_146
-149 val_149
-15 val_15
-150 val_150
-152 val_152
-153 val_153
155 val_155
-156 val_156
157 val_157
-158 val_158
160 val_160
+180 val_180
+183 val_183
+190 val_190
+191 val_191
+193 val_193
+205 val_205
+207 val_207
+213 val_213
+223 val_223
+235 val_235
+238 val_238
+239 val_239
+24 val_24
+248 val_248
+260 val_260
+28 val_28
+286 val_286
+298 val_298
+305 val_305
+306 val_306
+307 val_307
+308 val_308
+315 val_315
+317 val_317
+321 val_321
+33 val_33
+331 val_331
+356 val_356
+360 val_360
+366 val_366
+367 val_367
+368 val_368
+37 val_37
+378 val_378
+379 val_379
+382 val_382
+389 val_389
+395 val_395
+400 val_400
+402 val_402
+406 val_406
+407 val_407
+42 val_42
+430 val_430
+436 val_436
+44 val_44
+452 val_452
+466 val_466
+467 val_467
+472 val_472
+480 val_480
+484 val_484
+485 val_485
+487 val_487
+495 val_495
+496 val_496
+498 val_498
+51 val_51
+57 val_57
+58 val_58
+65 val_65
+66 val_66
+69 val_69
+70 val_70
+78 val_78
+8 val_8
+92 val_92
+96 val_96
+104 val_104
+111 val_111
+114 val_114
+118 val_118
+12 val_12
+133 val_133
+138 val_138
+153 val_153
+156 val_156
162 val_162
-163 val_163
-164 val_164
-165 val_165
-166 val_166
-167 val_167
168 val_168
-169 val_169
-17 val_17
-170 val_170
-172 val_172
174 val_174
-175 val_175
176 val_176
-177 val_177
178 val_178
-179 val_179
-18 val_18
-180 val_180
181 val_181
-183 val_183
186 val_186
187 val_187
-189 val_189
-19 val_19
-190 val_190
-191 val_191
192 val_192
-193 val_193
-194 val_194
-195 val_195
-196 val_196
197 val_197
199 val_199
2 val_2
-20 val_20
-200 val_200
201 val_201
-202 val_202
203 val_203
-205 val_205
-207 val_207
208 val_208
-209 val_209
-213 val_213
214 val_214
-216 val_216
-217 val_217
218 val_218
219 val_219
-221 val_221
-222 val_222
-223 val_223
+230 val_230
+237 val_237
+249 val_249
+256 val_256
+257 val_257
+277 val_277
+278 val_278
+284 val_284
+285 val_285
+310 val_310
+322 val_322
+327 val_327
+333 val_333
+336 val_336
+338 val_338
+341 val_341
+344 val_344
+348 val_348
+351 val_351
+362 val_362
+364 val_364
+374 val_374
+392 val_392
+397 val_397
+4 val_4
+403 val_403
+404 val_404
+419 val_419
+421 val_421
+427 val_427
+429 val_429
+437 val_437
+438 val_438
+439 val_439
+454 val_454
+455 val_455
+460 val_460
+463 val_463
+470 val_470
+478 val_478
+479 val_479
+489 val_489
+491 val_491
+492 val_492
+53 val_53
+67 val_67
+82 val_82
+90 val_90
+97 val_97
+10 val_10
+125 val_125
+134 val_134
+143 val_143
+145 val_145
+149 val_149
+150 val_150
+158 val_158
+163 val_163
+164 val_164
+166 val_166
+17 val_17
+170 val_170
+172 val_172
+189 val_189
+19 val_19
+195 val_195
+196 val_196
+20 val_20
+209 val_209
+216 val_216
+217 val_217
224 val_224
-226 val_226
228 val_228
229 val_229
-230 val_230
233 val_233
-235 val_235
-237 val_237
-238 val_238
-239 val_239
-24 val_24
241 val_241
-242 val_242
244 val_244
247 val_247
-248 val_248
-249 val_249
-252 val_252
255 val_255
-256 val_256
-257 val_257
258 val_258
26 val_26
-260 val_260
-262 val_262
263 val_263
265 val_265
266 val_266
-27 val_27
272 val_272
273 val_273
274 val_274
-275 val_275
-277 val_277
-278 val_278
-28 val_28
-280 val_280
281 val_281
-282 val_282
-283 val_283
-284 val_284
-285 val_285
-286 val_286
-287 val_287
-288 val_288
-289 val_289
291 val_291
-292 val_292
296 val_296
-298 val_298
30 val_30
302 val_302
-305 val_305
-306 val_306
-307 val_307
-308 val_308
309 val_309
-310 val_310
-311 val_311
-315 val_315
316 val_316
-317 val_317
318 val_318
-321 val_321
-322 val_322
-323 val_323
325 val_325
-327 val_327
-33 val_33
-331 val_331
332 val_332
-333 val_333
335 val_335
-336 val_336
-338 val_338
339 val_339
-34 val_34
-341 val_341
342 val_342
-344 val_344
345 val_345
-348 val_348
-35 val_35
-351 val_351
353 val_353
-356 val_356
-360 val_360
-362 val_362
-364 val_364
-365 val_365
-366 val_366
-367 val_367
-368 val_368
369 val_369
-37 val_37
373 val_373
-374 val_374
375 val_375
377 val_377
-378 val_378
-379 val_379
-382 val_382
384 val_384
386 val_386
-389 val_389
-392 val_392
-393 val_393
394 val_394
-395 val_395
396 val_396
-397 val_397
399 val_399
-4 val_4
-400 val_400
401 val_401
-402 val_402
-403 val_403
-404 val_404
-406 val_406
-407 val_407
-409 val_409
41 val_41
-411 val_411
413 val_413
414 val_414
-417 val_417
-418 val_418
-419 val_419
-42 val_42
-421 val_421
-424 val_424
-427 val_427
-429 val_429
-43 val_43
-430 val_430
431 val_431
-432 val_432
-435 val_435
-436 val_436
-437 val_437
-438 val_438
-439 val_439
-44 val_44
-443 val_443
-444 val_444
446 val_446
448 val_448
449 val_449
-452 val_452
-453 val_453
-454 val_454
-455 val_455
-457 val_457
-458 val_458
459 val_459
-460 val_460
462 val_462
-463 val_463
-466 val_466
-467 val_467
468 val_468
-469 val_469
47 val_47
-470 val_470
-472 val_472
-475 val_475
-477 val_477
-478 val_478
-479 val_479
-480 val_480
-481 val_481
482 val_482
-483 val_483
-484 val_484
-485 val_485
-487 val_487
-489 val_489
490 val_490
-491 val_491
-492 val_492
493 val_493
494 val_494
-495 val_495
-496 val_496
497 val_497
-498 val_498
5 val_5
-51 val_51
-53 val_53
54 val_54
-57 val_57
-58 val_58
-64 val_64
-65 val_65
-66 val_66
-67 val_67
-69 val_69
-70 val_70
-72 val_72
74 val_74
-76 val_76
77 val_77
-78 val_78
-8 val_8
80 val_80
-82 val_82
-83 val_83
84 val_84
85 val_85
-86 val_86
87 val_87
9 val_9
-90 val_90
-92 val_92
95 val_95
-96 val_96
-97 val_97
+100 val_100
+11 val_11
+113 val_113
+119 val_119
+126 val_126
+128 val_128
+137 val_137
+146 val_146
+15 val_15
+152 val_152
+165 val_165
+167 val_167
+169 val_169
+175 val_175
+177 val_177
+179 val_179
+18 val_18
+194 val_194
+200 val_200
+202 val_202
+221 val_221
+222 val_222
+226 val_226
+242 val_242
+252 val_252
+262 val_262
+27 val_27
+275 val_275
+280 val_280
+282 val_282
+283 val_283
+287 val_287
+288 val_288
+289 val_289
+292 val_292
+311 val_311
+323 val_323
+34 val_34
+35 val_35
+365 val_365
+393 val_393
+409 val_409
+411 val_411
+417 val_417
+418 val_418
+424 val_424
+43 val_43
+432 val_432
+435 val_435
+443 val_443
+444 val_444
+453 val_453
+457 val_457
+458 val_458
+469 val_469
+475 val_475
+477 val_477
+481 val_481
+483 val_483
+64 val_64
+72 val_72
+76 val_76
+83 val_83
+86 val_86
98 val_98
PREHOOK: query: explain select value from a group by value intersect distinct select key from b group by key
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/lateral_view.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/lateral_view.q.out b/ql/src/test/results/clientpositive/llap/lateral_view.q.out
index 2a1ed11..7e4ad81 100644
--- a/ql/src/test/results/clientpositive/llap/lateral_view.q.out
+++ b/ql/src/test/results/clientpositive/llap/lateral_view.q.out
@@ -718,14 +718,14 @@ POSTHOOK: Input: default@tmp_pyang_src_rcfile
#### A masked pattern was here ####
["val_0"] val_0
["val_10"] val_10
-["val_100"] val_100
-["val_103"] val_103
["val_104"] val_104
["val_105"] val_105
-["val_11"] val_11
["val_111"] val_111
["val_113"] val_113
["val_114"] val_114
["val_116"] val_116
-["val_118"] val_118
["val_119"] val_119
+["val_103"] val_103
+["val_100"] val_100
+["val_11"] val_11
+["val_118"] val_118
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/lineage2.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/lineage2.q.out b/ql/src/test/results/clientpositive/llap/lineage2.q.out
index 0967f20..79590a7 100644
--- a/ql/src/test/results/clientpositive/llap/lineage2.q.out
+++ b/ql/src/test/results/clientpositive/llap/lineage2.q.out
@@ -141,87 +141,87 @@ PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
{"version":"1.0","engine":"tez","database":"default","hash":"3901b5e3a164064736b3234355046340","queryText":"select key, count(1) a from dest1 group by key","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"count(1)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"key"},{"id":1,"vertexType":"COLUMN","vertexId":"a"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.key"},{"id":3,"vertexType":"TABLE","vertexId":"default.dest1"}]}
- 20
128 2
-146 2
-150 2
213 2
-224 2
+278 2
+369 2
+ 20
+150 2
238 2
+66 2
+146 2
+224 2
255 2
273 2
-278 2
311 2
-369 2
401 2
406 2
-66 2
98 2
PREHOOK: query: select key k, count(*) from dest1 group by key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
{"version":"1.0","engine":"tez","database":"default","hash":"0d5a212f10847aeaab31e8c31121e6d4","queryText":"select key k, count(*) from dest1 group by key","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"count(*)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"k"},{"id":1,"vertexType":"COLUMN","vertexId":"_c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.key"},{"id":3,"vertexType":"TABLE","vertexId":"default.dest1"}]}
- 20
128 2
-146 2
-150 2
213 2
-224 2
+278 2
+369 2
+ 20
+150 2
238 2
+66 2
+146 2
+224 2
255 2
273 2
-278 2
311 2
-369 2
401 2
406 2
-66 2
98 2
PREHOOK: query: select key k, count(value) from dest1 group by key
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
{"version":"1.0","engine":"tez","database":"default","hash":"56429eccb04ded722f5bd9d9d8cf7260","queryText":"select key k, count(value) from dest1 group by key","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"count(default.dest1.value)","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"k"},{"id":1,"vertexType":"COLUMN","vertexId":"_c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.key"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest1.value"}]}
- 20
128 2
-146 2
-150 2
213 2
-224 2
+278 2
+369 2
+ 20
+150 2
238 2
+66 2
+146 2
+224 2
255 2
273 2
-278 2
311 2
-369 2
401 2
406 2
-66 2
98 2
PREHOOK: query: select value, max(length(key)) from dest1 group by value
PREHOOK: type: QUERY
PREHOOK: Input: default@dest1
#### A masked pattern was here ####
{"version":"1.0","engine":"tez","database":"default","hash":"7e1cfc3dece85b41b6f7c46365580cde","queryText":"select value, max(length(key)) from dest1 group by value","edges":[{"sources":[2],"targets":[0],"edgeType":"PROJECTION"},{"sources":[3],"targets":[1],"expression":"max(length(dest1.key))","edgeType":"PROJECTION"}],"vertices":[{"id":0,"vertexType":"COLUMN","vertexId":"value"},{"id":1,"vertexType":"COLUMN","vertexId":"_c1"},{"id":2,"vertexType":"COLUMN","vertexId":"default.dest1.value"},{"id":3,"vertexType":"COLUMN","vertexId":"default.dest1.key"}]}
- 3
val_146 3
-val_150 3
+val_27 0
+val_409 0
+val_484 0
+val_66 2
+ 3
val_165 0
+val_238 3
val_193 0
val_213 3
-val_238 3
val_255 3
val_265 0
-val_27 0
val_273 3
val_278 3
-val_311 3
val_401 3
+val_150 3
+val_311 3
val_406 3
-val_409 0
-val_484 0
-val_66 2
val_98 2
PREHOOK: query: select value, max(length(key)) from dest1 group by value order by value limit 5
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
index 73ccdf5..6d756a8 100644
--- a/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
+++ b/ql/src/test/results/clientpositive/llap/multiMapJoin1.q.out
@@ -659,12 +659,12 @@ POSTHOOK: Input: default@smalltbl1
POSTHOOK: Input: default@smalltbl2
#### A masked pattern was here ####
RUN: Stage-1:MAPRED
-270
10
10
-270
10
10
+270
+270
PREHOOK: query: drop table bigTbl
PREHOOK: type: DROPTABLE
PREHOOK: Input: default@bigtbl
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
index d8f9f03..227e4d7 100644
--- a/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
+++ b/ql/src/test/results/clientpositive/llap/multi_column_in.q.out
@@ -303,8 +303,8 @@ select * from emps where (empno,deptno) in ((1,2),(3,2))
POSTHOOK: type: QUERY
POSTHOOK: Input: default@emps
#### A masked pattern was here ####
-1 2 11
2 5 22
+1 2 11
PREHOOK: query: drop view v
PREHOOK: type: DROPVIEW
POSTHOOK: query: drop view v
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out
index ad74867..0f4f803 100644
--- a/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out
+++ b/ql/src/test/results/clientpositive/llap/multi_count_distinct_null.q.out
@@ -289,24 +289,24 @@ group by department_id, gender, education_level grouping sets
POSTHOOK: type: QUERY
POSTHOOK: Input: default@employee
#### A masked pattern was here ####
-2 NULL NULL NULL
-3 NULL NULL NULL
-5 NULL NULL NULL
6 NULL NULL NULL
-2 NULL NULL 1
-6 NULL NULL 1
6 NULL NULL 2
-6 NULL NULL 3
5 NULL F NULL
-5 NULL M NULL
-3 1 NULL NULL
-2 1 NULL 1
-2 1 NULL 2
+2 2 NULL 3
+2 NULL NULL NULL
+2 NULL NULL 1
2 1 NULL 3
3 2 NULL NULL
2 2 NULL 1
-2 2 NULL 3
3 3 NULL NULL
2 3 NULL 2
-3 4 NULL NULL
+3 NULL NULL NULL
+5 NULL NULL NULL
+5 NULL M NULL
+2 1 NULL 1
+2 1 NULL 2
2 4 NULL 1
+6 NULL NULL 1
+6 NULL NULL 3
+3 1 NULL NULL
+3 4 NULL NULL
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/parquet_types.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/parquet_types.q.out b/ql/src/test/results/clientpositive/llap/parquet_types.q.out
index a3a5640..4d7c5fd 100644
--- a/ql/src/test/results/clientpositive/llap/parquet_types.q.out
+++ b/ql/src/test/results/clientpositive/llap/parquet_types.q.out
@@ -369,7 +369,7 @@ POSTHOOK: query: SELECT hex(cbinary), count(*) FROM parquet_types GROUP BY cbina
POSTHOOK: type: QUERY
POSTHOOK: Input: default@parquet_types
#### A masked pattern was here ####
+68692CCAC0BDE7 10
1
68656C6C6F 1
-68692CCAC0BDE7 10
B4F3CAFDBEDD 10
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out b/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
index 5082734..fb60ce3 100644
--- a/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
+++ b/ql/src/test/results/clientpositive/llap/partition_multilevels.q.out
@@ -471,17 +471,17 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
2222 111 11 11
-2222 111 22 12
-2222 111 33 13
-2222 111 44 14
-2222 222 11 15
2222 222 22 16
-2222 222 33 17
2222 222 44 18
2222 333 11 19
+2222 333 44 22
+2222 111 22 12
+2222 111 33 13
+2222 222 11 15
2222 333 22 20
+2222 222 33 17
2222 333 33 21
-2222 333 44 22
+2222 111 44 14
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 >= '2222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -514,18 +514,18 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
-2222 111 11 11
-2222 111 22 12
-2222 111 33 13
-2222 111 44 14
2222 222 11 15
2222 222 22 16
-2222 222 33 17
+2222 333 33 21
+2222 111 33 13
2222 222 44 18
2222 333 11 19
2222 333 22 20
-2222 333 33 21
2222 333 44 22
+2222 111 11 11
+2222 111 22 12
+2222 111 44 14
+2222 222 33 17
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 !='2222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -558,16 +558,16 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+1111 222 11 15
+1111 222 44 18
+1111 333 22 20
1111 111 22 12
1111 111 33 13
1111 111 44 14
-1111 222 11 15
1111 222 22 16
1111 222 33 17
-1111 222 44 18
+1111 111 11 11
1111 333 11 19
-1111 333 22 20
1111 333 33 21
1111 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 = '222' group by level1, level2, level3
@@ -594,14 +594,14 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=44
#### A masked pattern was here ####
-1111 222 11 15
+2222 222 33 17
1111 222 22 16
-1111 222 33 17
1111 222 44 18
-2222 222 11 15
-2222 222 22 16
-2222 222 33 17
2222 222 44 18
+1111 222 11 15
+1111 222 33 17
+2222 222 22 16
+2222 222 11 15
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 <= '222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -642,22 +642,22 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+1111 222 11 15
+2222 222 11 15
+2222 222 22 16
+1111 222 44 18
+2222 111 33 13
+2222 222 44 18
1111 111 22 12
1111 111 33 13
1111 111 44 14
-1111 222 11 15
1111 222 22 16
1111 222 33 17
-1111 222 44 18
+1111 111 11 11
2222 111 11 11
2222 111 22 12
-2222 111 33 13
2222 111 44 14
-2222 222 11 15
-2222 222 22 16
2222 222 33 17
-2222 222 44 18
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 != '222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -698,22 +698,22 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+2222 333 33 21
+1111 333 22 20
+2222 111 33 13
+2222 333 11 19
1111 111 22 12
1111 111 33 13
1111 111 44 14
+2222 333 22 20
+2222 333 44 22
+1111 111 11 11
1111 333 11 19
-1111 333 22 20
1111 333 33 21
1111 333 44 22
2222 111 11 11
2222 111 22 12
-2222 111 33 13
2222 111 44 14
-2222 333 11 19
-2222 333 22 20
-2222 333 33 21
-2222 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level3 = '22' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -734,11 +734,11 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=111/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=22
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=22
#### A masked pattern was here ####
-1111 111 22 12
-1111 222 22 16
1111 333 22 20
-2222 111 22 12
2222 222 22 16
+1111 222 22 16
+1111 111 22 12
+2222 111 22 12
2222 333 22 20
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level3 >= '22' group by level1, level2, level3
PREHOOK: type: QUERY
@@ -784,24 +784,24 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
+2222 222 22 16
+2222 333 33 21
+1111 222 44 18
+1111 333 22 20
+2222 111 33 13
+2222 222 44 18
1111 111 22 12
1111 111 33 13
1111 111 44 14
1111 222 22 16
1111 222 33 17
-1111 222 44 18
-1111 333 22 20
+2222 333 22 20
+2222 333 44 22
1111 333 33 21
1111 333 44 22
2222 111 22 12
-2222 111 33 13
2222 111 44 14
-2222 222 22 16
2222 222 33 17
-2222 222 44 18
-2222 333 22 20
-2222 333 33 21
-2222 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level3 != '22' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -846,24 +846,24 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+1111 222 11 15
+2222 222 11 15
+2222 333 33 21
+1111 222 44 18
+2222 111 33 13
+2222 222 44 18
+2222 333 11 19
1111 111 33 13
1111 111 44 14
-1111 222 11 15
1111 222 33 17
-1111 222 44 18
+2222 333 44 22
+1111 111 11 11
1111 333 11 19
1111 333 33 21
1111 333 44 22
2222 111 11 11
-2222 111 33 13
2222 111 44 14
-2222 222 11 15
2222 222 33 17
-2222 222 44 18
-2222 333 11 19
-2222 333 33 21
-2222 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 >= '222' and level3 = '33' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -880,9 +880,9 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
#### A masked pattern was here ####
-1111 222 33 17
1111 333 33 21
2222 222 33 17
+1111 222 33 17
2222 333 33 21
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 <= '1111' and level3 >= '33' group by level1, level2, level3
PREHOOK: type: QUERY
@@ -904,10 +904,10 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=222/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=44
#### A masked pattern was here ####
+1111 222 44 18
1111 111 33 13
1111 111 44 14
1111 222 33 17
-1111 222 44 18
1111 333 33 21
1111 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 = '2222' and level2 >= '222' and level3 <= '33' group by level1, level2, level3
@@ -930,11 +930,11 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=22
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
#### A masked pattern was here ####
-2222 222 11 15
2222 222 22 16
-2222 222 33 17
2222 333 11 19
+2222 222 11 15
2222 333 22 20
+2222 222 33 17
2222 333 33 21
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where (level1 = '2222') and (level2 between '222' and '333') and (level3 between '11' and '33') group by level1, level2, level3
PREHOOK: type: QUERY
@@ -956,11 +956,11 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=22
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
#### A masked pattern was here ####
-2222 222 11 15
2222 222 22 16
-2222 222 33 17
2222 333 11 19
+2222 222 11 15
2222 333 22 20
+2222 222 33 17
2222 333 33 21
PREHOOK: query: explain select level1, level2, level3, count(*) from partition_test_multilevel where (level1 = '2222') and (level2 between '222' and '333') and (level3 between '11' and '33') group by level1, level2, level3
PREHOOK: type: QUERY
@@ -1061,17 +1061,17 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
2222 111 11 11
-2222 111 22 12
-2222 111 33 13
-2222 111 44 14
-2222 222 11 15
2222 222 22 16
-2222 222 33 17
2222 222 44 18
2222 333 11 19
+2222 333 44 22
+2222 111 22 12
+2222 111 33 13
+2222 222 11 15
2222 333 22 20
+2222 222 33 17
2222 333 33 21
-2222 333 44 22
+2222 111 44 14
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 >= '2222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1104,18 +1104,18 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
-2222 111 11 11
-2222 111 22 12
-2222 111 33 13
-2222 111 44 14
2222 222 11 15
2222 222 22 16
-2222 222 33 17
+2222 333 33 21
+2222 111 33 13
2222 222 44 18
2222 333 11 19
2222 333 22 20
-2222 333 33 21
2222 333 44 22
+2222 111 11 11
+2222 111 22 12
+2222 111 44 14
+2222 222 33 17
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 !='2222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1148,16 +1148,16 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+1111 222 11 15
+1111 222 44 18
+1111 333 22 20
1111 111 22 12
1111 111 33 13
1111 111 44 14
-1111 222 11 15
1111 222 22 16
1111 222 33 17
-1111 222 44 18
+1111 111 11 11
1111 333 11 19
-1111 333 22 20
1111 333 33 21
1111 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 = '222' group by level1, level2, level3
@@ -1184,14 +1184,14 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=44
#### A masked pattern was here ####
-1111 222 11 15
+2222 222 33 17
1111 222 22 16
-1111 222 33 17
1111 222 44 18
-2222 222 11 15
-2222 222 22 16
-2222 222 33 17
2222 222 44 18
+1111 222 11 15
+1111 222 33 17
+2222 222 22 16
+2222 222 11 15
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 <= '222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1232,22 +1232,22 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+1111 222 11 15
+2222 222 11 15
+2222 222 22 16
+1111 222 44 18
+2222 111 33 13
+2222 222 44 18
1111 111 22 12
1111 111 33 13
1111 111 44 14
-1111 222 11 15
1111 222 22 16
1111 222 33 17
-1111 222 44 18
+1111 111 11 11
2222 111 11 11
2222 111 22 12
-2222 111 33 13
2222 111 44 14
-2222 222 11 15
-2222 222 22 16
2222 222 33 17
-2222 222 44 18
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 != '222' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1288,22 +1288,22 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+2222 333 33 21
+1111 333 22 20
+2222 111 33 13
+2222 333 11 19
1111 111 22 12
1111 111 33 13
1111 111 44 14
+2222 333 22 20
+2222 333 44 22
+1111 111 11 11
1111 333 11 19
-1111 333 22 20
1111 333 33 21
1111 333 44 22
2222 111 11 11
2222 111 22 12
-2222 111 33 13
2222 111 44 14
-2222 333 11 19
-2222 333 22 20
-2222 333 33 21
-2222 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level3 = '22' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1324,11 +1324,11 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=111/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=22
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=22
#### A masked pattern was here ####
-1111 111 22 12
-1111 222 22 16
1111 333 22 20
-2222 111 22 12
2222 222 22 16
+1111 222 22 16
+1111 111 22 12
+2222 111 22 12
2222 333 22 20
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level3 >= '22' group by level1, level2, level3
PREHOOK: type: QUERY
@@ -1374,24 +1374,24 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
+2222 222 22 16
+2222 333 33 21
+1111 222 44 18
+1111 333 22 20
+2222 111 33 13
+2222 222 44 18
1111 111 22 12
1111 111 33 13
1111 111 44 14
1111 222 22 16
1111 222 33 17
-1111 222 44 18
-1111 333 22 20
+2222 333 22 20
+2222 333 44 22
1111 333 33 21
1111 333 44 22
2222 111 22 12
-2222 111 33 13
2222 111 44 14
-2222 222 22 16
2222 222 33 17
-2222 222 44 18
-2222 333 22 20
-2222 333 33 21
-2222 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level3 != '22' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1436,24 +1436,24 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=44
#### A masked pattern was here ####
-1111 111 11 11
+1111 222 11 15
+2222 222 11 15
+2222 333 33 21
+1111 222 44 18
+2222 111 33 13
+2222 222 44 18
+2222 333 11 19
1111 111 33 13
1111 111 44 14
-1111 222 11 15
1111 222 33 17
-1111 222 44 18
+2222 333 44 22
+1111 111 11 11
1111 333 11 19
1111 333 33 21
1111 333 44 22
2222 111 11 11
-2222 111 33 13
2222 111 44 14
-2222 222 11 15
2222 222 33 17
-2222 222 44 18
-2222 333 11 19
-2222 333 33 21
-2222 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level2 >= '222' and level3 = '33' group by level1, level2, level3
PREHOOK: type: QUERY
PREHOOK: Input: default@partition_test_multilevel
@@ -1470,9 +1470,9 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=222/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
#### A masked pattern was here ####
-1111 222 33 17
1111 333 33 21
2222 222 33 17
+1111 222 33 17
2222 333 33 21
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 <= '1111' and level3 >= '33' group by level1, level2, level3
PREHOOK: type: QUERY
@@ -1494,10 +1494,10 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=222/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=33
POSTHOOK: Input: default@partition_test_multilevel@level1=1111/level2=333/level3=44
#### A masked pattern was here ####
+1111 222 44 18
1111 111 33 13
1111 111 44 14
1111 222 33 17
-1111 222 44 18
1111 333 33 21
1111 333 44 22
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where level1 = '2222' and level2 >= '222' and level3 <= '33' group by level1, level2, level3
@@ -1520,11 +1520,11 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=22
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
#### A masked pattern was here ####
-2222 222 11 15
2222 222 22 16
-2222 222 33 17
2222 333 11 19
+2222 222 11 15
2222 333 22 20
+2222 222 33 17
2222 333 33 21
PREHOOK: query: select level1, level2, level3, count(*) from partition_test_multilevel where (level1 = '2222') and (level2 between '222' and '333') and (level3 between '11' and '33') group by level1, level2, level3
PREHOOK: type: QUERY
@@ -1546,11 +1546,11 @@ POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=22
POSTHOOK: Input: default@partition_test_multilevel@level1=2222/level2=333/level3=33
#### A masked pattern was here ####
-2222 222 11 15
2222 222 22 16
-2222 222 33 17
2222 333 11 19
+2222 222 11 15
2222 333 22 20
+2222 222 33 17
2222 333 33 21
PREHOOK: query: explain select level1, level2, level3, count(*) from partition_test_multilevel where (level1 = '2222') and (level2 between '222' and '333') and (level3 between '11' and '33') group by level1, level2, level3
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out b/ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out
index 834a251..bc44db7 100644
--- a/ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out
+++ b/ql/src/test/results/clientpositive/llap/reduce_deduplicate_extended.q.out
@@ -1856,20 +1856,20 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-128 384.0
-146 292.0
-150 150.0
213 426.0
-224 448.0
238 476.0
+406 1624.0
+66 66.0
+278 556.0
+150 150.0
+224 448.0
255 510.0
273 819.0
-278 556.0
-311 933.0
369 1107.0
401 2005.0
-406 1624.0
-66 66.0
+128 384.0
+146 292.0
+311 933.0
98 196.0
PREHOOK: query: select src.key, src.value FROM src JOIN src1 ON src.key = src1.key order by src.key, src.value
PREHOOK: type: QUERY
@@ -4386,20 +4386,20 @@ POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
POSTHOOK: Input: default@src1
#### A masked pattern was here ####
-128 384.0
-146 292.0
-150 150.0
213 426.0
-224 448.0
238 476.0
+406 1624.0
+66 66.0
+278 556.0
+150 150.0
+224 448.0
255 510.0
273 819.0
-278 556.0
-311 933.0
369 1107.0
401 2005.0
-406 1624.0
-66 66.0
+128 384.0
+146 292.0
+311 933.0
98 196.0
PREHOOK: query: select src.key, src.value FROM src JOIN src1 ON src.key = src1.key order by src.key, src.value
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/skiphf_aggr.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/skiphf_aggr.q.out b/ql/src/test/results/clientpositive/llap/skiphf_aggr.q.out
index 2af06db..3814030 100644
--- a/ql/src/test/results/clientpositive/llap/skiphf_aggr.q.out
+++ b/ql/src/test/results/clientpositive/llap/skiphf_aggr.q.out
@@ -87,9 +87,9 @@ POSTHOOK: Input: default@skiphtbl
POSTHOOK: Input: default@skiphtbl@b=1
POSTHOOK: Input: default@skiphtbl@b=2
#### A masked pattern was here ####
+4
2
3
-4
PREHOOK: query: INSERT OVERWRITE TABLE skipHTbl PARTITION (b = 1) VALUES (1)
PREHOOK: type: QUERY
PREHOOK: Output: default@skiphtbl@b=1
@@ -142,9 +142,9 @@ POSTHOOK: Input: default@skiphtbl
POSTHOOK: Input: default@skiphtbl@b=1
POSTHOOK: Input: default@skiphtbl@b=2
#### A masked pattern was here ####
+4
2
3
-4
PREHOOK: query: DROP TABLE IF EXISTS skipFTbl
PREHOOK: type: DROPTABLE
POSTHOOK: query: DROP TABLE IF EXISTS skipFTbl
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_multi.q.out b/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
index e5c22e0..95c78f5 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_multi.q.out
@@ -3597,305 +3597,305 @@ having count(*) in (select count(*) from src s1 where s1.key > '9' and exists (s
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-53 val_53 1
-351 val_351 1
-82 val_82 1
-356 val_356 1
-360 val_360 1
-362 val_362 1
-364 val_364 1
+292 val_292 1
+477 val_477 1
+323 val_323 1
+34 val_34 1
+475 val_475 1
365 val_365 1
-366 val_366 1
-194 val_194 1
-368 val_368 1
-497 val_497 1
-143 val_143 1
-373 val_373 1
-374 val_374 1
-375 val_375 1
-377 val_377 1
-378 val_378 1
-379 val_379 1
-196 val_196 1
-496 val_496 1
-386 val_386 1
-389 val_389 1
-392 val_392 1
393 val_393 1
-394 val_394 1
-145 val_145 1
-495 val_495 1
-80 val_80 1
-2 val_2 1
-4 val_4 1
-400 val_400 1
-494 val_494 1
-402 val_402 1
-493 val_493 1
-20 val_20 1
-491 val_491 1
-407 val_407 1
-490 val_490 1
-41 val_41 1
+457 val_457 1
411 val_411 1
-96 val_96 1
-201 val_201 1
-487 val_487 1
+453 val_453 1
418 val_418 1
-419 val_419 1
-202 val_202 1
-421 val_421 1
-11 val_11 1
-427 val_427 1
-111 val_111 1
+64 val_64 1
43 val_43 1
-485 val_485 1
-484 val_484 1
432 val_432 1
435 val_435 1
-436 val_436 1
-437 val_437 1
-483 val_483 1
-150 val_150 1
-44 val_44 1
443 val_443 1
444 val_444 1
-446 val_446 1
-448 val_448 1
-449 val_449 1
-452 val_452 1
-453 val_453 1
-482 val_482 1
-455 val_455 1
-457 val_457 1
-8 val_8 1
-10 val_10 1
-460 val_460 1
-153 val_153 1
-214 val_214 1
+194 val_194 1
+11 val_11 1
+202 val_202 1
+483 val_483 1
+222 val_222 1
+226 val_226 1
481 val_481 1
-467 val_467 1
+252 val_252 1
+262 val_262 1
+27 val_27 1
+275 val_275 1
+86 val_86 1
+177 val_177 1
+283 val_283 1
+287 val_287 1
+126 val_126 1
+289 val_289 1
+336 val_336 1
+338 val_338 1
+341 val_341 1
+181 val_181 1
+455 val_455 1
+351 val_351 1
+362 val_362 1
+364 val_364 1
+374 val_374 1
+392 val_392 1
+186 val_186 1
+4 val_4 1
+437 val_437 1
+53 val_53 1
+419 val_419 1
+421 val_421 1
+427 val_427 1
+192 val_192 1
+133 val_133 1
+491 val_491 1
+2 val_2 1
+201 val_201 1
+82 val_82 1
479 val_479 1
-477 val_477 1
-47 val_47 1
+214 val_214 1
+218 val_218 1
+153 val_153 1
470 val_470 1
-472 val_472 1
-475 val_475 1
-155 val_155 1
156 val_156 1
-218 val_218 1
-157 val_157 1
-158 val_158 1
-222 val_222 1
-160 val_160 1
+249 val_249 1
162 val_162 1
-226 val_226 1
-228 val_228 1
-163 val_163 1
-78 val_78 1
-126 val_126 1
-235 val_235 1
-92 val_92 1
-166 val_166 1
-87 val_87 1
+257 val_257 1
+460 val_460 1
168 val_168 1
+284 val_284 1
+285 val_285 1
+310 val_310 1
+111 val_111 1
+114 val_114 1
+178 val_178 1
+345 val_345 1
+145 val_145 1
+85 val_85 1
+373 val_373 1
+375 val_375 1
+377 val_377 1
+80 val_80 1
+386 val_386 1
+394 val_394 1
+77 val_77 1
+166 val_166 1
+74 val_74 1
+41 val_41 1
+228 val_228 1
+17 val_17 1
+54 val_54 1
+446 val_446 1
+448 val_448 1
+449 val_449 1
+170 val_170 1
241 val_241 1
-86 val_86 1
+497 val_497 1
+47 val_47 1
+482 val_482 1
+490 val_490 1
+493 val_493 1
+494 val_494 1
244 val_244 1
247 val_247 1
-248 val_248 1
-249 val_249 1
-252 val_252 1
-17 val_17 1
-170 val_170 1
-257 val_257 1
+143 val_143 1
258 val_258 1
-114 val_114 1
-260 val_260 1
-262 val_262 1
+189 val_189 1
263 val_263 1
-131 val_131 1
+19 val_19 1
266 val_266 1
-27 val_27 1
-133 val_133 1
-77 val_77 1
+150 val_150 1
+9 val_9 1
274 val_274 1
-275 val_275 1
-74 val_74 1
-116 val_116 1
-28 val_28 1
-177 val_177 1
-178 val_178 1
-136 val_136 1
-283 val_283 1
-284 val_284 1
-285 val_285 1
-286 val_286 1
-287 val_287 1
-105 val_105 1
-289 val_289 1
+196 val_196 1
291 val_291 1
-292 val_292 1
296 val_296 1
-69 val_69 1
30 val_30 1
302 val_302 1
+20 val_20 1
+10 val_10 1
+87 val_87 1
+158 val_158 1
+332 val_332 1
+335 val_335 1
+339 val_339 1
+163 val_163 1
+96 val_96 1
+105 val_105 1
+116 val_116 1
+131 val_131 1
+136 val_136 1
+155 val_155 1
+157 val_157 1
+160 val_160 1
+180 val_180 1
+183 val_183 1
+190 val_190 1
+235 val_235 1
+248 val_248 1
+260 val_260 1
+28 val_28 1
+286 val_286 1
305 val_305 1
306 val_306 1
-180 val_180 1
308 val_308 1
-181 val_181 1
-310 val_310 1
-66 val_66 1
315 val_315 1
-65 val_65 1
-183 val_183 1
-64 val_64 1
-186 val_186 1
-85 val_85 1
-323 val_323 1
-189 val_189 1
-57 val_57 1
33 val_33 1
-19 val_19 1
-332 val_332 1
-190 val_190 1
-335 val_335 1
-336 val_336 1
-338 val_338 1
-339 val_339 1
-34 val_34 1
-341 val_341 1
-9 val_9 1
-192 val_192 1
-345 val_345 1
-54 val_54 1
-98 val_98 2
-100 val_100 2
+356 val_356 1
+360 val_360 1
+366 val_366 1
+368 val_368 1
+378 val_378 1
+379 val_379 1
+389 val_389 1
+400 val_400 1
+402 val_402 1
+407 val_407 1
+436 val_436 1
+44 val_44 1
+452 val_452 1
+467 val_467 1
+472 val_472 1
+484 val_484 1
+485 val_485 1
+487 val_487 1
+495 val_495 1
+496 val_496 1
+57 val_57 1
+65 val_65 1
+66 val_66 1
+69 val_69 1
+78 val_78 1
+8 val_8 1
+92 val_92 1
+207 val_207 2
+213 val_213 2
+223 val_223 2
+238 val_238 2
+239 val_239 2
+24 val_24 2
+37 val_37 2
+51 val_51 2
+382 val_382 2
+395 val_395 2
+307 val_307 2
103 val_103 2
-104 val_104 2
-113 val_113 2
-118 val_118 2
-12 val_12 2
+58 val_58 2
120 val_120 2
-125 val_125 2
129 val_129 2
-134 val_134 2
+317 val_317 2
+321 val_321 2
+331 val_331 2
+42 val_42 2
+367 val_367 2
+191 val_191 2
+205 val_205 2
+97 val_97 2
+118 val_118 2
+12 val_12 2
+174 val_174 2
+176 val_176 2
+197 val_197 2
+203 val_203 2
+219 val_219 2
+237 val_237 2
+256 val_256 2
+278 val_278 2
+322 val_322 2
+104 val_104 2
+333 val_333 2
+344 val_344 2
+397 val_397 2
+404 val_404 2
+429 val_429 2
+439 val_439 2
+463 val_463 2
+478 val_478 2
+492 val_492 2
+67 val_67 2
+100 val_100 2
+113 val_113 2
137 val_137 2
146 val_146 2
-149 val_149 2
15 val_15 2
152 val_152 2
-164 val_164 2
165 val_165 2
-172 val_172 2
-174 val_174 2
175 val_175 2
-176 val_176 2
179 val_179 2
18 val_18 2
-191 val_191 2
-195 val_195 2
-197 val_197 2
200 val_200 2
-203 val_203 2
-205 val_205 2
-207 val_207 2
+221 val_221 2
+242 val_242 2
+280 val_280 2
+282 val_282 2
+288 val_288 2
+424 val_424 2
+458 val_458 2
+72 val_72 2
+76 val_76 2
+83 val_83 2
+98 val_98 2
+95 val_95 2
+125 val_125 2
+134 val_134 2
+149 val_149 2
+164 val_164 2
+172 val_172 2
+195 val_195 2
209 val_209 2
-213 val_213 2
216 val_216 2
217 val_217 2
-219 val_219 2
-221 val_221 2
-223 val_223 2
224 val_224 2
229 val_229 2
233 val_233 2
-237 val_237 2
-238 val_238 2
-239 val_239 2
-24 val_24 2
-242 val_242 2
255 val_255 2
-256 val_256 2
26 val_26 2
265 val_265 2
272 val_272 2
-278 val_278 2
-280 val_280 2
281 val_281 2
-282 val_282 2
-288 val_288 2
-307 val_307 2
309 val_309 2
-317 val_317 2
-321 val_321 2
-322 val_322 2
325 val_325 2
-331 val_331 2
-333 val_333 2
342 val_342 2
-344 val_344 2
353 val_353 2
-367 val_367 2
-37 val_37 2
-382 val_382 2
-395 val_395 2
-397 val_397 2
399 val_399 2
-404 val_404 2
413 val_413 2
414 val_414 2
-42 val_42 2
-424 val_424 2
-429 val_429 2
-439 val_439 2
-458 val_458 2
459 val_459 2
462 val_462 2
-463 val_463 2
-478 val_478 2
-492 val_492 2
-51 val_51 2
-58 val_58 2
-67 val_67 2
-72 val_72 2
-76 val_76 2
-83 val_83 2
84 val_84 2
-95 val_95 2
-97 val_97 2
-409 val_409 3
-187 val_187 3
-403 val_403 3
+5 val_5 3
+431 val_431 3
396 val_396 3
384 val_384 3
+316 val_316 3
369 val_369 3
-498 val_498 3
-5 val_5 3
-35 val_35 3
-327 val_327 3
-167 val_167 3
318 val_318 3
-316 val_316 3
-311 val_311 3
-298 val_298 3
-70 val_70 3
-90 val_90 3
-128 val_128 3
273 val_273 3
+403 val_403 3
+438 val_438 3
+187 val_187 3
+327 val_327 3
208 val_208 3
+454 val_454 3
199 val_199 3
-193 val_193 3
-0 val_0 3
-119 val_119 3
-480 val_480 3
+90 val_90 3
466 val_466 3
-454 val_454 3
-438 val_438 3
-431 val_431 3
430 val_430 3
+480 val_480 3
+193 val_193 3
+70 val_70 3
+0 val_0 3
+298 val_298 3
+498 val_498 3
+311 val_311 3
+167 val_167 3
+128 val_128 3
417 val_417 3
+409 val_409 3
+119 val_119 3
+35 val_35 3
Warning: Shuffle Join MERGEJOIN[28][tables = [$hdt$_1, $hdt$_2]] in Stage 'Reducer 4' is a cross product
PREHOOK: query: explain select * from part where p_name IN (select p_name from part p where part.p_type <> '1')
PREHOOK: type: QUERY
http://git-wip-us.apache.org/repos/asf/hive/blob/10bd23eb/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
----------------------------------------------------------------------
diff --git a/ql/src/test/results/clientpositive/llap/subquery_notin.q.out b/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
index f28fcab..d89361d 100644
--- a/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
+++ b/ql/src/test/results/clientpositive/llap/subquery_notin.q.out
@@ -1329,22 +1329,22 @@ group by li.l_partkey
POSTHOOK: type: QUERY
POSTHOOK: Input: default@lineitem
#### A masked pattern was here ####
-450 1
-7068 1
-21636 1
22630 1
59694 1
-61931 1
-85951 1
-88035 1
-88362 1
106170 1
-119477 1
-119767 1
123076 1
139636 1
+450 1
+61931 1
+119767 1
175839 1
+7068 1
+88362 1
182052 1
+21636 1
+85951 1
+88035 1
+119477 1
Warning: Shuffle Join MERGEJOIN[30][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: select *
from src
@@ -4042,37 +4042,37 @@ POSTHOOK: query: select key, count(*) from src where value NOT IN (select key fr
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-409 3
-187 3
-403 3
-396 3
-384 3
+430 3
+128 3
369 3
-498 3
-5 3
-35 3
-327 3
-167 3
-318 3
316 3
+199 3
+454 3
+384 3
311 3
+208 3
298 3
-70 3
-90 3
-128 3
+187 3
273 3
-208 3
-199 3
+417 3
+396 3
+409 3
+403 3
+35 3
+90 3
+438 3
+327 3
+480 3
+466 3
+318 3
193 3
+498 3
+5 3
0 3
+167 3
119 3
-480 3
-466 3
-454 3
-438 3
431 3
-430 3
-417 3
+70 3
PREHOOK: query: explain select key, count(*) from src where value NOT IN (select concat('v', value) from src sc where sc.key = src.key ) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
PREHOOK: type: QUERY
POSTHOOK: query: explain select key, count(*) from src where value NOT IN (select concat('v', value) from src sc where sc.key = src.key ) group by key having count(*) in (select count(*) from src s1 where s1.key = '90' group by s1.key )
@@ -4354,37 +4354,37 @@ POSTHOOK: query: select key, count(*) from src where value NOT IN (select concat
POSTHOOK: type: QUERY
POSTHOOK: Input: default@src
#### A masked pattern was here ####
-409 3
-187 3
-403 3
-396 3
-384 3
+430 3
+128 3
369 3
-498 3
-5 3
-35 3
-327 3
-167 3
-318 3
316 3
+199 3
+454 3
+384 3
311 3
+208 3
298 3
-70 3
-90 3
-128 3
+187 3
273 3
-208 3
-199 3
+417 3
+396 3
+409 3
+403 3
+35 3
+90 3
+438 3
+327 3
+480 3
+466 3
+318 3
193 3
+498 3
+5 3
0 3
+167 3
119 3
-480 3
-466 3
-454 3
-438 3
431 3
-430 3
-417 3
+70 3
Warning: Shuffle Join MERGEJOIN[38][tables = [$hdt$_0, $hdt$_1]] in Stage 'Reducer 2' is a cross product
PREHOOK: query: explain select * from part where (p_size-1) NOT IN (select min(p_size) from part group by p_type) order by p_brand
PREHOOK: type: QUERY