http://git-wip-us.apache.org/repos/asf/hive/blob/3c71687d/ql/src/test/results/clientpositive/masking_4.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_4.q.out b/ql/src/test/results/clientpositive/masking_4.q.out index 068c484..1d096f8 100644 --- a/ql/src/test/results/clientpositive/masking_4.q.out +++ b/ql/src/test/results/clientpositive/masking_4.q.out @@ -85,15 +85,15 @@ STAGE PLANS: alias: masking_test_n11 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (key = 5) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + predicate: (((key % 2) = 0) and (key = 5)) (type: boolean) + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: 5 (type: int), value (type: string) + expressions: 5 (type: int), reverse(value) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -126,15 +126,15 @@ STAGE PLANS: alias: masking_test_n11 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (key = 5) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + predicate: (((key % 2) = 0) and (key = 5)) (type: boolean) + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: 5 (type: int), value (type: string) + expressions: 5 (type: int), reverse(value) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 125 Data size: 1328 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -156,19 +156,137 @@ with q1 as ( select * from masking_test_n11 where key = '5') select * from masking_test_subq_n2 POSTHOOK: type: QUERY STAGE DEPENDENCIES: - Stage-0 is a root stage + Stage-3 is a root stage + Stage-2 depends on stages: Stage-3 + Stage-1 depends on stages: Stage-2 + Stage-0 depends on stages: Stage-1 STAGE PLANS: + Stage: Stage-3 + Map Reduce + Map Operator Tree: + TableScan + alias: masking_test_subq_n2 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Group By Operator + keys: key (type: int) + mode: hash + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: _col0 (type: int) + sort order: + + Map-reduce partition columns: _col0 (type: int) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Execution mode: vectorized + Reduce Operator Tree: + Group By Operator + keys: KEY._col0 (type: int) + mode: mergepartial + outputColumnNames: _col0 + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-2 + Map Reduce + 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 (type: boolean) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: string) + outputColumnNames: _col0 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: UDFToDouble(_col0) (type: double) + sort order: + + Map-reduce partition columns: UDFToDouble(_col0) (type: double) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: string) + TableScan + Reduce Output Operator + key expressions: UDFToDouble(_col0) (type: double) + sort order: + + Map-reduce partition columns: UDFToDouble(_col0) (type: double) + Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + value expressions: _col0 (type: int) + Reduce Operator Tree: + Join Operator + condition map: + Inner Join 0 to 1 + keys: + 0 UDFToDouble(_col0) (type: double) + 1 UDFToDouble(_col0) (type: double) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE + Group By Operator + keys: _col0 (type: string), _col1 (type: int) + mode: hash + outputColumnNames: _col0, _col1 + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + table: + input format: org.apache.hadoop.mapred.SequenceFileInputFormat + output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat + serde: org.apache.hadoop.hive.serde2.lazybinary.LazyBinarySerDe + + Stage: Stage-1 + Map Reduce + Map Operator Tree: + TableScan + alias: masking_test_subq_n2 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: key is not null (type: boolean) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), value (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Reduce Output Operator + key expressions: UDFToDouble(_col0) (type: double), _col0 (type: int) + sort order: ++ + Map-reduce partition columns: UDFToDouble(_col0) (type: double), _col0 (type: int) + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + value expressions: _col1 (type: string) + TableScan + Reduce Output Operator + key expressions: UDFToDouble(_col0) (type: double), _col1 (type: int) + sort order: ++ + Map-reduce partition columns: UDFToDouble(_col0) (type: double), _col1 (type: int) + Statistics: Num rows: 550 Data size: 5843 Basic stats: COMPLETE Column stats: NONE + Reduce Operator Tree: + Join Operator + condition map: + Left Semi Join 0 to 1 + keys: + 0 UDFToDouble(_col0) (type: double), _col0 (type: int) + 1 UDFToDouble(_col0) (type: double), _col1 (type: int) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 605 Data size: 6427 Basic stats: COMPLETE Column stats: NONE + 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: - TableScan - alias: masking_test_subq_n2 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - ListSink + ListSink
http://git-wip-us.apache.org/repos/asf/hive/blob/3c71687d/ql/src/test/results/clientpositive/masking_5.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_5.q.out b/ql/src/test/results/clientpositive/masking_5.q.out index 420a680..a0735ff 100644 --- a/ql/src/test/results/clientpositive/masking_5.q.out +++ b/ql/src/test/results/clientpositive/masking_5.q.out @@ -15,22 +15,38 @@ PREHOOK: type: QUERY POSTHOOK: query: explain select * from masking_test_n6 tablesample (10 rows) POSTHOOK: type: QUERY STAGE DEPENDENCIES: - Stage-0 is a root stage + 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: masking_test_n6 + Row Limit Per Split: 10 + Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE + Filter Operator + predicate: (((key % 2) = 0) and (key < 10)) (type: boolean) + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), reverse(value) (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + 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 + Execution mode: vectorized + Stage: Stage-0 Fetch Operator limit: -1 Processor Tree: - TableScan - alias: masking_test_n6 - Row Limit Per Split: 10 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - ListSink + ListSink PREHOOK: query: select * from masking_test_n6 tablesample (10 rows) PREHOOK: type: QUERY @@ -40,16 +56,6 @@ POSTHOOK: query: select * from masking_test_n6 tablesample (10 rows) POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n6 #### A masked pattern was here #### -238 val_238 -86 val_86 -311 val_311 -27 val_27 -165 val_165 -409 val_409 -255 val_255 -278 val_278 -98 val_98 -484 val_484 PREHOOK: query: explain select * from masking_test_n6 tablesample(1 percent) PREHOOK: type: QUERY @@ -67,17 +73,20 @@ STAGE PLANS: TableScan alias: masking_test_n6 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: key (type: int), value (type: string) - outputColumnNames: _col0, _col1 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - 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 + Filter Operator + predicate: (((key % 2) = 0) and (key < 10)) (type: boolean) + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: key (type: int), reverse(value) (type: string) + outputColumnNames: _col0, _col1 + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + 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 Execution mode: vectorized Stage: Stage-0 @@ -94,506 +103,12 @@ POSTHOOK: query: select * from masking_test_n6 tablesample(1 percent) POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n6 #### A masked pattern was here #### -238 val_238 -86 val_86 -311 val_311 -27 val_27 -165 val_165 -409 val_409 -255 val_255 -278 val_278 -98 val_98 -484 val_484 -265 val_265 -193 val_193 -401 val_401 -150 val_150 -273 val_273 -224 val_224 -369 val_369 -66 val_66 -128 val_128 -213 val_213 -146 val_146 -406 val_406 -429 val_429 -374 val_374 -152 val_152 -469 val_469 -145 val_145 -495 val_495 -37 val_37 -327 val_327 -281 val_281 -277 val_277 -209 val_209 -15 val_15 -82 val_82 -403 val_403 -166 val_166 -417 val_417 -430 val_430 -252 val_252 -292 val_292 -219 val_219 -287 val_287 -153 val_153 -193 val_193 -338 val_338 -446 val_446 -459 val_459 -394 val_394 -237 val_237 -482 val_482 -174 val_174 -413 val_413 -494 val_494 -207 val_207 -199 val_199 -466 val_466 -208 val_208 -174 val_174 -399 val_399 -396 val_396 -247 val_247 -417 val_417 -489 val_489 -162 val_162 -377 val_377 -397 val_397 -309 val_309 -365 val_365 -266 val_266 -439 val_439 -342 val_342 -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 -0 val_0 -455 val_455 -128 val_128 -311 val_311 -316 val_316 -57 val_57 -302 val_302 -205 val_205 -149 val_149 -438 val_438 -345 val_345 -129 val_129 -170 val_170 -20 val_20 -489 val_489 -157 val_157 -378 val_378 -221 val_221 -92 val_92 -111 val_111 -47 val_47 -72 val_72 -4 val_4 -280 val_280 -35 val_35 -427 val_427 -277 val_277 -208 val_208 -356 val_356 -399 val_399 -169 val_169 -382 val_382 -498 val_498 -125 val_125 -386 val_386 -437 val_437 -469 val_469 -192 val_192 -286 val_286 -187 val_187 -176 val_176 -54 val_54 -459 val_459 -51 val_51 -138 val_138 -103 val_103 -239 val_239 -213 val_213 -216 val_216 -430 val_430 -278 val_278 -176 val_176 -289 val_289 -221 val_221 -65 val_65 -318 val_318 -332 val_332 -311 val_311 -275 val_275 -137 val_137 -241 val_241 -83 val_83 -333 val_333 -180 val_180 -284 val_284 -12 val_12 -230 val_230 -181 val_181 -67 val_67 -260 val_260 -404 val_404 -384 val_384 -489 val_489 -353 val_353 -373 val_373 -272 val_272 -138 val_138 -217 val_217 -84 val_84 -348 val_348 -466 val_466 -58 val_58 -8 val_8 -411 val_411 -230 val_230 -208 val_208 -348 val_348 -24 val_24 -463 val_463 -431 val_431 -179 val_179 -172 val_172 -42 val_42 -129 val_129 -158 val_158 -119 val_119 -496 val_496 -0 val_0 -322 val_322 -197 val_197 -468 val_468 -393 val_393 -454 val_454 -100 val_100 -298 val_298 -199 val_199 -191 val_191 -418 val_418 -96 val_96 -26 val_26 -165 val_165 -327 val_327 -230 val_230 -205 val_205 -120 val_120 -131 val_131 -51 val_51 -404 val_404 -43 val_43 -436 val_436 -156 val_156 -469 val_469 -468 val_468 -308 val_308 -95 val_95 -196 val_196 -288 val_288 -481 val_481 -457 val_457 -98 val_98 -282 val_282 -197 val_197 -187 val_187 -318 val_318 -318 val_318 -409 val_409 -470 val_470 -137 val_137 -369 val_369 -316 val_316 -169 val_169 -413 val_413 -85 val_85 -77 val_77 -0 val_0 -490 val_490 -87 val_87 -364 val_364 -179 val_179 -118 val_118 -134 val_134 -395 val_395 -282 val_282 -138 val_138 -238 val_238 -419 val_419 -15 val_15 -118 val_118 -72 val_72 -90 val_90 -307 val_307 -19 val_19 -435 val_435 -10 val_10 -277 val_277 -273 val_273 -306 val_306 -224 val_224 -309 val_309 -389 val_389 -327 val_327 -242 val_242 -369 val_369 -392 val_392 -272 val_272 -331 val_331 -401 val_401 -242 val_242 -452 val_452 -177 val_177 -226 val_226 -5 val_5 -497 val_497 -402 val_402 -396 val_396 -317 val_317 -395 val_395 -58 val_58 -35 val_35 -336 val_336 -95 val_95 -11 val_11 -168 val_168 -34 val_34 -229 val_229 -233 val_233 -143 val_143 -472 val_472 -322 val_322 -498 val_498 -160 val_160 -195 val_195 -42 val_42 -321 val_321 -430 val_430 -119 val_119 -489 val_489 -458 val_458 -78 val_78 -76 val_76 -41 val_41 -223 val_223 -492 val_492 -149 val_149 -449 val_449 -218 val_218 -228 val_228 -138 val_138 -453 val_453 -30 val_30 -209 val_209 -64 val_64 -468 val_468 -76 val_76 -74 val_74 -342 val_342 -69 val_69 -230 val_230 -33 val_33 -368 val_368 -103 val_103 -296 val_296 -113 val_113 -216 val_216 -367 val_367 -344 val_344 -167 val_167 -274 val_274 -219 val_219 -239 val_239 -485 val_485 -116 val_116 -223 val_223 -256 val_256 -263 val_263 -70 val_70 -487 val_487 -480 val_480 -401 val_401 -288 val_288 -191 val_191 -5 val_5 -244 val_244 -438 val_438 -128 val_128 -467 val_467 -432 val_432 -202 val_202 -316 val_316 -229 val_229 -469 val_469 -463 val_463 -280 val_280 -2 val_2 -35 val_35 -283 val_283 -331 val_331 -235 val_235 -80 val_80 -44 val_44 -193 val_193 -321 val_321 -335 val_335 -104 val_104 -466 val_466 -366 val_366 -175 val_175 -403 val_403 -483 val_483 -53 val_53 -105 val_105 -257 val_257 -406 val_406 -409 val_409 -190 val_190 -406 val_406 -401 val_401 -114 val_114 -258 val_258 -90 val_90 -203 val_203 -262 val_262 -348 val_348 -424 val_424 -12 val_12 -396 val_396 -201 val_201 -217 val_217 -164 val_164 -431 val_431 -454 val_454 -478 val_478 -298 val_298 -125 val_125 -431 val_431 -164 val_164 -424 val_424 -187 val_187 -382 val_382 -5 val_5 -70 val_70 -397 val_397 -480 val_480 -291 val_291 -24 val_24 -351 val_351 -255 val_255 -104 val_104 -70 val_70 -163 val_163 -438 val_438 -119 val_119 -414 val_414 -200 val_200 -491 val_491 -237 val_237 -439 val_439 -360 val_360 -248 val_248 -479 val_479 -305 val_305 -417 val_417 -199 val_199 -444 val_444 -120 val_120 -429 val_429 -169 val_169 -443 val_443 -323 val_323 -325 val_325 -277 val_277 -230 val_230 -478 val_478 -178 val_178 -468 val_468 -310 val_310 -317 val_317 -333 val_333 -493 val_493 -460 val_460 -207 val_207 -249 val_249 -265 val_265 -480 val_480 -83 val_83 -136 val_136 -353 val_353 -172 val_172 -214 val_214 -462 val_462 -233 val_233 -406 val_406 -133 val_133 -175 val_175 -189 val_189 -454 val_454 -375 val_375 -401 val_401 -421 val_421 -407 val_407 -384 val_384 -256 val_256 -26 val_26 -134 val_134 -67 val_67 -384 val_384 -379 val_379 -18 val_18 -462 val_462 -492 val_492 -100 val_100 -298 val_298 -9 val_9 -341 val_341 -498 val_498 -146 val_146 -458 val_458 -362 val_362 -186 val_186 -285 val_285 -348 val_348 -167 val_167 -18 val_18 -273 val_273 -183 val_183 -281 val_281 -344 val_344 -97 val_97 -469 val_469 -315 val_315 -84 val_84 -28 val_28 -37 val_37 -448 val_448 -152 val_152 -348 val_348 -307 val_307 -194 val_194 -414 val_414 -477 val_477 -222 val_222 -126 val_126 -90 val_90 -169 val_169 -403 val_403 -400 val_400 -200 val_200 -97 val_97 +0 0_lav +4 4_lav +8 8_lav +0 0_lav +0 0_lav +2 2_lav PREHOOK: query: drop table masking_test_n6 PREHOOK: type: DROPTABLE PREHOOK: Input: default@masking_test_n6 @@ -637,18 +152,18 @@ STAGE PLANS: Map Reduce Map Operator Tree: TableScan - alias: s + alias: masking_test_n6 Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (((hash(key) & 2147483647) % 2) = 0) (type: boolean) - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + predicate: ((((hash(key) & 2147483647) % 2) = 0) and ((key % 2) = 0) and (key < 10)) (type: boolean) + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: key (type: int), value (type: string) + expressions: key (type: int), reverse(value) (type: string) outputColumnNames: _col0, _col1 - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 250 Data size: 2656 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 41 Data size: 435 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -669,246 +184,4 @@ POSTHOOK: query: select * from masking_test_n6 tablesample (bucket 1 out of 2) s POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n6 #### A masked pattern was here #### -238 val_238 -90 val_90 -126 val_126 -414 val_414 -348 val_348 -84 val_84 -344 val_344 -348 val_348 -362 val_362 -458 val_458 -146 val_146 -498 val_498 -384 val_384 -134 val_134 -256 val_256 -384 val_384 -454 val_454 -214 val_214 -480 val_480 -310 val_310 -178 val_178 -478 val_478 -444 val_444 -248 val_248 -360 val_360 -414 val_414 -70 val_70 -480 val_480 -70 val_70 -164 val_164 -478 val_478 -454 val_454 -164 val_164 -396 val_396 -348 val_348 -90 val_90 -190 val_190 -466 val_466 -80 val_80 -2 val_2 -316 val_316 -202 val_202 -432 val_432 -244 val_244 -480 val_480 -70 val_70 -256 val_256 -116 val_116 -344 val_344 -216 val_216 -368 val_368 -342 val_342 -64 val_64 -30 val_30 -458 val_458 -430 val_430 -498 val_498 -472 val_472 -336 val_336 -58 val_58 -396 val_396 -402 val_402 -226 val_226 -452 val_452 -272 val_272 -392 val_392 -10 val_10 -90 val_90 -238 val_238 -134 val_134 -364 val_364 -490 val_490 -316 val_316 -98 val_98 -308 val_308 -156 val_156 -404 val_404 -96 val_96 -454 val_454 -158 val_158 -348 val_348 -208 val_208 -58 val_58 -466 val_466 -348 val_348 -84 val_84 -272 val_272 -384 val_384 -404 val_404 -260 val_260 -284 val_284 -332 val_332 -430 val_430 -216 val_216 -54 val_54 -286 val_286 -386 val_386 -498 val_498 -208 val_208 -378 val_378 -20 val_20 -316 val_316 -342 val_342 -266 val_266 -162 val_162 -396 val_396 -208 val_208 -466 val_466 -482 val_482 -394 val_394 -446 val_446 -338 val_338 -292 val_292 -252 val_252 -430 val_430 -146 val_146 -484 val_484 -98 val_98 -86 val_86 -327 val_327 -437 val_437 -97 val_97 -435 val_435 -169 val_169 -19 val_19 -307 val_307 -255 val_255 -169 val_169 -307 val_307 -419 val_419 -399 val_399 -153 val_153 -287 val_287 -315 val_315 -97 val_97 -427 val_427 -369 val_369 -341 val_341 -77 val_77 -85 val_85 -169 val_169 -409 val_409 -369 val_369 -67 val_67 -137 val_137 -409 val_409 -407 val_407 -421 val_421 -133 val_133 -187 val_187 -233 val_233 -197 val_197 -221 val_221 -417 val_417 -353 val_353 -83 val_83 -249 val_249 -157 val_157 -317 val_317 -165 val_165 -325 val_325 -443 val_443 -169 val_169 -199 val_199 -417 val_417 -479 val_479 -43 val_43 -237 val_237 -491 val_491 -51 val_51 -119 val_119 -149 val_149 -163 val_163 -255 val_255 -351 val_351 -327 val_327 -291 val_291 -165 val_165 -397 val_397 -57 val_57 -187 val_187 -191 val_191 -199 val_199 -311 val_311 -201 val_201 -393 val_393 -197 val_197 -339 val_339 -119 val_119 -113 val_113 -17 val_17 -409 val_409 -105 val_105 -483 val_483 -463 val_463 -195 val_195 -325 val_325 -463 val_463 -229 val_229 -411 val_411 -327 val_327 -467 val_467 -365 val_365 -191 val_191 -397 val_397 -377 val_377 -353 val_353 -485 val_485 -239 val_239 -495 val_495 -113 val_113 -417 val_417 -67 val_67 -181 val_181 -69 val_69 -399 val_399 -83 val_83 -453 val_453 -137 val_137 -449 val_449 -149 val_149 -311 val_311 -41 val_41 -65 val_65 -119 val_119 -221 val_221 -289 val_289 -195 val_195 -199 val_199 -233 val_233 -229 val_229 -239 val_239 -27 val_27 -317 val_317 -51 val_51 -459 val_459 -497 val_497 -311 val_311 -177 val_177 -237 val_237 -187 val_187 -459 val_459 -369 val_369 +2 2_lav http://git-wip-us.apache.org/repos/asf/hive/blob/3c71687d/ql/src/test/results/clientpositive/masking_6.q.out ---------------------------------------------------------------------- diff --git a/ql/src/test/results/clientpositive/masking_6.q.out b/ql/src/test/results/clientpositive/masking_6.q.out index bee347f..0f1bcb4 100644 --- a/ql/src/test/results/clientpositive/masking_6.q.out +++ b/ql/src/test/results/clientpositive/masking_6.q.out @@ -32,17 +32,20 @@ STAGE PLANS: properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: UDFToInteger(key) (type: int), value (type: string), '12' (type: string) - outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - 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 + Filter Operator + predicate: (((UDFToInteger(key) % 2) = 0) and (UDFToInteger(key) < 10)) (type: boolean) + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: UDFToInteger(key) (type: int), reverse(value) (type: string), '12' (type: string) + outputColumnNames: _col0, _col1, _col2 + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + 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 Execution mode: vectorized Stage: Stage-0 @@ -61,506 +64,12 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n0 POSTHOOK: Input: default@src #### A masked pattern was here #### -238 val_238 12 -86 val_86 12 -311 val_311 12 -27 val_27 12 -165 val_165 12 -409 val_409 12 -255 val_255 12 -278 val_278 12 -98 val_98 12 -484 val_484 12 -265 val_265 12 -193 val_193 12 -401 val_401 12 -150 val_150 12 -273 val_273 12 -224 val_224 12 -369 val_369 12 -66 val_66 12 -128 val_128 12 -213 val_213 12 -146 val_146 12 -406 val_406 12 -429 val_429 12 -374 val_374 12 -152 val_152 12 -469 val_469 12 -145 val_145 12 -495 val_495 12 -37 val_37 12 -327 val_327 12 -281 val_281 12 -277 val_277 12 -209 val_209 12 -15 val_15 12 -82 val_82 12 -403 val_403 12 -166 val_166 12 -417 val_417 12 -430 val_430 12 -252 val_252 12 -292 val_292 12 -219 val_219 12 -287 val_287 12 -153 val_153 12 -193 val_193 12 -338 val_338 12 -446 val_446 12 -459 val_459 12 -394 val_394 12 -237 val_237 12 -482 val_482 12 -174 val_174 12 -413 val_413 12 -494 val_494 12 -207 val_207 12 -199 val_199 12 -466 val_466 12 -208 val_208 12 -174 val_174 12 -399 val_399 12 -396 val_396 12 -247 val_247 12 -417 val_417 12 -489 val_489 12 -162 val_162 12 -377 val_377 12 -397 val_397 12 -309 val_309 12 -365 val_365 12 -266 val_266 12 -439 val_439 12 -342 val_342 12 -367 val_367 12 -325 val_325 12 -167 val_167 12 -195 val_195 12 -475 val_475 12 -17 val_17 12 -113 val_113 12 -155 val_155 12 -203 val_203 12 -339 val_339 12 -0 val_0 12 -455 val_455 12 -128 val_128 12 -311 val_311 12 -316 val_316 12 -57 val_57 12 -302 val_302 12 -205 val_205 12 -149 val_149 12 -438 val_438 12 -345 val_345 12 -129 val_129 12 -170 val_170 12 -20 val_20 12 -489 val_489 12 -157 val_157 12 -378 val_378 12 -221 val_221 12 -92 val_92 12 -111 val_111 12 -47 val_47 12 -72 val_72 12 -4 val_4 12 -280 val_280 12 -35 val_35 12 -427 val_427 12 -277 val_277 12 -208 val_208 12 -356 val_356 12 -399 val_399 12 -169 val_169 12 -382 val_382 12 -498 val_498 12 -125 val_125 12 -386 val_386 12 -437 val_437 12 -469 val_469 12 -192 val_192 12 -286 val_286 12 -187 val_187 12 -176 val_176 12 -54 val_54 12 -459 val_459 12 -51 val_51 12 -138 val_138 12 -103 val_103 12 -239 val_239 12 -213 val_213 12 -216 val_216 12 -430 val_430 12 -278 val_278 12 -176 val_176 12 -289 val_289 12 -221 val_221 12 -65 val_65 12 -318 val_318 12 -332 val_332 12 -311 val_311 12 -275 val_275 12 -137 val_137 12 -241 val_241 12 -83 val_83 12 -333 val_333 12 -180 val_180 12 -284 val_284 12 -12 val_12 12 -230 val_230 12 -181 val_181 12 -67 val_67 12 -260 val_260 12 -404 val_404 12 -384 val_384 12 -489 val_489 12 -353 val_353 12 -373 val_373 12 -272 val_272 12 -138 val_138 12 -217 val_217 12 -84 val_84 12 -348 val_348 12 -466 val_466 12 -58 val_58 12 -8 val_8 12 -411 val_411 12 -230 val_230 12 -208 val_208 12 -348 val_348 12 -24 val_24 12 -463 val_463 12 -431 val_431 12 -179 val_179 12 -172 val_172 12 -42 val_42 12 -129 val_129 12 -158 val_158 12 -119 val_119 12 -496 val_496 12 -0 val_0 12 -322 val_322 12 -197 val_197 12 -468 val_468 12 -393 val_393 12 -454 val_454 12 -100 val_100 12 -298 val_298 12 -199 val_199 12 -191 val_191 12 -418 val_418 12 -96 val_96 12 -26 val_26 12 -165 val_165 12 -327 val_327 12 -230 val_230 12 -205 val_205 12 -120 val_120 12 -131 val_131 12 -51 val_51 12 -404 val_404 12 -43 val_43 12 -436 val_436 12 -156 val_156 12 -469 val_469 12 -468 val_468 12 -308 val_308 12 -95 val_95 12 -196 val_196 12 -288 val_288 12 -481 val_481 12 -457 val_457 12 -98 val_98 12 -282 val_282 12 -197 val_197 12 -187 val_187 12 -318 val_318 12 -318 val_318 12 -409 val_409 12 -470 val_470 12 -137 val_137 12 -369 val_369 12 -316 val_316 12 -169 val_169 12 -413 val_413 12 -85 val_85 12 -77 val_77 12 -0 val_0 12 -490 val_490 12 -87 val_87 12 -364 val_364 12 -179 val_179 12 -118 val_118 12 -134 val_134 12 -395 val_395 12 -282 val_282 12 -138 val_138 12 -238 val_238 12 -419 val_419 12 -15 val_15 12 -118 val_118 12 -72 val_72 12 -90 val_90 12 -307 val_307 12 -19 val_19 12 -435 val_435 12 -10 val_10 12 -277 val_277 12 -273 val_273 12 -306 val_306 12 -224 val_224 12 -309 val_309 12 -389 val_389 12 -327 val_327 12 -242 val_242 12 -369 val_369 12 -392 val_392 12 -272 val_272 12 -331 val_331 12 -401 val_401 12 -242 val_242 12 -452 val_452 12 -177 val_177 12 -226 val_226 12 -5 val_5 12 -497 val_497 12 -402 val_402 12 -396 val_396 12 -317 val_317 12 -395 val_395 12 -58 val_58 12 -35 val_35 12 -336 val_336 12 -95 val_95 12 -11 val_11 12 -168 val_168 12 -34 val_34 12 -229 val_229 12 -233 val_233 12 -143 val_143 12 -472 val_472 12 -322 val_322 12 -498 val_498 12 -160 val_160 12 -195 val_195 12 -42 val_42 12 -321 val_321 12 -430 val_430 12 -119 val_119 12 -489 val_489 12 -458 val_458 12 -78 val_78 12 -76 val_76 12 -41 val_41 12 -223 val_223 12 -492 val_492 12 -149 val_149 12 -449 val_449 12 -218 val_218 12 -228 val_228 12 -138 val_138 12 -453 val_453 12 -30 val_30 12 -209 val_209 12 -64 val_64 12 -468 val_468 12 -76 val_76 12 -74 val_74 12 -342 val_342 12 -69 val_69 12 -230 val_230 12 -33 val_33 12 -368 val_368 12 -103 val_103 12 -296 val_296 12 -113 val_113 12 -216 val_216 12 -367 val_367 12 -344 val_344 12 -167 val_167 12 -274 val_274 12 -219 val_219 12 -239 val_239 12 -485 val_485 12 -116 val_116 12 -223 val_223 12 -256 val_256 12 -263 val_263 12 -70 val_70 12 -487 val_487 12 -480 val_480 12 -401 val_401 12 -288 val_288 12 -191 val_191 12 -5 val_5 12 -244 val_244 12 -438 val_438 12 -128 val_128 12 -467 val_467 12 -432 val_432 12 -202 val_202 12 -316 val_316 12 -229 val_229 12 -469 val_469 12 -463 val_463 12 -280 val_280 12 -2 val_2 12 -35 val_35 12 -283 val_283 12 -331 val_331 12 -235 val_235 12 -80 val_80 12 -44 val_44 12 -193 val_193 12 -321 val_321 12 -335 val_335 12 -104 val_104 12 -466 val_466 12 -366 val_366 12 -175 val_175 12 -403 val_403 12 -483 val_483 12 -53 val_53 12 -105 val_105 12 -257 val_257 12 -406 val_406 12 -409 val_409 12 -190 val_190 12 -406 val_406 12 -401 val_401 12 -114 val_114 12 -258 val_258 12 -90 val_90 12 -203 val_203 12 -262 val_262 12 -348 val_348 12 -424 val_424 12 -12 val_12 12 -396 val_396 12 -201 val_201 12 -217 val_217 12 -164 val_164 12 -431 val_431 12 -454 val_454 12 -478 val_478 12 -298 val_298 12 -125 val_125 12 -431 val_431 12 -164 val_164 12 -424 val_424 12 -187 val_187 12 -382 val_382 12 -5 val_5 12 -70 val_70 12 -397 val_397 12 -480 val_480 12 -291 val_291 12 -24 val_24 12 -351 val_351 12 -255 val_255 12 -104 val_104 12 -70 val_70 12 -163 val_163 12 -438 val_438 12 -119 val_119 12 -414 val_414 12 -200 val_200 12 -491 val_491 12 -237 val_237 12 -439 val_439 12 -360 val_360 12 -248 val_248 12 -479 val_479 12 -305 val_305 12 -417 val_417 12 -199 val_199 12 -444 val_444 12 -120 val_120 12 -429 val_429 12 -169 val_169 12 -443 val_443 12 -323 val_323 12 -325 val_325 12 -277 val_277 12 -230 val_230 12 -478 val_478 12 -178 val_178 12 -468 val_468 12 -310 val_310 12 -317 val_317 12 -333 val_333 12 -493 val_493 12 -460 val_460 12 -207 val_207 12 -249 val_249 12 -265 val_265 12 -480 val_480 12 -83 val_83 12 -136 val_136 12 -353 val_353 12 -172 val_172 12 -214 val_214 12 -462 val_462 12 -233 val_233 12 -406 val_406 12 -133 val_133 12 -175 val_175 12 -189 val_189 12 -454 val_454 12 -375 val_375 12 -401 val_401 12 -421 val_421 12 -407 val_407 12 -384 val_384 12 -256 val_256 12 -26 val_26 12 -134 val_134 12 -67 val_67 12 -384 val_384 12 -379 val_379 12 -18 val_18 12 -462 val_462 12 -492 val_492 12 -100 val_100 12 -298 val_298 12 -9 val_9 12 -341 val_341 12 -498 val_498 12 -146 val_146 12 -458 val_458 12 -362 val_362 12 -186 val_186 12 -285 val_285 12 -348 val_348 12 -167 val_167 12 -18 val_18 12 -273 val_273 12 -183 val_183 12 -281 val_281 12 -344 val_344 12 -97 val_97 12 -469 val_469 12 -315 val_315 12 -84 val_84 12 -28 val_28 12 -37 val_37 12 -448 val_448 12 -152 val_152 12 -348 val_348 12 -307 val_307 12 -194 val_194 12 -414 val_414 12 -477 val_477 12 -222 val_222 12 -126 val_126 12 -90 val_90 12 -169 val_169 12 -403 val_403 12 -400 val_400 12 -200 val_200 12 -97 val_97 12 +0 0_lav 12 +4 4_lav 12 +8 8_lav 12 +0 0_lav 12 +0 0_lav 12 +2 2_lav 12 PREHOOK: query: explain select * from masking_test_n0 where key > 0 PREHOOK: type: QUERY POSTHOOK: query: explain select * from masking_test_n0 where key > 0 @@ -579,15 +88,15 @@ STAGE PLANS: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (UDFToInteger(key) > 0) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE + predicate: (((UDFToInteger(key) % 2) = 0) and (UDFToInteger(key) < 10) and (UDFToInteger(key) > 0)) (type: boolean) + Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE Select Operator - expressions: UDFToInteger(key) (type: int), value (type: string), '12' (type: string) + expressions: UDFToInteger(key) (type: int), reverse(value) (type: string), '12' (type: string) outputColumnNames: _col0, _col1, _col2 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -610,503 +119,9 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n0 POSTHOOK: Input: default@src #### A masked pattern was here #### -238 val_238 12 -86 val_86 12 -311 val_311 12 -27 val_27 12 -165 val_165 12 -409 val_409 12 -255 val_255 12 -278 val_278 12 -98 val_98 12 -484 val_484 12 -265 val_265 12 -193 val_193 12 -401 val_401 12 -150 val_150 12 -273 val_273 12 -224 val_224 12 -369 val_369 12 -66 val_66 12 -128 val_128 12 -213 val_213 12 -146 val_146 12 -406 val_406 12 -429 val_429 12 -374 val_374 12 -152 val_152 12 -469 val_469 12 -145 val_145 12 -495 val_495 12 -37 val_37 12 -327 val_327 12 -281 val_281 12 -277 val_277 12 -209 val_209 12 -15 val_15 12 -82 val_82 12 -403 val_403 12 -166 val_166 12 -417 val_417 12 -430 val_430 12 -252 val_252 12 -292 val_292 12 -219 val_219 12 -287 val_287 12 -153 val_153 12 -193 val_193 12 -338 val_338 12 -446 val_446 12 -459 val_459 12 -394 val_394 12 -237 val_237 12 -482 val_482 12 -174 val_174 12 -413 val_413 12 -494 val_494 12 -207 val_207 12 -199 val_199 12 -466 val_466 12 -208 val_208 12 -174 val_174 12 -399 val_399 12 -396 val_396 12 -247 val_247 12 -417 val_417 12 -489 val_489 12 -162 val_162 12 -377 val_377 12 -397 val_397 12 -309 val_309 12 -365 val_365 12 -266 val_266 12 -439 val_439 12 -342 val_342 12 -367 val_367 12 -325 val_325 12 -167 val_167 12 -195 val_195 12 -475 val_475 12 -17 val_17 12 -113 val_113 12 -155 val_155 12 -203 val_203 12 -339 val_339 12 -455 val_455 12 -128 val_128 12 -311 val_311 12 -316 val_316 12 -57 val_57 12 -302 val_302 12 -205 val_205 12 -149 val_149 12 -438 val_438 12 -345 val_345 12 -129 val_129 12 -170 val_170 12 -20 val_20 12 -489 val_489 12 -157 val_157 12 -378 val_378 12 -221 val_221 12 -92 val_92 12 -111 val_111 12 -47 val_47 12 -72 val_72 12 -4 val_4 12 -280 val_280 12 -35 val_35 12 -427 val_427 12 -277 val_277 12 -208 val_208 12 -356 val_356 12 -399 val_399 12 -169 val_169 12 -382 val_382 12 -498 val_498 12 -125 val_125 12 -386 val_386 12 -437 val_437 12 -469 val_469 12 -192 val_192 12 -286 val_286 12 -187 val_187 12 -176 val_176 12 -54 val_54 12 -459 val_459 12 -51 val_51 12 -138 val_138 12 -103 val_103 12 -239 val_239 12 -213 val_213 12 -216 val_216 12 -430 val_430 12 -278 val_278 12 -176 val_176 12 -289 val_289 12 -221 val_221 12 -65 val_65 12 -318 val_318 12 -332 val_332 12 -311 val_311 12 -275 val_275 12 -137 val_137 12 -241 val_241 12 -83 val_83 12 -333 val_333 12 -180 val_180 12 -284 val_284 12 -12 val_12 12 -230 val_230 12 -181 val_181 12 -67 val_67 12 -260 val_260 12 -404 val_404 12 -384 val_384 12 -489 val_489 12 -353 val_353 12 -373 val_373 12 -272 val_272 12 -138 val_138 12 -217 val_217 12 -84 val_84 12 -348 val_348 12 -466 val_466 12 -58 val_58 12 -8 val_8 12 -411 val_411 12 -230 val_230 12 -208 val_208 12 -348 val_348 12 -24 val_24 12 -463 val_463 12 -431 val_431 12 -179 val_179 12 -172 val_172 12 -42 val_42 12 -129 val_129 12 -158 val_158 12 -119 val_119 12 -496 val_496 12 -322 val_322 12 -197 val_197 12 -468 val_468 12 -393 val_393 12 -454 val_454 12 -100 val_100 12 -298 val_298 12 -199 val_199 12 -191 val_191 12 -418 val_418 12 -96 val_96 12 -26 val_26 12 -165 val_165 12 -327 val_327 12 -230 val_230 12 -205 val_205 12 -120 val_120 12 -131 val_131 12 -51 val_51 12 -404 val_404 12 -43 val_43 12 -436 val_436 12 -156 val_156 12 -469 val_469 12 -468 val_468 12 -308 val_308 12 -95 val_95 12 -196 val_196 12 -288 val_288 12 -481 val_481 12 -457 val_457 12 -98 val_98 12 -282 val_282 12 -197 val_197 12 -187 val_187 12 -318 val_318 12 -318 val_318 12 -409 val_409 12 -470 val_470 12 -137 val_137 12 -369 val_369 12 -316 val_316 12 -169 val_169 12 -413 val_413 12 -85 val_85 12 -77 val_77 12 -490 val_490 12 -87 val_87 12 -364 val_364 12 -179 val_179 12 -118 val_118 12 -134 val_134 12 -395 val_395 12 -282 val_282 12 -138 val_138 12 -238 val_238 12 -419 val_419 12 -15 val_15 12 -118 val_118 12 -72 val_72 12 -90 val_90 12 -307 val_307 12 -19 val_19 12 -435 val_435 12 -10 val_10 12 -277 val_277 12 -273 val_273 12 -306 val_306 12 -224 val_224 12 -309 val_309 12 -389 val_389 12 -327 val_327 12 -242 val_242 12 -369 val_369 12 -392 val_392 12 -272 val_272 12 -331 val_331 12 -401 val_401 12 -242 val_242 12 -452 val_452 12 -177 val_177 12 -226 val_226 12 -5 val_5 12 -497 val_497 12 -402 val_402 12 -396 val_396 12 -317 val_317 12 -395 val_395 12 -58 val_58 12 -35 val_35 12 -336 val_336 12 -95 val_95 12 -11 val_11 12 -168 val_168 12 -34 val_34 12 -229 val_229 12 -233 val_233 12 -143 val_143 12 -472 val_472 12 -322 val_322 12 -498 val_498 12 -160 val_160 12 -195 val_195 12 -42 val_42 12 -321 val_321 12 -430 val_430 12 -119 val_119 12 -489 val_489 12 -458 val_458 12 -78 val_78 12 -76 val_76 12 -41 val_41 12 -223 val_223 12 -492 val_492 12 -149 val_149 12 -449 val_449 12 -218 val_218 12 -228 val_228 12 -138 val_138 12 -453 val_453 12 -30 val_30 12 -209 val_209 12 -64 val_64 12 -468 val_468 12 -76 val_76 12 -74 val_74 12 -342 val_342 12 -69 val_69 12 -230 val_230 12 -33 val_33 12 -368 val_368 12 -103 val_103 12 -296 val_296 12 -113 val_113 12 -216 val_216 12 -367 val_367 12 -344 val_344 12 -167 val_167 12 -274 val_274 12 -219 val_219 12 -239 val_239 12 -485 val_485 12 -116 val_116 12 -223 val_223 12 -256 val_256 12 -263 val_263 12 -70 val_70 12 -487 val_487 12 -480 val_480 12 -401 val_401 12 -288 val_288 12 -191 val_191 12 -5 val_5 12 -244 val_244 12 -438 val_438 12 -128 val_128 12 -467 val_467 12 -432 val_432 12 -202 val_202 12 -316 val_316 12 -229 val_229 12 -469 val_469 12 -463 val_463 12 -280 val_280 12 -2 val_2 12 -35 val_35 12 -283 val_283 12 -331 val_331 12 -235 val_235 12 -80 val_80 12 -44 val_44 12 -193 val_193 12 -321 val_321 12 -335 val_335 12 -104 val_104 12 -466 val_466 12 -366 val_366 12 -175 val_175 12 -403 val_403 12 -483 val_483 12 -53 val_53 12 -105 val_105 12 -257 val_257 12 -406 val_406 12 -409 val_409 12 -190 val_190 12 -406 val_406 12 -401 val_401 12 -114 val_114 12 -258 val_258 12 -90 val_90 12 -203 val_203 12 -262 val_262 12 -348 val_348 12 -424 val_424 12 -12 val_12 12 -396 val_396 12 -201 val_201 12 -217 val_217 12 -164 val_164 12 -431 val_431 12 -454 val_454 12 -478 val_478 12 -298 val_298 12 -125 val_125 12 -431 val_431 12 -164 val_164 12 -424 val_424 12 -187 val_187 12 -382 val_382 12 -5 val_5 12 -70 val_70 12 -397 val_397 12 -480 val_480 12 -291 val_291 12 -24 val_24 12 -351 val_351 12 -255 val_255 12 -104 val_104 12 -70 val_70 12 -163 val_163 12 -438 val_438 12 -119 val_119 12 -414 val_414 12 -200 val_200 12 -491 val_491 12 -237 val_237 12 -439 val_439 12 -360 val_360 12 -248 val_248 12 -479 val_479 12 -305 val_305 12 -417 val_417 12 -199 val_199 12 -444 val_444 12 -120 val_120 12 -429 val_429 12 -169 val_169 12 -443 val_443 12 -323 val_323 12 -325 val_325 12 -277 val_277 12 -230 val_230 12 -478 val_478 12 -178 val_178 12 -468 val_468 12 -310 val_310 12 -317 val_317 12 -333 val_333 12 -493 val_493 12 -460 val_460 12 -207 val_207 12 -249 val_249 12 -265 val_265 12 -480 val_480 12 -83 val_83 12 -136 val_136 12 -353 val_353 12 -172 val_172 12 -214 val_214 12 -462 val_462 12 -233 val_233 12 -406 val_406 12 -133 val_133 12 -175 val_175 12 -189 val_189 12 -454 val_454 12 -375 val_375 12 -401 val_401 12 -421 val_421 12 -407 val_407 12 -384 val_384 12 -256 val_256 12 -26 val_26 12 -134 val_134 12 -67 val_67 12 -384 val_384 12 -379 val_379 12 -18 val_18 12 -462 val_462 12 -492 val_492 12 -100 val_100 12 -298 val_298 12 -9 val_9 12 -341 val_341 12 -498 val_498 12 -146 val_146 12 -458 val_458 12 -362 val_362 12 -186 val_186 12 -285 val_285 12 -348 val_348 12 -167 val_167 12 -18 val_18 12 -273 val_273 12 -183 val_183 12 -281 val_281 12 -344 val_344 12 -97 val_97 12 -469 val_469 12 -315 val_315 12 -84 val_84 12 -28 val_28 12 -37 val_37 12 -448 val_448 12 -152 val_152 12 -348 val_348 12 -307 val_307 12 -194 val_194 12 -414 val_414 12 -477 val_477 12 -222 val_222 12 -126 val_126 12 -90 val_90 12 -169 val_169 12 -403 val_403 12 -400 val_400 12 -200 val_200 12 -97 val_97 12 +4 4_lav 12 +8 8_lav 12 +2 2_lav 12 PREHOOK: query: drop view masking_test_n0 PREHOOK: type: DROPVIEW PREHOOK: Input: default@masking_test_n0 @@ -1158,17 +173,20 @@ STAGE PLANS: properties: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - Select Operator - expressions: UDFToInteger(key) (type: int), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string) - outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - File Output Operator - compressed: false - Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE - 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 + Filter Operator + predicate: (((UDFToInteger(key) % 2) = 0) and (UDFToInteger(key) < 10)) (type: boolean) + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + Select Operator + expressions: UDFToInteger(key) (type: int), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string) + outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + File Output Operator + compressed: false + Statistics: Num rows: 83 Data size: 881 Basic stats: COMPLETE Column stats: NONE + 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 Execution mode: vectorized Stage: Stage-0 @@ -1187,506 +205,12 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n0 POSTHOOK: Input: default@src #### A masked pattern was here #### -238 12 12 12 12 12 12 12 12 12 12 12 -86 12 12 12 12 12 12 12 12 12 12 12 -311 12 12 12 12 12 12 12 12 12 12 12 -27 12 12 12 12 12 12 12 12 12 12 12 -165 12 12 12 12 12 12 12 12 12 12 12 -409 12 12 12 12 12 12 12 12 12 12 12 -255 12 12 12 12 12 12 12 12 12 12 12 -278 12 12 12 12 12 12 12 12 12 12 12 -98 12 12 12 12 12 12 12 12 12 12 12 -484 12 12 12 12 12 12 12 12 12 12 12 -265 12 12 12 12 12 12 12 12 12 12 12 -193 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -150 12 12 12 12 12 12 12 12 12 12 12 -273 12 12 12 12 12 12 12 12 12 12 12 -224 12 12 12 12 12 12 12 12 12 12 12 -369 12 12 12 12 12 12 12 12 12 12 12 -66 12 12 12 12 12 12 12 12 12 12 12 -128 12 12 12 12 12 12 12 12 12 12 12 -213 12 12 12 12 12 12 12 12 12 12 12 -146 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -429 12 12 12 12 12 12 12 12 12 12 12 -374 12 12 12 12 12 12 12 12 12 12 12 -152 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -145 12 12 12 12 12 12 12 12 12 12 12 -495 12 12 12 12 12 12 12 12 12 12 12 -37 12 12 12 12 12 12 12 12 12 12 12 -327 12 12 12 12 12 12 12 12 12 12 12 -281 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -209 12 12 12 12 12 12 12 12 12 12 12 -15 12 12 12 12 12 12 12 12 12 12 12 -82 12 12 12 12 12 12 12 12 12 12 12 -403 12 12 12 12 12 12 12 12 12 12 12 -166 12 12 12 12 12 12 12 12 12 12 12 -417 12 12 12 12 12 12 12 12 12 12 12 -430 12 12 12 12 12 12 12 12 12 12 12 -252 12 12 12 12 12 12 12 12 12 12 12 -292 12 12 12 12 12 12 12 12 12 12 12 -219 12 12 12 12 12 12 12 12 12 12 12 -287 12 12 12 12 12 12 12 12 12 12 12 -153 12 12 12 12 12 12 12 12 12 12 12 -193 12 12 12 12 12 12 12 12 12 12 12 -338 12 12 12 12 12 12 12 12 12 12 12 -446 12 12 12 12 12 12 12 12 12 12 12 -459 12 12 12 12 12 12 12 12 12 12 12 -394 12 12 12 12 12 12 12 12 12 12 12 -237 12 12 12 12 12 12 12 12 12 12 12 -482 12 12 12 12 12 12 12 12 12 12 12 -174 12 12 12 12 12 12 12 12 12 12 12 -413 12 12 12 12 12 12 12 12 12 12 12 -494 12 12 12 12 12 12 12 12 12 12 12 -207 12 12 12 12 12 12 12 12 12 12 12 -199 12 12 12 12 12 12 12 12 12 12 12 -466 12 12 12 12 12 12 12 12 12 12 12 -208 12 12 12 12 12 12 12 12 12 12 12 -174 12 12 12 12 12 12 12 12 12 12 12 -399 12 12 12 12 12 12 12 12 12 12 12 -396 12 12 12 12 12 12 12 12 12 12 12 -247 12 12 12 12 12 12 12 12 12 12 12 -417 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -162 12 12 12 12 12 12 12 12 12 12 12 -377 12 12 12 12 12 12 12 12 12 12 12 -397 12 12 12 12 12 12 12 12 12 12 12 -309 12 12 12 12 12 12 12 12 12 12 12 -365 12 12 12 12 12 12 12 12 12 12 12 -266 12 12 12 12 12 12 12 12 12 12 12 -439 12 12 12 12 12 12 12 12 12 12 12 -342 12 12 12 12 12 12 12 12 12 12 12 -367 12 12 12 12 12 12 12 12 12 12 12 -325 12 12 12 12 12 12 12 12 12 12 12 -167 12 12 12 12 12 12 12 12 12 12 12 -195 12 12 12 12 12 12 12 12 12 12 12 -475 12 12 12 12 12 12 12 12 12 12 12 -17 12 12 12 12 12 12 12 12 12 12 12 -113 12 12 12 12 12 12 12 12 12 12 12 -155 12 12 12 12 12 12 12 12 12 12 12 -203 12 12 12 12 12 12 12 12 12 12 12 -339 12 12 12 12 12 12 12 12 12 12 12 0 12 12 12 12 12 12 12 12 12 12 12 -455 12 12 12 12 12 12 12 12 12 12 12 -128 12 12 12 12 12 12 12 12 12 12 12 -311 12 12 12 12 12 12 12 12 12 12 12 -316 12 12 12 12 12 12 12 12 12 12 12 -57 12 12 12 12 12 12 12 12 12 12 12 -302 12 12 12 12 12 12 12 12 12 12 12 -205 12 12 12 12 12 12 12 12 12 12 12 -149 12 12 12 12 12 12 12 12 12 12 12 -438 12 12 12 12 12 12 12 12 12 12 12 -345 12 12 12 12 12 12 12 12 12 12 12 -129 12 12 12 12 12 12 12 12 12 12 12 -170 12 12 12 12 12 12 12 12 12 12 12 -20 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -157 12 12 12 12 12 12 12 12 12 12 12 -378 12 12 12 12 12 12 12 12 12 12 12 -221 12 12 12 12 12 12 12 12 12 12 12 -92 12 12 12 12 12 12 12 12 12 12 12 -111 12 12 12 12 12 12 12 12 12 12 12 -47 12 12 12 12 12 12 12 12 12 12 12 -72 12 12 12 12 12 12 12 12 12 12 12 4 12 12 12 12 12 12 12 12 12 12 12 -280 12 12 12 12 12 12 12 12 12 12 12 -35 12 12 12 12 12 12 12 12 12 12 12 -427 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -208 12 12 12 12 12 12 12 12 12 12 12 -356 12 12 12 12 12 12 12 12 12 12 12 -399 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -382 12 12 12 12 12 12 12 12 12 12 12 -498 12 12 12 12 12 12 12 12 12 12 12 -125 12 12 12 12 12 12 12 12 12 12 12 -386 12 12 12 12 12 12 12 12 12 12 12 -437 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -192 12 12 12 12 12 12 12 12 12 12 12 -286 12 12 12 12 12 12 12 12 12 12 12 -187 12 12 12 12 12 12 12 12 12 12 12 -176 12 12 12 12 12 12 12 12 12 12 12 -54 12 12 12 12 12 12 12 12 12 12 12 -459 12 12 12 12 12 12 12 12 12 12 12 -51 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -103 12 12 12 12 12 12 12 12 12 12 12 -239 12 12 12 12 12 12 12 12 12 12 12 -213 12 12 12 12 12 12 12 12 12 12 12 -216 12 12 12 12 12 12 12 12 12 12 12 -430 12 12 12 12 12 12 12 12 12 12 12 -278 12 12 12 12 12 12 12 12 12 12 12 -176 12 12 12 12 12 12 12 12 12 12 12 -289 12 12 12 12 12 12 12 12 12 12 12 -221 12 12 12 12 12 12 12 12 12 12 12 -65 12 12 12 12 12 12 12 12 12 12 12 -318 12 12 12 12 12 12 12 12 12 12 12 -332 12 12 12 12 12 12 12 12 12 12 12 -311 12 12 12 12 12 12 12 12 12 12 12 -275 12 12 12 12 12 12 12 12 12 12 12 -137 12 12 12 12 12 12 12 12 12 12 12 -241 12 12 12 12 12 12 12 12 12 12 12 -83 12 12 12 12 12 12 12 12 12 12 12 -333 12 12 12 12 12 12 12 12 12 12 12 -180 12 12 12 12 12 12 12 12 12 12 12 -284 12 12 12 12 12 12 12 12 12 12 12 -12 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -181 12 12 12 12 12 12 12 12 12 12 12 -67 12 12 12 12 12 12 12 12 12 12 12 -260 12 12 12 12 12 12 12 12 12 12 12 -404 12 12 12 12 12 12 12 12 12 12 12 -384 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -353 12 12 12 12 12 12 12 12 12 12 12 -373 12 12 12 12 12 12 12 12 12 12 12 -272 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -217 12 12 12 12 12 12 12 12 12 12 12 -84 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -466 12 12 12 12 12 12 12 12 12 12 12 -58 12 12 12 12 12 12 12 12 12 12 12 8 12 12 12 12 12 12 12 12 12 12 12 -411 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -208 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -24 12 12 12 12 12 12 12 12 12 12 12 -463 12 12 12 12 12 12 12 12 12 12 12 -431 12 12 12 12 12 12 12 12 12 12 12 -179 12 12 12 12 12 12 12 12 12 12 12 -172 12 12 12 12 12 12 12 12 12 12 12 -42 12 12 12 12 12 12 12 12 12 12 12 -129 12 12 12 12 12 12 12 12 12 12 12 -158 12 12 12 12 12 12 12 12 12 12 12 -119 12 12 12 12 12 12 12 12 12 12 12 -496 12 12 12 12 12 12 12 12 12 12 12 0 12 12 12 12 12 12 12 12 12 12 12 -322 12 12 12 12 12 12 12 12 12 12 12 -197 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -393 12 12 12 12 12 12 12 12 12 12 12 -454 12 12 12 12 12 12 12 12 12 12 12 -100 12 12 12 12 12 12 12 12 12 12 12 -298 12 12 12 12 12 12 12 12 12 12 12 -199 12 12 12 12 12 12 12 12 12 12 12 -191 12 12 12 12 12 12 12 12 12 12 12 -418 12 12 12 12 12 12 12 12 12 12 12 -96 12 12 12 12 12 12 12 12 12 12 12 -26 12 12 12 12 12 12 12 12 12 12 12 -165 12 12 12 12 12 12 12 12 12 12 12 -327 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -205 12 12 12 12 12 12 12 12 12 12 12 -120 12 12 12 12 12 12 12 12 12 12 12 -131 12 12 12 12 12 12 12 12 12 12 12 -51 12 12 12 12 12 12 12 12 12 12 12 -404 12 12 12 12 12 12 12 12 12 12 12 -43 12 12 12 12 12 12 12 12 12 12 12 -436 12 12 12 12 12 12 12 12 12 12 12 -156 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -308 12 12 12 12 12 12 12 12 12 12 12 -95 12 12 12 12 12 12 12 12 12 12 12 -196 12 12 12 12 12 12 12 12 12 12 12 -288 12 12 12 12 12 12 12 12 12 12 12 -481 12 12 12 12 12 12 12 12 12 12 12 -457 12 12 12 12 12 12 12 12 12 12 12 -98 12 12 12 12 12 12 12 12 12 12 12 -282 12 12 12 12 12 12 12 12 12 12 12 -197 12 12 12 12 12 12 12 12 12 12 12 -187 12 12 12 12 12 12 12 12 12 12 12 -318 12 12 12 12 12 12 12 12 12 12 12 -318 12 12 12 12 12 12 12 12 12 12 12 -409 12 12 12 12 12 12 12 12 12 12 12 -470 12 12 12 12 12 12 12 12 12 12 12 -137 12 12 12 12 12 12 12 12 12 12 12 -369 12 12 12 12 12 12 12 12 12 12 12 -316 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -413 12 12 12 12 12 12 12 12 12 12 12 -85 12 12 12 12 12 12 12 12 12 12 12 -77 12 12 12 12 12 12 12 12 12 12 12 0 12 12 12 12 12 12 12 12 12 12 12 -490 12 12 12 12 12 12 12 12 12 12 12 -87 12 12 12 12 12 12 12 12 12 12 12 -364 12 12 12 12 12 12 12 12 12 12 12 -179 12 12 12 12 12 12 12 12 12 12 12 -118 12 12 12 12 12 12 12 12 12 12 12 -134 12 12 12 12 12 12 12 12 12 12 12 -395 12 12 12 12 12 12 12 12 12 12 12 -282 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -238 12 12 12 12 12 12 12 12 12 12 12 -419 12 12 12 12 12 12 12 12 12 12 12 -15 12 12 12 12 12 12 12 12 12 12 12 -118 12 12 12 12 12 12 12 12 12 12 12 -72 12 12 12 12 12 12 12 12 12 12 12 -90 12 12 12 12 12 12 12 12 12 12 12 -307 12 12 12 12 12 12 12 12 12 12 12 -19 12 12 12 12 12 12 12 12 12 12 12 -435 12 12 12 12 12 12 12 12 12 12 12 -10 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -273 12 12 12 12 12 12 12 12 12 12 12 -306 12 12 12 12 12 12 12 12 12 12 12 -224 12 12 12 12 12 12 12 12 12 12 12 -309 12 12 12 12 12 12 12 12 12 12 12 -389 12 12 12 12 12 12 12 12 12 12 12 -327 12 12 12 12 12 12 12 12 12 12 12 -242 12 12 12 12 12 12 12 12 12 12 12 -369 12 12 12 12 12 12 12 12 12 12 12 -392 12 12 12 12 12 12 12 12 12 12 12 -272 12 12 12 12 12 12 12 12 12 12 12 -331 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -242 12 12 12 12 12 12 12 12 12 12 12 -452 12 12 12 12 12 12 12 12 12 12 12 -177 12 12 12 12 12 12 12 12 12 12 12 -226 12 12 12 12 12 12 12 12 12 12 12 -5 12 12 12 12 12 12 12 12 12 12 12 -497 12 12 12 12 12 12 12 12 12 12 12 -402 12 12 12 12 12 12 12 12 12 12 12 -396 12 12 12 12 12 12 12 12 12 12 12 -317 12 12 12 12 12 12 12 12 12 12 12 -395 12 12 12 12 12 12 12 12 12 12 12 -58 12 12 12 12 12 12 12 12 12 12 12 -35 12 12 12 12 12 12 12 12 12 12 12 -336 12 12 12 12 12 12 12 12 12 12 12 -95 12 12 12 12 12 12 12 12 12 12 12 -11 12 12 12 12 12 12 12 12 12 12 12 -168 12 12 12 12 12 12 12 12 12 12 12 -34 12 12 12 12 12 12 12 12 12 12 12 -229 12 12 12 12 12 12 12 12 12 12 12 -233 12 12 12 12 12 12 12 12 12 12 12 -143 12 12 12 12 12 12 12 12 12 12 12 -472 12 12 12 12 12 12 12 12 12 12 12 -322 12 12 12 12 12 12 12 12 12 12 12 -498 12 12 12 12 12 12 12 12 12 12 12 -160 12 12 12 12 12 12 12 12 12 12 12 -195 12 12 12 12 12 12 12 12 12 12 12 -42 12 12 12 12 12 12 12 12 12 12 12 -321 12 12 12 12 12 12 12 12 12 12 12 -430 12 12 12 12 12 12 12 12 12 12 12 -119 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -458 12 12 12 12 12 12 12 12 12 12 12 -78 12 12 12 12 12 12 12 12 12 12 12 -76 12 12 12 12 12 12 12 12 12 12 12 -41 12 12 12 12 12 12 12 12 12 12 12 -223 12 12 12 12 12 12 12 12 12 12 12 -492 12 12 12 12 12 12 12 12 12 12 12 -149 12 12 12 12 12 12 12 12 12 12 12 -449 12 12 12 12 12 12 12 12 12 12 12 -218 12 12 12 12 12 12 12 12 12 12 12 -228 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -453 12 12 12 12 12 12 12 12 12 12 12 -30 12 12 12 12 12 12 12 12 12 12 12 -209 12 12 12 12 12 12 12 12 12 12 12 -64 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -76 12 12 12 12 12 12 12 12 12 12 12 -74 12 12 12 12 12 12 12 12 12 12 12 -342 12 12 12 12 12 12 12 12 12 12 12 -69 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -33 12 12 12 12 12 12 12 12 12 12 12 -368 12 12 12 12 12 12 12 12 12 12 12 -103 12 12 12 12 12 12 12 12 12 12 12 -296 12 12 12 12 12 12 12 12 12 12 12 -113 12 12 12 12 12 12 12 12 12 12 12 -216 12 12 12 12 12 12 12 12 12 12 12 -367 12 12 12 12 12 12 12 12 12 12 12 -344 12 12 12 12 12 12 12 12 12 12 12 -167 12 12 12 12 12 12 12 12 12 12 12 -274 12 12 12 12 12 12 12 12 12 12 12 -219 12 12 12 12 12 12 12 12 12 12 12 -239 12 12 12 12 12 12 12 12 12 12 12 -485 12 12 12 12 12 12 12 12 12 12 12 -116 12 12 12 12 12 12 12 12 12 12 12 -223 12 12 12 12 12 12 12 12 12 12 12 -256 12 12 12 12 12 12 12 12 12 12 12 -263 12 12 12 12 12 12 12 12 12 12 12 -70 12 12 12 12 12 12 12 12 12 12 12 -487 12 12 12 12 12 12 12 12 12 12 12 -480 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -288 12 12 12 12 12 12 12 12 12 12 12 -191 12 12 12 12 12 12 12 12 12 12 12 -5 12 12 12 12 12 12 12 12 12 12 12 -244 12 12 12 12 12 12 12 12 12 12 12 -438 12 12 12 12 12 12 12 12 12 12 12 -128 12 12 12 12 12 12 12 12 12 12 12 -467 12 12 12 12 12 12 12 12 12 12 12 -432 12 12 12 12 12 12 12 12 12 12 12 -202 12 12 12 12 12 12 12 12 12 12 12 -316 12 12 12 12 12 12 12 12 12 12 12 -229 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -463 12 12 12 12 12 12 12 12 12 12 12 -280 12 12 12 12 12 12 12 12 12 12 12 2 12 12 12 12 12 12 12 12 12 12 12 -35 12 12 12 12 12 12 12 12 12 12 12 -283 12 12 12 12 12 12 12 12 12 12 12 -331 12 12 12 12 12 12 12 12 12 12 12 -235 12 12 12 12 12 12 12 12 12 12 12 -80 12 12 12 12 12 12 12 12 12 12 12 -44 12 12 12 12 12 12 12 12 12 12 12 -193 12 12 12 12 12 12 12 12 12 12 12 -321 12 12 12 12 12 12 12 12 12 12 12 -335 12 12 12 12 12 12 12 12 12 12 12 -104 12 12 12 12 12 12 12 12 12 12 12 -466 12 12 12 12 12 12 12 12 12 12 12 -366 12 12 12 12 12 12 12 12 12 12 12 -175 12 12 12 12 12 12 12 12 12 12 12 -403 12 12 12 12 12 12 12 12 12 12 12 -483 12 12 12 12 12 12 12 12 12 12 12 -53 12 12 12 12 12 12 12 12 12 12 12 -105 12 12 12 12 12 12 12 12 12 12 12 -257 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -409 12 12 12 12 12 12 12 12 12 12 12 -190 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -114 12 12 12 12 12 12 12 12 12 12 12 -258 12 12 12 12 12 12 12 12 12 12 12 -90 12 12 12 12 12 12 12 12 12 12 12 -203 12 12 12 12 12 12 12 12 12 12 12 -262 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -424 12 12 12 12 12 12 12 12 12 12 12 -12 12 12 12 12 12 12 12 12 12 12 12 -396 12 12 12 12 12 12 12 12 12 12 12 -201 12 12 12 12 12 12 12 12 12 12 12 -217 12 12 12 12 12 12 12 12 12 12 12 -164 12 12 12 12 12 12 12 12 12 12 12 -431 12 12 12 12 12 12 12 12 12 12 12 -454 12 12 12 12 12 12 12 12 12 12 12 -478 12 12 12 12 12 12 12 12 12 12 12 -298 12 12 12 12 12 12 12 12 12 12 12 -125 12 12 12 12 12 12 12 12 12 12 12 -431 12 12 12 12 12 12 12 12 12 12 12 -164 12 12 12 12 12 12 12 12 12 12 12 -424 12 12 12 12 12 12 12 12 12 12 12 -187 12 12 12 12 12 12 12 12 12 12 12 -382 12 12 12 12 12 12 12 12 12 12 12 -5 12 12 12 12 12 12 12 12 12 12 12 -70 12 12 12 12 12 12 12 12 12 12 12 -397 12 12 12 12 12 12 12 12 12 12 12 -480 12 12 12 12 12 12 12 12 12 12 12 -291 12 12 12 12 12 12 12 12 12 12 12 -24 12 12 12 12 12 12 12 12 12 12 12 -351 12 12 12 12 12 12 12 12 12 12 12 -255 12 12 12 12 12 12 12 12 12 12 12 -104 12 12 12 12 12 12 12 12 12 12 12 -70 12 12 12 12 12 12 12 12 12 12 12 -163 12 12 12 12 12 12 12 12 12 12 12 -438 12 12 12 12 12 12 12 12 12 12 12 -119 12 12 12 12 12 12 12 12 12 12 12 -414 12 12 12 12 12 12 12 12 12 12 12 -200 12 12 12 12 12 12 12 12 12 12 12 -491 12 12 12 12 12 12 12 12 12 12 12 -237 12 12 12 12 12 12 12 12 12 12 12 -439 12 12 12 12 12 12 12 12 12 12 12 -360 12 12 12 12 12 12 12 12 12 12 12 -248 12 12 12 12 12 12 12 12 12 12 12 -479 12 12 12 12 12 12 12 12 12 12 12 -305 12 12 12 12 12 12 12 12 12 12 12 -417 12 12 12 12 12 12 12 12 12 12 12 -199 12 12 12 12 12 12 12 12 12 12 12 -444 12 12 12 12 12 12 12 12 12 12 12 -120 12 12 12 12 12 12 12 12 12 12 12 -429 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -443 12 12 12 12 12 12 12 12 12 12 12 -323 12 12 12 12 12 12 12 12 12 12 12 -325 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -478 12 12 12 12 12 12 12 12 12 12 12 -178 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -310 12 12 12 12 12 12 12 12 12 12 12 -317 12 12 12 12 12 12 12 12 12 12 12 -333 12 12 12 12 12 12 12 12 12 12 12 -493 12 12 12 12 12 12 12 12 12 12 12 -460 12 12 12 12 12 12 12 12 12 12 12 -207 12 12 12 12 12 12 12 12 12 12 12 -249 12 12 12 12 12 12 12 12 12 12 12 -265 12 12 12 12 12 12 12 12 12 12 12 -480 12 12 12 12 12 12 12 12 12 12 12 -83 12 12 12 12 12 12 12 12 12 12 12 -136 12 12 12 12 12 12 12 12 12 12 12 -353 12 12 12 12 12 12 12 12 12 12 12 -172 12 12 12 12 12 12 12 12 12 12 12 -214 12 12 12 12 12 12 12 12 12 12 12 -462 12 12 12 12 12 12 12 12 12 12 12 -233 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -133 12 12 12 12 12 12 12 12 12 12 12 -175 12 12 12 12 12 12 12 12 12 12 12 -189 12 12 12 12 12 12 12 12 12 12 12 -454 12 12 12 12 12 12 12 12 12 12 12 -375 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -421 12 12 12 12 12 12 12 12 12 12 12 -407 12 12 12 12 12 12 12 12 12 12 12 -384 12 12 12 12 12 12 12 12 12 12 12 -256 12 12 12 12 12 12 12 12 12 12 12 -26 12 12 12 12 12 12 12 12 12 12 12 -134 12 12 12 12 12 12 12 12 12 12 12 -67 12 12 12 12 12 12 12 12 12 12 12 -384 12 12 12 12 12 12 12 12 12 12 12 -379 12 12 12 12 12 12 12 12 12 12 12 -18 12 12 12 12 12 12 12 12 12 12 12 -462 12 12 12 12 12 12 12 12 12 12 12 -492 12 12 12 12 12 12 12 12 12 12 12 -100 12 12 12 12 12 12 12 12 12 12 12 -298 12 12 12 12 12 12 12 12 12 12 12 -9 12 12 12 12 12 12 12 12 12 12 12 -341 12 12 12 12 12 12 12 12 12 12 12 -498 12 12 12 12 12 12 12 12 12 12 12 -146 12 12 12 12 12 12 12 12 12 12 12 -458 12 12 12 12 12 12 12 12 12 12 12 -362 12 12 12 12 12 12 12 12 12 12 12 -186 12 12 12 12 12 12 12 12 12 12 12 -285 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -167 12 12 12 12 12 12 12 12 12 12 12 -18 12 12 12 12 12 12 12 12 12 12 12 -273 12 12 12 12 12 12 12 12 12 12 12 -183 12 12 12 12 12 12 12 12 12 12 12 -281 12 12 12 12 12 12 12 12 12 12 12 -344 12 12 12 12 12 12 12 12 12 12 12 -97 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -315 12 12 12 12 12 12 12 12 12 12 12 -84 12 12 12 12 12 12 12 12 12 12 12 -28 12 12 12 12 12 12 12 12 12 12 12 -37 12 12 12 12 12 12 12 12 12 12 12 -448 12 12 12 12 12 12 12 12 12 12 12 -152 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -307 12 12 12 12 12 12 12 12 12 12 12 -194 12 12 12 12 12 12 12 12 12 12 12 -414 12 12 12 12 12 12 12 12 12 12 12 -477 12 12 12 12 12 12 12 12 12 12 12 -222 12 12 12 12 12 12 12 12 12 12 12 -126 12 12 12 12 12 12 12 12 12 12 12 -90 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -403 12 12 12 12 12 12 12 12 12 12 12 -400 12 12 12 12 12 12 12 12 12 12 12 -200 12 12 12 12 12 12 12 12 12 12 12 -97 12 12 12 12 12 12 12 12 12 12 12 PREHOOK: query: explain select * from masking_test_n0 where key > 0 PREHOOK: type: QUERY POSTHOOK: query: explain select * from masking_test_n0 where key > 0 @@ -1705,15 +229,15 @@ STAGE PLANS: insideView TRUE Statistics: Num rows: 500 Data size: 5312 Basic stats: COMPLETE Column stats: NONE Filter Operator - predicate: (UDFToInteger(key) > 0) (type: boolean) - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE + predicate: (((UDFToInteger(key) % 2) = 0) and (UDFToInteger(key) < 10) and (UDFToInteger(key) > 0)) (type: boolean) + Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE Select Operator expressions: UDFToInteger(key) (type: int), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string), '12' (type: string) outputColumnNames: _col0, _col1, _col2, _col3, _col4, _col5, _col6, _col7, _col8, _col9, _col10, _col11 - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE File Output Operator compressed: false - Statistics: Num rows: 166 Data size: 1763 Basic stats: COMPLETE Column stats: NONE + Statistics: Num rows: 27 Data size: 286 Basic stats: COMPLETE Column stats: NONE table: input format: org.apache.hadoop.mapred.SequenceFileInputFormat output format: org.apache.hadoop.hive.ql.io.HiveSequenceFileOutputFormat @@ -1736,500 +260,6 @@ POSTHOOK: type: QUERY POSTHOOK: Input: default@masking_test_n0 POSTHOOK: Input: default@src #### A masked pattern was here #### -238 12 12 12 12 12 12 12 12 12 12 12 -86 12 12 12 12 12 12 12 12 12 12 12 -311 12 12 12 12 12 12 12 12 12 12 12 -27 12 12 12 12 12 12 12 12 12 12 12 -165 12 12 12 12 12 12 12 12 12 12 12 -409 12 12 12 12 12 12 12 12 12 12 12 -255 12 12 12 12 12 12 12 12 12 12 12 -278 12 12 12 12 12 12 12 12 12 12 12 -98 12 12 12 12 12 12 12 12 12 12 12 -484 12 12 12 12 12 12 12 12 12 12 12 -265 12 12 12 12 12 12 12 12 12 12 12 -193 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -150 12 12 12 12 12 12 12 12 12 12 12 -273 12 12 12 12 12 12 12 12 12 12 12 -224 12 12 12 12 12 12 12 12 12 12 12 -369 12 12 12 12 12 12 12 12 12 12 12 -66 12 12 12 12 12 12 12 12 12 12 12 -128 12 12 12 12 12 12 12 12 12 12 12 -213 12 12 12 12 12 12 12 12 12 12 12 -146 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -429 12 12 12 12 12 12 12 12 12 12 12 -374 12 12 12 12 12 12 12 12 12 12 12 -152 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -145 12 12 12 12 12 12 12 12 12 12 12 -495 12 12 12 12 12 12 12 12 12 12 12 -37 12 12 12 12 12 12 12 12 12 12 12 -327 12 12 12 12 12 12 12 12 12 12 12 -281 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -209 12 12 12 12 12 12 12 12 12 12 12 -15 12 12 12 12 12 12 12 12 12 12 12 -82 12 12 12 12 12 12 12 12 12 12 12 -403 12 12 12 12 12 12 12 12 12 12 12 -166 12 12 12 12 12 12 12 12 12 12 12 -417 12 12 12 12 12 12 12 12 12 12 12 -430 12 12 12 12 12 12 12 12 12 12 12 -252 12 12 12 12 12 12 12 12 12 12 12 -292 12 12 12 12 12 12 12 12 12 12 12 -219 12 12 12 12 12 12 12 12 12 12 12 -287 12 12 12 12 12 12 12 12 12 12 12 -153 12 12 12 12 12 12 12 12 12 12 12 -193 12 12 12 12 12 12 12 12 12 12 12 -338 12 12 12 12 12 12 12 12 12 12 12 -446 12 12 12 12 12 12 12 12 12 12 12 -459 12 12 12 12 12 12 12 12 12 12 12 -394 12 12 12 12 12 12 12 12 12 12 12 -237 12 12 12 12 12 12 12 12 12 12 12 -482 12 12 12 12 12 12 12 12 12 12 12 -174 12 12 12 12 12 12 12 12 12 12 12 -413 12 12 12 12 12 12 12 12 12 12 12 -494 12 12 12 12 12 12 12 12 12 12 12 -207 12 12 12 12 12 12 12 12 12 12 12 -199 12 12 12 12 12 12 12 12 12 12 12 -466 12 12 12 12 12 12 12 12 12 12 12 -208 12 12 12 12 12 12 12 12 12 12 12 -174 12 12 12 12 12 12 12 12 12 12 12 -399 12 12 12 12 12 12 12 12 12 12 12 -396 12 12 12 12 12 12 12 12 12 12 12 -247 12 12 12 12 12 12 12 12 12 12 12 -417 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -162 12 12 12 12 12 12 12 12 12 12 12 -377 12 12 12 12 12 12 12 12 12 12 12 -397 12 12 12 12 12 12 12 12 12 12 12 -309 12 12 12 12 12 12 12 12 12 12 12 -365 12 12 12 12 12 12 12 12 12 12 12 -266 12 12 12 12 12 12 12 12 12 12 12 -439 12 12 12 12 12 12 12 12 12 12 12 -342 12 12 12 12 12 12 12 12 12 12 12 -367 12 12 12 12 12 12 12 12 12 12 12 -325 12 12 12 12 12 12 12 12 12 12 12 -167 12 12 12 12 12 12 12 12 12 12 12 -195 12 12 12 12 12 12 12 12 12 12 12 -475 12 12 12 12 12 12 12 12 12 12 12 -17 12 12 12 12 12 12 12 12 12 12 12 -113 12 12 12 12 12 12 12 12 12 12 12 -155 12 12 12 12 12 12 12 12 12 12 12 -203 12 12 12 12 12 12 12 12 12 12 12 -339 12 12 12 12 12 12 12 12 12 12 12 -455 12 12 12 12 12 12 12 12 12 12 12 -128 12 12 12 12 12 12 12 12 12 12 12 -311 12 12 12 12 12 12 12 12 12 12 12 -316 12 12 12 12 12 12 12 12 12 12 12 -57 12 12 12 12 12 12 12 12 12 12 12 -302 12 12 12 12 12 12 12 12 12 12 12 -205 12 12 12 12 12 12 12 12 12 12 12 -149 12 12 12 12 12 12 12 12 12 12 12 -438 12 12 12 12 12 12 12 12 12 12 12 -345 12 12 12 12 12 12 12 12 12 12 12 -129 12 12 12 12 12 12 12 12 12 12 12 -170 12 12 12 12 12 12 12 12 12 12 12 -20 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -157 12 12 12 12 12 12 12 12 12 12 12 -378 12 12 12 12 12 12 12 12 12 12 12 -221 12 12 12 12 12 12 12 12 12 12 12 -92 12 12 12 12 12 12 12 12 12 12 12 -111 12 12 12 12 12 12 12 12 12 12 12 -47 12 12 12 12 12 12 12 12 12 12 12 -72 12 12 12 12 12 12 12 12 12 12 12 4 12 12 12 12 12 12 12 12 12 12 12 -280 12 12 12 12 12 12 12 12 12 12 12 -35 12 12 12 12 12 12 12 12 12 12 12 -427 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -208 12 12 12 12 12 12 12 12 12 12 12 -356 12 12 12 12 12 12 12 12 12 12 12 -399 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -382 12 12 12 12 12 12 12 12 12 12 12 -498 12 12 12 12 12 12 12 12 12 12 12 -125 12 12 12 12 12 12 12 12 12 12 12 -386 12 12 12 12 12 12 12 12 12 12 12 -437 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -192 12 12 12 12 12 12 12 12 12 12 12 -286 12 12 12 12 12 12 12 12 12 12 12 -187 12 12 12 12 12 12 12 12 12 12 12 -176 12 12 12 12 12 12 12 12 12 12 12 -54 12 12 12 12 12 12 12 12 12 12 12 -459 12 12 12 12 12 12 12 12 12 12 12 -51 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -103 12 12 12 12 12 12 12 12 12 12 12 -239 12 12 12 12 12 12 12 12 12 12 12 -213 12 12 12 12 12 12 12 12 12 12 12 -216 12 12 12 12 12 12 12 12 12 12 12 -430 12 12 12 12 12 12 12 12 12 12 12 -278 12 12 12 12 12 12 12 12 12 12 12 -176 12 12 12 12 12 12 12 12 12 12 12 -289 12 12 12 12 12 12 12 12 12 12 12 -221 12 12 12 12 12 12 12 12 12 12 12 -65 12 12 12 12 12 12 12 12 12 12 12 -318 12 12 12 12 12 12 12 12 12 12 12 -332 12 12 12 12 12 12 12 12 12 12 12 -311 12 12 12 12 12 12 12 12 12 12 12 -275 12 12 12 12 12 12 12 12 12 12 12 -137 12 12 12 12 12 12 12 12 12 12 12 -241 12 12 12 12 12 12 12 12 12 12 12 -83 12 12 12 12 12 12 12 12 12 12 12 -333 12 12 12 12 12 12 12 12 12 12 12 -180 12 12 12 12 12 12 12 12 12 12 12 -284 12 12 12 12 12 12 12 12 12 12 12 -12 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -181 12 12 12 12 12 12 12 12 12 12 12 -67 12 12 12 12 12 12 12 12 12 12 12 -260 12 12 12 12 12 12 12 12 12 12 12 -404 12 12 12 12 12 12 12 12 12 12 12 -384 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -353 12 12 12 12 12 12 12 12 12 12 12 -373 12 12 12 12 12 12 12 12 12 12 12 -272 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -217 12 12 12 12 12 12 12 12 12 12 12 -84 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -466 12 12 12 12 12 12 12 12 12 12 12 -58 12 12 12 12 12 12 12 12 12 12 12 8 12 12 12 12 12 12 12 12 12 12 12 -411 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -208 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -24 12 12 12 12 12 12 12 12 12 12 12 -463 12 12 12 12 12 12 12 12 12 12 12 -431 12 12 12 12 12 12 12 12 12 12 12 -179 12 12 12 12 12 12 12 12 12 12 12 -172 12 12 12 12 12 12 12 12 12 12 12 -42 12 12 12 12 12 12 12 12 12 12 12 -129 12 12 12 12 12 12 12 12 12 12 12 -158 12 12 12 12 12 12 12 12 12 12 12 -119 12 12 12 12 12 12 12 12 12 12 12 -496 12 12 12 12 12 12 12 12 12 12 12 -322 12 12 12 12 12 12 12 12 12 12 12 -197 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -393 12 12 12 12 12 12 12 12 12 12 12 -454 12 12 12 12 12 12 12 12 12 12 12 -100 12 12 12 12 12 12 12 12 12 12 12 -298 12 12 12 12 12 12 12 12 12 12 12 -199 12 12 12 12 12 12 12 12 12 12 12 -191 12 12 12 12 12 12 12 12 12 12 12 -418 12 12 12 12 12 12 12 12 12 12 12 -96 12 12 12 12 12 12 12 12 12 12 12 -26 12 12 12 12 12 12 12 12 12 12 12 -165 12 12 12 12 12 12 12 12 12 12 12 -327 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -205 12 12 12 12 12 12 12 12 12 12 12 -120 12 12 12 12 12 12 12 12 12 12 12 -131 12 12 12 12 12 12 12 12 12 12 12 -51 12 12 12 12 12 12 12 12 12 12 12 -404 12 12 12 12 12 12 12 12 12 12 12 -43 12 12 12 12 12 12 12 12 12 12 12 -436 12 12 12 12 12 12 12 12 12 12 12 -156 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -308 12 12 12 12 12 12 12 12 12 12 12 -95 12 12 12 12 12 12 12 12 12 12 12 -196 12 12 12 12 12 12 12 12 12 12 12 -288 12 12 12 12 12 12 12 12 12 12 12 -481 12 12 12 12 12 12 12 12 12 12 12 -457 12 12 12 12 12 12 12 12 12 12 12 -98 12 12 12 12 12 12 12 12 12 12 12 -282 12 12 12 12 12 12 12 12 12 12 12 -197 12 12 12 12 12 12 12 12 12 12 12 -187 12 12 12 12 12 12 12 12 12 12 12 -318 12 12 12 12 12 12 12 12 12 12 12 -318 12 12 12 12 12 12 12 12 12 12 12 -409 12 12 12 12 12 12 12 12 12 12 12 -470 12 12 12 12 12 12 12 12 12 12 12 -137 12 12 12 12 12 12 12 12 12 12 12 -369 12 12 12 12 12 12 12 12 12 12 12 -316 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -413 12 12 12 12 12 12 12 12 12 12 12 -85 12 12 12 12 12 12 12 12 12 12 12 -77 12 12 12 12 12 12 12 12 12 12 12 -490 12 12 12 12 12 12 12 12 12 12 12 -87 12 12 12 12 12 12 12 12 12 12 12 -364 12 12 12 12 12 12 12 12 12 12 12 -179 12 12 12 12 12 12 12 12 12 12 12 -118 12 12 12 12 12 12 12 12 12 12 12 -134 12 12 12 12 12 12 12 12 12 12 12 -395 12 12 12 12 12 12 12 12 12 12 12 -282 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -238 12 12 12 12 12 12 12 12 12 12 12 -419 12 12 12 12 12 12 12 12 12 12 12 -15 12 12 12 12 12 12 12 12 12 12 12 -118 12 12 12 12 12 12 12 12 12 12 12 -72 12 12 12 12 12 12 12 12 12 12 12 -90 12 12 12 12 12 12 12 12 12 12 12 -307 12 12 12 12 12 12 12 12 12 12 12 -19 12 12 12 12 12 12 12 12 12 12 12 -435 12 12 12 12 12 12 12 12 12 12 12 -10 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -273 12 12 12 12 12 12 12 12 12 12 12 -306 12 12 12 12 12 12 12 12 12 12 12 -224 12 12 12 12 12 12 12 12 12 12 12 -309 12 12 12 12 12 12 12 12 12 12 12 -389 12 12 12 12 12 12 12 12 12 12 12 -327 12 12 12 12 12 12 12 12 12 12 12 -242 12 12 12 12 12 12 12 12 12 12 12 -369 12 12 12 12 12 12 12 12 12 12 12 -392 12 12 12 12 12 12 12 12 12 12 12 -272 12 12 12 12 12 12 12 12 12 12 12 -331 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -242 12 12 12 12 12 12 12 12 12 12 12 -452 12 12 12 12 12 12 12 12 12 12 12 -177 12 12 12 12 12 12 12 12 12 12 12 -226 12 12 12 12 12 12 12 12 12 12 12 -5 12 12 12 12 12 12 12 12 12 12 12 -497 12 12 12 12 12 12 12 12 12 12 12 -402 12 12 12 12 12 12 12 12 12 12 12 -396 12 12 12 12 12 12 12 12 12 12 12 -317 12 12 12 12 12 12 12 12 12 12 12 -395 12 12 12 12 12 12 12 12 12 12 12 -58 12 12 12 12 12 12 12 12 12 12 12 -35 12 12 12 12 12 12 12 12 12 12 12 -336 12 12 12 12 12 12 12 12 12 12 12 -95 12 12 12 12 12 12 12 12 12 12 12 -11 12 12 12 12 12 12 12 12 12 12 12 -168 12 12 12 12 12 12 12 12 12 12 12 -34 12 12 12 12 12 12 12 12 12 12 12 -229 12 12 12 12 12 12 12 12 12 12 12 -233 12 12 12 12 12 12 12 12 12 12 12 -143 12 12 12 12 12 12 12 12 12 12 12 -472 12 12 12 12 12 12 12 12 12 12 12 -322 12 12 12 12 12 12 12 12 12 12 12 -498 12 12 12 12 12 12 12 12 12 12 12 -160 12 12 12 12 12 12 12 12 12 12 12 -195 12 12 12 12 12 12 12 12 12 12 12 -42 12 12 12 12 12 12 12 12 12 12 12 -321 12 12 12 12 12 12 12 12 12 12 12 -430 12 12 12 12 12 12 12 12 12 12 12 -119 12 12 12 12 12 12 12 12 12 12 12 -489 12 12 12 12 12 12 12 12 12 12 12 -458 12 12 12 12 12 12 12 12 12 12 12 -78 12 12 12 12 12 12 12 12 12 12 12 -76 12 12 12 12 12 12 12 12 12 12 12 -41 12 12 12 12 12 12 12 12 12 12 12 -223 12 12 12 12 12 12 12 12 12 12 12 -492 12 12 12 12 12 12 12 12 12 12 12 -149 12 12 12 12 12 12 12 12 12 12 12 -449 12 12 12 12 12 12 12 12 12 12 12 -218 12 12 12 12 12 12 12 12 12 12 12 -228 12 12 12 12 12 12 12 12 12 12 12 -138 12 12 12 12 12 12 12 12 12 12 12 -453 12 12 12 12 12 12 12 12 12 12 12 -30 12 12 12 12 12 12 12 12 12 12 12 -209 12 12 12 12 12 12 12 12 12 12 12 -64 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -76 12 12 12 12 12 12 12 12 12 12 12 -74 12 12 12 12 12 12 12 12 12 12 12 -342 12 12 12 12 12 12 12 12 12 12 12 -69 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -33 12 12 12 12 12 12 12 12 12 12 12 -368 12 12 12 12 12 12 12 12 12 12 12 -103 12 12 12 12 12 12 12 12 12 12 12 -296 12 12 12 12 12 12 12 12 12 12 12 -113 12 12 12 12 12 12 12 12 12 12 12 -216 12 12 12 12 12 12 12 12 12 12 12 -367 12 12 12 12 12 12 12 12 12 12 12 -344 12 12 12 12 12 12 12 12 12 12 12 -167 12 12 12 12 12 12 12 12 12 12 12 -274 12 12 12 12 12 12 12 12 12 12 12 -219 12 12 12 12 12 12 12 12 12 12 12 -239 12 12 12 12 12 12 12 12 12 12 12 -485 12 12 12 12 12 12 12 12 12 12 12 -116 12 12 12 12 12 12 12 12 12 12 12 -223 12 12 12 12 12 12 12 12 12 12 12 -256 12 12 12 12 12 12 12 12 12 12 12 -263 12 12 12 12 12 12 12 12 12 12 12 -70 12 12 12 12 12 12 12 12 12 12 12 -487 12 12 12 12 12 12 12 12 12 12 12 -480 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -288 12 12 12 12 12 12 12 12 12 12 12 -191 12 12 12 12 12 12 12 12 12 12 12 -5 12 12 12 12 12 12 12 12 12 12 12 -244 12 12 12 12 12 12 12 12 12 12 12 -438 12 12 12 12 12 12 12 12 12 12 12 -128 12 12 12 12 12 12 12 12 12 12 12 -467 12 12 12 12 12 12 12 12 12 12 12 -432 12 12 12 12 12 12 12 12 12 12 12 -202 12 12 12 12 12 12 12 12 12 12 12 -316 12 12 12 12 12 12 12 12 12 12 12 -229 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -463 12 12 12 12 12 12 12 12 12 12 12 -280 12 12 12 12 12 12 12 12 12 12 12 2 12 12 12 12 12 12 12 12 12 12 12 -35 12 12 12 12 12 12 12 12 12 12 12 -283 12 12 12 12 12 12 12 12 12 12 12 -331 12 12 12 12 12 12 12 12 12 12 12 -235 12 12 12 12 12 12 12 12 12 12 12 -80 12 12 12 12 12 12 12 12 12 12 12 -44 12 12 12 12 12 12 12 12 12 12 12 -193 12 12 12 12 12 12 12 12 12 12 12 -321 12 12 12 12 12 12 12 12 12 12 12 -335 12 12 12 12 12 12 12 12 12 12 12 -104 12 12 12 12 12 12 12 12 12 12 12 -466 12 12 12 12 12 12 12 12 12 12 12 -366 12 12 12 12 12 12 12 12 12 12 12 -175 12 12 12 12 12 12 12 12 12 12 12 -403 12 12 12 12 12 12 12 12 12 12 12 -483 12 12 12 12 12 12 12 12 12 12 12 -53 12 12 12 12 12 12 12 12 12 12 12 -105 12 12 12 12 12 12 12 12 12 12 12 -257 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -409 12 12 12 12 12 12 12 12 12 12 12 -190 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -114 12 12 12 12 12 12 12 12 12 12 12 -258 12 12 12 12 12 12 12 12 12 12 12 -90 12 12 12 12 12 12 12 12 12 12 12 -203 12 12 12 12 12 12 12 12 12 12 12 -262 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -424 12 12 12 12 12 12 12 12 12 12 12 -12 12 12 12 12 12 12 12 12 12 12 12 -396 12 12 12 12 12 12 12 12 12 12 12 -201 12 12 12 12 12 12 12 12 12 12 12 -217 12 12 12 12 12 12 12 12 12 12 12 -164 12 12 12 12 12 12 12 12 12 12 12 -431 12 12 12 12 12 12 12 12 12 12 12 -454 12 12 12 12 12 12 12 12 12 12 12 -478 12 12 12 12 12 12 12 12 12 12 12 -298 12 12 12 12 12 12 12 12 12 12 12 -125 12 12 12 12 12 12 12 12 12 12 12 -431 12 12 12 12 12 12 12 12 12 12 12 -164 12 12 12 12 12 12 12 12 12 12 12 -424 12 12 12 12 12 12 12 12 12 12 12 -187 12 12 12 12 12 12 12 12 12 12 12 -382 12 12 12 12 12 12 12 12 12 12 12 -5 12 12 12 12 12 12 12 12 12 12 12 -70 12 12 12 12 12 12 12 12 12 12 12 -397 12 12 12 12 12 12 12 12 12 12 12 -480 12 12 12 12 12 12 12 12 12 12 12 -291 12 12 12 12 12 12 12 12 12 12 12 -24 12 12 12 12 12 12 12 12 12 12 12 -351 12 12 12 12 12 12 12 12 12 12 12 -255 12 12 12 12 12 12 12 12 12 12 12 -104 12 12 12 12 12 12 12 12 12 12 12 -70 12 12 12 12 12 12 12 12 12 12 12 -163 12 12 12 12 12 12 12 12 12 12 12 -438 12 12 12 12 12 12 12 12 12 12 12 -119 12 12 12 12 12 12 12 12 12 12 12 -414 12 12 12 12 12 12 12 12 12 12 12 -200 12 12 12 12 12 12 12 12 12 12 12 -491 12 12 12 12 12 12 12 12 12 12 12 -237 12 12 12 12 12 12 12 12 12 12 12 -439 12 12 12 12 12 12 12 12 12 12 12 -360 12 12 12 12 12 12 12 12 12 12 12 -248 12 12 12 12 12 12 12 12 12 12 12 -479 12 12 12 12 12 12 12 12 12 12 12 -305 12 12 12 12 12 12 12 12 12 12 12 -417 12 12 12 12 12 12 12 12 12 12 12 -199 12 12 12 12 12 12 12 12 12 12 12 -444 12 12 12 12 12 12 12 12 12 12 12 -120 12 12 12 12 12 12 12 12 12 12 12 -429 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -443 12 12 12 12 12 12 12 12 12 12 12 -323 12 12 12 12 12 12 12 12 12 12 12 -325 12 12 12 12 12 12 12 12 12 12 12 -277 12 12 12 12 12 12 12 12 12 12 12 -230 12 12 12 12 12 12 12 12 12 12 12 -478 12 12 12 12 12 12 12 12 12 12 12 -178 12 12 12 12 12 12 12 12 12 12 12 -468 12 12 12 12 12 12 12 12 12 12 12 -310 12 12 12 12 12 12 12 12 12 12 12 -317 12 12 12 12 12 12 12 12 12 12 12 -333 12 12 12 12 12 12 12 12 12 12 12 -493 12 12 12 12 12 12 12 12 12 12 12 -460 12 12 12 12 12 12 12 12 12 12 12 -207 12 12 12 12 12 12 12 12 12 12 12 -249 12 12 12 12 12 12 12 12 12 12 12 -265 12 12 12 12 12 12 12 12 12 12 12 -480 12 12 12 12 12 12 12 12 12 12 12 -83 12 12 12 12 12 12 12 12 12 12 12 -136 12 12 12 12 12 12 12 12 12 12 12 -353 12 12 12 12 12 12 12 12 12 12 12 -172 12 12 12 12 12 12 12 12 12 12 12 -214 12 12 12 12 12 12 12 12 12 12 12 -462 12 12 12 12 12 12 12 12 12 12 12 -233 12 12 12 12 12 12 12 12 12 12 12 -406 12 12 12 12 12 12 12 12 12 12 12 -133 12 12 12 12 12 12 12 12 12 12 12 -175 12 12 12 12 12 12 12 12 12 12 12 -189 12 12 12 12 12 12 12 12 12 12 12 -454 12 12 12 12 12 12 12 12 12 12 12 -375 12 12 12 12 12 12 12 12 12 12 12 -401 12 12 12 12 12 12 12 12 12 12 12 -421 12 12 12 12 12 12 12 12 12 12 12 -407 12 12 12 12 12 12 12 12 12 12 12 -384 12 12 12 12 12 12 12 12 12 12 12 -256 12 12 12 12 12 12 12 12 12 12 12 -26 12 12 12 12 12 12 12 12 12 12 12 -134 12 12 12 12 12 12 12 12 12 12 12 -67 12 12 12 12 12 12 12 12 12 12 12 -384 12 12 12 12 12 12 12 12 12 12 12 -379 12 12 12 12 12 12 12 12 12 12 12 -18 12 12 12 12 12 12 12 12 12 12 12 -462 12 12 12 12 12 12 12 12 12 12 12 -492 12 12 12 12 12 12 12 12 12 12 12 -100 12 12 12 12 12 12 12 12 12 12 12 -298 12 12 12 12 12 12 12 12 12 12 12 -9 12 12 12 12 12 12 12 12 12 12 12 -341 12 12 12 12 12 12 12 12 12 12 12 -498 12 12 12 12 12 12 12 12 12 12 12 -146 12 12 12 12 12 12 12 12 12 12 12 -458 12 12 12 12 12 12 12 12 12 12 12 -362 12 12 12 12 12 12 12 12 12 12 12 -186 12 12 12 12 12 12 12 12 12 12 12 -285 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -167 12 12 12 12 12 12 12 12 12 12 12 -18 12 12 12 12 12 12 12 12 12 12 12 -273 12 12 12 12 12 12 12 12 12 12 12 -183 12 12 12 12 12 12 12 12 12 12 12 -281 12 12 12 12 12 12 12 12 12 12 12 -344 12 12 12 12 12 12 12 12 12 12 12 -97 12 12 12 12 12 12 12 12 12 12 12 -469 12 12 12 12 12 12 12 12 12 12 12 -315 12 12 12 12 12 12 12 12 12 12 12 -84 12 12 12 12 12 12 12 12 12 12 12 -28 12 12 12 12 12 12 12 12 12 12 12 -37 12 12 12 12 12 12 12 12 12 12 12 -448 12 12 12 12 12 12 12 12 12 12 12 -152 12 12 12 12 12 12 12 12 12 12 12 -348 12 12 12 12 12 12 12 12 12 12 12 -307 12 12 12 12 12 12 12 12 12 12 12 -194 12 12 12 12 12 12 12 12 12 12 12 -414 12 12 12 12 12 12 12 12 12 12 12 -477 12 12 12 12 12 12 12 12 12 12 12 -222 12 12 12 12 12 12 12 12 12 12 12 -126 12 12 12 12 12 12 12 12 12 12 12 -90 12 12 12 12 12 12 12 12 12 12 12 -169 12 12 12 12 12 12 12 12 12 12 12 -403 12 12 12 12 12 12 12 12 12 12 12 -400 12 12 12 12 12 12 12 12 12 12 12 -200 12 12 12 12 12 12 12 12 12 12 12 -97 12 12 12 12 12 12 12 12 12 12 12