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