https://community.cloudera.com/t5/Archives-of-Support-Questions/Masking-timestamps/m-p/203924#M76969 <P>It's not elegant, but this custom masking seems to work.</P><PRE>cast(mask(cast(to_date({col}) as date), 'x', 'x', 'x', -1, '1', 1, 0, -1) as timestamp)</PRE> Mon, 09 Apr 2018 04:30:01 GMT laura_ngo 2018-04-09T04:30:01Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Masking-timestamps/m-p/203923#M76968 <P>Is there a way of masking timestamps using the masking policies in Ranger? Perhaps through a custom UDF referenced in the policy?</P><P>The masking type of "Date: show only year" only works for dates, not timestamps.</P><P>Looking at GitHub (as the Ranger documentation isn't complete) timestamps cannot be masked, only nullified - <A href="https://github.com/myui/hive-udf-backports/tree/master/src/main/java/org/apache/hadoop/hive/ql/udf/generic" target="_blank">https://github.com/myui/hive-udf-backports/tree/master/src/main/java/org/apache/hadoop/hive/ql/udf/generic</A></P><PRE>mask(value, upperChar, lowerChar, digitChar, otherChar, numberChar, dayValue, monthValue, yearValue) Supported types: TINYINT, SMALLINT, INT, BIGINT, STRING, VARCHAR, CHAR, DATE </PRE><P>Reason: some systems store dates as timestamps, so date of birth (PII) could be stored as a timestamp and I need to mask it.</P> Sun, 08 Apr 2018 07:54:14 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Masking-timestamps/m-p/203923#M76968 laura_ngo 2018-04-08T07:54:14Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Masking-timestamps/m-p/203924#M76969 <P>It's not elegant, but this custom masking seems to work.</P><PRE>cast(mask(cast(to_date({col}) as date), 'x', 'x', 'x', -1, '1', 1, 0, -1) as timestamp)</PRE> Mon, 09 Apr 2018 04:30:01 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Masking-timestamps/m-p/203924#M76969 laura_ngo 2018-04-09T04:30:01Z