http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/tez_dml.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/tez_dml.q.out b/ql/src/test/results/clientpositive/tez/tez_dml.q.out index 4fe91f5..ae85292 100644 --- a/ql/src/test/results/clientpositive/tez/tez_dml.q.out +++ b/ql/src/test/results/clientpositive/tez/tez_dml.q.out @@ -1,7 +1,11 @@ PREHOOK: query: -- CTAS +-- SORT_QUERY_RESULTS + EXPLAIN CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt PREHOOK: type: CREATETABLE_AS_SELECT POSTHOOK: query: -- CTAS +-- SORT_QUERY_RESULTS + EXPLAIN CREATE TABLE tmp_src AS SELECT * FROM (SELECT value, count(value) AS cnt FROM src GROUP BY value) f1 ORDER BY cnt POSTHOOK: type: CREATETABLE_AS_SELECT STAGE DEPENDENCIES: @@ -107,337 +111,337 @@ POSTHOOK: query: SELECT * FROM tmp_src POSTHOOK: type: QUERY POSTHOOK: Input: default@tmp_src #### A masked pattern was here #### -val_490 1 -val_287 1 -val_286 1 -val_285 1 -val_284 1 -val_283 1 +val_0 3 +val_10 1 +val_100 2 +val_103 2 +val_104 2 +val_105 1 +val_11 1 +val_111 1 +val_113 2 val_114 1 -val_487 1 -val_485 1 -val_28 1 -val_484 1 -val_181 1 -val_275 1 -val_274 1 -val_183 1 -val_483 1 -val_27 1 -val_266 1 -val_482 1 -val_263 1 -val_262 1 -val_260 1 -val_481 1 -val_258 1 -val_257 1 val_116 1 -val_479 1 -val_252 1 -val_249 1 -val_248 1 -val_247 1 -val_244 1 -val_92 1 -val_241 1 -val_477 1 -val_475 1 -val_472 1 -val_470 1 -val_235 1 -val_47 1 -val_186 1 +val_118 2 +val_119 3 +val_12 2 +val_120 2 +val_125 2 val_126 1 -val_228 1 -val_226 1 +val_128 3 +val_129 2 val_131 1 -val_467 1 -val_222 1 val_133 1 -val_82 1 -val_218 1 -val_80 1 -val_460 1 -val_214 1 -val_8 1 -val_78 1 -val_189 1 -val_457 1 -val_455 1 +val_134 2 val_136 1 -val_202 1 -val_201 1 -val_453 1 -val_20 1 -val_2 1 -val_19 1 -val_452 1 -val_196 1 -val_449 1 -val_194 1 -val_190 1 -val_192 1 -val_448 1 -val_446 1 -val_444 1 -val_443 1 -val_44 1 -val_77 1 +val_137 2 +val_138 4 val_143 1 -val_437 1 -val_436 1 -val_435 1 -val_432 1 val_145 1 +val_146 2 +val_149 2 +val_15 2 val_150 1 -val_43 1 -val_10 1 -val_427 1 -val_74 1 -val_421 1 -val_9 1 -val_419 1 -val_418 1 +val_152 2 val_153 1 -val_105 1 -val_69 1 -val_411 1 -val_41 1 val_155 1 -val_407 1 val_156 1 -val_87 1 val_157 1 -val_402 1 val_158 1 -val_400 1 -val_4 1 -val_66 1 -val_65 1 val_160 1 -val_64 1 -val_394 1 -val_393 1 -val_392 1 -val_389 1 -val_386 1 val_162 1 -val_86 1 -val_379 1 -val_378 1 -val_377 1 -val_375 1 -val_374 1 -val_373 1 -val_57 1 val_163 1 -val_368 1 -val_54 1 -val_366 1 -val_365 1 -val_364 1 -val_362 1 -val_360 1 -val_356 1 -val_53 1 -val_351 1 +val_164 2 +val_165 2 val_166 1 +val_167 3 val_168 1 -val_345 1 -val_85 1 -val_11 1 -val_341 1 -val_34 1 -val_339 1 -val_338 1 -val_336 1 -val_335 1 -val_111 1 -val_332 1 -val_497 1 -val_33 1 +val_169 4 val_17 1 -val_496 1 -val_323 1 -val_495 1 -val_494 1 val_170 1 -val_493 1 +val_172 2 +val_174 2 +val_175 2 +val_176 2 val_177 1 -val_315 1 val_178 1 -val_310 1 -val_96 1 -val_308 1 -val_491 1 -val_306 1 -val_305 1 -val_302 1 -val_30 1 -val_180 1 -val_296 1 -val_292 1 -val_291 1 -val_289 1 -val_98 2 -val_97 2 -val_95 2 -val_84 2 -val_83 2 -val_76 2 -val_72 2 -val_67 2 -val_58 2 -val_51 2 -val_492 2 -val_478 2 -val_463 2 -val_462 2 -val_459 2 -val_458 2 -val_439 2 -val_429 2 -val_424 2 -val_42 2 -val_414 2 -val_413 2 -val_404 2 -val_399 2 -val_397 2 -val_395 2 -val_382 2 -val_37 2 -val_367 2 -val_353 2 -val_344 2 -val_342 2 -val_333 2 -val_331 2 -val_325 2 -val_322 2 -val_321 2 -val_317 2 -val_309 2 -val_307 2 -val_288 2 -val_282 2 -val_281 2 -val_280 2 -val_278 2 -val_272 2 -val_265 2 -val_26 2 -val_256 2 -val_255 2 -val_242 2 -val_24 2 -val_239 2 -val_238 2 -val_237 2 -val_233 2 -val_229 2 -val_224 2 -val_223 2 -val_221 2 -val_219 2 -val_217 2 -val_216 2 -val_213 2 -val_209 2 -val_207 2 -val_205 2 -val_203 2 -val_200 2 -val_197 2 -val_195 2 -val_191 2 -val_18 2 val_179 2 -val_176 2 -val_175 2 -val_174 2 -val_172 2 -val_165 2 -val_164 2 -val_152 2 -val_15 2 -val_149 2 -val_146 2 -val_137 2 -val_134 2 -val_129 2 -val_125 2 -val_120 2 -val_12 2 -val_118 2 -val_113 2 -val_104 2 -val_103 2 -val_100 2 -val_498 3 +val_18 2 +val_180 1 +val_181 1 +val_183 1 +val_186 1 +val_187 3 +val_189 1 +val_19 1 +val_190 1 +val_191 2 +val_192 1 +val_193 3 +val_194 1 +val_195 2 +val_196 1 +val_197 2 +val_199 3 +val_2 1 +val_20 1 +val_200 2 +val_201 1 +val_202 1 +val_203 2 +val_205 2 +val_207 2 +val_208 3 +val_209 2 +val_213 2 +val_214 1 +val_216 2 +val_217 2 +val_218 1 +val_219 2 +val_221 2 +val_222 1 +val_223 2 +val_224 2 +val_226 1 +val_228 1 +val_229 2 +val_230 5 +val_233 2 +val_235 1 +val_237 2 +val_238 2 +val_239 2 +val_24 2 +val_241 1 +val_242 2 +val_244 1 +val_247 1 +val_248 1 +val_249 1 +val_252 1 +val_255 2 +val_256 2 +val_257 1 +val_258 1 +val_26 2 +val_260 1 +val_262 1 +val_263 1 +val_265 2 +val_266 1 +val_27 1 +val_272 2 +val_273 3 +val_274 1 +val_275 1 +val_277 4 +val_278 2 +val_28 1 +val_280 2 +val_281 2 +val_282 2 +val_283 1 +val_284 1 +val_285 1 +val_286 1 +val_287 1 +val_288 2 +val_289 1 +val_291 1 +val_292 1 +val_296 1 +val_298 3 +val_30 1 +val_302 1 +val_305 1 +val_306 1 +val_307 2 +val_308 1 +val_309 2 +val_310 1 +val_311 3 +val_315 1 +val_316 3 +val_317 2 +val_318 3 +val_321 2 +val_322 2 +val_323 1 +val_325 2 +val_327 3 +val_33 1 +val_331 2 +val_332 1 +val_333 2 +val_335 1 +val_336 1 +val_338 1 +val_339 1 +val_34 1 +val_341 1 +val_342 2 +val_344 2 +val_345 1 +val_348 5 +val_35 3 +val_351 1 +val_353 2 +val_356 1 +val_360 1 +val_362 1 +val_364 1 +val_365 1 +val_366 1 +val_367 2 +val_368 1 val_369 3 +val_37 2 +val_373 1 +val_374 1 +val_375 1 +val_377 1 +val_378 1 +val_379 1 +val_382 2 val_384 3 +val_386 1 +val_389 1 +val_392 1 +val_393 1 +val_394 1 +val_395 2 val_396 3 +val_397 2 +val_399 2 +val_4 1 +val_400 1 +val_401 5 +val_402 1 val_403 3 +val_404 2 +val_406 4 +val_407 1 val_409 3 +val_41 1 +val_411 1 +val_413 2 +val_414 2 val_417 3 -val_5 3 +val_418 1 +val_419 1 +val_42 2 +val_421 1 +val_424 2 +val_427 1 +val_429 2 +val_43 1 val_430 3 -val_70 3 -val_119 3 -val_0 3 val_431 3 +val_432 1 +val_435 1 +val_436 1 +val_437 1 val_438 3 -val_480 3 -val_193 3 -val_199 3 -val_208 3 -val_187 3 -val_273 3 -val_298 3 +val_439 2 +val_44 1 +val_443 1 +val_444 1 +val_446 1 +val_448 1 +val_449 1 +val_452 1 +val_453 1 val_454 3 -val_311 3 -val_316 3 +val_455 1 +val_457 1 +val_458 2 +val_459 2 +val_460 1 +val_462 2 +val_463 2 val_466 3 -val_90 3 -val_128 3 -val_318 3 -val_327 3 -val_167 3 -val_35 3 +val_467 1 val_468 4 -val_489 4 -val_406 4 -val_169 4 -val_138 4 -val_277 4 val_469 5 -val_401 5 -val_230 5 -val_348 5 -PREHOOK: query: -- dyn partitions -CREATE TABLE tmp_src_part (c string) PARTITIONED BY (d int) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@tmp_src_part -POSTHOOK: query: -- dyn partitions -CREATE TABLE tmp_src_part (c string) PARTITIONED BY (d int) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@tmp_src_part -PREHOOK: query: EXPLAIN INSERT INTO TABLE tmp_src_part PARTITION (d) SELECT * FROM tmp_src -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO TABLE tmp_src_part PARTITION (d) SELECT * FROM tmp_src -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-2 depends on stages: Stage-1 - Stage-0 depends on stages: Stage-2 - Stage-3 depends on stages: Stage-0 - -STAGE PLANS: - Stage: Stage-1 +val_47 1 +val_470 1 +val_472 1 +val_475 1 +val_477 1 +val_478 2 +val_479 1 +val_480 3 +val_481 1 +val_482 1 +val_483 1 +val_484 1 +val_485 1 +val_487 1 +val_489 4 +val_490 1 +val_491 1 +val_492 2 +val_493 1 +val_494 1 +val_495 1 +val_496 1 +val_497 1 +val_498 3 +val_5 3 +val_51 2 +val_53 1 +val_54 1 +val_57 1 +val_58 2 +val_64 1 +val_65 1 +val_66 1 +val_67 2 +val_69 1 +val_70 3 +val_72 2 +val_74 1 +val_76 2 +val_77 1 +val_78 1 +val_8 1 +val_80 1 +val_82 1 +val_83 2 +val_84 2 +val_85 1 +val_86 1 +val_87 1 +val_9 1 +val_90 3 +val_92 1 +val_95 2 +val_96 1 +val_97 2 +val_98 2 +PREHOOK: query: -- dyn partitions +CREATE TABLE tmp_src_part (c string) PARTITIONED BY (d int) +PREHOOK: type: CREATETABLE +PREHOOK: Output: database:default +PREHOOK: Output: default@tmp_src_part +POSTHOOK: query: -- dyn partitions +CREATE TABLE tmp_src_part (c string) PARTITIONED BY (d int) +POSTHOOK: type: CREATETABLE +POSTHOOK: Output: database:default +POSTHOOK: Output: default@tmp_src_part +PREHOOK: query: EXPLAIN INSERT INTO TABLE tmp_src_part PARTITION (d) SELECT * FROM tmp_src +PREHOOK: type: QUERY +POSTHOOK: query: EXPLAIN INSERT INTO TABLE tmp_src_part PARTITION (d) SELECT * FROM tmp_src +POSTHOOK: type: QUERY +STAGE DEPENDENCIES: + Stage-1 is a root stage + Stage-2 depends on stages: Stage-1 + Stage-0 depends on stages: Stage-2 + Stage-3 depends on stages: Stage-0 + +STAGE PLANS: + Stage: Stage-1 Tez #### A masked pattern was here #### Vertices: @@ -512,315 +516,315 @@ POSTHOOK: Input: default@tmp_src_part@d=3 POSTHOOK: Input: default@tmp_src_part@d=4 POSTHOOK: Input: default@tmp_src_part@d=5 #### A masked pattern was here #### -val_490 1 -val_287 1 -val_286 1 -val_285 1 -val_284 1 -val_283 1 +val_0 3 +val_10 1 +val_100 2 +val_103 2 +val_104 2 +val_105 1 +val_11 1 +val_111 1 +val_113 2 val_114 1 -val_487 1 -val_485 1 -val_28 1 -val_484 1 -val_181 1 -val_275 1 -val_274 1 -val_183 1 -val_483 1 -val_27 1 -val_266 1 -val_482 1 -val_263 1 -val_262 1 -val_260 1 -val_481 1 -val_258 1 -val_257 1 val_116 1 -val_479 1 -val_252 1 -val_249 1 -val_248 1 -val_247 1 -val_244 1 -val_92 1 -val_241 1 -val_477 1 -val_475 1 -val_472 1 -val_470 1 -val_235 1 -val_47 1 -val_186 1 +val_118 2 +val_119 3 +val_12 2 +val_120 2 +val_125 2 val_126 1 -val_228 1 -val_226 1 +val_128 3 +val_129 2 val_131 1 -val_467 1 -val_222 1 val_133 1 -val_82 1 -val_218 1 -val_80 1 -val_460 1 -val_214 1 -val_8 1 -val_78 1 -val_189 1 -val_457 1 -val_455 1 +val_134 2 val_136 1 -val_202 1 -val_201 1 -val_453 1 -val_20 1 -val_2 1 -val_19 1 -val_452 1 -val_196 1 -val_449 1 -val_194 1 -val_190 1 -val_192 1 -val_448 1 -val_446 1 -val_444 1 -val_443 1 -val_44 1 -val_77 1 +val_137 2 +val_138 4 val_143 1 -val_437 1 -val_436 1 -val_435 1 -val_432 1 val_145 1 +val_146 2 +val_149 2 +val_15 2 val_150 1 -val_43 1 -val_10 1 -val_427 1 -val_74 1 -val_421 1 -val_9 1 -val_419 1 -val_418 1 +val_152 2 val_153 1 -val_105 1 -val_69 1 -val_411 1 -val_41 1 val_155 1 -val_407 1 val_156 1 -val_87 1 val_157 1 -val_402 1 val_158 1 -val_400 1 -val_4 1 -val_66 1 -val_65 1 val_160 1 -val_64 1 -val_394 1 -val_393 1 -val_392 1 -val_389 1 -val_386 1 val_162 1 -val_86 1 -val_379 1 -val_378 1 -val_377 1 -val_375 1 -val_374 1 -val_373 1 -val_57 1 val_163 1 -val_368 1 -val_54 1 -val_366 1 -val_365 1 -val_364 1 -val_362 1 -val_360 1 -val_356 1 -val_53 1 -val_351 1 +val_164 2 +val_165 2 val_166 1 +val_167 3 val_168 1 -val_345 1 -val_85 1 -val_11 1 -val_341 1 -val_34 1 -val_339 1 -val_338 1 -val_336 1 -val_335 1 -val_111 1 -val_332 1 -val_497 1 -val_33 1 +val_169 4 val_17 1 -val_496 1 -val_323 1 -val_495 1 -val_494 1 val_170 1 -val_493 1 +val_172 2 +val_174 2 +val_175 2 +val_176 2 val_177 1 -val_315 1 val_178 1 -val_310 1 -val_96 1 -val_308 1 -val_491 1 -val_306 1 -val_305 1 -val_302 1 -val_30 1 +val_179 2 +val_18 2 val_180 1 -val_296 1 -val_292 1 -val_291 1 +val_181 1 +val_183 1 +val_186 1 +val_187 3 +val_189 1 +val_19 1 +val_190 1 +val_191 2 +val_192 1 +val_193 3 +val_194 1 +val_195 2 +val_196 1 +val_197 2 +val_199 3 +val_2 1 +val_20 1 +val_200 2 +val_201 1 +val_202 1 +val_203 2 +val_205 2 +val_207 2 +val_208 3 +val_209 2 +val_213 2 +val_214 1 +val_216 2 +val_217 2 +val_218 1 +val_219 2 +val_221 2 +val_222 1 +val_223 2 +val_224 2 +val_226 1 +val_228 1 +val_229 2 +val_230 5 +val_233 2 +val_235 1 +val_237 2 +val_238 2 +val_239 2 +val_24 2 +val_241 1 +val_242 2 +val_244 1 +val_247 1 +val_248 1 +val_249 1 +val_252 1 +val_255 2 +val_256 2 +val_257 1 +val_258 1 +val_26 2 +val_260 1 +val_262 1 +val_263 1 +val_265 2 +val_266 1 +val_27 1 +val_272 2 +val_273 3 +val_274 1 +val_275 1 +val_277 4 +val_278 2 +val_28 1 +val_280 2 +val_281 2 +val_282 2 +val_283 1 +val_284 1 +val_285 1 +val_286 1 +val_287 1 +val_288 2 val_289 1 -val_98 2 -val_97 2 -val_95 2 -val_84 2 -val_83 2 -val_76 2 -val_72 2 -val_67 2 -val_58 2 -val_51 2 -val_492 2 -val_478 2 -val_463 2 -val_462 2 -val_459 2 -val_458 2 -val_439 2 -val_429 2 -val_424 2 -val_42 2 -val_414 2 -val_413 2 -val_404 2 -val_399 2 -val_397 2 -val_395 2 -val_382 2 -val_37 2 -val_367 2 -val_353 2 -val_344 2 -val_342 2 -val_333 2 -val_331 2 -val_325 2 -val_322 2 -val_321 2 -val_317 2 -val_309 2 +val_291 1 +val_292 1 +val_296 1 +val_298 3 +val_30 1 +val_302 1 +val_305 1 +val_306 1 val_307 2 -val_288 2 -val_282 2 -val_281 2 -val_280 2 -val_278 2 -val_272 2 -val_265 2 -val_26 2 -val_256 2 -val_255 2 -val_242 2 -val_24 2 -val_239 2 -val_238 2 -val_237 2 -val_233 2 -val_229 2 -val_224 2 -val_223 2 -val_221 2 -val_219 2 -val_217 2 -val_216 2 -val_213 2 -val_209 2 -val_207 2 -val_205 2 -val_203 2 -val_200 2 -val_197 2 -val_195 2 -val_191 2 -val_18 2 -val_179 2 -val_176 2 -val_175 2 -val_174 2 -val_172 2 -val_165 2 -val_164 2 -val_152 2 -val_15 2 -val_149 2 -val_146 2 -val_137 2 -val_134 2 -val_129 2 -val_125 2 -val_120 2 -val_12 2 -val_118 2 -val_113 2 -val_104 2 -val_103 2 -val_100 2 -val_498 3 +val_308 1 +val_309 2 +val_310 1 +val_311 3 +val_315 1 +val_316 3 +val_317 2 +val_318 3 +val_321 2 +val_322 2 +val_323 1 +val_325 2 +val_327 3 +val_33 1 +val_331 2 +val_332 1 +val_333 2 +val_335 1 +val_336 1 +val_338 1 +val_339 1 +val_34 1 +val_341 1 +val_342 2 +val_344 2 +val_345 1 +val_348 5 +val_35 3 +val_351 1 +val_353 2 +val_356 1 +val_360 1 +val_362 1 +val_364 1 +val_365 1 +val_366 1 +val_367 2 +val_368 1 val_369 3 +val_37 2 +val_373 1 +val_374 1 +val_375 1 +val_377 1 +val_378 1 +val_379 1 +val_382 2 val_384 3 +val_386 1 +val_389 1 +val_392 1 +val_393 1 +val_394 1 +val_395 2 val_396 3 +val_397 2 +val_399 2 +val_4 1 +val_400 1 +val_401 5 +val_402 1 val_403 3 +val_404 2 +val_406 4 +val_407 1 val_409 3 +val_41 1 +val_411 1 +val_413 2 +val_414 2 val_417 3 -val_5 3 +val_418 1 +val_419 1 +val_42 2 +val_421 1 +val_424 2 +val_427 1 +val_429 2 +val_43 1 val_430 3 -val_70 3 -val_119 3 -val_0 3 val_431 3 +val_432 1 +val_435 1 +val_436 1 +val_437 1 val_438 3 -val_480 3 -val_193 3 -val_199 3 -val_208 3 -val_187 3 -val_273 3 -val_298 3 +val_439 2 +val_44 1 +val_443 1 +val_444 1 +val_446 1 +val_448 1 +val_449 1 +val_452 1 +val_453 1 val_454 3 -val_311 3 -val_316 3 +val_455 1 +val_457 1 +val_458 2 +val_459 2 +val_460 1 +val_462 2 +val_463 2 val_466 3 -val_90 3 -val_128 3 -val_318 3 -val_327 3 -val_167 3 -val_35 3 +val_467 1 val_468 4 -val_489 4 -val_406 4 -val_169 4 -val_138 4 -val_277 4 val_469 5 -val_401 5 -val_230 5 -val_348 5 +val_47 1 +val_470 1 +val_472 1 +val_475 1 +val_477 1 +val_478 2 +val_479 1 +val_480 3 +val_481 1 +val_482 1 +val_483 1 +val_484 1 +val_485 1 +val_487 1 +val_489 4 +val_490 1 +val_491 1 +val_492 2 +val_493 1 +val_494 1 +val_495 1 +val_496 1 +val_497 1 +val_498 3 +val_5 3 +val_51 2 +val_53 1 +val_54 1 +val_57 1 +val_58 2 +val_64 1 +val_65 1 +val_66 1 +val_67 2 +val_69 1 +val_70 3 +val_72 2 +val_74 1 +val_76 2 +val_77 1 +val_78 1 +val_8 1 +val_80 1 +val_82 1 +val_83 2 +val_84 2 +val_85 1 +val_86 1 +val_87 1 +val_9 1 +val_90 3 +val_92 1 +val_95 2 +val_96 1 +val_97 2 +val_98 2 PREHOOK: query: -- multi insert CREATE TABLE even (c int, d string) PREHOOK: type: CREATETABLE @@ -953,253 +957,253 @@ POSTHOOK: query: SELECT * FROM even POSTHOOK: type: QUERY POSTHOOK: Input: default@even #### A masked pattern was here #### -238 val_238 -86 val_86 -278 val_278 -98 val_98 -484 val_484 -150 val_150 -224 val_224 -66 val_66 +0 val_0 +0 val_0 +0 val_0 +10 val_10 +100 val_100 +100 val_100 +104 val_104 +104 val_104 +114 val_114 +116 val_116 +118 val_118 +118 val_118 +12 val_12 +12 val_12 +120 val_120 +120 val_120 +126 val_126 +128 val_128 128 val_128 +128 val_128 +134 val_134 +134 val_134 +136 val_136 +138 val_138 +138 val_138 +138 val_138 +138 val_138 146 val_146 -406 val_406 -374 val_374 +146 val_146 +150 val_150 152 val_152 -82 val_82 +152 val_152 +156 val_156 +158 val_158 +160 val_160 +162 val_162 +164 val_164 +164 val_164 166 val_166 -430 val_430 -252 val_252 -292 val_292 -338 val_338 -446 val_446 -394 val_394 -482 val_482 +168 val_168 +170 val_170 +172 val_172 +172 val_172 174 val_174 -494 val_494 -466 val_466 -208 val_208 174 val_174 -396 val_396 -162 val_162 -266 val_266 -342 val_342 -0 val_0 -128 val_128 -316 val_316 -302 val_302 -438 val_438 -170 val_170 -20 val_20 -378 val_378 -92 val_92 -72 val_72 -4 val_4 -280 val_280 -208 val_208 -356 val_356 -382 val_382 -498 val_498 -386 val_386 -192 val_192 -286 val_286 176 val_176 -54 val_54 -138 val_138 -216 val_216 -430 val_430 -278 val_278 176 val_176 -318 val_318 -332 val_332 +178 val_178 +18 val_18 +18 val_18 180 val_180 -284 val_284 -12 val_12 +186 val_186 +190 val_190 +192 val_192 +194 val_194 +196 val_196 +2 val_2 +20 val_20 +200 val_200 +200 val_200 +202 val_202 +208 val_208 +208 val_208 +208 val_208 +214 val_214 +216 val_216 +216 val_216 +218 val_218 +222 val_222 +224 val_224 +224 val_224 +226 val_226 +228 val_228 230 val_230 -260 val_260 -404 val_404 -384 val_384 -272 val_272 -138 val_138 -84 val_84 -348 val_348 -466 val_466 -58 val_58 -8 val_8 230 val_230 -208 val_208 -348 val_348 +230 val_230 +230 val_230 +230 val_230 +238 val_238 +238 val_238 24 val_24 -172 val_172 -42 val_42 -158 val_158 -496 val_496 -0 val_0 -322 val_322 -468 val_468 -454 val_454 -100 val_100 -298 val_298 -418 val_418 -96 val_96 +24 val_24 +242 val_242 +242 val_242 +244 val_244 +248 val_248 +252 val_252 +256 val_256 +256 val_256 +258 val_258 26 val_26 -230 val_230 -120 val_120 -404 val_404 -436 val_436 -156 val_156 -468 val_468 -308 val_308 -196 val_196 -288 val_288 -98 val_98 +26 val_26 +260 val_260 +262 val_262 +266 val_266 +272 val_272 +272 val_272 +274 val_274 +278 val_278 +278 val_278 +28 val_28 +280 val_280 +280 val_280 282 val_282 -318 val_318 -318 val_318 -470 val_470 -316 val_316 -0 val_0 -490 val_490 -364 val_364 -118 val_118 -134 val_134 282 val_282 -138 val_138 -238 val_238 -118 val_118 -72 val_72 -90 val_90 -10 val_10 +284 val_284 +286 val_286 +288 val_288 +288 val_288 +292 val_292 +296 val_296 +298 val_298 +298 val_298 +298 val_298 +30 val_30 +302 val_302 306 val_306 -224 val_224 -242 val_242 -392 val_392 -272 val_272 -242 val_242 -452 val_452 -226 val_226 -402 val_402 -396 val_396 -58 val_58 +308 val_308 +310 val_310 +316 val_316 +316 val_316 +316 val_316 +318 val_318 +318 val_318 +318 val_318 +322 val_322 +322 val_322 +332 val_332 336 val_336 -168 val_168 +338 val_338 34 val_34 -472 val_472 -322 val_322 -498 val_498 -160 val_160 -42 val_42 -430 val_430 -458 val_458 -78 val_78 -76 val_76 -492 val_492 -218 val_218 -228 val_228 -138 val_138 -30 val_30 -64 val_64 -468 val_468 -76 val_76 -74 val_74 342 val_342 -230 val_230 -368 val_368 -296 val_296 -216 val_216 +342 val_342 344 val_344 -274 val_274 -116 val_116 -256 val_256 -70 val_70 -480 val_480 -288 val_288 -244 val_244 -438 val_438 -128 val_128 -432 val_432 -202 val_202 -316 val_316 -280 val_280 -2 val_2 -80 val_80 -44 val_44 -104 val_104 -466 val_466 +344 val_344 +348 val_348 +348 val_348 +348 val_348 +348 val_348 +348 val_348 +356 val_356 +360 val_360 +362 val_362 +364 val_364 366 val_366 +368 val_368 +374 val_374 +378 val_378 +382 val_382 +382 val_382 +384 val_384 +384 val_384 +384 val_384 +386 val_386 +392 val_392 +394 val_394 +396 val_396 +396 val_396 +396 val_396 +4 val_4 +400 val_400 +402 val_402 +404 val_404 +404 val_404 406 val_406 -190 val_190 406 val_406 -114 val_114 -258 val_258 -90 val_90 -262 val_262 -348 val_348 +406 val_406 +406 val_406 +414 val_414 +414 val_414 +418 val_418 +42 val_42 +42 val_42 424 val_424 -12 val_12 -396 val_396 -164 val_164 -454 val_454 -478 val_478 -298 val_298 -164 val_164 424 val_424 -382 val_382 -70 val_70 -480 val_480 -24 val_24 -104 val_104 -70 val_70 +430 val_430 +430 val_430 +430 val_430 +432 val_432 +436 val_436 438 val_438 -414 val_414 -200 val_200 -360 val_360 -248 val_248 +438 val_438 +438 val_438 +44 val_44 444 val_444 -120 val_120 -230 val_230 -478 val_478 -178 val_178 -468 val_468 -310 val_310 +446 val_446 +448 val_448 +452 val_452 +454 val_454 +454 val_454 +454 val_454 +458 val_458 +458 val_458 460 val_460 -480 val_480 -136 val_136 -172 val_172 -214 val_214 462 val_462 -406 val_406 -454 val_454 -384 val_384 -256 val_256 -26 val_26 -134 val_134 -384 val_384 -18 val_18 462 val_462 +466 val_466 +466 val_466 +466 val_466 +468 val_468 +468 val_468 +468 val_468 +468 val_468 +470 val_470 +472 val_472 +478 val_478 +478 val_478 +480 val_480 +480 val_480 +480 val_480 +482 val_482 +484 val_484 +490 val_490 492 val_492 -100 val_100 -298 val_298 +492 val_492 +494 val_494 +496 val_496 498 val_498 -146 val_146 -458 val_458 -362 val_362 -186 val_186 -348 val_348 -18 val_18 -344 val_344 +498 val_498 +498 val_498 +54 val_54 +58 val_58 +58 val_58 +64 val_64 +66 val_66 +70 val_70 +70 val_70 +70 val_70 +72 val_72 +72 val_72 +74 val_74 +76 val_76 +76 val_76 +78 val_78 +8 val_8 +80 val_80 +82 val_82 84 val_84 -28 val_28 -448 val_448 -152 val_152 -348 val_348 -194 val_194 -414 val_414 -222 val_222 -126 val_126 +84 val_84 +86 val_86 90 val_90 -400 val_400 -200 val_200 +90 val_90 +90 val_90 +92 val_92 +96 val_96 +98 val_98 +98 val_98 PREHOOK: query: SELECT * FROM odd PREHOOK: type: QUERY PREHOOK: Input: default@odd @@ -1208,258 +1212,258 @@ POSTHOOK: query: SELECT * FROM odd POSTHOOK: type: QUERY POSTHOOK: Input: default@odd #### A masked pattern was here #### -311 val_311 -27 val_27 -165 val_165 -409 val_409 -255 val_255 -265 val_265 -193 val_193 -401 val_401 -273 val_273 -369 val_369 -213 val_213 -429 val_429 -469 val_469 +103 val_103 +103 val_103 +105 val_105 +11 val_11 +111 val_111 +113 val_113 +113 val_113 +119 val_119 +119 val_119 +119 val_119 +125 val_125 +125 val_125 +129 val_129 +129 val_129 +131 val_131 +133 val_133 +137 val_137 +137 val_137 +143 val_143 145 val_145 -495 val_495 -37 val_37 -327 val_327 -281 val_281 -277 val_277 -209 val_209 +149 val_149 +149 val_149 +15 val_15 15 val_15 -403 val_403 -417 val_417 -219 val_219 -287 val_287 153 val_153 -193 val_193 -459 val_459 -237 val_237 -413 val_413 -207 val_207 -199 val_199 -399 val_399 -247 val_247 -417 val_417 -489 val_489 -377 val_377 -397 val_397 -309 val_309 -365 val_365 -439 val_439 -367 val_367 -325 val_325 -167 val_167 -195 val_195 -475 val_475 -17 val_17 -113 val_113 155 val_155 -203 val_203 -339 val_339 -455 val_455 -311 val_311 -57 val_57 -205 val_205 -149 val_149 -345 val_345 -129 val_129 -489 val_489 157 val_157 -221 val_221 -111 val_111 -47 val_47 -35 val_35 -427 val_427 -277 val_277 -399 val_399 -169 val_169 -125 val_125 -437 val_437 -469 val_469 -187 val_187 -459 val_459 -51 val_51 -103 val_103 -239 val_239 -213 val_213 -289 val_289 -221 val_221 -65 val_65 -311 val_311 -275 val_275 -137 val_137 -241 val_241 -83 val_83 -333 val_333 -181 val_181 -67 val_67 -489 val_489 -353 val_353 -373 val_373 -217 val_217 -411 val_411 -463 val_463 -431 val_431 -179 val_179 -129 val_129 -119 val_119 -197 val_197 -393 val_393 -199 val_199 -191 val_191 +163 val_163 165 val_165 -327 val_327 -205 val_205 -131 val_131 -51 val_51 -43 val_43 -469 val_469 -95 val_95 -481 val_481 -457 val_457 -197 val_197 -187 val_187 -409 val_409 -137 val_137 -369 val_369 +165 val_165 +167 val_167 +167 val_167 +167 val_167 169 val_169 -413 val_413 -85 val_85 -77 val_77 -87 val_87 +169 val_169 +169 val_169 +169 val_169 +17 val_17 +175 val_175 +175 val_175 +177 val_177 179 val_179 -395 val_395 -419 val_419 -15 val_15 -307 val_307 +179 val_179 +181 val_181 +183 val_183 +187 val_187 +187 val_187 +187 val_187 +189 val_189 19 val_19 -435 val_435 -277 val_277 -273 val_273 -309 val_309 -389 val_389 -327 val_327 -369 val_369 -331 val_331 -401 val_401 -177 val_177 -5 val_5 -497 val_497 -317 val_317 -395 val_395 -35 val_35 -95 val_95 -11 val_11 -229 val_229 -233 val_233 -143 val_143 -195 val_195 -321 val_321 -119 val_119 -489 val_489 -41 val_41 -223 val_223 -149 val_149 -449 val_449 -453 val_453 +191 val_191 +191 val_191 +193 val_193 +193 val_193 +193 val_193 +195 val_195 +195 val_195 +197 val_197 +197 val_197 +199 val_199 +199 val_199 +199 val_199 +201 val_201 +203 val_203 +203 val_203 +205 val_205 +205 val_205 +207 val_207 +207 val_207 209 val_209 -69 val_69 -33 val_33 -103 val_103 -113 val_113 -367 val_367 -167 val_167 +209 val_209 +213 val_213 +213 val_213 +217 val_217 +217 val_217 219 val_219 -239 val_239 -485 val_485 +219 val_219 +221 val_221 +221 val_221 +223 val_223 223 val_223 -263 val_263 -487 val_487 -401 val_401 -191 val_191 -5 val_5 -467 val_467 229 val_229 -469 val_469 -463 val_463 -35 val_35 -283 val_283 -331 val_331 +229 val_229 +233 val_233 +233 val_233 235 val_235 -193 val_193 -321 val_321 -335 val_335 -175 val_175 -403 val_403 -483 val_483 -53 val_53 -105 val_105 +237 val_237 +237 val_237 +239 val_239 +239 val_239 +241 val_241 +247 val_247 +249 val_249 +255 val_255 +255 val_255 257 val_257 -409 val_409 -401 val_401 -203 val_203 -201 val_201 -217 val_217 -431 val_431 -125 val_125 -431 val_431 -187 val_187 -5 val_5 -397 val_397 +263 val_263 +265 val_265 +265 val_265 +27 val_27 +273 val_273 +273 val_273 +273 val_273 +275 val_275 +277 val_277 +277 val_277 +277 val_277 +277 val_277 +281 val_281 +281 val_281 +283 val_283 +285 val_285 +287 val_287 +289 val_289 291 val_291 -351 val_351 -255 val_255 -163 val_163 -119 val_119 -491 val_491 -237 val_237 -439 val_439 -479 val_479 305 val_305 -417 val_417 -199 val_199 -429 val_429 -169 val_169 -443 val_443 +307 val_307 +307 val_307 +309 val_309 +309 val_309 +311 val_311 +311 val_311 +311 val_311 +315 val_315 +317 val_317 +317 val_317 +321 val_321 +321 val_321 323 val_323 325 val_325 -277 val_277 -317 val_317 +325 val_325 +327 val_327 +327 val_327 +327 val_327 +33 val_33 +331 val_331 +331 val_331 333 val_333 -493 val_493 -207 val_207 -249 val_249 -265 val_265 -83 val_83 +333 val_333 +335 val_335 +339 val_339 +341 val_341 +345 val_345 +35 val_35 +35 val_35 +35 val_35 +351 val_351 353 val_353 -233 val_233 -133 val_133 -175 val_175 -189 val_189 +353 val_353 +365 val_365 +367 val_367 +367 val_367 +369 val_369 +369 val_369 +369 val_369 +37 val_37 +37 val_37 +373 val_373 375 val_375 +377 val_377 +379 val_379 +389 val_389 +393 val_393 +395 val_395 +395 val_395 +397 val_397 +397 val_397 +399 val_399 +399 val_399 401 val_401 -421 val_421 +401 val_401 +401 val_401 +401 val_401 +401 val_401 +403 val_403 +403 val_403 +403 val_403 407 val_407 +409 val_409 +409 val_409 +409 val_409 +41 val_41 +411 val_411 +413 val_413 +413 val_413 +417 val_417 +417 val_417 +417 val_417 +419 val_419 +421 val_421 +427 val_427 +429 val_429 +429 val_429 +43 val_43 +431 val_431 +431 val_431 +431 val_431 +435 val_435 +437 val_437 +439 val_439 +439 val_439 +443 val_443 +449 val_449 +453 val_453 +455 val_455 +457 val_457 +459 val_459 +459 val_459 +463 val_463 +463 val_463 +467 val_467 +469 val_469 +469 val_469 +469 val_469 +469 val_469 +469 val_469 +47 val_47 +475 val_475 +477 val_477 +479 val_479 +481 val_481 +483 val_483 +485 val_485 +487 val_487 +489 val_489 +489 val_489 +489 val_489 +489 val_489 +491 val_491 +493 val_493 +495 val_495 +497 val_497 +5 val_5 +5 val_5 +5 val_5 +51 val_51 +51 val_51 +53 val_53 +57 val_57 +65 val_65 67 val_67 -379 val_379 +67 val_67 +69 val_69 +77 val_77 +83 val_83 +83 val_83 +85 val_85 +87 val_87 9 val_9 -341 val_341 -285 val_285 -167 val_167 -273 val_273 -183 val_183 -281 val_281 +95 val_95 +95 val_95 97 val_97 -469 val_469 -315 val_315 -37 val_37 -307 val_307 -477 val_477 -169 val_169 -403 val_403 97 val_97 PREHOOK: query: -- create empty table CREATE TABLE empty STORED AS orc AS SELECT * FROM tmp_src_part WHERE d = -1000
http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out b/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out index e782c73..59c8df4 100644 --- a/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out +++ b/ql/src/test/results/clientpositive/tez/tez_join_hash.q.out @@ -1,8 +1,12 @@ -PREHOOK: query: create table orc_src (key string, value string) STORED AS ORC +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table orc_src (key string, value string) STORED AS ORC PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@orc_src -POSTHOOK: query: create table orc_src (key string, value string) STORED AS ORC +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table orc_src (key string, value string) STORED AS ORC POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@orc_src @@ -327,72 +331,143 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 #### A masked pattern was here #### 0 468 10 20 +100 144 103 144 +104 144 105 20 +11 20 +111 20 +113 144 +114 20 116 20 +118 144 +119 468 +12 144 120 144 125 144 +126 20 +128 468 129 144 131 20 +133 20 134 144 136 20 +137 144 +138 1088 143 20 145 20 +146 144 149 144 +15 144 150 20 +152 144 +153 20 155 20 +156 20 157 20 158 20 160 20 +162 20 163 20 164 144 +165 144 166 20 +167 468 +168 20 +169 1088 17 20 170 20 172 144 +174 144 +175 144 +176 144 +177 20 +178 20 +179 144 +18 144 180 20 +181 20 183 20 +186 20 +187 468 189 20 19 20 190 20 191 144 +192 20 193 468 +194 20 195 144 196 20 +197 144 +199 468 +2 20 20 20 +200 144 +201 20 +202 20 +203 144 205 144 207 144 +208 468 209 144 213 144 +214 20 216 144 217 144 +218 20 +219 144 +221 144 +222 20 223 144 224 144 +226 20 228 20 229 144 +230 2100 233 144 235 20 +237 144 238 144 239 144 24 144 241 20 +242 144 244 20 247 20 248 20 +249 20 +252 20 255 144 +256 144 +257 20 258 20 26 144 260 20 +262 20 263 20 265 144 266 20 +27 20 272 144 273 468 274 20 +275 20 +277 1088 +278 144 28 20 +280 144 281 144 +282 144 +283 20 +284 20 +285 20 286 20 +287 20 +288 144 +289 20 291 20 +292 20 296 20 298 468 30 20 @@ -402,28 +477,46 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 307 144 308 20 309 144 +310 20 +311 468 315 20 316 468 317 144 318 468 321 144 +322 144 +323 20 325 144 +327 468 33 20 331 144 332 20 +333 144 335 20 +336 20 +338 20 339 20 +34 20 +341 20 342 144 +344 144 345 20 +348 2100 +35 468 +351 20 353 144 356 20 360 20 +362 20 +364 20 +365 20 366 20 367 144 368 20 369 468 37 144 373 20 +374 20 375 20 377 20 378 20 @@ -432,40 +525,81 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 384 468 386 20 389 20 +392 20 +393 20 394 20 395 144 396 468 +397 144 399 144 +4 20 400 20 401 2100 402 20 +403 468 +404 144 406 1088 407 20 +409 468 41 20 +411 20 413 144 414 144 +417 468 +418 20 +419 20 42 144 +421 20 +424 144 +427 20 +429 144 +43 20 430 468 431 468 +432 20 +435 20 436 20 +437 20 +438 468 +439 144 44 20 +443 20 +444 20 446 20 448 20 449 20 452 20 +453 20 +454 468 +455 20 +457 20 +458 144 459 144 +460 20 462 144 +463 144 466 468 467 20 468 1088 +469 2100 47 20 +470 20 472 20 +475 20 +477 20 +478 144 +479 20 480 468 +481 20 482 20 +483 20 484 20 485 20 487 20 +489 1088 490 20 +491 20 +492 144 493 20 494 20 495 20 @@ -474,164 +608,34 @@ POSTHOOK: Input: default@srcpart@ds=2008-04-09/hr=12 498 468 5 468 51 144 +53 20 54 20 57 20 58 144 +64 20 65 20 66 20 +67 144 69 20 70 468 +72 144 74 20 +76 144 77 20 78 20 8 20 80 20 +82 20 +83 144 84 144 85 20 +86 20 87 20 9 20 +90 468 92 20 95 144 96 20 -100 144 -104 144 -11 20 -111 20 -113 144 -114 20 -118 144 -119 468 -12 144 -126 20 -128 468 -133 20 -137 144 -138 1088 -146 144 -15 144 -152 144 -153 20 -156 20 -162 20 -165 144 -167 468 -168 20 -169 1088 -174 144 -175 144 -176 144 -177 20 -178 20 -179 144 -18 144 -181 20 -186 20 -187 468 -192 20 -194 20 -197 144 -199 468 -2 20 -200 144 -201 20 -202 20 -203 144 -208 468 -214 20 -218 20 -219 144 -221 144 -222 20 -226 20 -230 2100 -237 144 -242 144 -249 20 -252 20 -256 144 -257 20 -262 20 -27 20 -275 20 -277 1088 -278 144 -280 144 -282 144 -283 20 -284 20 -285 20 -287 20 -288 144 -289 20 -292 20 -310 20 -311 468 -322 144 -323 20 -327 468 -333 144 -336 20 -338 20 -34 20 -341 20 -344 144 -348 2100 -35 468 -351 20 -362 20 -364 20 -365 20 -374 20 -392 20 -393 20 -397 144 -4 20 -403 468 -404 144 -409 468 -411 20 -417 468 -418 20 -419 20 -421 20 -424 144 -427 20 -429 144 -43 20 -432 20 -435 20 -437 20 -438 468 -439 144 -443 20 -444 20 -453 20 -454 468 -455 20 -457 20 -458 144 -460 20 -463 144 -469 2100 -470 20 -475 20 -477 20 -478 144 -479 20 -481 20 -483 20 -489 1088 -491 20 -492 144 -53 20 -64 20 -67 144 -72 144 -76 144 -82 20 -83 144 -86 20 -90 468 97 144 98 144 PREHOOK: query: select key, count(*) from (select x.key as key, y.value as value from http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out b/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out index 668f75b..31f7275 100644 --- a/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out +++ b/ql/src/test/results/clientpositive/tez/tez_joins_explain.q.out @@ -1,10 +1,8 @@ PREHOOK: query: -- SORT_QUERY_RESULTS - explain select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key PREHOOK: type: QUERY POSTHOOK: query: -- SORT_QUERY_RESULTS - explain select * from (select b.key, b.value from src1 a left outer join src b on (a.key = b.key) order by b.key) x right outer join src c on (x.value = c.value) order by x.key POSTHOOK: type: QUERY http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/tez_multi_union.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/tez_multi_union.q.out b/ql/src/test/results/clientpositive/tez/tez_multi_union.q.out index a649431..fbc1c2f 100644 --- a/ql/src/test/results/clientpositive/tez/tez_multi_union.q.out +++ b/ql/src/test/results/clientpositive/tez/tez_multi_union.q.out @@ -1,4 +1,5 @@ -PREHOOK: query: select key from +PREHOOK: query: -- SORT_QUERY_RESULTS +select key from ( select key from src union all @@ -9,7 +10,8 @@ select key from src PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### -POSTHOOK: query: select key from +POSTHOOK: query: -- SORT_QUERY_RESULTS +select key from ( select key from src union all @@ -21,811 +23,811 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### 0 +0 +0 +0 +10 10 100 +100 +100 +103 +103 103 104 +104 +104 105 +105 +11 11 111 +111 +113 113 +113 +114 114 116 +116 +118 118 +118 +119 119 +119 +119 +12 +12 12 120 +120 +120 +125 +125 125 126 +126 +128 +128 +128 128 129 +129 +129 131 +131 +133 133 134 +134 +134 136 +136 +137 137 +137 +138 +138 +138 138 +138 +143 143 145 +145 +146 146 +146 +149 149 +149 +15 15 +15 +150 150 152 +152 +152 153 +153 +155 155 156 +156 +157 157 158 +158 +160 160 162 +162 +163 163 164 +164 +164 +165 +165 165 166 +166 +167 +167 +167 167 168 +168 +169 +169 +169 169 +169 +17 17 170 +170 +172 172 +172 +174 174 +174 +175 175 +175 +176 176 +176 +177 177 178 +178 +179 179 +179 +18 18 +18 +180 180 181 +181 +183 183 186 +186 +187 +187 +187 187 189 +189 +19 19 190 +190 +191 191 +191 +192 192 193 +193 +193 +193 +194 194 195 +195 +195 196 +196 +197 197 +197 +199 +199 +199 199 2 +2 +20 20 200 +200 +200 201 +201 +202 202 203 +203 +203 +205 +205 205 207 +207 +207 +208 +208 208 +208 +209 209 +209 +213 213 +213 +214 214 216 +216 +216 +217 +217 217 218 +218 +219 219 +219 +221 221 +221 +222 222 223 +223 +223 +224 +224 224 226 +226 +228 228 229 +229 +229 +230 +230 +230 +230 230 +230 +233 233 +233 +235 235 237 +237 +237 +238 +238 238 239 +239 +239 +24 +24 24 241 +241 +242 242 +242 +244 244 247 +247 +248 248 249 +249 +252 252 255 +255 +255 +256 +256 256 257 +257 +258 258 26 +26 +26 260 +260 +262 262 263 +263 +265 265 +265 +266 266 27 +27 +272 272 +272 +273 +273 +273 273 274 +274 +275 275 277 +277 +277 +277 +277 +278 +278 278 28 +28 +280 280 +280 +281 281 +281 +282 282 +282 +283 283 284 +284 +285 285 286 +286 +287 287 288 +288 +288 289 +289 +291 291 292 +292 +296 296 298 +298 +298 +298 +30 30 302 +302 +305 305 306 +306 +307 307 +307 +308 308 309 +309 +309 310 +310 +311 +311 +311 311 315 +315 +316 316 +316 +316 +317 +317 317 318 +318 +318 +318 +321 321 +321 +322 322 +322 +323 323 325 +325 +325 +327 +327 327 +327 +33 33 331 +331 +331 332 +332 +333 333 +333 +335 335 336 +336 +338 338 339 +339 +34 34 341 +341 +342 342 +342 +344 344 +344 +345 345 348 +348 +348 +348 +348 +348 +35 +35 +35 35 351 +351 +353 353 +353 +356 356 360 +360 +362 362 364 +364 +365 365 366 +366 +367 367 +367 +368 368 369 +369 +369 +369 +37 37 +37 +373 373 374 +374 +375 375 377 +377 +378 378 379 +379 +382 382 +382 +384 +384 +384 384 386 +386 +389 389 392 +392 +393 393 394 +394 +395 395 +395 +396 +396 +396 396 397 +397 +397 +399 +399 399 4 +4 +400 400 401 +401 +401 +401 +401 +401 +402 402 403 +403 +403 +403 +404 404 +404 +406 +406 +406 406 +406 +407 407 409 +409 +409 +409 +41 41 411 +411 +413 413 +413 +414 414 +414 +417 +417 +417 417 418 +418 +419 419 42 +42 +42 421 +421 +424 424 +424 +427 427 429 +429 +429 43 +43 +430 +430 +430 430 431 +431 +431 +431 +432 432 435 +435 +436 436 437 +437 +438 438 +438 +438 +439 +439 439 44 +44 +443 443 444 +444 +446 446 448 +448 +449 449 452 +452 +453 453 454 +454 +454 +454 +455 455 457 +457 +458 458 +458 +459 459 +459 +460 460 462 +462 +462 463 +463 +463 +466 +466 466 +466 +467 467 468 +468 +468 +468 +468 +469 +469 469 +469 +469 +469 +47 47 470 +470 +472 472 475 +475 +477 477 478 +478 +478 479 +479 +480 +480 +480 480 481 +481 +482 482 483 +483 +484 484 485 +485 +487 487 489 +489 +489 +489 +489 490 +490 +491 491 492 +492 +492 493 +493 +494 494 495 +495 +496 496 497 +497 +498 +498 +498 498 5 +5 +5 +5 +51 51 +51 +53 53 54 +54 +57 57 58 +58 +58 64 +64 +65 65 66 +66 +67 67 +67 +69 69 70 +70 +70 +70 +72 72 +72 +74 74 76 +76 +76 77 +77 +78 78 8 +8 +80 80 82 +82 +83 83 +83 +84 84 +84 +85 85 86 +86 +87 87 9 +9 +90 +90 +90 90 92 +92 +95 95 +95 +96 96 97 +97 +97 98 -238 -86 -311 -27 -165 -409 -255 -278 98 -484 -265 -193 -401 -150 -273 -224 -369 -66 -128 -213 -146 -406 -429 -374 -152 -469 -145 -495 -37 -327 -281 -277 -209 -15 -82 -403 -166 -417 -430 -252 -292 -219 -287 -153 -193 -338 -446 -459 -394 -237 -482 -174 -413 -494 -207 -199 -466 -208 -174 -399 -396 -247 -417 -489 -162 -377 -397 -309 -365 -266 -439 -342 -367 -325 -167 -195 -475 -17 -113 -155 -203 -339 -0 -455 -128 -311 -316 -57 -302 -205 -149 -438 -345 -129 -170 -20 -489 -157 -378 -221 -92 -111 -47 -72 -4 -280 -35 -427 -277 -208 -356 -399 -169 -382 -498 -125 -386 -437 -469 -192 -286 -187 -176 -54 -459 -51 -138 -103 -239 -213 -216 -430 -278 -176 -289 -221 -65 -318 -332 -311 -275 -137 -241 -83 -333 -180 -284 -12 -230 -181 -67 -260 -404 -384 -489 -353 -373 -272 -138 -217 -84 -348 -466 -58 -8 -411 -230 -208 -348 -24 -463 -431 -179 -172 -42 -129 -158 -119 -496 -0 -322 -197 -468 -393 -454 -100 -298 -199 -191 -418 -96 -26 -165 -327 -230 -205 -120 -131 -51 -404 -43 -436 -156 -469 -468 -308 -95 -196 -288 -481 -457 98 -282 -197 -187 -318 -318 -409 -470 -137 -369 -316 -169 -413 -85 -77 -0 -490 -87 -364 -179 -118 -134 -395 -282 -138 -238 -419 -15 -118 -72 -90 -307 -19 -435 -10 -277 -273 -306 -224 -309 -389 -327 -242 -369 -392 -272 -331 -401 -242 -452 -177 -226 -5 -497 -402 -396 -317 -395 -58 -35 -336 -95 -11 -168 -34 -229 -233 -143 -472 -322 -498 -160 -195 -42 -321 -430 -119 -489 -458 -78 -76 -41 -223 -492 -149 -449 -218 -228 -138 -453 -30 -209 -64 -468 -76 -74 -342 -69 -230 -33 -368 -103 -296 -113 -216 -367 -344 -167 -274 -219 -239 -485 -116 -223 -256 -263 -70 -487 -480 -401 -288 -191 -5 -244 -438 -128 -467 -432 -202 -316 -229 -469 -463 -280 -2 -35 -283 -331 -235 -80 -44 -193 -321 -335 -104 -466 -366 -175 -403 -483 -53 -105 -257 -406 -409 -190 -406 -401 -114 -258 -90 -203 -262 -348 -424 -12 -396 -201 -217 -164 -431 -454 -478 -298 -125 -431 -164 -424 -187 -382 -5 -70 -397 -480 -291 -24 -351 -255 -104 -70 -163 -438 -119 -414 -200 -491 -237 -439 -360 -248 -479 -305 -417 -199 -444 -120 -429 -169 -443 -323 -325 -277 -230 -478 -178 -468 -310 -317 -333 -493 -460 -207 -249 -265 -480 -83 -136 -353 -172 -214 -462 -233 -406 -133 -175 -189 -454 -375 -401 -421 -407 -384 -256 -26 -134 -67 -384 -379 -18 -462 -492 -100 -298 -9 -341 -498 -146 -458 -362 -186 -285 -348 -167 -18 -273 -183 -281 -344 -97 -469 -315 -84 -28 -37 -448 -152 -348 -307 -194 -414 -477 -222 -126 -90 -169 -403 -400 -200 -97 http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out b/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out index 6316268..548035d 100644 --- a/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out +++ b/ql/src/test/results/clientpositive/tez/tez_schema_evolution.q.out @@ -1,16 +1,20 @@ -PREHOOK: query: create table test (key int, value string) partitioned by (p int) stored as textfile +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table test (key int, value string) partitioned by (p int) stored as textfile PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@test -POSTHOOK: query: create table test (key int, value string) partitioned by (p int) stored as textfile +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table test (key int, value string) partitioned by (p int) stored as textfile POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@test -PREHOOK: query: insert into table test partition (p=1) select * from src limit 10 +PREHOOK: query: insert into table test partition (p=1) select * from src order by key limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@test@p=1 -POSTHOOK: query: insert into table test partition (p=1) select * from src limit 10 +POSTHOOK: query: insert into table test partition (p=1) select * from src order by key limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@test@p=1 @@ -24,11 +28,11 @@ POSTHOOK: query: alter table test set fileformat orc POSTHOOK: type: ALTERTABLE_FILEFORMAT POSTHOOK: Input: default@test POSTHOOK: Output: default@test -PREHOOK: query: insert into table test partition (p=2) select * from src limit 10 +PREHOOK: query: insert into table test partition (p=2) select * from src order by key limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@src PREHOOK: Output: default@test@p=2 -POSTHOOK: query: insert into table test partition (p=2) select * from src limit 10 +POSTHOOK: query: insert into table test partition (p=2) select * from src order by key limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@src POSTHOOK: Output: default@test@p=2 @@ -48,75 +52,63 @@ p int # col_name data_type comment p int -PREHOOK: query: select * from test where p=1 and key > 0 +PREHOOK: query: select * from test where p=1 and key > 0 order by key PREHOOK: type: QUERY PREHOOK: Input: default@test PREHOOK: Input: default@test@p=1 #### A masked pattern was here #### -POSTHOOK: query: select * from test where p=1 and key > 0 +POSTHOOK: query: select * from test where p=1 and key > 0 order by key POSTHOOK: type: QUERY POSTHOOK: Input: default@test POSTHOOK: Input: default@test@p=1 #### A masked pattern was here #### -484 val_484 1 -98 val_98 1 -278 val_278 1 -255 val_255 1 -409 val_409 1 -165 val_165 1 -27 val_27 1 -311 val_311 1 -86 val_86 1 -238 val_238 1 -PREHOOK: query: select * from test where p=2 and key > 0 +10 val_10 1 +100 val_100 1 +100 val_100 1 +103 val_103 1 +103 val_103 1 +104 val_104 1 +104 val_104 1 +PREHOOK: query: select * from test where p=2 and key > 0 order by key PREHOOK: type: QUERY PREHOOK: Input: default@test PREHOOK: Input: default@test@p=2 #### A masked pattern was here #### -POSTHOOK: query: select * from test where p=2 and key > 0 +POSTHOOK: query: select * from test where p=2 and key > 0 order by key POSTHOOK: type: QUERY POSTHOOK: Input: default@test POSTHOOK: Input: default@test@p=2 #### A masked pattern was here #### -484 val_484 2 -98 val_98 2 -278 val_278 2 -255 val_255 2 -409 val_409 2 -165 val_165 2 -27 val_27 2 -311 val_311 2 -86 val_86 2 -238 val_238 2 -PREHOOK: query: select * from test where key > 0 +10 val_10 2 +100 val_100 2 +100 val_100 2 +103 val_103 2 +103 val_103 2 +104 val_104 2 +104 val_104 2 +PREHOOK: query: select * from test where key > 0 order by key PREHOOK: type: QUERY PREHOOK: Input: default@test PREHOOK: Input: default@test@p=1 PREHOOK: Input: default@test@p=2 #### A masked pattern was here #### -POSTHOOK: query: select * from test where key > 0 +POSTHOOK: query: select * from test where key > 0 order by key POSTHOOK: type: QUERY POSTHOOK: Input: default@test POSTHOOK: Input: default@test@p=1 POSTHOOK: Input: default@test@p=2 #### A masked pattern was here #### -484 val_484 1 -98 val_98 1 -278 val_278 1 -255 val_255 1 -409 val_409 1 -165 val_165 1 -27 val_27 1 -311 val_311 1 -86 val_86 1 -238 val_238 1 -484 val_484 2 -98 val_98 2 -278 val_278 2 -255 val_255 2 -409 val_409 2 -165 val_165 2 -27 val_27 2 -311 val_311 2 -86 val_86 2 -238 val_238 2 +10 val_10 1 +10 val_10 2 +100 val_100 1 +100 val_100 1 +100 val_100 2 +100 val_100 2 +103 val_103 1 +103 val_103 1 +103 val_103 2 +103 val_103 2 +104 val_104 1 +104 val_104 1 +104 val_104 2 +104 val_104 2 http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out b/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out index 286e2ed..4ee1e2e 100644 --- a/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out +++ b/ql/src/test/results/clientpositive/tez/update_all_partitioned.q.out @@ -6,21 +6,21 @@ POSTHOOK: query: create table acid_uap(a int, b varchar(128)) partitioned by (ds POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@acid_uap -PREHOOK: query: insert into table acid_uap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 +PREHOOK: query: insert into table acid_uap partition (ds='today') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint < 0 order by cint, cs limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@acid_uap@ds=today -POSTHOOK: query: insert into table acid_uap partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 +POSTHOOK: query: insert into table acid_uap partition (ds='today') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint < 0 order by cint, cs limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@acid_uap@ds=today POSTHOOK: Lineage: acid_uap PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] POSTHOOK: Lineage: acid_uap PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_uap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 10 order by cint limit 10 +PREHOOK: query: insert into table acid_uap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint > 10 order by cint, cs limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@acid_uap@ds=tomorrow -POSTHOOK: query: insert into table acid_uap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 10 order by cint limit 10 +POSTHOOK: query: insert into table acid_uap partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint > 10 order by cint, cs limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@acid_uap@ds=tomorrow @@ -53,11 +53,11 @@ POSTHOOK: Input: default@acid_uap@ds=tomorrow 762 BLoMwUJ51ns6pd tomorrow 762 a10E76jX35YwquKCTA tomorrow 762 q5y2Vy1 tomorrow +6981 NULL tomorrow 6981 1FNNhmiFLGw425NA13g tomorrow +6981 4KhrrQ0nJ7bMNTvhSCA tomorrow 6981 K630vaVf tomorrow -6981 YdG61y00526u5 tomorrow -6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow -6981 o4lvY20511w0EOX3P3I82p63 tomorrow +6981 Y5x3JuI3M8jngv5N tomorrow PREHOOK: query: update acid_uap set b = 'fred' PREHOOK: type: QUERY PREHOOK: Input: default@acid_uap http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out b/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out index fef0dc0..1834e83 100644 --- a/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out +++ b/ql/src/test/results/clientpositive/tez/update_where_partitioned.q.out @@ -6,21 +6,21 @@ POSTHOOK: query: create table acid_uwp(a int, b varchar(128)) partitioned by (ds POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@acid_uwp -PREHOOK: query: insert into table acid_uwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 +PREHOOK: query: insert into table acid_uwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint < 0 order by cint, cs limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@acid_uwp@ds=today -POSTHOOK: query: insert into table acid_uwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint < 0 order by cint limit 10 +POSTHOOK: query: insert into table acid_uwp partition (ds='today') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint < 0 order by cint, cs limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@acid_uwp@ds=today POSTHOOK: Lineage: acid_uwp PARTITION(ds=today).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] POSTHOOK: Lineage: acid_uwp PARTITION(ds=today).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 100 order by cint limit 10 +PREHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint > 100 order by cint, cs limit 10 PREHOOK: type: QUERY PREHOOK: Input: default@alltypesorc PREHOOK: Output: default@acid_uwp@ds=tomorrow -POSTHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null and cint > 100 order by cint limit 10 +POSTHOOK: query: insert into table acid_uwp partition (ds='tomorrow') select cint, cast(cstring1 as varchar(128)) as cs from alltypesorc where cint is not null and cint > 100 order by cint, cs limit 10 POSTHOOK: type: QUERY POSTHOOK: Input: default@alltypesorc POSTHOOK: Output: default@acid_uwp@ds=tomorrow @@ -53,11 +53,11 @@ POSTHOOK: Input: default@acid_uwp@ds=tomorrow 762 BLoMwUJ51ns6pd tomorrow 762 a10E76jX35YwquKCTA tomorrow 762 q5y2Vy1 tomorrow +6981 NULL tomorrow 6981 1FNNhmiFLGw425NA13g tomorrow +6981 4KhrrQ0nJ7bMNTvhSCA tomorrow 6981 K630vaVf tomorrow -6981 YdG61y00526u5 tomorrow -6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow -6981 o4lvY20511w0EOX3P3I82p63 tomorrow +6981 Y5x3JuI3M8jngv5N tomorrow PREHOOK: query: update acid_uwp set b = 'fred' where b = 'k17Am8uPHWk02cEf1jet' PREHOOK: type: QUERY PREHOOK: Input: default@acid_uwp @@ -99,8 +99,8 @@ POSTHOOK: Input: default@acid_uwp@ds=tomorrow 762 BLoMwUJ51ns6pd tomorrow 762 a10E76jX35YwquKCTA tomorrow 762 q5y2Vy1 tomorrow +6981 NULL tomorrow 6981 1FNNhmiFLGw425NA13g tomorrow +6981 4KhrrQ0nJ7bMNTvhSCA tomorrow 6981 K630vaVf tomorrow -6981 YdG61y00526u5 tomorrow -6981 a3EhVU6Wuy7ycJ7wY7h2gv tomorrow -6981 o4lvY20511w0EOX3P3I82p63 tomorrow +6981 Y5x3JuI3M8jngv5N tomorrow http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/vector_data_types.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_data_types.q.out b/ql/src/test/results/clientpositive/tez/vector_data_types.q.out index eca2cbc..972404b 100644 --- a/ql/src/test/results/clientpositive/tez/vector_data_types.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_data_types.q.out @@ -97,9 +97,9 @@ POSTHOOK: Lineage: over1korc.s SIMPLE [(over1k)over1k.FieldSchema(name:s, type:s POSTHOOK: Lineage: over1korc.si SIMPLE [(over1k)over1k.FieldSchema(name:si, type:smallint, comment:null), ] POSTHOOK: Lineage: over1korc.t SIMPLE [(over1k)over1k.FieldSchema(name:t, type:tinyint, comment:null), ] POSTHOOK: Lineage: over1korc.ts SIMPLE [(over1k)over1k.FieldSchema(name:ts, type:timestamp, comment:null), ] -PREHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +PREHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +POSTHOOK: query: EXPLAIN SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage @@ -122,14 +122,14 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: _col2 (type: int) - sort order: + + key expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: int) + sort order: +++ Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: boolean), _col7 (type: string), _col8 (type: timestamp), _col9 (type: decimal(4,2)), _col10 (type: binary) + value expressions: _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: boolean), _col7 (type: string), _col8 (type: timestamp), _col9 (type: decimal(4,2)), _col10 (type: binary) Reducer 2 Reduce Operator Tree: Select Operator - expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), KEY.reducesinkkey0 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: boolean), VALUE._col6 (type: string), VALUE._col7 (type: timestamp), VALUE._col8 (type: decimal(4,2)), VALUE._col9 (type: binary) + expressions: KEY.reducesinkkey0 (type: tinyint), KEY.reducesinkkey1 (type: smallint), KEY.reducesinkkey2 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: boolean), VALUE._col4 (type: string), VALUE._col5 (type: timestamp), VALUE._col6 (type: decimal(4,2)), VALUE._col7 (type: binary) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE Limit @@ -149,48 +149,48 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +PREHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY PREHOOK: Input: default@over1korc #### A masked pattern was here #### -POSTHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +POSTHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.7 undecided -118 497 65536 4294967381 50.32 12.72 false david nixon 2013-03-01 09:11:58.703285 83.48 values clariffication -18 280 65536 4294967320 32.92 45.94 false holly white 2013-03-01 09:11:58.703086 58.86 topology -69 489 65536 4294967404 33.52 17.99 false oscar ichabod 2013-03-01 09:11:58.703247 32.68 topology -27 405 65536 4294967508 82.24 29.41 true oscar ovid 2013-03-01 09:11:58.703166 16.85 biology -42 495 65536 4294967431 43.57 46.81 false tom johnson 2013-03-01 09:11:58.703245 62.25 american history +NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history -59 431 65537 4294967326 11.34 2.9 true oscar robinson 2013-03-01 09:11:58.703161 81.04 zync studies -63 458 65537 4294967463 21.94 49.71 true fred van buren 2013-03-01 09:11:58.703278 99.34 wind surfing -121 355 65537 4294967437 85.9 10.99 true calvin brown 2013-03-01 09:11:58.703254 4.49 yard duty -72 267 65537 4294967460 55.2 42.89 false oscar carson 2013-03-01 09:11:58.703153 51.91 topology -22 264 65537 4294967419 8.07 10.71 false david xylophone 2013-03-01 09:11:58.703136 11.87 undecided -101 283 65538 4294967527 84.03 27.29 true yuri brown 2013-03-01 09:11:58.703306 44.24 biology -109 376 65538 4294967453 59.61 35.62 true priscilla xylophone 2013-03-01 09:11:58.703286 9.53 study skills -83 353 65538 4294967339 0.08 23.91 true holly thompson 2013-03-01 09:11:58.703157 30.27 quiet hour -29 331 65539 4294967420 73.18 28.96 true ethan brown 2013-03-01 09:11:58.703094 58.85 zync studies -70 430 65539 4294967534 18.89 43.84 true tom carson 2013-03-01 09:11:58.703182 21.93 joggying -120 331 65539 4294967324 88.02 40.94 true holly nixon 2013-03-01 09:11:58.703262 96.64 yard duty -71 298 65540 4294967510 91.63 9.6 false gabriella zipper 2013-03-01 09:11:58.70314 68.14 geology -114 385 65541 4294967458 73.48 34.97 true oscar quirinius 2013-03-01 09:11:58.703143 72.33 xylophone band +NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.8 mathematics +-3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided +-3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing +-3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education +-3 438 65618 4294967398 62.39 4.62 false victor xylophone 2013-03-01 09:11:58.703135 88.38 values clariffication +-3 458 65696 4294967418 45.24 8.49 false irene ellison 2013-03-01 09:11:58.703092 54.02 american history +-3 467 65575 4294967437 81.64 23.53 true tom hernandez 2013-03-01 09:11:58.703188 32.85 study skills +-2 261 65603 4294967332 39.18 28.98 false fred polk 2013-03-01 09:11:58.70331 69.26 opthamology +-2 269 65681 4294967544 99.24 28.19 false rachel falkner 2013-03-01 09:11:58.703089 41.57 quiet hour +-2 288 65658 4294967383 53.78 19.92 false holly nixon 2013-03-01 09:11:58.703224 42.93 industrial engineering +-2 304 65629 4294967386 84.38 33.49 false zach garcia 2013-03-01 09:11:58.703264 56.99 chemistry +-2 340 65627 4294967533 76.52 21.91 true quinn laertes 2013-03-01 09:11:58.703178 93.29 xylophone band +-2 427 65666 4294967465 19.69 33.24 true bob xylophone 2013-03-01 09:11:58.703219 32.73 joggying +-2 429 65664 4294967441 45.19 40.43 false wendy king 2013-03-01 09:11:58.703265 11.46 industrial engineering +-2 461 65648 4294967425 58.52 24.85 false rachel thompson 2013-03-01 09:11:58.703318 85.62 zync studies +-1 268 65778 4294967418 56.33 44.73 true calvin falkner 2013-03-01 09:11:58.70322 7.37 history +-1 281 65643 4294967323 15.1 45.0 false irene nixon 2013-03-01 09:11:58.703223 80.96 undecided +-1 300 65663 4294967343 71.26 34.62 true calvin ovid 2013-03-01 09:11:58.703262 78.56 study skills PREHOOK: query: SELECT SUM(HASH(*)) -FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i) as q +FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i) as q PREHOOK: type: QUERY PREHOOK: Input: default@over1korc #### A masked pattern was here #### POSTHOOK: query: SELECT SUM(HASH(*)) -FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i) as q +FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i) as q POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -17045922556 -PREHOOK: query: EXPLAIN select t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +PREHOOK: query: EXPLAIN select t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN select t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +POSTHOOK: query: EXPLAIN select t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage @@ -213,15 +213,15 @@ STAGE PLANS: outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator - key expressions: _col2 (type: int) - sort order: + + key expressions: _col0 (type: tinyint), _col1 (type: smallint), _col2 (type: int) + sort order: +++ Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE - value expressions: _col0 (type: tinyint), _col1 (type: smallint), _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: boolean), _col7 (type: string), _col8 (type: timestamp), _col9 (type: decimal(4,2)), _col10 (type: binary) + value expressions: _col3 (type: bigint), _col4 (type: float), _col5 (type: double), _col6 (type: boolean), _col7 (type: string), _col8 (type: timestamp), _col9 (type: decimal(4,2)), _col10 (type: binary) Execution mode: vectorized Reducer 2 Reduce Operator Tree: Select Operator - expressions: VALUE._col0 (type: tinyint), VALUE._col1 (type: smallint), KEY.reducesinkkey0 (type: int), VALUE._col2 (type: bigint), VALUE._col3 (type: float), VALUE._col4 (type: double), VALUE._col5 (type: boolean), VALUE._col6 (type: string), VALUE._col7 (type: timestamp), VALUE._col8 (type: decimal(4,2)), VALUE._col9 (type: binary) + expressions: KEY.reducesinkkey0 (type: tinyint), KEY.reducesinkkey1 (type: smallint), KEY.reducesinkkey2 (type: int), VALUE._col0 (type: bigint), VALUE._col1 (type: float), VALUE._col2 (type: double), VALUE._col3 (type: boolean), VALUE._col4 (type: string), VALUE._col5 (type: timestamp), VALUE._col6 (type: decimal(4,2)), VALUE._col7 (type: binary) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10 Statistics: Num rows: 1049 Data size: 311170 Basic stats: COMPLETE Column stats: NONE Limit @@ -242,41 +242,41 @@ STAGE PLANS: Processor Tree: ListSink -PREHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +PREHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 PREHOOK: type: QUERY PREHOOK: Input: default@over1korc #### A masked pattern was here #### -POSTHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i LIMIT 20 +POSTHOOK: query: SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i LIMIT 20 POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### -108 301 65536 4294967357 90.05 17.59 true ethan johnson 2013-03-01 09:11:58.703271 75.7 undecided -118 497 65536 4294967381 50.32 12.72 false david nixon 2013-03-01 09:11:58.703285 83.48 values clariffication -18 280 65536 4294967320 32.92 45.94 false holly white 2013-03-01 09:11:58.703086 58.86 topology -69 489 65536 4294967404 33.52 17.99 false oscar ichabod 2013-03-01 09:11:58.703247 32.68 topology -27 405 65536 4294967508 82.24 29.41 true oscar ovid 2013-03-01 09:11:58.703166 16.85 biology -42 495 65536 4294967431 43.57 46.81 false tom johnson 2013-03-01 09:11:58.703245 62.25 american history +NULL 374 65560 4294967516 65.43 22.48 true oscar quirinius 2013-03-01 09:11:58.703316 16.86 mathematics NULL 409 65536 4294967490 46.97 25.92 false fred miller 2013-03-01 09:11:58.703116 33.45 history -59 431 65537 4294967326 11.34 2.9 true oscar robinson 2013-03-01 09:11:58.703161 81.04 zync studies -63 458 65537 4294967463 21.94 49.71 true fred van buren 2013-03-01 09:11:58.703278 99.34 wind surfing -121 355 65537 4294967437 85.9 10.99 true calvin brown 2013-03-01 09:11:58.703254 4.49 yard duty -72 267 65537 4294967460 55.2 42.89 false oscar carson 2013-03-01 09:11:58.703153 51.91 topology -22 264 65537 4294967419 8.07 10.71 false david xylophone 2013-03-01 09:11:58.703136 11.87 undecided -101 283 65538 4294967527 84.03 27.29 true yuri brown 2013-03-01 09:11:58.703306 44.24 biology -109 376 65538 4294967453 59.61 35.62 true priscilla xylophone 2013-03-01 09:11:58.703286 9.53 study skills -83 353 65538 4294967339 0.08 23.91 true holly thompson 2013-03-01 09:11:58.703157 30.27 quiet hour -29 331 65539 4294967420 73.18 28.96 true ethan brown 2013-03-01 09:11:58.703094 58.85 zync studies -70 430 65539 4294967534 18.89 43.84 true tom carson 2013-03-01 09:11:58.703182 21.93 joggying -120 331 65539 4294967324 88.02 40.94 true holly nixon 2013-03-01 09:11:58.703262 96.64 yard duty -71 298 65540 4294967510 91.63 9.6 false gabriella zipper 2013-03-01 09:11:58.70314 68.14 geology -114 385 65541 4294967458 73.48 34.97 true oscar quirinius 2013-03-01 09:11:58.703143 72.33 xylophone band +NULL 473 65720 4294967324 80.74 40.6 false holly falkner 2013-03-01 09:11:58.703111 18.8 mathematics +-3 275 65622 4294967302 71.78 8.49 false wendy robinson 2013-03-01 09:11:58.703294 95.39 undecided +-3 344 65733 4294967363 0.56 11.96 true rachel thompson 2013-03-01 09:11:58.703276 88.46 wind surfing +-3 376 65548 4294967431 96.78 43.23 false fred ellison 2013-03-01 09:11:58.703233 75.39 education +-3 438 65618 4294967398 62.39 4.62 false victor xylophone 2013-03-01 09:11:58.703135 88.38 values clariffication +-3 458 65696 4294967418 45.24 8.49 false irene ellison 2013-03-01 09:11:58.703092 54.02 american history +-3 467 65575 4294967437 81.64 23.53 true tom hernandez 2013-03-01 09:11:58.703188 32.85 study skills +-2 261 65603 4294967332 39.18 28.98 false fred polk 2013-03-01 09:11:58.70331 69.26 opthamology +-2 269 65681 4294967544 99.24 28.19 false rachel falkner 2013-03-01 09:11:58.703089 41.57 quiet hour +-2 288 65658 4294967383 53.78 19.92 false holly nixon 2013-03-01 09:11:58.703224 42.93 industrial engineering +-2 304 65629 4294967386 84.38 33.49 false zach garcia 2013-03-01 09:11:58.703264 56.99 chemistry +-2 340 65627 4294967533 76.52 21.91 true quinn laertes 2013-03-01 09:11:58.703178 93.29 xylophone band +-2 427 65666 4294967465 19.69 33.24 true bob xylophone 2013-03-01 09:11:58.703219 32.73 joggying +-2 429 65664 4294967441 45.19 40.43 false wendy king 2013-03-01 09:11:58.703265 11.46 industrial engineering +-2 461 65648 4294967425 58.52 24.85 false rachel thompson 2013-03-01 09:11:58.703318 85.62 zync studies +-1 268 65778 4294967418 56.33 44.73 true calvin falkner 2013-03-01 09:11:58.70322 7.37 history +-1 281 65643 4294967323 15.1 45.0 false irene nixon 2013-03-01 09:11:58.703223 80.96 undecided +-1 300 65663 4294967343 71.26 34.62 true calvin ovid 2013-03-01 09:11:58.703262 78.56 study skills PREHOOK: query: SELECT SUM(HASH(*)) -FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i) as q +FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i) as q PREHOOK: type: QUERY PREHOOK: Input: default@over1korc #### A masked pattern was here #### POSTHOOK: query: SELECT SUM(HASH(*)) -FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY i) as q +FROM (SELECT t, si, i, b, f, d, bo, s, ts, dec, bin FROM over1korc ORDER BY t, si, i) as q POSTHOOK: type: QUERY POSTHOOK: Input: default@over1korc #### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/7a02f726/ql/src/test/results/clientpositive/tez/vector_null_projection.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/vector_null_projection.q.out b/ql/src/test/results/clientpositive/tez/vector_null_projection.q.out index 6af333d..88587e9 100644 --- a/ql/src/test/results/clientpositive/tez/vector_null_projection.q.out +++ b/ql/src/test/results/clientpositive/tez/vector_null_projection.q.out @@ -1,8 +1,12 @@ -PREHOOK: query: create table a(s string) stored as orc +PREHOOK: query: -- SORT_QUERY_RESULTS + +create table a(s string) stored as orc PREHOOK: type: CREATETABLE PREHOOK: Output: database:default PREHOOK: Output: default@a -POSTHOOK: query: create table a(s string) stored as orc +POSTHOOK: query: -- SORT_QUERY_RESULTS + +create table a(s string) stored as orc POSTHOOK: type: CREATETABLE POSTHOOK: Output: database:default POSTHOOK: Output: default@a