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

Highlighted

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
Highlighted

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

Explorer

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

Highlighted

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