I used Ranger to create policy in Hive wherein only one user is allowed to execute only Select query on a table and everyone else is not given any privilege.
With this I assume that the data is safe.
I could see that the query is being appended to hiveserver2.log in plain format and the query is below:
select * from employee where SSN=1234-567-890 ( This is test query )
I believe logs are not redacted.
Is there any feature in Hortonworks wherein logs don't display confidential information as above.
Thanks for your time.
Anyone who can help me out on this?