http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/having.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/having.q.out b/ql/src/test/results/clientpositive/tez/having.q.out deleted file mode 100644 index 6ae1ff7..0000000 --- a/ql/src/test/results/clientpositive/tez/having.q.out +++ /dev/null @@ -1,1284 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS -EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3 -PREHOOK: type: QUERY -POSTHOOK: query: -- SORT_QUERY_RESULTS -EXPLAIN SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: key, value - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count(value) - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 19475 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 205 Data size: 19475 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: bigint) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 19475 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col1 (type: bigint) - outputColumnNames: _col1 - Statistics: Num rows: 205 Data size: 1640 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (_col1 > 3) (type: boolean) - Statistics: Num rows: 68 Data size: 544 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col1 (type: bigint) - outputColumnNames: _col0 - Statistics: Num rows: 68 Data size: 544 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 68 Data size: 544 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT count(value) AS c FROM src GROUP BY key HAVING c > 3 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -4 -4 -4 -4 -4 -4 -5 -5 -5 -5 -PREHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (UDFToDouble(key) <> 302.0) (type: boolean) - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: max(value) - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: max(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, max(value) AS c FROM src GROUP BY key HAVING key != 302 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -0 val_0 -10 val_10 -100 val_100 -103 val_103 -104 val_104 -105 val_105 -11 val_11 -111 val_111 -113 val_113 -114 val_114 -116 val_116 -118 val_118 -119 val_119 -12 val_12 -120 val_120 -125 val_125 -126 val_126 -128 val_128 -129 val_129 -131 val_131 -133 val_133 -134 val_134 -136 val_136 -137 val_137 -138 val_138 -143 val_143 -145 val_145 -146 val_146 -149 val_149 -15 val_15 -150 val_150 -152 val_152 -153 val_153 -155 val_155 -156 val_156 -157 val_157 -158 val_158 -160 val_160 -162 val_162 -163 val_163 -164 val_164 -165 val_165 -166 val_166 -167 val_167 -168 val_168 -169 val_169 -17 val_17 -170 val_170 -172 val_172 -174 val_174 -175 val_175 -176 val_176 -177 val_177 -178 val_178 -179 val_179 -18 val_18 -180 val_180 -181 val_181 -183 val_183 -186 val_186 -187 val_187 -189 val_189 -19 val_19 -190 val_190 -191 val_191 -192 val_192 -193 val_193 -194 val_194 -195 val_195 -196 val_196 -197 val_197 -199 val_199 -2 val_2 -20 val_20 -200 val_200 -201 val_201 -202 val_202 -203 val_203 -205 val_205 -207 val_207 -208 val_208 -209 val_209 -213 val_213 -214 val_214 -216 val_216 -217 val_217 -218 val_218 -219 val_219 -221 val_221 -222 val_222 -223 val_223 -224 val_224 -226 val_226 -228 val_228 -229 val_229 -230 val_230 -233 val_233 -235 val_235 -237 val_237 -238 val_238 -239 val_239 -24 val_24 -241 val_241 -242 val_242 -244 val_244 -247 val_247 -248 val_248 -249 val_249 -252 val_252 -255 val_255 -256 val_256 -257 val_257 -258 val_258 -26 val_26 -260 val_260 -262 val_262 -263 val_263 -265 val_265 -266 val_266 -27 val_27 -272 val_272 -273 val_273 -274 val_274 -275 val_275 -277 val_277 -278 val_278 -28 val_28 -280 val_280 -281 val_281 -282 val_282 -283 val_283 -284 val_284 -285 val_285 -286 val_286 -287 val_287 -288 val_288 -289 val_289 -291 val_291 -292 val_292 -296 val_296 -298 val_298 -30 val_30 -305 val_305 -306 val_306 -307 val_307 -308 val_308 -309 val_309 -310 val_310 -311 val_311 -315 val_315 -316 val_316 -317 val_317 -318 val_318 -321 val_321 -322 val_322 -323 val_323 -325 val_325 -327 val_327 -33 val_33 -331 val_331 -332 val_332 -333 val_333 -335 val_335 -336 val_336 -338 val_338 -339 val_339 -34 val_34 -341 val_341 -342 val_342 -344 val_344 -345 val_345 -348 val_348 -35 val_35 -351 val_351 -353 val_353 -356 val_356 -360 val_360 -362 val_362 -364 val_364 -365 val_365 -366 val_366 -367 val_367 -368 val_368 -369 val_369 -37 val_37 -373 val_373 -374 val_374 -375 val_375 -377 val_377 -378 val_378 -379 val_379 -382 val_382 -384 val_384 -386 val_386 -389 val_389 -392 val_392 -393 val_393 -394 val_394 -395 val_395 -396 val_396 -397 val_397 -399 val_399 -4 val_4 -400 val_400 -401 val_401 -402 val_402 -403 val_403 -404 val_404 -406 val_406 -407 val_407 -409 val_409 -41 val_41 -411 val_411 -413 val_413 -414 val_414 -417 val_417 -418 val_418 -419 val_419 -42 val_42 -421 val_421 -424 val_424 -427 val_427 -429 val_429 -43 val_43 -430 val_430 -431 val_431 -432 val_432 -435 val_435 -436 val_436 -437 val_437 -438 val_438 -439 val_439 -44 val_44 -443 val_443 -444 val_444 -446 val_446 -448 val_448 -449 val_449 -452 val_452 -453 val_453 -454 val_454 -455 val_455 -457 val_457 -458 val_458 -459 val_459 -460 val_460 -462 val_462 -463 val_463 -466 val_466 -467 val_467 -468 val_468 -469 val_469 -47 val_47 -470 val_470 -472 val_472 -475 val_475 -477 val_477 -478 val_478 -479 val_479 -480 val_480 -481 val_481 -482 val_482 -483 val_483 -484 val_484 -485 val_485 -487 val_487 -489 val_489 -490 val_490 -491 val_491 -492 val_492 -493 val_493 -494 val_494 -495 val_495 -496 val_496 -497 val_497 -498 val_498 -5 val_5 -51 val_51 -53 val_53 -54 val_54 -57 val_57 -58 val_58 -64 val_64 -65 val_65 -66 val_66 -67 val_67 -69 val_69 -70 val_70 -72 val_72 -74 val_74 -76 val_76 -77 val_77 -78 val_78 -8 val_8 -80 val_80 -82 val_82 -83 val_83 -84 val_84 -85 val_85 -86 val_86 -87 val_87 -9 val_9 -90 val_90 -92 val_92 -95 val_95 -96 val_96 -97 val_97 -98 val_98 -PREHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255" -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key FROM src GROUP BY key HAVING max(value) > "val_255" -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: key, value - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: max(value) - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: max(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (_col1 > 'val_255') (type: boolean) - Statistics: Num rows: 68 Data size: 18428 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col0 (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 68 Data size: 5916 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 68 Data size: 5916 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key FROM src GROUP BY key HAVING max(value) > "val_255" -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key FROM src GROUP BY key HAVING max(value) > "val_255" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -256 -257 -258 -26 -260 -262 -263 -265 -266 -27 -272 -273 -274 -275 -277 -278 -28 -280 -281 -282 -283 -284 -285 -286 -287 -288 -289 -291 -292 -296 -298 -30 -302 -305 -306 -307 -308 -309 -310 -311 -315 -316 -317 -318 -321 -322 -323 -325 -327 -33 -331 -332 -333 -335 -336 -338 -339 -34 -341 -342 -344 -345 -348 -35 -351 -353 -356 -360 -362 -364 -365 -366 -367 -368 -369 -37 -373 -374 -375 -377 -378 -379 -382 -384 -386 -389 -392 -393 -394 -395 -396 -397 -399 -4 -400 -401 -402 -403 -404 -406 -407 -409 -41 -411 -413 -414 -417 -418 -419 -42 -421 -424 -427 -429 -43 -430 -431 -432 -435 -436 -437 -438 -439 -44 -443 -444 -446 -448 -449 -452 -453 -454 -455 -457 -458 -459 -460 -462 -463 -466 -467 -468 -469 -47 -470 -472 -475 -477 -478 -479 -480 -481 -482 -483 -484 -485 -487 -489 -490 -491 -492 -493 -494 -495 -496 -497 -498 -5 -51 -53 -54 -57 -58 -64 -65 -66 -67 -69 -70 -72 -74 -76 -77 -78 -8 -80 -82 -83 -84 -85 -86 -87 -9 -90 -92 -95 -96 -97 -98 -PREHOOK: query: EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255" -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255" -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (UDFToDouble(key) > 300.0) (type: boolean) - Statistics: Num rows: 166 Data size: 29548 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: max(value) - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 69 Data size: 18699 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 69 Data size: 18699 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: max(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 69 Data size: 18699 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (_col1 > 'val_255') (type: boolean) - Statistics: Num rows: 23 Data size: 6233 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: _col0 (type: string) - outputColumnNames: _col0 - Statistics: Num rows: 23 Data size: 2001 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 23 Data size: 2001 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255" -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key FROM src where key > 300 GROUP BY key HAVING max(value) > "val_255" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -302 -305 -306 -307 -308 -309 -310 -311 -315 -316 -317 -318 -321 -322 -323 -325 -327 -331 -332 -333 -335 -336 -338 -339 -341 -342 -344 -345 -348 -351 -353 -356 -360 -362 -364 -365 -366 -367 -368 -369 -373 -374 -375 -377 -378 -379 -382 -384 -386 -389 -392 -393 -394 -395 -396 -397 -399 -400 -401 -402 -403 -404 -406 -407 -409 -411 -413 -414 -417 -418 -419 -421 -424 -427 -429 -430 -431 -432 -435 -436 -437 -438 -439 -443 -444 -446 -448 -449 -452 -453 -454 -455 -457 -458 -459 -460 -462 -463 -466 -467 -468 -469 -470 -472 -475 -477 -478 -479 -480 -481 -482 -483 -484 -485 -487 -489 -490 -491 -492 -493 -494 -495 -496 -497 -498 -PREHOOK: query: EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255" -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255" -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: key, value - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: max(value) - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: max(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 55555 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (_col1 > 'val_255') (type: boolean) - Statistics: Num rows: 68 Data size: 18428 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 68 Data size: 18428 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255" -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, max(value) FROM src GROUP BY key HAVING max(value) > "val_255" -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -256 val_256 -257 val_257 -258 val_258 -26 val_26 -260 val_260 -262 val_262 -263 val_263 -265 val_265 -266 val_266 -27 val_27 -272 val_272 -273 val_273 -274 val_274 -275 val_275 -277 val_277 -278 val_278 -28 val_28 -280 val_280 -281 val_281 -282 val_282 -283 val_283 -284 val_284 -285 val_285 -286 val_286 -287 val_287 -288 val_288 -289 val_289 -291 val_291 -292 val_292 -296 val_296 -298 val_298 -30 val_30 -302 val_302 -305 val_305 -306 val_306 -307 val_307 -308 val_308 -309 val_309 -310 val_310 -311 val_311 -315 val_315 -316 val_316 -317 val_317 -318 val_318 -321 val_321 -322 val_322 -323 val_323 -325 val_325 -327 val_327 -33 val_33 -331 val_331 -332 val_332 -333 val_333 -335 val_335 -336 val_336 -338 val_338 -339 val_339 -34 val_34 -341 val_341 -342 val_342 -344 val_344 -345 val_345 -348 val_348 -35 val_35 -351 val_351 -353 val_353 -356 val_356 -360 val_360 -362 val_362 -364 val_364 -365 val_365 -366 val_366 -367 val_367 -368 val_368 -369 val_369 -37 val_37 -373 val_373 -374 val_374 -375 val_375 -377 val_377 -378 val_378 -379 val_379 -382 val_382 -384 val_384 -386 val_386 -389 val_389 -392 val_392 -393 val_393 -394 val_394 -395 val_395 -396 val_396 -397 val_397 -399 val_399 -4 val_4 -400 val_400 -401 val_401 -402 val_402 -403 val_403 -404 val_404 -406 val_406 -407 val_407 -409 val_409 -41 val_41 -411 val_411 -413 val_413 -414 val_414 -417 val_417 -418 val_418 -419 val_419 -42 val_42 -421 val_421 -424 val_424 -427 val_427 -429 val_429 -43 val_43 -430 val_430 -431 val_431 -432 val_432 -435 val_435 -436 val_436 -437 val_437 -438 val_438 -439 val_439 -44 val_44 -443 val_443 -444 val_444 -446 val_446 -448 val_448 -449 val_449 -452 val_452 -453 val_453 -454 val_454 -455 val_455 -457 val_457 -458 val_458 -459 val_459 -460 val_460 -462 val_462 -463 val_463 -466 val_466 -467 val_467 -468 val_468 -469 val_469 -47 val_47 -470 val_470 -472 val_472 -475 val_475 -477 val_477 -478 val_478 -479 val_479 -480 val_480 -481 val_481 -482 val_482 -483 val_483 -484 val_484 -485 val_485 -487 val_487 -489 val_489 -490 val_490 -491 val_491 -492 val_492 -493 val_493 -494 val_494 -495 val_495 -496 val_496 -497 val_497 -498 val_498 -5 val_5 -51 val_51 -53 val_53 -54 val_54 -57 val_57 -58 val_58 -64 val_64 -65 val_65 -66 val_66 -67 val_67 -69 val_69 -70 val_70 -72 val_72 -74 val_74 -76 val_76 -77 val_77 -78 val_78 -8 val_8 -80 val_80 -82 val_82 -83 val_83 -84 val_84 -85 val_85 -86 val_86 -87 val_87 -9 val_9 -90 val_90 -92 val_92 -95 val_95 -96 val_96 -97 val_97 -98 val_98 -PREHOOK: query: EXPLAIN SELECT key, COUNT(value) FROM src GROUP BY key HAVING count(value) >= 4 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN SELECT key, COUNT(value) FROM src GROUP BY key HAVING count(value) >= 4 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: key, value - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count(value) - keys: key (type: string) - mode: hash - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 19475 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Map-reduce partition columns: _col0 (type: string) - Statistics: Num rows: 205 Data size: 19475 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col1 (type: bigint) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - keys: KEY._col0 (type: string) - mode: mergepartial - outputColumnNames: _col0, _col1 - Statistics: Num rows: 205 Data size: 19475 Basic stats: COMPLETE Column stats: COMPLETE - Filter Operator - predicate: (_col1 >= 4) (type: boolean) - Statistics: Num rows: 68 Data size: 6460 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 68 Data size: 6460 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: SELECT key, COUNT(value) FROM src GROUP BY key HAVING count(value) >= 4 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: SELECT key, COUNT(value) FROM src GROUP BY key HAVING count(value) >= 4 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -138 4 -169 4 -230 5 -277 4 -348 5 -401 5 -406 4 -468 4 -469 5 -489 4
http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/identity_project_remove_skip.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/identity_project_remove_skip.q.out b/ql/src/test/results/clientpositive/tez/identity_project_remove_skip.q.out deleted file mode 100644 index d9d24f4..0000000 --- a/ql/src/test/results/clientpositive/tez/identity_project_remove_skip.q.out +++ /dev/null @@ -1,120 +0,0 @@ -PREHOOK: query: explain -select t2.* -from - (select key,value from (select key,value from src) t1 sort by key) t2 - join - (select * from src sort by key) t3 - on (t2.key=t3.key ) - where t2.value='val_105' and t3.key='105' -PREHOOK: type: QUERY -POSTHOOK: query: explain -select t2.* -from - (select key,value from (select key,value from src) t1 sort by key) t2 - join - (select * from src sort by key) t3 - on (t2.key=t3.key ) - where t2.value='val_105' and t3.key='105' -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) - Reducer 4 <- Map 3 (SIMPLE_EDGE), Reducer 2 (BROADCAST_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: ((key is not null and (value = 'val_105')) and (key = '105')) (type: boolean) - Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE - Select Operator - Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: '105' (type: string) - sort order: + - Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE - Map 3 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Filter Operator - predicate: (key = '105') (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Select Operator - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: '105' (type: string) - sort order: + - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Reducer 2 - Reduce Operator Tree: - Select Operator - Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE - Reduce Output Operator - key expressions: '105' (type: string) - sort order: + - Map-reduce partition columns: '105' (type: string) - Statistics: Num rows: 62 Data size: 658 Basic stats: COMPLETE Column stats: NONE - Reducer 4 - Reduce Operator Tree: - Select Operator - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE - Map Join Operator - condition map: - Inner Join 0 to 1 - keys: - 0 '105' (type: string) - 1 '105' (type: string) - input vertices: - 0 Reducer 2 - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE - HybridGraceHashJoin: true - Select Operator - expressions: '105' (type: string), 'val_105' (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 275 Data size: 2921 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select t2.* -from - (select key,value from (select key,value from src) t1 sort by key) t2 - join - (select * from src sort by key) t3 - on (t2.key=t3.key ) - where t2.value='val_105' and t3.key='105' -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: select t2.* -from - (select key,value from (select key,value from src) t1 sort by key) t2 - join - (select * from src sort by key) t3 - on (t2.key=t3.key ) - where t2.value='val_105' and t3.key='105' -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -105 val_105 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/insert1.q.out b/ql/src/test/results/clientpositive/tez/insert1.q.out deleted file mode 100644 index 468c03f..0000000 --- a/ql/src/test/results/clientpositive/tez/insert1.q.out +++ /dev/null @@ -1,440 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -create table insert1(key int, value string) stored as textfile -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@insert1 -POSTHOOK: query: -- SORT_QUERY_RESULTS - -create table insert1(key int, value string) stored as textfile -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@insert1 -PREHOOK: query: create table insert2(key int, value string) stored as textfile -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@insert2 -POSTHOOK: query: create table insert2(key int, value string) stored as textfile -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@insert2 -PREHOOK: query: insert overwrite table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1) -PREHOOK: type: QUERY -PREHOOK: Input: default@insert2 -PREHOOK: Output: default@insert1 -POSTHOOK: query: insert overwrite table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1) -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert2 -POSTHOOK: Output: default@insert1 -POSTHOOK: Lineage: insert1.key SIMPLE [(insert2)a.FieldSchema(name:key, type:int, comment:null), ] -POSTHOOK: Lineage: insert1.value SIMPLE [(insert2)a.FieldSchema(name:value, type:string, comment:null), ] -PREHOOK: query: explain insert into table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1) -PREHOOK: type: QUERY -POSTHOOK: query: explain insert into table insert1 select a.key, a.value from insert2 a WHERE (a.key=-1) -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: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Filter Operator - predicate: (key = -1) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: -1 (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: explain insert into table INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) -PREHOOK: type: QUERY -POSTHOOK: query: explain insert into table INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) -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: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Filter Operator - predicate: (key = -1) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: -1 (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: -- HIVE-3465 -create database x -PREHOOK: type: CREATEDATABASE -PREHOOK: Output: database:x -POSTHOOK: query: -- HIVE-3465 -create database x -POSTHOOK: type: CREATEDATABASE -POSTHOOK: Output: database:x -PREHOOK: query: create table x.insert1(key int, value string) stored as textfile -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:x -PREHOOK: Output: x@insert1 -POSTHOOK: query: create table x.insert1(key int, value string) stored as textfile -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:x -POSTHOOK: Output: x@insert1 -PREHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) -PREHOOK: type: QUERY -POSTHOOK: query: explain insert into table x.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) -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: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Filter Operator - predicate: (key = -1) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: -1 (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x.insert1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x.insert1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: explain insert into table default.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) -PREHOOK: type: QUERY -POSTHOOK: query: explain insert into table default.INSERT1 select a.key, a.value from insert2 a WHERE (a.key=-1) -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: - Map 1 - Map Operator Tree: - TableScan - alias: a - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Filter Operator - predicate: (key = -1) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: -1 (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: explain -from insert2 -insert into table insert1 select * where key < 10 -insert overwrite table x.insert1 select * where key > 10 and key < 20 -PREHOOK: type: QUERY -POSTHOOK: query: explain -from insert2 -insert into table insert1 select * where key < 10 -insert overwrite table x.insert1 select * where key > 10 and key < 20 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-2 is a root stage - Stage-3 depends on stages: Stage-2 - Stage-0 depends on stages: Stage-3 - Stage-4 depends on stages: Stage-0 - Stage-1 depends on stages: Stage-3 - Stage-5 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-2 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: insert2 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Filter Operator - predicate: (key < 10) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - Filter Operator - predicate: ((key > 10) and (key < 20)) (type: boolean) - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 0 Basic stats: PARTIAL Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x.insert1 - - Stage: Stage-3 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert1 - - Stage: Stage-4 - Stats-Aggr Operator - - Stage: Stage-1 - Move Operator - tables: - replace: true - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: x.insert1 - - Stage: Stage-5 - Stats-Aggr Operator - -PREHOOK: query: -- HIVE-3676 -CREATE DATABASE db2 -PREHOOK: type: CREATEDATABASE -PREHOOK: Output: database:db2 -POSTHOOK: query: -- HIVE-3676 -CREATE DATABASE db2 -POSTHOOK: type: CREATEDATABASE -POSTHOOK: Output: database:db2 -PREHOOK: query: USE db2 -PREHOOK: type: SWITCHDATABASE -PREHOOK: Input: database:db2 -POSTHOOK: query: USE db2 -POSTHOOK: type: SWITCHDATABASE -POSTHOOK: Input: database:db2 -PREHOOK: query: CREATE TABLE result(col1 STRING) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:db2 -PREHOOK: Output: db2@result -POSTHOOK: query: CREATE TABLE result(col1 STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:db2 -POSTHOOK: Output: db2@result -PREHOOK: query: INSERT OVERWRITE TABLE result SELECT 'db2_insert1' FROM default.src LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: db2@result -POSTHOOK: query: INSERT OVERWRITE TABLE result SELECT 'db2_insert1' FROM default.src LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: db2@result -POSTHOOK: Lineage: result.col1 SIMPLE [] -PREHOOK: query: INSERT INTO TABLE result SELECT 'db2_insert2' FROM default.src LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: db2@result -POSTHOOK: query: INSERT INTO TABLE result SELECT 'db2_insert2' FROM default.src LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: db2@result -POSTHOOK: Lineage: result.col1 SIMPLE [] -PREHOOK: query: SELECT * FROM result -PREHOOK: type: QUERY -PREHOOK: Input: db2@result -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM result -POSTHOOK: type: QUERY -POSTHOOK: Input: db2@result -#### A masked pattern was here #### -db2_insert1 -db2_insert2 -PREHOOK: query: USE default -PREHOOK: type: SWITCHDATABASE -PREHOOK: Input: database:default -POSTHOOK: query: USE default -POSTHOOK: type: SWITCHDATABASE -POSTHOOK: Input: database:default -PREHOOK: query: CREATE DATABASE db1 -PREHOOK: type: CREATEDATABASE -PREHOOK: Output: database:db1 -POSTHOOK: query: CREATE DATABASE db1 -POSTHOOK: type: CREATEDATABASE -POSTHOOK: Output: database:db1 -PREHOOK: query: CREATE TABLE db1.result(col1 STRING) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:db1 -PREHOOK: Output: db1@result -POSTHOOK: query: CREATE TABLE db1.result(col1 STRING) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:db1 -POSTHOOK: Output: db1@result -PREHOOK: query: INSERT OVERWRITE TABLE db1.result SELECT 'db1_insert1' FROM src LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: db1@result -POSTHOOK: query: INSERT OVERWRITE TABLE db1.result SELECT 'db1_insert1' FROM src LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: db1@result -POSTHOOK: Lineage: result.col1 SIMPLE [] -PREHOOK: query: INSERT INTO TABLE db1.result SELECT 'db1_insert2' FROM src LIMIT 1 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: db1@result -POSTHOOK: query: INSERT INTO TABLE db1.result SELECT 'db1_insert2' FROM src LIMIT 1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: db1@result -POSTHOOK: Lineage: result.col1 SIMPLE [] -PREHOOK: query: SELECT * FROM db1.result -PREHOOK: type: QUERY -PREHOOK: Input: db1@result -#### A masked pattern was here #### -POSTHOOK: query: SELECT * FROM db1.result -POSTHOOK: type: QUERY -POSTHOOK: Input: db1@result -#### A masked pattern was here #### -db1_insert1 -db1_insert2 http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out b/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out deleted file mode 100644 index 07eedf3..0000000 --- a/ql/src/test/results/clientpositive/tez/insert_acid_dynamic_partition.q.out +++ /dev/null @@ -1,48 +0,0 @@ -PREHOOK: query: create table acid_dynamic(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_dynamic -POSTHOOK: query: create table acid_dynamic(a int, b varchar(128)) partitioned by (ds string) clustered by (a) into 2 buckets stored as orc TBLPROPERTIES ('transactional'='true') -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_dynamic -PREHOOK: query: insert into table acid_dynamic partition (ds) select cint, cast(cstring1 as varchar(128)), cstring2 from alltypesorc where cint is not null and cint < 0 order by cint limit 5 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_dynamic -POSTHOOK: query: insert into table acid_dynamic partition (ds) select cint, cast(cstring1 as varchar(128)), cstring2 from alltypesorc where cint is not null and cint < 0 order by cint limit 5 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P -POSTHOOK: Output: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d -POSTHOOK: Output: default@acid_dynamic@ds=KbaDXiN85adbHRx58v -POSTHOOK: Output: default@acid_dynamic@ds=P76636jJ6qM17d7DIy -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4KWs6gw7lv2WYd66P).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4KWs6gw7lv2WYd66P).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4hA4KQj2vD3fI6gX82220d).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=4hA4KQj2vD3fI6gX82220d).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=KbaDXiN85adbHRx58v).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=KbaDXiN85adbHRx58v).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=P76636jJ6qM17d7DIy).a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_dynamic PARTITION(ds=P76636jJ6qM17d7DIy).b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select * from acid_dynamic order by a,b -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_dynamic -PREHOOK: Input: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P -PREHOOK: Input: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d -PREHOOK: Input: default@acid_dynamic@ds=KbaDXiN85adbHRx58v -PREHOOK: Input: default@acid_dynamic@ds=P76636jJ6qM17d7DIy -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_dynamic order by a,b -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_dynamic -POSTHOOK: Input: default@acid_dynamic@ds=4KWs6gw7lv2WYd66P -POSTHOOK: Input: default@acid_dynamic@ds=4hA4KQj2vD3fI6gX82220d -POSTHOOK: Input: default@acid_dynamic@ds=KbaDXiN85adbHRx58v -POSTHOOK: Input: default@acid_dynamic@ds=P76636jJ6qM17d7DIy -#### A masked pattern was here #### --1073279343 oj1YrV5Wa P76636jJ6qM17d7DIy --1073051226 A34p7oRr2WvUJNf 4hA4KQj2vD3fI6gX82220d --1072910839 0iqrc5 KbaDXiN85adbHRx58v --1072081801 dPkN74F7 4KWs6gw7lv2WYd66P --1072076362 2uLyD28144vklju213J1mr 4KWs6gw7lv2WYd66P http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out b/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out deleted file mode 100644 index 985ae40..0000000 --- a/ql/src/test/results/clientpositive/tez/insert_acid_not_bucketed.q.out +++ /dev/null @@ -1,36 +0,0 @@ -PREHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@acid_notbucketed -POSTHOOK: query: create table acid_notbucketed(a int, b varchar(128)) stored as orc -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@acid_notbucketed -PREHOOK: query: insert into table acid_notbucketed select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@alltypesorc -PREHOOK: Output: default@acid_notbucketed -POSTHOOK: query: insert into table acid_notbucketed select cint, cast(cstring1 as varchar(128)) from alltypesorc where cint is not null order by cint limit 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@alltypesorc -POSTHOOK: Output: default@acid_notbucketed -POSTHOOK: Lineage: acid_notbucketed.a SIMPLE [(alltypesorc)alltypesorc.FieldSchema(name:cint, type:int, comment:null), ] -POSTHOOK: Lineage: acid_notbucketed.b EXPRESSION [(alltypesorc)alltypesorc.FieldSchema(name:cstring1, type:string, comment:null), ] -PREHOOK: query: select * from acid_notbucketed -PREHOOK: type: QUERY -PREHOOK: Input: default@acid_notbucketed -#### A masked pattern was here #### -POSTHOOK: query: select * from acid_notbucketed -POSTHOOK: type: QUERY -POSTHOOK: Input: default@acid_notbucketed -#### A masked pattern was here #### --1073279343 oj1YrV5Wa --1073051226 A34p7oRr2WvUJNf --1072910839 0iqrc5 --1072081801 dPkN74F7 --1072076362 2uLyD28144vklju213J1mr --1071480828 aw724t8c5558x2xneC624 --1071363017 Anj0oF --1070883071 0ruyd6Y50JpdGRf6HqD --1070551679 iUR3Q --1069736047 k17Am8uPHWk02cEf1jet http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_dir_distcp.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/insert_dir_distcp.q.out b/ql/src/test/results/clientpositive/tez/insert_dir_distcp.q.out deleted file mode 100644 index b70fa01..0000000 --- a/ql/src/test/results/clientpositive/tez/insert_dir_distcp.q.out +++ /dev/null @@ -1,14 +0,0 @@ -PREHOOK: query: -- see TEZ-2931 for using INFO logging - -#### A masked pattern was here #### -PREHOOK: type: QUERY -PREHOOK: Input: default@src -#### A masked pattern was here #### -POSTHOOK: query: -- see TEZ-2931 for using INFO logging - -#### A masked pattern was here #### -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -#### A masked pattern was here #### -Found 1 items -#### A masked pattern was here #### http://git-wip-us.apache.org/repos/asf/hive/blob/975a49b6/ql/src/test/results/clientpositive/tez/insert_into1.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/tez/insert_into1.q.out b/ql/src/test/results/clientpositive/tez/insert_into1.q.out deleted file mode 100644 index 3729370..0000000 --- a/ql/src/test/results/clientpositive/tez/insert_into1.q.out +++ /dev/null @@ -1,632 +0,0 @@ -PREHOOK: query: -- SORT_QUERY_RESULTS - -DROP TABLE insert_into1 -PREHOOK: type: DROPTABLE -POSTHOOK: query: -- SORT_QUERY_RESULTS - -DROP TABLE insert_into1 -POSTHOOK: type: DROPTABLE -PREHOOK: query: CREATE TABLE insert_into1 (key int, value string) -PREHOOK: type: CREATETABLE -PREHOOK: Output: database:default -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: CREATE TABLE insert_into1 (key int, value string) -POSTHOOK: type: CREATETABLE -POSTHOOK: Output: database:default -POSTHOOK: Output: default@insert_into1 -PREHOOK: query: EXPLAIN INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 100 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 100 -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 #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 100 - Statistics: Num rows: 100 Data size: 17800 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: UDFToInteger(_col0) (type: int), _col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: INSERT INTO TABLE insert_into1 SELECT * from src ORDER BY key LIMIT 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@insert_into1 -POSTHOOK: Lineage: insert_into1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: insert_into1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT SUM(HASH(c)) FROM ( - SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 -) t -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT SUM(HASH(c)) FROM ( - SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 -) t -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### --1142373758 -PREHOOK: query: explain -select count(*) from insert_into1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -select count(*) from insert_into1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: 1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from insert_into1 -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from insert_into1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -100 -PREHOOK: query: EXPLAIN INSERT INTO TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 100 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT INTO TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 100 -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 #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 100 - Statistics: Num rows: 100 Data size: 17800 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: UDFToInteger(_col0) (type: int), _col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 100 Data size: 9500 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: INSERT INTO TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 100 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: INSERT INTO TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 100 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@insert_into1 -POSTHOOK: Lineage: insert_into1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: insert_into1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT SUM(HASH(c)) FROM ( - SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 -) t -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT SUM(HASH(c)) FROM ( - SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 -) t -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### --2284747516 -PREHOOK: query: explain -SELECT COUNT(*) FROM insert_into1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -SELECT COUNT(*) FROM insert_into1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: 1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from insert_into1 -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from insert_into1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -200 -PREHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 10 -PREHOOK: type: QUERY -POSTHOOK: query: EXPLAIN INSERT OVERWRITE TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 10 -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 #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: src - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: key (type: string), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - key expressions: _col0 (type: string) - sort order: + - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - TopN Hash Memory Usage: 0.1 - value expressions: _col1 (type: string) - Reducer 2 - Reduce Operator Tree: - Select Operator - expressions: KEY.reducesinkkey0 (type: string), VALUE._col0 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 89000 Basic stats: COMPLETE Column stats: COMPLETE - Limit - Number of rows: 10 - Statistics: Num rows: 10 Data size: 1780 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: UDFToInteger(_col0) (type: int), _col1 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 10 Data size: 950 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 10 Data size: 950 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: true - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: INSERT OVERWRITE TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 10 -PREHOOK: type: QUERY -PREHOOK: Input: default@src -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: INSERT OVERWRITE TABLE insert_into1 SELECT * FROM src ORDER BY key LIMIT 10 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@src -POSTHOOK: Output: default@insert_into1 -POSTHOOK: Lineage: insert_into1.key EXPRESSION [(src)src.FieldSchema(name:key, type:string, comment:default), ] -POSTHOOK: Lineage: insert_into1.value SIMPLE [(src)src.FieldSchema(name:value, type:string, comment:default), ] -PREHOOK: query: SELECT SUM(HASH(c)) FROM ( - SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 -) t -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: SELECT SUM(HASH(c)) FROM ( - SELECT TRANSFORM(*) USING 'tr \t _' AS (c) FROM insert_into1 -) t -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### --2693537120 -PREHOOK: query: explain -SELECT COUNT(*) FROM insert_into1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -SELECT COUNT(*) FROM insert_into1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-0 is a root stage - -STAGE PLANS: - Stage: Stage-0 - Fetch Operator - limit: 1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from insert_into1 -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from insert_into1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -10 -PREHOOK: query: explain insert overwrite table insert_into1 select 1, 'a' -PREHOOK: type: QUERY -POSTHOOK: query: explain insert overwrite table insert_into1 select 1, 'a' -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: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: 1 (type: int), 'a' (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: true - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: insert overwrite table insert_into1 select 1, 'a' -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: insert overwrite table insert_into1 select 1, 'a' -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@insert_into1 -POSTHOOK: Lineage: insert_into1.key SIMPLE [] -POSTHOOK: Lineage: insert_into1.value SIMPLE [] -PREHOOK: query: explain insert into insert_into1 select 2, 'b' -PREHOOK: type: QUERY -POSTHOOK: query: explain insert into insert_into1 select 2, 'b' -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: - Map 1 - Map Operator Tree: - TableScan - alias: _dummy_table - Row Limit Per Split: 1 - Statistics: Num rows: 1 Data size: 1 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - expressions: 2 (type: int), 'b' (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 89 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-3 - Stats-Aggr Operator - -PREHOOK: query: insert into insert_into1 select 2, 'b' -PREHOOK: type: QUERY -PREHOOK: Input: _dummy_database@_dummy_table -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: insert into insert_into1 select 2, 'b' -POSTHOOK: type: QUERY -POSTHOOK: Input: _dummy_database@_dummy_table -POSTHOOK: Output: default@insert_into1 -POSTHOOK: Lineage: insert_into1.key SIMPLE [] -POSTHOOK: Lineage: insert_into1.value SIMPLE [] -PREHOOK: query: select * from insert_into1 -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: select * from insert_into1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -1 a -2 b -PREHOOK: query: explain -insert into table insert_into1 values(1, 'abc') -PREHOOK: type: QUERY -POSTHOOK: query: explain -insert into table insert_into1 values(1, 'abc') -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 PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: values__tmp__table__1 - Statistics: Num rows: 1 Data size: 6 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: UDFToInteger(tmp_values_col1) (type: int), tmp_values_col2 (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 1 Data size: 6 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 6 Basic stats: COMPLETE Column stats: NONE - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - - Stage: Stage-2 - Dependency Collection - - Stage: Stage-0 - Move Operator - tables: - replace: false - table: - input format: org.apache.hadoop.mapred.TextInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - name: default.insert_into1 - -PREHOOK: query: insert into table insert_into1 values(1, 'abc') -PREHOOK: type: QUERY -PREHOOK: Input: default@values__tmp__table__2 -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: insert into table insert_into1 values(1, 'abc') -POSTHOOK: type: QUERY -POSTHOOK: Input: default@values__tmp__table__2 -POSTHOOK: Output: default@insert_into1 -POSTHOOK: Lineage: insert_into1.key EXPRESSION [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col1, type:string, comment:), ] -POSTHOOK: Lineage: insert_into1.value SIMPLE [(values__tmp__table__2)values__tmp__table__2.FieldSchema(name:tmp_values_col2, type:string, comment:), ] -PREHOOK: query: explain -SELECT COUNT(*) FROM insert_into1 -PREHOOK: type: QUERY -POSTHOOK: query: explain -SELECT COUNT(*) FROM insert_into1 -POSTHOOK: type: QUERY -STAGE DEPENDENCIES: - Stage-1 is a root stage - Stage-0 depends on stages: Stage-1 - -STAGE PLANS: - Stage: Stage-1 - Tez -#### A masked pattern was here #### - Edges: - Reducer 2 <- Map 1 (SIMPLE_EDGE) -#### A masked pattern was here #### - Vertices: - Map 1 - Map Operator Tree: - TableScan - alias: insert_into1 - Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: COMPLETE - Select Operator - Statistics: Num rows: 2 Data size: 6 Basic stats: COMPLETE Column stats: COMPLETE - Group By Operator - aggregations: count() - mode: hash - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - Reduce Output Operator - sort order: - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - value expressions: _col0 (type: bigint) - Reducer 2 - Reduce Operator Tree: - Group By Operator - aggregations: count(VALUE._col0) - mode: mergepartial - outputColumnNames: _col0 - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - File Output Operator - compressed: false - Statistics: Num rows: 1 Data size: 8 Basic stats: COMPLETE Column stats: COMPLETE - table: - input format: org.apache.hadoop.mapred.SequenceFileInputFormat - output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat - serde: org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe - - Stage: Stage-0 - Fetch Operator - limit: -1 - Processor Tree: - ListSink - -PREHOOK: query: select count(*) from insert_into1 -PREHOOK: type: QUERY -PREHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -POSTHOOK: query: select count(*) from insert_into1 -POSTHOOK: type: QUERY -POSTHOOK: Input: default@insert_into1 -#### A masked pattern was here #### -3 -PREHOOK: query: DROP TABLE insert_into1 -PREHOOK: type: DROPTABLE -PREHOOK: Input: default@insert_into1 -PREHOOK: Output: default@insert_into1 -POSTHOOK: query: DROP TABLE insert_into1 -POSTHOOK: type: DROPTABLE -POSTHOOK: Input: default@insert_into1 -POSTHOOK: Output: default@insert_into1
