I am implementing column level security in Hive using Ranger.
I followed the tutorial listed on the hortonworks website listed here: http://hortonworks.com/hadoop-tutorial/tag-based-policies-atlas-ranger/.
I created a table employee with columns name, ssn and location. I then spun up Tableau and connected it to the Hive database using
the Tableau provided ODBC driver. I gave the username raj_ops access to the employee table and
was able to access it in Tableau as expected. Then I created a policy to restrict raj_ops
access to the location field of the employee table. I then tried accessing the data through Tableau and received the following error message while connecting, “[Hortonworks][Hardy]
(80) Syntax or semantic analysis error thrown in server while executing query.
Error message from server: Error while compiling statement: FAILED:
HiveAccessControlException Permission denied: user [raj_ops] does not have
[SELECT] privilege on [default/employee/location,name,ssn] “ My questions is there a way to pull the columns raj_ops still has
access to – name and ssn? Or is it all or nothing in the -- the entire employee table or no columns at all? Thank you! Kate
... View more
