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.

Access denied in issue in Hive - HDP 2.2

Highlighted

Access denied in issue in Hive - HDP 2.2

I recently downloaded HDP 2.2 and facing issues with hive configuration. Every time I login to Ambari/Hue after first use, i get permission denied error. I tried up changing hdfs permissions,few basics authorizations setting in hive conf, grant access through CLI, but nothing works. Please assist

11 REPLIES 11
Highlighted

Re: Access denied in issue in Hive - HDP 2.2

@dhawal shah Can you share the exact error message, log snippet or a screen snapshot? It is hard to say whats going on without more information..

Also, moving the question to Data Processing category.

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

@dhawal shah try this

su - hive and then run hive

example:

826-screen-shot-2015-12-14-at-72246-pm.png

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

@Neeraj Sabharwal

Thank you!

This works fine.

However, whenever i access hive through Ambari/Beeline i get access denied error. It happens whenever i import appliance and login second time.

Tried Grant commands as well.

Attached logs with error messages. hue-logs-145018895474.ziphue-logs-145018895474.zip

Re: Access denied in issue in Hive - HDP 2.2

@dhawal shah

It looks like that you ended up enabling Ranger for Hive. Can you check?

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

@Neeraj Sabharwal

I don't see ranger installed on my HDP 2.2. No knox or Ranger running since i am unable to reach http://myip:6080.

Is there any specific configuration i need to look for?

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

hue-logs-145018895474.zipAttaching error message logs

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

Mentor

Just under your nose the permission issue for the user hdfs once that corrected you will be good to go !

Check the file permissions and owner of the Hive installation.

Processing exception: Error occurred executing hive query: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [hdfs] does not have [USE] privilege on [default]: Traceback (most recent call last):

Either use the chown -R user:group /hive_install_dir *

or su to the owner of the /hive_install_dir and retry

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

@Geoffrey Shelton Okot

Hi Geoffrey,

I changed the permission of my hive installation(and logged in as a user who is owner of this directory) directory but could not resolve the issue.

Highlighted

Re: Access denied in issue in Hive - HDP 2.2

Mentor

@dhawal shah has this been resolved? Please accept best answer or provide your own solution.

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