http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out b/ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out index b4594b9..53fc0ac 100644 --- a/ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out +++ b/ql/src/test/results/clientpositive/llap/unionDistinct_1.q.out @@ -638,314 +638,314 @@ POSTHOOK: query: select unionsrc.key, unionsrc.value FROM (select s1.key as key, POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: hdfs://### HDFS PATH ### -0 val_0 -103 val_103 -105 val_105 116 val_116 +118 val_118 120 val_120 -129 val_129 131 val_131 -136 val_136 +133 val_133 +15 val_15 +150 val_150 +152 val_152 +153 val_153 155 val_155 -157 val_157 160 val_160 -180 val_180 +169 val_169 +175 val_175 +176 val_176 +178 val_178 183 val_183 -190 val_190 -191 val_191 -193 val_193 -205 val_205 -207 val_207 +186 val_186 +194 val_194 +202 val_202 +203 val_203 213 val_213 223 val_223 -235 val_235 -238 val_238 +224 val_224 +226 val_226 +228 val_228 239 val_239 -24 val_24 -248 val_248 -260 val_260 +244 val_244 +247 val_247 +252 val_252 +255 val_255 +256 val_256 +257 val_257 +266 val_266 +272 val_272 +274 val_274 +275 val_275 28 val_28 +284 val_284 286 val_286 -298 val_298 -305 val_305 +289 val_289 +296 val_296 +302 val_302 306 val_306 307 val_307 -308 val_308 -315 val_315 317 val_317 321 val_321 +323 val_323 33 val_33 -331 val_331 -356 val_356 +338 val_338 +34 val_34 +35 val_35 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 +365 val_365 +374 val_374 +377 val_377 +393 val_393 +399 val_399 +404 val_404 406 val_406 -407 val_407 +409 val_409 +41 val_41 +417 val_417 +418 val_418 42 val_42 -430 val_430 -436 val_436 +431 val_431 +439 val_439 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 +443 val_443 +448 val_448 +455 val_455 +459 val_459 +462 val_462 +463 val_463 +470 val_470 +490 val_490 +491 val_491 +494 val_494 +5 val_5 +53 val_53 66 val_66 -69 val_69 -70 val_70 -78 val_78 -8 val_8 -92 val_92 -96 val_96 -104 val_104 +72 val_72 +76 val_76 +77 val_77 +80 val_80 +84 val_84 +90 val_90 +10 val_10 +105 val_105 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 +113 val_113 +119 val_119 +129 val_129 +136 val_136 +143 val_143 +149 val_149 +163 val_163 +167 val_167 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 +200 val_200 208 val_208 -214 val_214 +209 val_209 +216 val_216 +217 val_217 218 val_218 -219 val_219 +221 val_221 230 val_230 -237 val_237 -249 val_249 -256 val_256 -257 val_257 +258 val_258 +26 val_26 +263 val_263 +273 val_273 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 +281 val_281 +292 val_292 +30 val_30 +316 val_316 +335 val_335 341 val_341 +342 val_342 344 val_344 -348 val_348 -351 val_351 +345 val_345 362 val_362 -364 val_364 -374 val_374 +367 val_367 +368 val_368 +37 val_37 392 val_392 -397 val_397 +394 val_394 4 val_4 -403 val_403 -404 val_404 -419 val_419 -421 val_421 -427 val_427 -429 val_429 +413 val_413 437 val_437 -438 val_438 -439 val_439 -454 val_454 -455 val_455 +444 val_444 +446 val_446 +452 val_452 +453 val_453 +457 val_457 460 val_460 -463 val_463 -470 val_470 -478 val_478 +466 val_466 +468 val_468 +477 val_477 479 val_479 -489 val_489 -491 val_491 +483 val_483 +487 val_487 492 val_492 -53 val_53 +493 val_493 +498 val_498 +51 val_51 +54 val_54 +64 val_64 +65 val_65 67 val_67 82 val_82 -90 val_90 -97 val_97 -10 val_10 -125 val_125 -134 val_134 -143 val_143 +85 val_85 +87 val_87 +95 val_95 +96 val_96 +100 val_100 +103 val_103 +104 val_104 +11 val_11 +114 val_114 +137 val_137 145 val_145 -149 val_149 -150 val_150 -158 val_158 -163 val_163 -164 val_164 -166 val_166 +156 val_156 +157 val_157 +162 val_162 +168 val_168 17 val_17 170 val_170 -172 val_172 -189 val_189 +180 val_180 19 val_19 -195 val_195 +190 val_190 +192 val_192 196 val_196 +199 val_199 20 val_20 -209 val_209 -216 val_216 -217 val_217 -224 val_224 -228 val_228 -229 val_229 +207 val_207 +214 val_214 +219 val_219 +222 val_222 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 +260 val_260 +27 val_27 +278 val_278 +280 val_280 +285 val_285 +288 val_288 +305 val_305 +311 val_311 318 val_318 -325 val_325 -332 val_332 -335 val_335 -339 val_339 -342 val_342 -345 val_345 -353 val_353 +322 val_322 +327 val_327 +331 val_331 +336 val_336 +348 val_348 +351 val_351 +366 val_366 369 val_369 -373 val_373 375 val_375 -377 val_377 +379 val_379 +382 val_382 384 val_384 -386 val_386 -394 val_394 +389 val_389 +395 val_395 396 val_396 -399 val_399 +397 val_397 +400 val_400 401 val_401 -41 val_41 -413 val_413 +407 val_407 414 val_414 -431 val_431 -446 val_446 -448 val_448 -449 val_449 -459 val_459 -462 val_462 -468 val_468 +421 val_421 +427 val_427 +430 val_430 +435 val_435 +438 val_438 +454 val_454 47 val_47 -482 val_482 -490 val_490 -493 val_493 -494 val_494 -497 val_497 -5 val_5 -54 val_54 +472 val_472 +478 val_478 +480 val_480 +481 val_481 +485 val_485 +489 val_489 +57 val_57 +69 val_69 74 val_74 -77 val_77 -80 val_80 -84 val_84 -85 val_85 -87 val_87 +78 val_78 +8 val_8 +86 val_86 9 val_9 -95 val_95 -100 val_100 -11 val_11 -113 val_113 -119 val_119 +0 val_0 +12 val_12 +125 val_125 126 val_126 128 val_128 -137 val_137 +134 val_134 +138 val_138 146 val_146 -15 val_15 -152 val_152 +158 val_158 +164 val_164 165 val_165 -167 val_167 -169 val_169 -175 val_175 +166 val_166 +172 val_172 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 +181 val_181 +189 val_189 +191 val_191 +193 val_193 +195 val_195 +201 val_201 +205 val_205 +229 val_229 +235 val_235 +237 val_237 +238 val_238 +24 val_24 242 val_242 -252 val_252 +248 val_248 +249 val_249 262 val_262 -27 val_27 -275 val_275 -280 val_280 +265 val_265 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 +291 val_291 +298 val_298 +308 val_308 +309 val_309 +310 val_310 +315 val_315 +325 val_325 +332 val_332 +333 val_333 +339 val_339 +353 val_353 +356 val_356 +364 val_364 +373 val_373 +378 val_378 +386 val_386 +402 val_402 +403 val_403 411 val_411 -417 val_417 -418 val_418 +419 val_419 424 val_424 +429 val_429 43 val_43 432 val_432 -435 val_435 -443 val_443 -444 val_444 -453 val_453 -457 val_457 +436 val_436 +449 val_449 458 val_458 +467 val_467 469 val_469 475 val_475 -477 val_477 -481 val_481 -483 val_483 -64 val_64 -72 val_72 -76 val_76 +482 val_482 +484 val_484 +495 val_495 +496 val_496 +497 val_497 +58 val_58 +70 val_70 83 val_83 -86 val_86 +92 val_92 +97 val_97 98 val_98 PREHOOK: query: CREATE TABLE DEST1(key STRING, value STRING) STORED AS TEXTFILE PREHOOK: type: CREATETABLE @@ -3813,6 +3813,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + bucketing_version 2 column.name.delimiter , columns k0,k1,k2,k3,k4,k5 columns.comments @@ -3890,6 +3891,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + bucketing_version 2 column.name.delimiter , columns k1,k2,k3,k4 columns.comments @@ -3967,6 +3969,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + bucketing_version 2 column.name.delimiter , columns k0,k1,k2,k3,k4,k5 columns.comments @@ -4007,6 +4010,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + bucketing_version 2 column.name.delimiter , columns k1,k2,k3,k4 columns.comments @@ -4132,6 +4136,7 @@ STAGE PLANS: output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat properties: bucket_count -1 + bucketing_version 2 column.name.delimiter , columns k1,k2,k3,k4 columns.comments @@ -4206,329 +4211,329 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@dst_union22 POSTHOOK: Input: default@dst_union22@ds=2 POSTHOOK: Output: hdfs://### HDFS PATH ### +100 val_100 100 val_100 2 103 val_103 103 val_103 2 -113 val_113 113 val_113 2 +104 val_104 104 val_104 2 +11 val_11 11 val_11 2 +114 val_114 114 val_114 2 +116 val_116 116 val_116 2 +118 val_118 118 val_118 2 120 val_120 120 val_120 2 -128 val_128 128 val_128 2 +131 val_131 131 val_131 2 +133 val_133 133 val_133 2 137 val_137 137 val_137 2 145 val_145 145 val_145 2 -146 val_146 146 val_146 2 15 val_15 15 val_15 2 +150 val_150 150 val_150 2 +152 val_152 152 val_152 2 +153 val_153 153 val_153 2 +155 val_155 155 val_155 2 156 val_156 156 val_156 2 -163 val_163 163 val_163 2 -165 val_165 165 val_165 2 -166 val_166 166 val_166 2 -167 val_167 167 val_167 2 +157 val_157 157 val_157 2 +160 val_160 160 val_160 2 +162 val_162 162 val_162 2 +168 val_168 168 val_168 2 +169 val_169 169 val_169 2 +17 val_17 17 val_17 2 170 val_170 170 val_170 2 -174 val_174 174 val_174 2 +175 val_175 175 val_175 2 +176 val_176 176 val_176 2 178 val_178 178 val_178 2 +180 val_180 180 val_180 2 183 val_183 183 val_183 2 -191 val_191 191 val_191 2 -195 val_195 195 val_195 2 +186 val_186 186 val_186 2 +19 val_19 19 val_19 2 +190 val_190 190 val_190 2 +192 val_192 192 val_192 2 +194 val_194 194 val_194 2 +196 val_196 196 val_196 2 199 val_199 199 val_199 2 -2 val_2 2 val_2 2 +20 val_20 20 val_20 2 +202 val_202 202 val_202 2 203 val_203 203 val_203 2 -217 val_217 217 val_217 2 +207 val_207 207 val_207 2 +213 val_213 213 val_213 2 +214 val_214 214 val_214 2 +219 val_219 219 val_219 2 +222 val_222 222 val_222 2 +223 val_223 223 val_223 2 224 val_224 224 val_224 2 -229 val_229 229 val_229 2 -242 val_242 242 val_242 2 -27 val_27 NULL NULL 2 -272 val_272 272 val_272 2 -28 val_28 NULL NULL 2 -280 val_280 280 val_280 2 -282 val_282 282 val_282 2 -283 val_283 283 val_283 2 -287 val_287 287 val_287 2 -289 val_289 289 val_289 2 -292 val_292 292 val_292 2 -306 val_306 306 val_306 2 -307 val_307 307 val_307 2 -309 val_309 309 val_309 2 -310 val_310 310 val_310 2 -315 val_315 315 val_315 2 -327 val_327 327 val_327 2 -33 val_33 33 val_33 2 -331 val_331 331 val_331 2 -332 val_332 332 val_332 2 -333 val_333 333 val_333 2 -338 val_338 338 val_338 2 -344 val_344 344 val_344 2 -348 val_348 348 val_348 2 -35 val_35 35 val_35 2 -353 val_353 353 val_353 2 -362 val_362 362 val_362 2 -37 val_37 37 val_37 2 -373 val_373 373 val_373 2 -379 val_379 379 val_379 2 -4 val_4 4 val_4 2 -400 val_400 400 val_400 2 -401 val_401 401 val_401 2 -403 val_403 403 val_403 2 -406 val_406 406 val_406 2 -41 val_41 41 val_41 2 -414 val_414 414 val_414 2 -417 val_417 417 val_417 2 -431 val_431 431 val_431 2 -432 val_432 432 val_432 2 -436 val_436 436 val_436 2 -439 val_439 439 val_439 2 -452 val_452 452 val_452 2 -453 val_453 453 val_453 2 -455 val_455 455 val_455 2 -466 val_466 466 val_466 2 -469 val_469 469 val_469 2 -47 val_47 NULL NULL 2 -470 val_470 470 val_470 2 -475 val_475 475 val_475 2 -477 val_477 477 val_477 2 -493 val_493 493 val_493 2 -496 val_496 496 val_496 2 -54 val_54 54 val_54 2 -57 val_57 57 val_57 2 -65 val_65 65 val_65 2 -69 val_69 69 val_69 2 -77 val_77 77 val_77 2 -78 val_78 78 val_78 2 -8 val_8 8 val_8 2 -82 val_82 82 val_82 2 -87 val_87 87 val_87 2 -9 val_9 9 val_9 2 -92 val_92 92 val_92 2 -10 val_10 10 val_10 2 -11 val_11 11 val_11 2 -111 val_111 111 val_111 2 -114 val_114 114 val_114 2 -116 val_116 116 val_116 2 -12 val_12 12 val_12 2 -129 val_129 129 val_129 2 -136 val_136 136 val_136 2 -152 val_152 152 val_152 2 -155 val_155 155 val_155 2 -158 val_158 158 val_158 2 -168 val_168 168 val_168 2 -176 val_176 176 val_176 2 -177 val_177 177 val_177 2 -179 val_179 179 val_179 2 -18 val_18 18 val_18 2 -186 val_186 186 val_186 2 -194 val_194 194 val_194 2 -208 val_208 208 val_208 2 -214 val_214 214 val_214 2 -222 val_222 222 val_222 2 226 val_226 226 val_226 2 -230 val_230 230 val_230 2 -237 val_237 237 val_237 2 -24 val_24 NULL NULL 2 -24 val_24 24 val_24 2 -248 val_248 248 val_248 2 +228 val_228 228 val_228 2 +233 val_233 233 val_233 2 +239 val_239 239 val_239 2 +241 val_241 241 val_241 2 +244 val_244 244 val_244 2 +247 val_247 247 val_247 2 +252 val_252 252 val_252 2 255 val_255 255 val_255 2 256 val_256 256 val_256 2 -26 val_26 26 val_26 2 -265 val_265 265 val_265 2 +257 val_257 257 val_257 2 +260 val_260 260 val_260 2 266 val_266 266 val_266 2 -273 val_273 273 val_273 2 +27 val_27 27 val_27 2 +272 val_272 272 val_272 2 +274 val_274 274 val_274 2 275 val_275 275 val_275 2 +278 val_278 278 val_278 2 +28 val_28 NULL NULL 2 28 val_28 28 val_28 2 +280 val_280 280 val_280 2 284 val_284 284 val_284 2 -291 val_291 291 val_291 2 -298 val_298 298 val_298 2 -30 val_30 NULL NULL 2 -30 val_30 30 val_30 2 -308 val_308 308 val_308 2 +285 val_285 285 val_285 2 +286 val_286 286 val_286 2 +288 val_288 288 val_288 2 +289 val_289 289 val_289 2 +296 val_296 296 val_296 2 +302 val_302 302 val_302 2 +305 val_305 305 val_305 2 +306 val_306 306 val_306 2 +307 val_307 307 val_307 2 +311 val_311 311 val_311 2 +317 val_317 317 val_317 2 +318 val_318 318 val_318 2 321 val_321 321 val_321 2 322 val_322 322 val_322 2 -335 val_335 335 val_335 2 +323 val_323 323 val_323 2 +327 val_327 327 val_327 2 +33 val_33 NULL NULL 2 +33 val_33 33 val_33 2 +331 val_331 331 val_331 2 336 val_336 336 val_336 2 +338 val_338 338 val_338 2 +34 val_34 NULL NULL 2 34 val_34 34 val_34 2 -341 val_341 341 val_341 2 -342 val_342 342 val_342 2 +348 val_348 348 val_348 2 +35 val_35 NULL NULL 2 +35 val_35 35 val_35 2 +351 val_351 351 val_351 2 +360 val_360 360 val_360 2 +365 val_365 365 val_365 2 +366 val_366 366 val_366 2 369 val_369 369 val_369 2 374 val_374 374 val_374 2 +375 val_375 375 val_375 2 377 val_377 377 val_377 2 +379 val_379 379 val_379 2 382 val_382 382 val_382 2 -386 val_386 386 val_386 2 +384 val_384 384 val_384 2 +389 val_389 389 val_389 2 393 val_393 393 val_393 2 +395 val_395 395 val_395 2 +396 val_396 396 val_396 2 397 val_397 397 val_397 2 -402 val_402 402 val_402 2 +399 val_399 399 val_399 2 +400 val_400 400 val_400 2 +401 val_401 401 val_401 2 404 val_404 404 val_404 2 +406 val_406 406 val_406 2 407 val_407 407 val_407 2 +409 val_409 409 val_409 2 +41 val_41 NULL NULL 2 +41 val_41 41 val_41 2 +414 val_414 414 val_414 2 +417 val_417 417 val_417 2 418 val_418 418 val_418 2 -446 val_446 446 val_446 2 +42 val_42 NULL NULL 2 +42 val_42 42 val_42 2 +421 val_421 421 val_421 2 +427 val_427 427 val_427 2 +430 val_430 430 val_430 2 +431 val_431 431 val_431 2 +435 val_435 435 val_435 2 +438 val_438 438 val_438 2 +439 val_439 439 val_439 2 +44 val_44 NULL NULL 2 +44 val_44 44 val_44 2 +443 val_443 443 val_443 2 448 val_448 448 val_448 2 -457 val_457 457 val_457 2 +454 val_454 454 val_454 2 +455 val_455 455 val_455 2 459 val_459 459 val_459 2 462 val_462 462 val_462 2 463 val_463 463 val_463 2 +47 val_47 47 val_47 2 +470 val_470 470 val_470 2 472 val_472 472 val_472 2 478 val_478 478 val_478 2 -479 val_479 479 val_479 2 480 val_480 480 val_480 2 -483 val_483 483 val_483 2 +481 val_481 481 val_481 2 485 val_485 485 val_485 2 +489 val_489 489 val_489 2 +490 val_490 490 val_490 2 491 val_491 491 val_491 2 +494 val_494 494 val_494 2 5 val_5 5 val_5 2 53 val_53 53 val_53 2 -67 val_67 67 val_67 2 +57 val_57 57 val_57 2 +66 val_66 66 val_66 2 +69 val_69 69 val_69 2 +72 val_72 72 val_72 2 +74 val_74 74 val_74 2 76 val_76 76 val_76 2 -83 val_83 83 val_83 2 +77 val_77 77 val_77 2 +78 val_78 78 val_78 2 +8 val_8 8 val_8 2 +80 val_80 80 val_80 2 +84 val_84 84 val_84 2 86 val_86 86 val_86 2 -95 val_95 95 val_95 2 -96 val_96 96 val_96 2 -98 val_98 98 val_98 2 -100 val_100 100 val_100 2 +9 val_9 9 val_9 2 +90 val_90 90 val_90 2 +26 val_26 NULL NULL 2 +30 val_30 NULL NULL 2 +37 val_37 NULL NULL 2 +0 val_0 0 val_0 2 +10 val_10 10 val_10 2 +105 val_105 105 val_105 2 +111 val_111 111 val_111 2 +113 val_113 113 val_113 2 +119 val_119 119 val_119 2 +12 val_12 12 val_12 2 125 val_125 125 val_125 2 126 val_126 126 val_126 2 +128 val_128 128 val_128 2 +129 val_129 129 val_129 2 134 val_134 134 val_134 2 +136 val_136 136 val_136 2 138 val_138 138 val_138 2 143 val_143 143 val_143 2 +146 val_146 146 val_146 2 149 val_149 149 val_149 2 -150 val_150 150 val_150 2 -157 val_157 157 val_157 2 +158 val_158 158 val_158 2 +163 val_163 163 val_163 2 164 val_164 164 val_164 2 -169 val_169 169 val_169 2 -17 val_17 17 val_17 2 +165 val_165 165 val_165 2 +166 val_166 166 val_166 2 +167 val_167 167 val_167 2 172 val_172 172 val_172 2 +174 val_174 174 val_174 2 +177 val_177 177 val_177 2 +179 val_179 179 val_179 2 +18 val_18 18 val_18 2 181 val_181 181 val_181 2 187 val_187 187 val_187 2 189 val_189 189 val_189 2 -190 val_190 190 val_190 2 -192 val_192 192 val_192 2 +191 val_191 191 val_191 2 +193 val_193 193 val_193 2 +195 val_195 195 val_195 2 197 val_197 197 val_197 2 +2 val_2 2 val_2 2 +200 val_200 200 val_200 2 201 val_201 201 val_201 2 -202 val_202 202 val_202 2 205 val_205 205 val_205 2 -207 val_207 207 val_207 2 +208 val_208 208 val_208 2 209 val_209 209 val_209 2 216 val_216 216 val_216 2 +217 val_217 217 val_217 2 218 val_218 218 val_218 2 -223 val_223 223 val_223 2 -228 val_228 228 val_228 2 -233 val_233 233 val_233 2 +221 val_221 221 val_221 2 +229 val_229 229 val_229 2 +230 val_230 230 val_230 2 235 val_235 235 val_235 2 +237 val_237 237 val_237 2 238 val_238 238 val_238 2 -241 val_241 241 val_241 2 -244 val_244 244 val_244 2 -247 val_247 247 val_247 2 -252 val_252 252 val_252 2 +24 val_24 24 val_24 2 +242 val_242 242 val_242 2 +248 val_248 248 val_248 2 +249 val_249 249 val_249 2 258 val_258 258 val_258 2 -260 val_260 260 val_260 2 +26 val_26 26 val_26 2 262 val_262 262 val_262 2 -27 val_27 27 val_27 2 -274 val_274 274 val_274 2 +263 val_263 263 val_263 2 +265 val_265 265 val_265 2 +27 val_27 NULL NULL 2 +273 val_273 273 val_273 2 277 val_277 277 val_277 2 -278 val_278 278 val_278 2 -288 val_288 288 val_288 2 -296 val_296 296 val_296 2 -302 val_302 302 val_302 2 -305 val_305 305 val_305 2 -311 val_311 311 val_311 2 -318 val_318 318 val_318 2 +281 val_281 281 val_281 2 +282 val_282 282 val_282 2 +283 val_283 283 val_283 2 +287 val_287 287 val_287 2 +291 val_291 291 val_291 2 +292 val_292 292 val_292 2 +298 val_298 298 val_298 2 +30 val_30 30 val_30 2 +308 val_308 308 val_308 2 +309 val_309 309 val_309 2 +310 val_310 310 val_310 2 +315 val_315 315 val_315 2 +316 val_316 316 val_316 2 +325 val_325 325 val_325 2 +332 val_332 332 val_332 2 +333 val_333 333 val_333 2 +335 val_335 335 val_335 2 +339 val_339 339 val_339 2 +341 val_341 341 val_341 2 +342 val_342 342 val_342 2 +344 val_344 344 val_344 2 345 val_345 345 val_345 2 -35 val_35 NULL NULL 2 +353 val_353 353 val_353 2 356 val_356 356 val_356 2 -360 val_360 360 val_360 2 -365 val_365 365 val_365 2 -375 val_375 375 val_375 2 -389 val_389 389 val_389 2 +362 val_362 362 val_362 2 +364 val_364 364 val_364 2 +367 val_367 367 val_367 2 +368 val_368 368 val_368 2 +37 val_37 37 val_37 2 +373 val_373 373 val_373 2 +378 val_378 378 val_378 2 +386 val_386 386 val_386 2 392 val_392 392 val_392 2 394 val_394 394 val_394 2 -395 val_395 395 val_395 2 -409 val_409 409 val_409 2 -41 val_41 NULL NULL 2 +4 val_4 4 val_4 2 +402 val_402 402 val_402 2 +403 val_403 403 val_403 2 411 val_411 411 val_411 2 413 val_413 413 val_413 2 419 val_419 419 val_419 2 -42 val_42 42 val_42 2 -427 val_427 427 val_427 2 +424 val_424 424 val_424 2 429 val_429 429 val_429 2 -430 val_430 430 val_430 2 -44 val_44 NULL NULL 2 +43 val_43 43 val_43 2 +432 val_432 432 val_432 2 +436 val_436 436 val_436 2 +437 val_437 437 val_437 2 444 val_444 444 val_444 2 -454 val_454 454 val_454 2 +446 val_446 446 val_446 2 +449 val_449 449 val_449 2 +452 val_452 452 val_452 2 +453 val_453 453 val_453 2 +457 val_457 457 val_457 2 +458 val_458 458 val_458 2 460 val_460 460 val_460 2 +466 val_466 466 val_466 2 +467 val_467 467 val_467 2 468 val_468 468 val_468 2 -47 val_47 47 val_47 2 -481 val_481 481 val_481 2 +469 val_469 469 val_469 2 +47 val_47 NULL NULL 2 +475 val_475 475 val_475 2 +477 val_477 477 val_477 2 +479 val_479 479 val_479 2 482 val_482 482 val_482 2 +483 val_483 483 val_483 2 484 val_484 484 val_484 2 -489 val_489 489 val_489 2 +487 val_487 487 val_487 2 492 val_492 492 val_492 2 +493 val_493 493 val_493 2 495 val_495 495 val_495 2 +496 val_496 496 val_496 2 +497 val_497 497 val_497 2 498 val_498 498 val_498 2 +51 val_51 51 val_51 2 +54 val_54 54 val_54 2 58 val_58 58 val_58 2 64 val_64 64 val_64 2 -66 val_66 66 val_66 2 +65 val_65 65 val_65 2 +67 val_67 67 val_67 2 70 val_70 70 val_70 2 -72 val_72 72 val_72 2 -74 val_74 74 val_74 2 -80 val_80 80 val_80 2 -84 val_84 84 val_84 2 -90 val_90 90 val_90 2 -0 val_0 0 val_0 2 -104 val_104 104 val_104 2 -105 val_105 105 val_105 2 -118 val_118 118 val_118 2 -119 val_119 119 val_119 2 -131 val_131 131 val_131 2 -133 val_133 133 val_133 2 -153 val_153 153 val_153 2 -160 val_160 160 val_160 2 -162 val_162 162 val_162 2 -175 val_175 175 val_175 2 -180 val_180 180 val_180 2 -19 val_19 19 val_19 2 -193 val_193 193 val_193 2 -196 val_196 196 val_196 2 -20 val_20 20 val_20 2 -200 val_200 200 val_200 2 -213 val_213 213 val_213 2 -219 val_219 219 val_219 2 -221 val_221 221 val_221 2 -239 val_239 239 val_239 2 -249 val_249 249 val_249 2 -257 val_257 257 val_257 2 -26 val_26 NULL NULL 2 -263 val_263 263 val_263 2 -281 val_281 281 val_281 2 -285 val_285 285 val_285 2 -286 val_286 286 val_286 2 -316 val_316 316 val_316 2 -317 val_317 317 val_317 2 -323 val_323 323 val_323 2 -325 val_325 325 val_325 2 -33 val_33 NULL NULL 2 -339 val_339 339 val_339 2 -34 val_34 NULL NULL 2 -351 val_351 351 val_351 2 -364 val_364 364 val_364 2 -366 val_366 366 val_366 2 -367 val_367 367 val_367 2 -368 val_368 368 val_368 2 -37 val_37 NULL NULL 2 -378 val_378 378 val_378 2 -384 val_384 384 val_384 2 -396 val_396 396 val_396 2 -399 val_399 399 val_399 2 -42 val_42 NULL NULL 2 -421 val_421 421 val_421 2 -424 val_424 424 val_424 2 -43 val_43 NULL NULL 2 -43 val_43 43 val_43 2 -435 val_435 435 val_435 2 -437 val_437 437 val_437 2 -438 val_438 438 val_438 2 -44 val_44 44 val_44 2 -443 val_443 443 val_443 2 -449 val_449 449 val_449 2 -458 val_458 458 val_458 2 -467 val_467 467 val_467 2 -487 val_487 487 val_487 2 -490 val_490 490 val_490 2 -494 val_494 494 val_494 2 -497 val_497 497 val_497 2 -51 val_51 51 val_51 2 +82 val_82 82 val_82 2 +83 val_83 83 val_83 2 85 val_85 85 val_85 2 +87 val_87 87 val_87 2 +92 val_92 92 val_92 2 +95 val_95 95 val_95 2 +96 val_96 96 val_96 2 97 val_97 97 val_97 2 +98 val_98 98 val_98 2 +24 val_24 NULL NULL 2 +43 val_43 NULL NULL 2 PREHOOK: query: explain select s.key2, s.value2 from ( @@ -4646,314 +4651,314 @@ from ( POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: hdfs://### HDFS PATH ### -0 val_0 -103 val_103 -105 val_105 116 val_116 +118 val_118 120 val_120 -129 val_129 131 val_131 -136 val_136 +133 val_133 +15 val_15 +150 val_150 +152 val_152 +153 val_153 155 val_155 -157 val_157 160 val_160 -180 val_180 +169 val_169 +175 val_175 +176 val_176 +178 val_178 183 val_183 -190 val_190 -191 val_191 -193 val_193 -205 val_205 -207 val_207 +186 val_186 +194 val_194 +202 val_202 +203 val_203 213 val_213 223 val_223 -235 val_235 -238 val_238 +224 val_224 +226 val_226 +228 val_228 239 val_239 -24 val_24 -248 val_248 -260 val_260 +244 val_244 +247 val_247 +252 val_252 +255 val_255 +256 val_256 +257 val_257 +266 val_266 +272 val_272 +274 val_274 +275 val_275 28 val_28 +284 val_284 286 val_286 -298 val_298 -305 val_305 +289 val_289 +296 val_296 +302 val_302 306 val_306 307 val_307 -308 val_308 -315 val_315 317 val_317 321 val_321 +323 val_323 33 val_33 -331 val_331 -356 val_356 +338 val_338 +34 val_34 +35 val_35 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 +365 val_365 +374 val_374 +377 val_377 +393 val_393 +399 val_399 +404 val_404 406 val_406 -407 val_407 +409 val_409 +41 val_41 +417 val_417 +418 val_418 42 val_42 -430 val_430 -436 val_436 +431 val_431 +439 val_439 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 +443 val_443 +448 val_448 +455 val_455 +459 val_459 +462 val_462 +463 val_463 +470 val_470 +490 val_490 +491 val_491 +494 val_494 +5 val_5 +53 val_53 66 val_66 -69 val_69 -70 val_70 -78 val_78 -8 val_8 -92 val_92 -96 val_96 -104 val_104 +72 val_72 +76 val_76 +77 val_77 +80 val_80 +84 val_84 +90 val_90 +10 val_10 +105 val_105 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 +113 val_113 +119 val_119 +129 val_129 +136 val_136 +143 val_143 +149 val_149 +163 val_163 +167 val_167 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 +200 val_200 208 val_208 -214 val_214 +209 val_209 +216 val_216 +217 val_217 218 val_218 -219 val_219 +221 val_221 230 val_230 -237 val_237 -249 val_249 -256 val_256 -257 val_257 +258 val_258 +26 val_26 +263 val_263 +273 val_273 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 +281 val_281 +292 val_292 +30 val_30 +316 val_316 +335 val_335 341 val_341 +342 val_342 344 val_344 -348 val_348 -351 val_351 +345 val_345 362 val_362 -364 val_364 -374 val_374 +367 val_367 +368 val_368 +37 val_37 392 val_392 -397 val_397 +394 val_394 4 val_4 -403 val_403 -404 val_404 -419 val_419 -421 val_421 -427 val_427 -429 val_429 +413 val_413 437 val_437 -438 val_438 -439 val_439 -454 val_454 -455 val_455 +444 val_444 +446 val_446 +452 val_452 +453 val_453 +457 val_457 460 val_460 -463 val_463 -470 val_470 -478 val_478 +466 val_466 +468 val_468 +477 val_477 479 val_479 -489 val_489 -491 val_491 +483 val_483 +487 val_487 492 val_492 -53 val_53 +493 val_493 +498 val_498 +51 val_51 +54 val_54 +64 val_64 +65 val_65 67 val_67 82 val_82 -90 val_90 -97 val_97 -10 val_10 -125 val_125 -134 val_134 -143 val_143 +85 val_85 +87 val_87 +95 val_95 +96 val_96 +100 val_100 +103 val_103 +104 val_104 +11 val_11 +114 val_114 +137 val_137 145 val_145 -149 val_149 -150 val_150 -158 val_158 -163 val_163 -164 val_164 -166 val_166 +156 val_156 +157 val_157 +162 val_162 +168 val_168 17 val_17 170 val_170 -172 val_172 -189 val_189 +180 val_180 19 val_19 -195 val_195 +190 val_190 +192 val_192 196 val_196 +199 val_199 20 val_20 -209 val_209 -216 val_216 -217 val_217 -224 val_224 -228 val_228 -229 val_229 +207 val_207 +214 val_214 +219 val_219 +222 val_222 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 +260 val_260 +27 val_27 +278 val_278 +280 val_280 +285 val_285 +288 val_288 +305 val_305 +311 val_311 318 val_318 -325 val_325 -332 val_332 -335 val_335 -339 val_339 -342 val_342 -345 val_345 -353 val_353 +322 val_322 +327 val_327 +331 val_331 +336 val_336 +348 val_348 +351 val_351 +366 val_366 369 val_369 -373 val_373 375 val_375 -377 val_377 +379 val_379 +382 val_382 384 val_384 -386 val_386 -394 val_394 +389 val_389 +395 val_395 396 val_396 -399 val_399 +397 val_397 +400 val_400 401 val_401 -41 val_41 -413 val_413 +407 val_407 414 val_414 -431 val_431 -446 val_446 -448 val_448 -449 val_449 -459 val_459 -462 val_462 -468 val_468 +421 val_421 +427 val_427 +430 val_430 +435 val_435 +438 val_438 +454 val_454 47 val_47 -482 val_482 -490 val_490 -493 val_493 -494 val_494 -497 val_497 -5 val_5 -54 val_54 +472 val_472 +478 val_478 +480 val_480 +481 val_481 +485 val_485 +489 val_489 +57 val_57 +69 val_69 74 val_74 -77 val_77 -80 val_80 -84 val_84 -85 val_85 -87 val_87 +78 val_78 +8 val_8 +86 val_86 9 val_9 -95 val_95 -100 val_100 -11 val_11 -113 val_113 -119 val_119 +0 val_0 +12 val_12 +125 val_125 126 val_126 128 val_128 -137 val_137 +134 val_134 +138 val_138 146 val_146 -15 val_15 -152 val_152 +158 val_158 +164 val_164 165 val_165 -167 val_167 -169 val_169 -175 val_175 +166 val_166 +172 val_172 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 +181 val_181 +189 val_189 +191 val_191 +193 val_193 +195 val_195 +201 val_201 +205 val_205 +229 val_229 +235 val_235 +237 val_237 +238 val_238 +24 val_24 242 val_242 -252 val_252 +248 val_248 +249 val_249 262 val_262 -27 val_27 -275 val_275 -280 val_280 +265 val_265 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 +291 val_291 +298 val_298 +308 val_308 +309 val_309 +310 val_310 +315 val_315 +325 val_325 +332 val_332 +333 val_333 +339 val_339 +353 val_353 +356 val_356 +364 val_364 +373 val_373 +378 val_378 +386 val_386 +402 val_402 +403 val_403 411 val_411 -417 val_417 -418 val_418 +419 val_419 424 val_424 +429 val_429 43 val_43 432 val_432 -435 val_435 -443 val_443 -444 val_444 -453 val_453 -457 val_457 +436 val_436 +449 val_449 458 val_458 +467 val_467 469 val_469 475 val_475 -477 val_477 -481 val_481 -483 val_483 -64 val_64 -72 val_72 -76 val_76 +482 val_482 +484 val_484 +495 val_495 +496 val_496 +497 val_497 +58 val_58 +70 val_70 83 val_83 -86 val_86 +92 val_92 +97 val_97 98 val_98 PREHOOK: query: create table src2 as select key, count(1) as count from src group by key PREHOOK: type: CREATETABLE_AS_SELECT @@ -5081,6 +5086,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5103,6 +5109,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5159,6 +5166,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5181,6 +5189,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5239,6 +5248,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5261,6 +5271,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5319,6 +5330,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5341,6 +5353,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5578,6 +5591,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5600,6 +5614,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5658,6 +5673,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5680,6 +5696,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5733,6 +5750,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5755,6 +5773,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5809,6 +5828,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -5831,6 +5851,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6047,6 +6068,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6069,6 +6091,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6122,6 +6145,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6144,6 +6168,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6202,6 +6227,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6224,6 +6250,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6277,6 +6304,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -6299,6 +6327,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true"} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,count columns.comments @@ -7276,314 +7305,314 @@ POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 POSTHOOK: Output: hdfs://### HDFS PATH ### -1 0 val_0 -1 103 val_103 -1 105 val_105 1 116 val_116 +1 118 val_118 1 120 val_120 -1 129 val_129 1 131 val_131 -1 136 val_136 +1 133 val_133 +1 15 val_15 +1 150 val_150 +1 152 val_152 +1 153 val_153 1 155 val_155 -1 157 val_157 1 160 val_160 -1 180 val_180 +1 169 val_169 +1 175 val_175 +1 176 val_176 +1 178 val_178 1 183 val_183 -1 190 val_190 -1 191 val_191 -1 193 val_193 -1 205 val_205 -1 207 val_207 +1 186 val_186 +1 194 val_194 +1 202 val_202 +1 203 val_203 1 213 val_213 1 223 val_223 -1 235 val_235 -1 238 val_238 +1 224 val_224 +1 226 val_226 +1 228 val_228 1 239 val_239 -1 24 val_24 -1 248 val_248 -1 260 val_260 +1 244 val_244 +1 247 val_247 +1 252 val_252 +1 255 val_255 +1 256 val_256 +1 257 val_257 +1 266 val_266 +1 272 val_272 +1 274 val_274 +1 275 val_275 1 28 val_28 +1 284 val_284 1 286 val_286 -1 298 val_298 -1 305 val_305 +1 289 val_289 +1 296 val_296 +1 302 val_302 1 306 val_306 1 307 val_307 -1 308 val_308 -1 315 val_315 1 317 val_317 1 321 val_321 +1 323 val_323 1 33 val_33 -1 331 val_331 -1 356 val_356 +1 338 val_338 +1 34 val_34 +1 35 val_35 1 360 val_360 -1 366 val_366 -1 367 val_367 -1 368 val_368 -1 37 val_37 -1 378 val_378 -1 379 val_379 -1 382 val_382 -1 389 val_389 -1 395 val_395 -1 400 val_400 -1 402 val_402 +1 365 val_365 +1 374 val_374 +1 377 val_377 +1 393 val_393 +1 399 val_399 +1 404 val_404 1 406 val_406 -1 407 val_407 +1 409 val_409 +1 41 val_41 +1 417 val_417 +1 418 val_418 1 42 val_42 -1 430 val_430 -1 436 val_436 +1 431 val_431 +1 439 val_439 1 44 val_44 +1 443 val_443 +1 448 val_448 +1 455 val_455 +1 459 val_459 +1 462 val_462 +1 463 val_463 +1 470 val_470 +1 490 val_490 +1 491 val_491 +1 494 val_494 +1 5 val_5 +1 53 val_53 +1 66 val_66 +1 72 val_72 +1 76 val_76 +1 77 val_77 +1 80 val_80 +1 84 val_84 +1 90 val_90 +1 10 val_10 +1 105 val_105 +1 111 val_111 +1 113 val_113 +1 119 val_119 +1 129 val_129 +1 136 val_136 +1 143 val_143 +1 149 val_149 +1 163 val_163 +1 167 val_167 +1 174 val_174 +1 187 val_187 +1 197 val_197 +1 2 val_2 +1 200 val_200 +1 208 val_208 +1 209 val_209 +1 216 val_216 +1 217 val_217 +1 218 val_218 +1 221 val_221 +1 230 val_230 +1 258 val_258 +1 26 val_26 +1 263 val_263 +1 273 val_273 +1 277 val_277 +1 281 val_281 +1 292 val_292 +1 30 val_30 +1 316 val_316 +1 335 val_335 +1 341 val_341 +1 342 val_342 +1 344 val_344 +1 345 val_345 +1 362 val_362 +1 367 val_367 +1 368 val_368 +1 37 val_37 +1 392 val_392 +1 394 val_394 +1 4 val_4 +1 413 val_413 +1 437 val_437 +1 444 val_444 +1 446 val_446 1 452 val_452 +1 453 val_453 +1 457 val_457 +1 460 val_460 1 466 val_466 -1 467 val_467 -1 472 val_472 -1 480 val_480 -1 484 val_484 -1 485 val_485 +1 468 val_468 +1 477 val_477 +1 479 val_479 +1 483 val_483 1 487 val_487 -1 495 val_495 -1 496 val_496 +1 492 val_492 +1 493 val_493 1 498 val_498 1 51 val_51 -1 57 val_57 -1 58 val_58 +1 54 val_54 +1 64 val_64 1 65 val_65 -1 66 val_66 -1 69 val_69 -1 70 val_70 -1 78 val_78 -1 8 val_8 -1 92 val_92 +1 67 val_67 +1 82 val_82 +1 85 val_85 +1 87 val_87 +1 95 val_95 1 96 val_96 +1 100 val_100 +1 103 val_103 1 104 val_104 -1 111 val_111 +1 11 val_11 1 114 val_114 -1 118 val_118 -1 12 val_12 -1 133 val_133 -1 138 val_138 -1 153 val_153 +1 137 val_137 +1 145 val_145 1 156 val_156 +1 157 val_157 1 162 val_162 1 168 val_168 -1 174 val_174 -1 176 val_176 -1 178 val_178 -1 181 val_181 -1 186 val_186 -1 187 val_187 +1 17 val_17 +1 170 val_170 +1 180 val_180 +1 19 val_19 +1 190 val_190 1 192 val_192 -1 197 val_197 +1 196 val_196 1 199 val_199 -1 2 val_2 -1 201 val_201 -1 203 val_203 -1 208 val_208 +1 20 val_20 +1 207 val_207 1 214 val_214 -1 218 val_218 1 219 val_219 -1 230 val_230 -1 237 val_237 -1 249 val_249 -1 256 val_256 -1 257 val_257 -1 277 val_277 +1 222 val_222 +1 233 val_233 +1 241 val_241 +1 260 val_260 +1 27 val_27 1 278 val_278 -1 284 val_284 +1 280 val_280 1 285 val_285 -1 310 val_310 +1 288 val_288 +1 305 val_305 +1 311 val_311 +1 318 val_318 1 322 val_322 1 327 val_327 -1 333 val_333 +1 331 val_331 1 336 val_336 -1 338 val_338 -1 341 val_341 -1 344 val_344 1 348 val_348 1 351 val_351 -1 362 val_362 -1 364 val_364 -1 374 val_374 -1 392 val_392 +1 366 val_366 +1 369 val_369 +1 375 val_375 +1 379 val_379 +1 382 val_382 +1 384 val_384 +1 389 val_389 +1 395 val_395 +1 396 val_396 1 397 val_397 -1 4 val_4 -1 403 val_403 -1 404 val_404 -1 419 val_419 +1 400 val_400 +1 401 val_401 +1 407 val_407 +1 414 val_414 1 421 val_421 1 427 val_427 -1 429 val_429 -1 437 val_437 +1 430 val_430 +1 435 val_435 1 438 val_438 -1 439 val_439 1 454 val_454 -1 455 val_455 -1 460 val_460 -1 463 val_463 -1 470 val_470 +1 47 val_47 +1 472 val_472 1 478 val_478 -1 479 val_479 +1 480 val_480 +1 481 val_481 +1 485 val_485 1 489 val_489 -1 491 val_491 -1 492 val_492 -1 53 val_53 -1 67 val_67 -1 82 val_82 -1 90 val_90 -1 97 val_97 -1 10 val_10 +1 57 val_57 +1 69 val_69 +1 74 val_74 +1 78 val_78 +1 8 val_8 +1 86 val_86 +1 9 val_9 +1 0 val_0 +1 12 val_12 1 125 val_125 +1 126 val_126 +1 128 val_128 1 134 val_134 -1 143 val_143 -1 145 val_145 -1 149 val_149 -1 150 val_150 +1 138 val_138 +1 146 val_146 1 158 val_158 -1 163 val_163 1 164 val_164 +1 165 val_165 1 166 val_166 -1 17 val_17 -1 170 val_170 1 172 val_172 +1 177 val_177 +1 179 val_179 +1 18 val_18 +1 181 val_181 1 189 val_189 -1 19 val_19 +1 191 val_191 +1 193 val_193 1 195 val_195 -1 196 val_196 -1 20 val_20 -1 209 val_209 -1 216 val_216 -1 217 val_217 -1 224 val_224 -1 228 val_228 +1 201 val_201 +1 205 val_205 1 229 val_229 -1 233 val_233 -1 241 val_241 -1 244 val_244 -1 247 val_247 -1 255 val_255 -1 258 val_258 -1 26 val_26 -1 263 val_263 +1 235 val_235 +1 237 val_237 +1 238 val_238 +1 24 val_24 +1 242 val_242 +1 248 val_248 +1 249 val_249 +1 262 val_262 1 265 val_265 -1 266 val_266 -1 272 val_272 -1 273 val_273 -1 274 val_274 -1 281 val_281 +1 282 val_282 +1 283 val_283 +1 287 val_287 1 291 val_291 -1 296 val_296 -1 30 val_30 -1 302 val_302 +1 298 val_298 +1 308 val_308 1 309 val_309 -1 316 val_316 -1 318 val_318 +1 310 val_310 +1 315 val_315 1 325 val_325 1 332 val_332 -1 335 val_335 +1 333 val_333 1 339 val_339 -1 342 val_342 -1 345 val_345 1 353 val_353 -1 369 val_369 +1 356 val_356 +1 364 val_364 1 373 val_373 -1 375 val_375 -1 377 val_377 -1 384 val_384 +1 378 val_378 1 386 val_386 -1 394 val_394 -1 396 val_396 -1 399 val_399 -1 401 val_401 -1 41 val_41 -1 413 val_413 -1 414 val_414 -1 431 val_431 -1 446 val_446 -1 448 val_448 -1 449 val_449 -1 459 val_459 -1 462 val_462 -1 468 val_468 -1 47 val_47 -1 482 val_482 -1 490 val_490 -1 493 val_493 -1 494 val_494 -1 497 val_497 -1 5 val_5 -1 54 val_54 -1 74 val_74 -1 77 val_77 -1 80 val_80 -1 84 val_84 -1 85 val_85 -1 87 val_87 -1 9 val_9 -1 95 val_95 -1 100 val_100 -1 11 val_11 -1 113 val_113 -1 119 val_119 -1 126 val_126 -1 128 val_128 -1 137 val_137 -1 146 val_146 -1 15 val_15 -1 152 val_152 -1 165 val_165 -1 167 val_167 -1 169 val_169 -1 175 val_175 -1 177 val_177 -1 179 val_179 -1 18 val_18 -1 194 val_194 -1 200 val_200 -1 202 val_202 -1 221 val_221 -1 222 val_222 -1 226 val_226 -1 242 val_242 -1 252 val_252 -1 262 val_262 -1 27 val_27 -1 275 val_275 -1 280 val_280 -1 282 val_282 -1 283 val_283 -1 287 val_287 -1 288 val_288 -1 289 val_289 -1 292 val_292 -1 311 val_311 -1 323 val_323 -1 34 val_34 -1 35 val_35 -1 365 val_365 -1 393 val_393 -1 409 val_409 +1 402 val_402 +1 403 val_403 1 411 val_411 -1 417 val_417 -1 418 val_418 +1 419 val_419 1 424 val_424 +1 429 val_429 1 43 val_43 1 432 val_432 -1 435 val_435 -1 443 val_443 -1 444 val_444 -1 453 val_453 -1 457 val_457 +1 436 val_436 +1 449 val_449 1 458 val_458 +1 467 val_467 1 469 val_469 1 475 val_475 -1 477 val_477 -1 481 val_481 -1 483 val_483 -1 64 val_64 -1 72 val_72 -1 76 val_76 +1 482 val_482 +1 484 val_484 +1 495 val_495 +1 496 val_496 +1 497 val_497 +1 58 val_58 +1 70 val_70 1 83 val_83 -1 86 val_86 +1 92 val_92 +1 97 val_97 1 98 val_98 PREHOOK: query: SELECT count(1) as counts, @@ -7635,314 +7664,314 @@ POSTHOOK: Input: default@srcpart POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=11 POSTHOOK: Input: default@srcpart@ds=2008-04-08/hr=12 POSTHOOK: Output: hdfs://### HDFS PATH ### -1 0 val_0 -1 103 val_103 -1 105 val_105 1 116 val_116 +1 118 val_118 1 120 val_120 -1 129 val_129 1 131 val_131 -1 136 val_136 +1 133 val_133 +1 15 val_15 +1 150 val_150 +1 152 val_152 +1 153 val_153 1 155 val_155 -1 157 val_157 1 160 val_160 -1 180 val_180 +1 169 val_169 +1 175 val_175 +1 176 val_176 +1 178 val_178 1 183 val_183 -1 190 val_190 -1 191 val_191 -1 193 val_193 -1 205 val_205 -1 207 val_207 +1 186 val_186 +1 194 val_194 +1 202 val_202 +1 203 val_203 1 213 val_213 1 223 val_223 -1 235 val_235 -1 238 val_238 +1 224 val_224 +1 226 val_226 +1 228 val_228 1 239 val_239 -1 24 val_24 -1 248 val_248 -1 260 val_260 +1 244 val_244 +1 247 val_247 +1 252 val_252 +1 255 val_255 +1 256 val_256 +1 257 val_257 +1 266 val_266 +1 272 val_272 +1 274 val_274 +1 275 val_275 1 28 val_28 +1 284 val_284 1 286 val_286 -1 298 val_298 -1 305 val_305 +1 289 val_289 +1 296 val_296 +1 302 val_302 1 306 val_306 1 307 val_307 -1 308 val_308 -1 315 val_315 1 317 val_317 1 321 val_321 +1 323 val_323 1 33 val_33 -1 331 val_331 -1 356 val_356 +1 338 val_338 +1 34 val_34 +1 35 val_35 1 360 val_360 -1 366 val_366 -1 367 val_367 -1 368 val_368 -1 37 val_37 -1 378 val_378 -1 379 val_379 -1 382 val_382 -1 389 val_389 -1 395 val_395 -1 400 val_400 -1 402 val_402 +1 365 val_365 +1 374 val_374 +1 377 val_377 +1 393 val_393 +1 399 val_399 +1 404 val_404 1 406 val_406 -1 407 val_407 +1 409 val_409 +1 41 val_41 +1 417 val_417 +1 418 val_418 1 42 val_42 -1 430 val_430 -1 436 val_436 +1 431 val_431 +1 439 val_439 1 44 val_44 -1 452 val_452 -1 466 val_466 -1 467 val_467 -1 472 val_472 -1 480 val_480 -1 484 val_484 -1 485 val_485 -1 487 val_487 -1 495 val_495 -1 496 val_496 -1 498 val_498 -1 51 val_51 -1 57 val_57 -1 58 val_58 -1 65 val_65 +1 443 val_443 +1 448 val_448 +1 455 val_455 +1 459 val_459 +1 462 val_462 +1 463 val_463 +1 470 val_470 +1 490 val_490 +1 491 val_491 +1 494 val_494 +1 5 val_5 +1 53 val_53 1 66 val_66 -1 69 val_69 -1 70 val_70 -1 78 val_78 -1 8 val_8 -1 92 val_92 -1 96 val_96 -1 104 val_104 +1 72 val_72 +1 76 val_76 +1 77 val_77 +1 80 val_80 +1 84 val_84 +1 90 val_90 +1 10 val_10 +1 105 val_105 1 111 val_111 -1 114 val_114 -1 118 val_118 -1 12 val_12 -1 133 val_133 -1 138 val_138 -1 153 val_153 -1 156 val_156 -1 162 val_162 -1 168 val_168 +1 113 val_113 +1 119 val_119 +1 129 val_129 +1 136 val_136 +1 143 val_143 +1 149 val_149 +1 163 val_163 +1 167 val_167 1 174 val_174 -1 176 val_176 -1 178 val_178 -1 181 val_181 -1 186 val_186 1 187 val_187 -1 192 val_192 1 197 val_197 -1 199 val_199 1 2 val_2 -1 201 val_201 -1 203 val_203 +1 200 val_200 1 208 val_208 -1 214 val_214 +1 209 val_209 +1 216 val_216 +1 217 val_217 1 218 val_218 -1 219 val_219 +1 221 val_221 1 230 val_230 -1 237 val_237 -1 249 val_249 -1 256 val_256 -1 257 val_257 +1 258 val_258 +1 26 val_26 +1 263 val_263 +1 273 val_273 1 277 val_277 -1 278 val_278 -1 284 val_284 -1 285 val_285 -1 310 val_310 -1 322 val_322 -1 327 val_327 -1 333 val_333 -1 336 val_336 -1 338 val_338 +1 281 val_281 +1 292 val_292 +1 30 val_30 +1 316 val_316 +1 335 val_335 1 341 val_341 +1 342 val_342 1 344 val_344 -1 348 val_348 -1 351 val_351 +1 345 val_345 1 362 val_362 -1 364 val_364 -1 374 val_374 +1 367 val_367 +1 368 val_368 +1 37 val_37 1 392 val_392 -1 397 val_397 +1 394 val_394 1 4 val_4 -1 403 val_403 -1 404 val_404 -1 419 val_419 -1 421 val_421 -1 427 val_427 -1 429 val_429 +1 413 val_413 1 437 val_437 -1 438 val_438 -1 439 val_439 -1 454 val_454 -1 455 val_455 +1 444 val_444 +1 446 val_446 +1 452 val_452 +1 453 val_453 +1 457 val_457 1 460 val_460 -1 463 val_463 -1 470 val_470 -1 478 val_478 +1 466 val_466 +1 468 val_468 +1 477 val_477 1 479 val_479 -1 489 val_489 -1 491 val_491 +1 483 val_483 +1 487 val_487 1 492 val_492 -1 53 val_53 -1 67 val_67 -1 82 val_82 -1 90 val_90 -1 97 val_97 -1 10 val_10 -1 125 val_125 -1 134 val_134 -1 143 val_143 +1 493 val_493 +1 498 val_498 +1 51 val_51 +1 54 val_54 +1 64 val_64 +1 65 val_65 +1 67 val_67 +1 82 val_82 +1 85 val_85 +1 87 val_87 +1 95 val_95 +1 96 val_96 +1 100 val_100 +1 103 val_103 +1 104 val_104 +1 11 val_11 +1 114 val_114 +1 137 val_137 1 145 val_145 -1 149 val_149 -1 150 val_150 -1 158 val_158 -1 163 val_163 -1 164 val_164 -1 166 val_166 +1 156 val_156 +1 157 val_157 +1 162 val_162 +1 168 val_168 1 17 val_17 1 170 val_170 -1 172 val_172 -1 189 val_189 +1 180 val_180 1 19 val_19 -1 195 val_195 +1 190 val_190 +1 192 val_192 1 196 val_196 +1 199 val_199 1 20 val_20 -1 209 val_209 -1 216 val_216 -1 217 val_217 -1 224 val_224 -1 228 val_228 -1 229 val_229 +1 207 val_207 +1 214 val_214 +1 219 val_219 +1 222 val_222 1 233 val_233 1 241 val_241 -1 244 val_244 -1 247 val_247 -1 255 val_255 -1 258 val_258 -1 26 val_26 -1 263 val_263 -1 265 val_265 -1 266 val_266 -1 272 val_272 -1 273 val_273 -1 274 val_274 -1 281 val_281 -1 291 val_291 -1 296 val_296 -1 30 val_30 -1 302 val_302 -1 309 val_309 -1 316 val_316 +1 260 val_260 +1 27 val_27 +1 278 val_278 +1 280 val_280 +1 285 val_285 +1 288 val_288 +1 305 val_305 +1 311 val_311 1 318 val_318 -1 325 val_325 -1 332 val_332 -1 335 val_335 -1 339 val_339 -1 342 val_342 -1 345 val_345 -1 353 val_353 +1 322 val_322 +1 327 val_327 +1 331 val_331 +1 336 val_336 +1 348 val_348 +1 351 val_351 +1 366 val_366 1 369 val_369 -1 373 val_373 1 375 val_375 -1 377 val_377 +1 379 val_379 +1 382 val_382 1 384 val_384 -1 386 val_386 -1 394 val_394 +1 389 val_389 +1 395 val_395 1 396 val_396 -1 399 val_399 +1 397 val_397 +1 400 val_400 1 401 val_401 -1 41 val_41 -1 413 val_413 +1 407 val_407 1 414 val_414 -1 431 val_431 -1 446 val_446 -1 448 val_448 -1 449 val_449 -1 459 val_459 -1 462 val_462 -1 468 val_468 +1 421 val_421 +1 427 val_427 +1 430 val_430 +1 435 val_435 +1 438 val_438 +1 454 val_454 1 47 val_47 -1 482 val_482 -1 490 val_490 -1 493 val_493 -1 494 val_494 -1 497 val_497 -1 5 val_5 -1 54 val_54 +1 472 val_472 +1 478 val_478 +1 480 val_480 +1 481 val_481 +1 485 val_485 +1 489 val_489 +1 57 val_57 +1 69 val_69 1 74 val_74 -1 77 val_77 -1 80 val_80 -1 84 val_84 -1 85 val_85 -1 87 val_87 +1 78 val_78 +1 8 val_8 +1 86 val_86 1 9 val_9 -1 95 val_95 -1 100 val_100 -1 11 val_11 -1 113 val_113 -1 119 val_119 +1 0 val_0 +1 12 val_12 +1 125 val_125 1 126 val_126 1 128 val_128 -1 137 val_137 +1 134 val_134 +1 138 val_138 1 146 val_146 -1 15 val_15 -1 152 val_152 +1 158 val_158 +1 164 val_164 1 165 val_165 -1 167 val_167 -1 169 val_169 -1 175 val_175 +1 166 val_166 +1 172 val_172 1 177 val_177 1 179 val_179 1 18 val_18 -1 194 val_194 -1 200 val_200 -1 202 val_202 -1 221 val_221 -1 222 val_222 -1 226 val_226 +1 181 val_181 +1 189 val_189 +1 191 val_191 +1 193 val_193 +1 195 val_195 +1 201 val_201 +1 205 val_205 +1 229 val_229 +1 235 val_235 +1 237 val_237 +1 238 val_238 +1 24 val_24 1 242 val_242 -1 252 val_252 +1 248 val_248 +1 249 val_249 1 262 val_262 -1 27 val_27 -1 275 val_275 -1 280 val_280 +1 265 val_265 1 282 val_282 1 283 val_283 1 287 val_287 -1 288 val_288 -1 289 val_289 -1 292 val_292 -1 311 val_311 -1 323 val_323 -1 34 val_34 -1 35 val_35 -1 365 val_365 -1 393 val_393 -1 409 val_409 +1 291 val_291 +1 298 val_298 +1 308 val_308 +1 309 val_309 +1 310 val_310 +1 315 val_315 +1 325 val_325 +1 332 val_332 +1 333 val_333 +1 339 val_339 +1 353 val_353 +1 356 val_356 +1 364 val_364 +1 373 val_373 +1 378 val_378 +1 386 val_386 +1 402 val_402 +1 403 val_403 1 411 val_411 -1 417 val_417 -1 418 val_418 +1 419 val_419 1 424 val_424 +1 429 val_429 1 43 val_43 1 432 val_432 -1 435 val_435 -1 443 val_443 -1 444 val_444 -1 453 val_453 -1 457 val_457 +1 436 val_436 +1 449 val_449 1 458 val_458 +1 467 val_467 1 469 val_469 1 475 val_475 -1 477 val_477 -1 481 val_481 -1 483 val_483 -1 64 val_64 -1 72 val_72 -1 76 val_76 +1 482 val_482 +1 484 val_484 +1 495 val_495 +1 496 val_496 +1 497 val_497 +1 58 val_58 +1 70 val_70 1 83 val_83 -1 86 val_86 +1 92 val_92 +1 97 val_97 1 98 val_98 PREHOOK: query: create table jackson_sev_same as select * from src PREHOOK: type: CREATETABLE_AS_SELECT @@ -8960,9 +8989,9 @@ POSTHOOK: query: select * from union_out POSTHOOK: type: QUERY POSTHOOK: Input: default@union_out POSTHOOK: Output: hdfs://### HDFS PATH ### -4 -1 2 +1 +4 3 PREHOOK: query: create table union_subq_union30(key int, value string) PREHOOK: type: CREATETABLE @@ -11763,15 +11792,15 @@ POSTHOOK: Input: default@src10_2 POSTHOOK: Input: default@src10_3 POSTHOOK: Input: default@src10_4 POSTHOOK: Output: hdfs://### HDFS PATH ### -238 val_238 -484 val_484 -278 val_278 255 val_255 -165 val_165 +409 val_409 27 val_27 +278 val_278 311 val_311 -409 val_409 86 val_86 +165 val_165 +238 val_238 +484 val_484 98 val_98 PREHOOK: query: explain SELECT * FROM ( @@ -11962,13 +11991,13 @@ POSTHOOK: Input: default@src10_2 POSTHOOK: Input: default@src10_3 POSTHOOK: Input: default@src10_4 POSTHOOK: Output: hdfs://### HDFS PATH ### -238 val_238 -484 val_484 -278 val_278 255 val_255 -165 val_165 +409 val_409 27 val_27 +278 val_278 311 val_311 -409 val_409 86 val_86 +165 val_165 +238 val_238 +484 val_484 98 val_98
http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/unionDistinct_3.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/unionDistinct_3.q.out b/ql/src/test/results/clientpositive/llap/unionDistinct_3.q.out index caf9ce8..f8bc2b8 100644 --- a/ql/src/test/results/clientpositive/llap/unionDistinct_3.q.out +++ b/ql/src/test/results/clientpositive/llap/unionDistinct_3.q.out @@ -489,315 +489,315 @@ POSTHOOK: query: select unionsrc.key, unionsrc.value FROM (select s1.key as key, POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### -0 val_0 -103 val_103 +104 val_104 105 val_105 -116 val_116 +113 val_113 +118 val_118 +12 val_12 120 val_120 -129 val_129 -131 val_131 +133 val_133 136 val_136 155 val_155 -157 val_157 +158 val_158 160 val_160 +162 val_162 +168 val_168 +17 val_17 +170 val_170 +175 val_175 +18 val_18 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 +186 val_186 +19 val_19 +197 val_197 +200 val_200 +216 val_216 +218 val_218 +222 val_222 +224 val_224 +228 val_228 235 val_235 -238 val_238 +237 val_237 239 val_239 -24 val_24 -248 val_248 -260 val_260 +244 val_244 +247 val_247 +256 val_256 +263 val_263 +273 val_273 28 val_28 +283 val_283 286 val_286 -298 val_298 -305 val_305 +292 val_292 306 val_306 -307 val_307 308 val_308 +327 val_327 +33 val_33 +348 val_348 +353 val_353 +362 val_362 +366 val_366 +396 val_396 +397 val_397 +401 val_401 +409 val_409 +411 val_411 +419 val_419 +427 val_427 +43 val_43 +432 val_432 +436 val_436 +439 val_439 +443 val_443 +453 val_453 +460 val_460 +462 val_462 +47 val_47 +472 val_472 +485 val_485 +496 val_496 +54 val_54 +64 val_64 +70 val_70 +8 val_8 +83 val_83 +84 val_84 +85 val_85 +90 val_90 +0 val_0 +103 val_103 +114 val_114 +125 val_125 +138 val_138 +146 val_146 +150 val_150 +152 val_152 +153 val_153 +156 val_156 +157 val_157 +165 val_165 +172 val_172 +177 val_177 +179 val_179 +187 val_187 +195 val_195 +196 val_196 +217 val_217 +242 val_242 +248 val_248 +252 val_252 +265 val_265 +27 val_27 +272 val_272 +280 val_280 +291 val_291 +305 val_305 +309 val_309 +311 val_311 315 val_315 317 val_317 -321 val_321 -33 val_33 -331 val_331 +322 val_322 +333 val_333 +34 val_34 +345 val_345 +35 val_35 356 val_356 -360 val_360 -366 val_366 -367 val_367 +364 val_364 368 val_368 +369 val_369 37 val_37 -378 val_378 -379 val_379 -382 val_382 -389 val_389 -395 val_395 -400 val_400 +373 val_373 +377 val_377 +4 val_4 402 val_402 -406 val_406 -407 val_407 +404 val_404 +413 val_413 42 val_42 430 val_430 -436 val_436 -44 val_44 +431 val_431 +444 val_444 +449 val_449 452 val_452 +454 val_454 +457 val_457 +463 val_463 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 +470 val_470 +475 val_475 +481 val_481 +489 val_489 +491 val_491 57 val_57 -58 val_58 65 val_65 66 val_66 -69 val_69 -70 val_70 +74 val_74 +76 val_76 78 val_78 -8 val_8 +9 val_9 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 -168 val_168 +95 val_95 +100 val_100 +119 val_119 +128 val_128 +129 val_129 +145 val_145 +167 val_167 174 val_174 -176 val_176 178 val_178 181 val_181 -186 val_186 -187 val_187 -192 val_192 -197 val_197 +193 val_193 199 val_199 -2 val_2 +20 val_20 201 val_201 -203 val_203 -208 val_208 +213 val_213 214 val_214 -218 val_218 219 val_219 -230 val_230 -237 val_237 +221 val_221 +223 val_223 +226 val_226 +233 val_233 +241 val_241 249 val_249 -256 val_256 -257 val_257 +260 val_260 +262 val_262 277 val_277 -278 val_278 -284 val_284 -285 val_285 +281 val_281 +287 val_287 +288 val_288 +298 val_298 +302 val_302 310 val_310 -322 val_322 -327 val_327 -333 val_333 +323 val_323 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 +375 val_375 +382 val_382 +384 val_384 +393 val_393 +395 val_395 +399 val_399 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 +406 val_406 +418 val_418 +435 val_435 455 val_455 -460 val_460 -463 val_463 -470 val_470 +459 val_459 +477 val_477 478 val_478 479 val_479 -489 val_489 -491 val_491 -492 val_492 -53 val_53 +482 val_482 +493 val_493 +494 val_494 +495 val_495 +497 val_497 +5 val_5 +58 val_58 67 val_67 -82 val_82 -90 val_90 +77 val_77 +80 val_80 +86 val_86 97 val_97 +98 val_98 10 val_10 -125 val_125 +11 val_11 +111 val_111 +116 val_116 +126 val_126 +131 val_131 134 val_134 +137 val_137 143 val_143 -145 val_145 149 val_149 -150 val_150 -158 val_158 +15 val_15 163 val_163 164 val_164 166 val_166 -17 val_17 -170 val_170 -172 val_172 +169 val_169 +176 val_176 +183 val_183 189 val_189 -19 val_19 -195 val_195 -196 val_196 -20 val_20 +190 val_190 +191 val_191 +192 val_192 +194 val_194 +2 val_2 +202 val_202 +203 val_203 +205 val_205 +207 val_207 +208 val_208 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 +230 val_230 +238 val_238 +24 val_24 255 val_255 +257 val_257 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 +275 val_275 +278 val_278 +282 val_282 +284 val_284 +285 val_285 +289 val_289 296 val_296 30 val_30 -302 val_302 -309 val_309 +307 val_307 316 val_316 318 val_318 +321 val_321 325 val_325 +331 val_331 332 val_332 335 val_335 +338 val_338 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 +360 val_360 +365 val_365 +367 val_367 +374 val_374 +378 val_378 +379 val_379 386 val_386 +389 val_389 +392 val_392 394 val_394 -396 val_396 -399 val_399 -401 val_401 +400 val_400 +407 val_407 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 +421 val_421 424 val_424 -43 val_43 -432 val_432 -435 val_435 -443 val_443 -444 val_444 -453 val_453 -457 val_457 +429 val_429 +437 val_437 +438 val_438 +44 val_44 +446 val_446 +448 val_448 458 val_458 +467 val_467 +468 val_468 469 val_469 -475 val_475 -477 val_477 -481 val_481 +480 val_480 483 val_483 -64 val_64 +484 val_484 +487 val_487 +490 val_490 +492 val_492 +498 val_498 +51 val_51 +53 val_53 +69 val_69 72 val_72 -76 val_76 -83 val_83 -86 val_86 -98 val_98 +82 val_82 +87 val_87 +96 val_96 PREHOOK: query: explain select unionsrc.key, count(1) FROM (select 'tst1' as key, count(1) as value from src s1 UNION DISTINCT @@ -2145,539 +2145,539 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Input: default@src_thrift #### A masked pattern was here #### -03 1 -071 1 -09 1 -1 1 +013 1 +061 1 +063 1 +064 1 +074 1 +08 1 +081 1 +094 1 10 1 100 1 +103 1 104 1 -111 1 -114 1 -116 1 -123 1 +105 1 +11 1 126 1 128 1 -131 1 +129 1 +133 1 134 1 -14 1 +136 1 +143 1 +149 1 152 1 -155 1 +153 1 +157 1 +162 1 +166 1 169 1 -17 1 170 1 -172 1 -178 1 -179 1 -182 1 -189 1 -19 1 -192 1 -194 1 -195 1 -199 1 -20 1 -207 1 -21 1 +174 1 +176 1 +184 1 +193 1 +196 1 +201 1 +205 1 +209 1 213 1 218 1 +221 1 223 1 -229 1 233 1 -235 1 +234 1 +239 1 24 1 -256 1 -257 1 +241 1 +242 1 +247 1 +248 1 +251 1 +254 1 26 1 -265 1 -266 1 -27 1 -278 1 -280 1 -284 1 -291 1 -294 1 -30 1 +263 1 +264 1 +272 1 +275 1 +285 1 +293 1 +296 1 +298 1 301 1 302 1 -305 1 -312 1 -314 1 -316 1 -321 1 +307 1 +310 1 323 1 -33 1 +325 1 333 1 +335 1 338 1 -344 1 -353 1 -356 1 -361 1 -364 1 -368 1 -369 1 -37 1 +360 1 +362 1 +367 1 +375 1 377 1 -378 1 -386 1 +38 1 +384 1 392 1 -397 1 +399 1 40 1 -404 1 -407 1 -411 1 -418 1 +401 1 +402 1 +403 1 +412 1 +413 1 +417 1 419 1 -422 1 -424 1 -430 1 -432 1 -436 1 -437 1 -448 1 -454 1 -457 1 -46 1 -468 1 -477 1 +42 1 +427 1 +438 1 +44 1 +458 1 +459 1 +461 1 +466 1 +469 1 +472 1 +475 1 +478 1 479 1 -490 1 -492 1 -493 1 +483 1 +489 1 495 1 496 1 -497 1 -501 1 +5 1 533 1 -534 1 -552 1 +551 1 57 1 +573 1 +58 1 582 1 -611 1 -62 1 +593 1 +594 1 +604 1 +64 1 652 1 -67 1 -671 1 -691 1 -712 1 -723 1 -73 1 -732 1 -75 1 -751 1 -761 1 -794 1 -8 1 -80 1 -814 1 -822 1 -831 1 -85 1 -854 1 -863 1 -871 1 -874 1 -882 1 +66 1 +682 1 +683 1 +69 1 +702 1 +713 1 +72 1 +76 1 +763 1 +77 1 +771 1 +774 1 +782 1 +791 1 +802 1 +812 1 +833 1 +842 1 +873 1 +894 1 9 1 -902 1 -904 1 -91 1 -911 1 -92 1 -921 1 -922 1 +90 1 +903 1 +912 1 +933 1 +954 1 964 1 -97 1 -974 1 -982 1 983 1 -record_7 1 +984 1 +record_2 1 +record_3 1 +record_6 1 record_8 1 NULL 1 -002 1 +0 1 +004 1 +01 1 02 1 032 1 -034 1 -07 1 -074 1 +062 1 +082 1 091 1 -105 1 -11 1 113 1 -124 1 -136 1 +114 1 +116 1 +118 1 +122 1 +123 1 137 1 138 1 -143 1 -150 1 +14 1 +145 1 +146 1 +155 1 158 1 -160 1 -162 1 +164 1 165 1 -166 1 -174 1 -177 1 -18 1 -180 1 +178 1 +181 1 +183 1 186 1 -196 1 -197 1 +189 1 +190 1 +191 1 +194 1 +195 1 +199 1 +2 1 204 1 -217 1 -219 1 -226 1 +207 1 +208 1 +214 1 +216 1 +222 1 +224 1 +229 1 230 1 238 1 -242 1 -248 1 -252 1 +243 1 +244 1 +258 1 260 1 -261 1 -263 1 -274 1 -277 1 -293 1 -296 1 -304 1 -307 1 -308 1 -325 1 -327 1 +262 1 +266 1 +27 1 +273 1 +28 1 +284 1 +288 1 +294 1 +30 1 +312 1 +314 1 +315 1 +321 1 +33 1 342 1 -348 1 35 1 -351 1 -367 1 +364 1 +365 1 +366 1 +368 1 381 1 +386 1 389 1 -393 1 394 1 +396 1 +397 1 4 1 -403 1 -409 1 -412 1 +41 1 414 1 421 1 -427 1 -429 1 -435 1 -438 1 -439 1 -45 1 +442 1 +444 1 +446 1 +448 1 +452 1 +454 1 455 1 -458 1 460 1 -461 1 -462 1 +463 1 471 1 -475 1 -478 1 -480 1 -484 1 -487 1 +473 1 +482 1 +492 1 +493 1 50 1 -503 1 -513 1 -521 1 -523 1 -53 1 -532 1 -551 1 -56 1 -563 1 -571 1 -573 1 -58 1 -59 1 -591 1 -603 1 -604 1 -622 1 +501 1 +502 1 +543 1 +554 1 +574 1 +584 1 +60 1 +621 1 633 1 -634 1 -641 1 -644 1 +65 1 651 1 -66 1 -661 1 -69 1 -693 1 -694 1 +662 1 +664 1 +681 1 +692 1 703 1 -71 1 +712 1 +714 1 +723 1 731 1 734 1 -752 1 -754 1 -764 1 -77 1 -772 1 +751 1 78 1 -784 1 -793 1 -803 1 -813 1 -83 1 -833 1 +80 1 +814 1 +831 1 +832 1 +834 1 843 1 844 1 -864 1 -89 1 -90 1 +852 1 +863 1 +882 1 +911 1 924 1 +932 1 934 1 -95 1 -954 1 -961 1 +942 1 +944 1 +963 1 +97 1 +982 1 +991 1 993 1 -record_0 1 -record_2 1 -record_4 1 -record_6 1 +record_1 1 +record_7 1 record_9 1 001 1 -004 1 -01 1 -013 1 +002 1 051 1 -061 1 -062 1 -063 1 +071 1 102 1 -103 1 +111 1 +12 1 120 1 -129 1 -133 1 -142 1 -145 1 -146 1 -149 1 -15 1 -157 1 -181 1 -187 1 -191 1 -2 1 -200 1 -201 1 -202 1 +131 1 +150 1 +156 1 +160 1 +163 1 +167 1 +168 1 +17 1 +175 1 +180 1 +182 1 +20 1 203 1 -208 1 -214 1 -216 1 -222 1 -224 1 -228 1 +21 1 +226 1 237 1 -239 1 -241 1 -244 1 -254 1 255 1 -258 1 -262 1 -264 1 -273 1 -275 1 -28 1 +256 1 +261 1 +271 1 +274 1 +277 1 +281 1 282 1 -285 1 286 1 287 1 -288 1 -29 1 +289 1 292 1 -298 1 -310 1 -311 1 +308 1 +309 1 +318 1 +327 1 332 1 -335 1 -336 1 339 1 +34 1 +341 1 +348 1 354 1 -360 1 -362 1 -373 1 -384 1 -395 1 -396 1 -402 1 -417 1 -42 1 +356 1 +361 1 +37 1 +372 1 +374 1 +379 1 +382 1 +409 1 +429 1 43 1 -442 1 -444 1 -449 1 -453 1 -459 1 -47 1 +430 1 +431 1 +432 1 +435 1 +437 1 +439 1 +443 1 +45 1 +457 1 +462 1 +467 1 +470 1 48 1 481 1 -482 1 -483 1 -485 1 -489 1 +487 1 494 1 -502 1 -541 1 -562 1 -574 1 -593 1 -60 1 -621 1 -631 1 -65 1 +51 1 +513 1 +521 1 +523 1 +532 1 +534 1 +552 1 +561 1 +563 1 +571 1 +603 1 +612 1 +62 1 +622 1 +641 1 +644 1 653 1 663 1 -664 1 -681 1 -682 1 -683 1 -713 1 -72 1 +68 1 +691 1 +70 1 +724 1 +73 1 +732 1 74 1 -742 1 -76 1 -763 1 -771 1 +752 1 +754 1 781 1 +784 1 79 1 -791 1 811 1 -812 1 82 1 -834 1 -852 1 -86 1 +821 1 +83 1 +84 1 861 1 -87 1 -872 1 -894 1 -903 1 -912 1 -914 1 -932 1 -942 1 -944 1 -96 1 -963 1 +904 1 +91 1 +941 1 +961 1 +971 1 +981 1 +record_4 1 record_5 1 -0 1 021 1 -064 1 -08 1 -081 1 -082 1 +03 1 +034 1 +07 1 084 1 -094 1 -118 1 +09 1 +1 1 119 1 -12 1 -122 1 +124 1 125 1 -153 1 -156 1 -163 1 -164 1 -167 1 -168 1 -175 1 -176 1 -183 1 -184 1 -190 1 -193 1 -205 1 -209 1 -221 1 -234 1 -243 1 -247 1 +142 1 +15 1 +172 1 +177 1 +179 1 +18 1 +187 1 +19 1 +192 1 +197 1 +200 1 +202 1 +217 1 +219 1 +228 1 +235 1 249 1 -251 1 -271 1 -272 1 -281 1 +252 1 +257 1 +265 1 +278 1 +280 1 283 1 -289 1 +29 1 +291 1 +304 1 +305 1 306 1 -309 1 -315 1 +311 1 +316 1 317 1 -318 1 322 1 331 1 -34 1 -341 1 +336 1 +344 1 345 1 -365 1 -366 1 -372 1 -374 1 -375 1 -379 1 -38 1 -382 1 +351 1 +353 1 +369 1 +373 1 +378 1 391 1 -399 1 +393 1 +395 1 400 1 -401 1 +404 1 406 1 -41 1 -413 1 -431 1 -44 1 -443 1 -446 1 -452 1 -463 1 -466 1 -467 1 -469 1 -470 1 -472 1 -473 1 +407 1 +411 1 +418 1 +422 1 +424 1 +436 1 +449 1 +453 1 +46 1 +468 1 +47 1 +477 1 +480 1 +484 1 +485 1 +490 1 491 1 +497 1 498 1 -5 1 -51 1 +503 1 +53 1 54 1 -543 1 -554 1 -561 1 +541 1 +56 1 +562 1 572 1 -584 1 -594 1 -612 1 +59 1 +591 1 +611 1 613 1 -64 1 -662 1 -68 1 -692 1 -70 1 -702 1 +631 1 +634 1 +661 1 +67 1 +671 1 +693 1 +694 1 704 1 -714 1 -724 1 +71 1 +742 1 +75 1 +761 1 +764 1 +772 1 773 1 -774 1 -782 1 -802 1 +793 1 +794 1 +8 1 +803 1 81 1 -821 1 -832 1 -84 1 -842 1 +813 1 +822 1 +85 1 851 1 -873 1 +854 1 +86 1 +864 1 +87 1 +871 1 +872 1 +874 1 +89 1 892 1 -933 1 -941 1 -971 1 +902 1 +914 1 +92 1 +921 1 +922 1 +95 1 +96 1 973 1 +974 1 98 1 -981 1 -984 1 -991 1 -record_1 1 -record_3 1 +record_0 1 http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/union_fast_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union_fast_stats.q.out b/ql/src/test/results/clientpositive/llap/union_fast_stats.q.out index 5cd5d41..4ca5f47 100644 --- a/ql/src/test/results/clientpositive/llap/union_fast_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/union_fast_stats.q.out @@ -176,6 +176,7 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 3 numRows 15 rawDataSize 3483 @@ -228,6 +229,7 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 3 numRows 15 rawDataSize 3483 @@ -292,6 +294,7 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 4 numRows 20 rawDataSize 4552 @@ -506,10 +509,11 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 1 numRows 5 rawDataSize 1069 - totalSize 3243 + totalSize 3245 #### A masked pattern was here #### # Storage Information @@ -558,10 +562,11 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 1 numRows 15 rawDataSize 3320 - totalSize 3243 + totalSize 3245 #### A masked pattern was here #### # Storage Information @@ -622,10 +627,11 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 2 numRows 20 rawDataSize 4389 - totalSize 4616 + totalSize 4618 #### A masked pattern was here #### # Storage Information http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/union_stats.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/union_stats.q.out b/ql/src/test/results/clientpositive/llap/union_stats.q.out index ba2700c..45c98db 100644 --- a/ql/src/test/results/clientpositive/llap/union_stats.q.out +++ b/ql/src/test/results/clientpositive/llap/union_stats.q.out @@ -62,6 +62,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,value columns.comments 'default','default' @@ -83,6 +84,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,value columns.comments 'default','default' @@ -146,6 +148,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,value columns.comments 'default','default' @@ -167,6 +170,7 @@ STAGE PLANS: properties: COLUMN_STATS_ACCURATE {"BASIC_STATS":"true","COLUMN_STATS":{"key":"true","value":"true"}} bucket_count -1 + bucketing_version 2 column.name.delimiter , columns key,value columns.comments 'default','default' @@ -251,6 +255,7 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 2 numRows 1000 rawDataSize 10624 @@ -299,6 +304,7 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 2 numRows 1500 rawDataSize 15936 @@ -355,6 +361,7 @@ Retention: 0 Table Type: MANAGED_TABLE Table Parameters: COLUMN_STATS_ACCURATE {\"BASIC_STATS\":\"true\"} + bucketing_version 2 numFiles 2 numRows 1500 rawDataSize 15936 http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out b/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out index e8bb722..451a6e1 100644 --- a/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_coalesce_2.q.out @@ -168,9 +168,9 @@ GROUP BY str2 POSTHOOK: type: QUERY POSTHOOK: Input: default@str_str_orc #### A masked pattern was here #### -y 0.0 -NULL 0.0 X 0.02 +NULL 0.0 +y 0.0 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COALESCE(str1, 0) as result from str_str_orc @@ -393,9 +393,9 @@ GROUP BY str2 POSTHOOK: type: QUERY POSTHOOK: Input: default@str_str_orc #### A masked pattern was here #### -y 0.0 -NULL 0.0 X 0.02 +NULL 0.0 +y 0.0 PREHOOK: query: EXPLAIN VECTORIZATION EXPRESSION SELECT COALESCE(str1, 0) as result from str_str_orc http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out b/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out index f2277c1..a123a33 100644 --- a/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_complex_all.q.out @@ -1112,9 +1112,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_create_complex #### A masked pattern was here #### lst strct +["g","h","i"] {"a":"five","b":"six"} ["a","b","c"] {"a":"one","b":"two"} ["d","e","f"] {"a":"three","b":"four"} -["g","h","i"] {"a":"five","b":"six"} PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT str, count(val) FROM orc_create_complex GROUP BY str PREHOOK: type: QUERY @@ -1253,9 +1253,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_create_complex #### A masked pattern was here #### str _c1 +line2 4501 line3 4501 line1 4501 -line2 4501 PREHOOK: query: EXPLAIN VECTORIZATION DETAIL SELECT strct.B, count(val) FROM orc_create_complex GROUP BY strct.B PREHOOK: type: QUERY @@ -1492,6 +1492,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@orc_create_complex #### A masked pattern was here #### strct mp lst str _c4 -{"a":"three","b":"four"} {"key21":"value21","key22":"value22","key23":"value23"} ["d","e","f"] line2 4501 {"a":"one","b":"two"} {"key11":"value11","key12":"value12","key13":"value13"} ["a","b","c"] line1 4501 +{"a":"three","b":"four"} {"key21":"value21","key22":"value22","key23":"value23"} ["d","e","f"] line2 4501 {"a":"five","b":"six"} {"key31":"value31","key32":"value32","key33":"value33"} ["g","h","i"] line3 4501 http://git-wip-us.apache.org/repos/asf/hive/blob/091fd962/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out b/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out index ec3e2b8..e31de7d 100644 --- a/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out +++ b/ql/src/test/results/clientpositive/llap/vector_grouping_sets.q.out @@ -247,13 +247,13 @@ POSTHOOK: query: select s_store_id POSTHOOK: type: QUERY POSTHOOK: Input: default@store #### A masked pattern was here #### +AAAAAAAACAAAAAAA +NULL AAAAAAAABAAAAAAA AAAAAAAAEAAAAAAA AAAAAAAAHAAAAAAA -NULL AAAAAAAAIAAAAAAA AAAAAAAAKAAAAAAA -AAAAAAAACAAAAAAA PREHOOK: query: explain vectorization expression select s_store_id, GROUPING__ID from store @@ -385,13 +385,13 @@ POSTHOOK: query: select s_store_id, GROUPING__ID POSTHOOK: type: QUERY POSTHOOK: Input: default@store #### A masked pattern was here #### +AAAAAAAACAAAAAAA 0 +NULL 1 AAAAAAAABAAAAAAA 0 AAAAAAAAEAAAAAAA 0 AAAAAAAAHAAAAAAA 0 -NULL 1 AAAAAAAAIAAAAAAA 0 AAAAAAAAKAAAAAAA 0 -AAAAAAAACAAAAAAA 0 PREHOOK: query: explain select s_store_id, GROUPING__ID from store
