http://git-wip-us.apache.org/repos/asf/hive/blob/6340a81f/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 5f90f3e..8ece717 100644
--- a/ql/src/test/results/clientpositive/masking_4.q.out
+++ b/ql/src/test/results/clientpositive/masking_4.q.out
@@ -84,18 +84,18 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: masking_test_n11
-            filterExpr: (key = 5) (type: boolean)
+            filterExpr: (((key % 2) = 0) and (key = 5)) (type: boolean)
             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,18 +126,18 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: masking_test_n11
-            filterExpr: (key = 5) (type: boolean)
+            filterExpr: (((key % 2) = 0) and (key = 5)) (type: boolean)
             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
@@ -159,19 +159,140 @@ 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
+            filterExpr: key is not null (type: boolean)
+            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
+            filterExpr: key is not null (type: boolean)
+            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
+            filterExpr: key is not null (type: boolean)
+            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/6340a81f/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..594abee 100644
--- a/ql/src/test/results/clientpositive/masking_5.q.out
+++ b/ql/src/test/results/clientpositive/masking_5.q.out
@@ -15,22 +15,39 @@ 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
+            filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean)
+            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 +57,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
@@ -66,18 +73,22 @@ STAGE PLANS:
       Map Operator Tree:
           TableScan
             alias: masking_test_n6
+            filterExpr: (((key % 2) = 0) and (key < 10)) (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
-              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 +105,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 +154,19 @@ STAGE PLANS:
     Map Reduce
       Map Operator Tree:
           TableScan
-            alias: s
+            alias: masking_test_n6
+            filterExpr: (((key % 2) = 0) and (key < 10)) (type: boolean)
             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 +187,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

Reply via email to