Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Table Grant Access : Permission Denied

Table Grant Access : Permission Denied

New Contributor

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

Re: Table Grant Access : Permission Denied

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).

Re: Table Grant Access : Permission Denied

New Contributor

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

Re: Table Grant Access : Permission Denied

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?

Don't have an account?
Coming from Hortonworks? Activate your account here