Have you followed the steps outlined by Neeraj to cleanup DB ? ... View more

To add in, as a best practice, we recommend customers using HDP 2.3.x or HDP 2.4.x to configure their audits to both Solr and HDFS. HDFS destination is for long term audit storage, while Solr could be used for short term audit query from the Ranger UI. It is recommended to use a ttl (time to live) setting in Solr to ensure documents are deleted automatically after a certain period. ... View more

@hduraiswamy Authorization and Masking are 2 separate events. You would need access to a column for the query to run. If customer would want to filter columns, best way would be to create views. This is no different than other databases. If the user has access to column, but the column data should be redacted, then masking would be an appropriate solution. ... View more

You can try writing a script to export/import policies from one Ranger instance to another using REST APIs. ... View more

What is the error that you are seeing ? ... View more

Is Ranger's audit source solr or db ? Check your config in Ambari ... View more

For Hive and HBase, you can execute GRANT/REVOKE statements from a shell and it will automatically create policies in Ranger. ... View more