Hi All,
I am using Ranger (version-0.4.0) hive authorization. I am facing an issue: For update privileges to a user I have to give Select AND Update both privilege. Otherwise update privileges don't work. Steps I followed: 1. Create a table "test?" in hive. 2. Give privilege of only update to a user, e.g. john. 3. Make connection in hive with the same user. Run update query on "test" table - "Update test? SET first_name='pr' where id=124;" Expected- It should update the table Actual- Getting exception- "FAILED: HiveAccessControlException Permission denied: user [john] does not have [SELECT] privilege on [default/test/id] (state=42000,code=40000) " Once providing both privileges 'select' and 'update' to user "john" then it's working fine. Please let me know the expected behavior. ------- Thanks & Regards, Hanish Bansal ________________________________ NOTE: This message may contain information that is confidential, proprietary, privileged or otherwise protected by law. The message is intended solely for the named addressee. If received in error, please destroy and notify the sender. Any use of this email is prohibited when received in error. Impetus does not represent, warrant and/or guarantee, that the integrity of this communication has been maintained nor that the communication is free of errors, virus, interception or interference.
