https://community.cloudera.com/t5/Support-Questions/Hue-Directory-Monitoring/m-p/382942#M244753 <P>I'm not sure if we have example scripts or custom functions, but the general idea to achieve what you're trying to do would be -&nbsp;<BR /><BR />1. Referring the&nbsp;HDFS reporting in CM or parse the fsimage (for large files).<BR />2. Write&nbsp;a MapReduce/Spark job to scan files, or run a query in Hive/Impala/SparkSQL to see if data files are mapped to Hive tables.<BR /><BR />You can also implement access controls through Ranger, enable transparent disk encryption (TDE) using Ranger KMS, tag sensitive hive columns (containing PII, PCI, PHI) using Atlas classification and assign tag-based masking policies from Ranger, implement navencrypt to encrypt the spill files, et. - if you're planning to protect the sensitive data from unauthorised access.&nbsp;</P> Wed, 31 Jan 2024 17:40:24 GMT Sean464 2024-01-31T17:40:24Z