Support Questions
Find answers, ask questions, and share your expertise
Announcements
Check out our newest addition to the community, the Cloudera Innovation Accelerator group hub.

Table Grant Access : Permission Denied

Explorer

Hi,

Trying to grant access to HIVE table. But getting privileges error as below. How to overcome this error?

14657-tablegrantaccessproblem.png

Thank You.

3 REPLIES 3

Super Guru
@Sasitharan Ravindar

Switch to user "hdfs" or "hive" before starting hive shell and then try again. Root user is not special for Hadoop (It's just another user and not super user).

Explorer

@mqureshi, Noted. Using which code i can change to "hdfs" or "hive? Thank You.

Contributor

@Sasitharan Ravindar : use below to swtich users to hdfs or hive

sudo -u hdfs OR sudo -u hive

PS: BTW Have you Configured Kerberos?