You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@hive.apache.org by jc...@apache.org on 2018/07/11 23:31:53 UTC
[5/9] hive git commit: HIVE-20123: Fix masking tests after HIVE-19617
(Jesus Camacho Rodriguez, reviewed by Ashutosh Chauhan)
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