Support Questions

Find answers, ask questions, and share your expertise
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

Sensitive Data Redaction not working

New Contributor



We applied data redaction rules for email and credit card on HDFS services. But when we query on data in hive through shell or HUE UI, redaction policies are not applied on data and data is not redacted. We tried it on 5.8 version of Quickstart VM . Please update and revert.





New Contributor

Could you please put your steps here you did

Community Manager

Hello Divya,


The purpose of Sensitive Data Redaction is to sanitize log files and query history or any other activitity that are stored outside of the database.  It is not applied to the actual data in your database.


When data redaction is enabled, the following data is redacted:

  • Logs in HDFS and any dependent cluster services.
  • Audit data sent to Cloudera Navigator
  • SQL query strings displayed by Hue, Hive, and Impala.


For example, if you set the search rules to replace "\d{3}[^\w]\d{2}[^\w]\d{4}" with "XXX-XX-XXXX" and, as a user authorized to access the table "employees", you run the following query:




SELECT * FROM employees
WHERE ssn = '123-45-6789'



The query will return the data you requested from the database.  The data redaction will be applied to the query history in Hue which will save the query as:



SELECT * FROM employees



If your database contains sensitive information, to protect it:

  • ensure the permissions on the database are set to only allow access only to authorized users
  • have the data sanitized before it is loaded into your database.


Please see the blog post at and the documentation at for more information.






David Wilder, Community Manager

Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.

Learn more about the Cloudera Community:

Terms of Service

Community Guidelines

How to use the forum

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.