PREHOOK: query: EXPLAIN SELECT src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: src Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value > 'val_10') and (value > 'val_200')) (type: boolean) Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: value (type: string), key (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((_col1 > 30) or (_col0 < 'val_400')) (type: boolean) Statistics: Num rows: 18 Data size: 190 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Statistics: Num rows: 18 Data size: 190 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 18 Data size: 190 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 src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### val_201 val_202 val_203 val_205 val_207 val_208 val_209 val_213 val_214 val_216 val_217 val_218 val_219 val_221 val_222 val_223 val_224 val_226 val_228 val_229 val_230 val_233 val_235 val_237 val_238 val_239 val_24 val_241 val_242 val_244 val_247 val_248 val_249 val_252 val_255 val_256 val_257 val_258 val_26 val_260 val_262 val_263 val_265 val_266 val_27 val_272 val_273 val_274 val_275 val_277 val_278 val_28 val_280 val_281 val_282 val_283 val_284 val_285 val_286 val_287 val_288 val_289 val_291 val_292 val_296 val_298 val_30 val_302 val_305 val_306 val_307 val_308 val_309 val_310 val_311 val_315 val_316 val_317 val_318 val_321 val_322 val_323 val_325 val_327 val_33 val_331 val_332 val_333 val_335 val_336 val_338 val_339 val_34 val_341 val_342 val_344 val_345 val_348 val_35 val_351 val_353 val_356 val_360 val_362 val_364 val_365 val_366 val_367 val_368 val_369 val_37 val_373 val_374 val_375 val_377 val_378 val_379 val_382 val_384 val_386 val_389 val_392 val_393 val_394 val_395 val_396 val_397 val_399 val_4 PREHOOK: query: EXPLAIN SELECT src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') PREHOOK: type: QUERY POSTHOOK: query: EXPLAIN SELECT src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') POSTHOOK: type: QUERY STAGE DEPENDENCIES: Stage-1 is a root stage Stage-0 depends on stages: Stage-1 STAGE PLANS: Stage: Stage-1 Map Reduce Map Operator Tree: TableScan alias: src Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((value > 'val_10') and (value > 'val_200')) (type: boolean) Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: value (type: string), key (type: string) outputColumnNames: _col0, _col1 Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Group By Operator aggregations: count(_col1) keys: _col0 (type: string) mode: hash outputColumnNames: _col0, _col1 Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE Reduce Output Operator key expressions: _col0 (type: string) sort order: + Map-reduce partition columns: _col0 (type: string) Statistics: Num rows: 55 Data size: 584 Basic stats: COMPLETE Column stats: NONE value expressions: _col1 (type: bigint) Reduce Operator Tree: Group By Operator aggregations: count(VALUE._col0) keys: KEY._col0 (type: string) mode: mergepartial outputColumnNames: _col0, _col1 Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE Filter Operator predicate: ((_col1 > 30) or (_col0 < 'val_400')) (type: boolean) Statistics: Num rows: 18 Data size: 190 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: _col0 (type: string) outputColumnNames: _col0 Statistics: Num rows: 18 Data size: 190 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false Statistics: Num rows: 18 Data size: 190 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 src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') PREHOOK: type: QUERY PREHOOK: Input: default@src #### A masked pattern was here #### POSTHOOK: query: SELECT src1.c1 FROM (SELECT src.value as c1, count(src.key) as c2 from src where src.value > 'val_10' group by src.value) src1 WHERE src1.c1 > 'val_200' and (src1.c2 > 30 or src1.c1 < 'val_400') POSTHOOK: type: QUERY POSTHOOK: Input: default@src #### A masked pattern was here #### val_201 val_202 val_203 val_205 val_207 val_208 val_209 val_213 val_214 val_216 val_217 val_218 val_219 val_221 val_222 val_223 val_224 val_226 val_228 val_229 val_230 val_233 val_235 val_237 val_238 val_239 val_24 val_241 val_242 val_244 val_247 val_248 val_249 val_252 val_255 val_256 val_257 val_258 val_26 val_260 val_262 val_263 val_265 val_266 val_27 val_272 val_273 val_274 val_275 val_277 val_278 val_28 val_280 val_281 val_282 val_283 val_284 val_285 val_286 val_287 val_288 val_289 val_291 val_292 val_296 val_298 val_30 val_302 val_305 val_306 val_307 val_308 val_309 val_310 val_311 val_315 val_316 val_317 val_318 val_321 val_322 val_323 val_325 val_327 val_33 val_331 val_332 val_333 val_335 val_336 val_338 val_339 val_34 val_341 val_342 val_344 val_345 val_348 val_35 val_351 val_353 val_356 val_360 val_362 val_364 val_365 val_366 val_367 val_368 val_369 val_37 val_373 val_374 val_375 val_377 val_378 val_379 val_382 val_384 val_386 val_389 val_392 val_393 val_394 val_395 val_396 val_397 val_399 val_4