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.

permission denied when creating function in hive

Solved Go to solution
Highlighted

permission denied when creating function in hive

Explorer

error received when trying to create UDF function:

Code:

ADD JAR /home/nbg/mlut.jar

create temporay function mlut as 'hive.udf.mlut'

Error while compiling statement: FAILED: HiveAccessControlException Permission denied: user [sbig] does not have [CREATE] privilege on [mlut]

with kerbores installed

Tried few workaround, but failed:

1.create a temporary tmp folder, and chmod to 777

2. Add the java file to tmp file, and list jars (confirmed file has been added)

3. But still failed.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: permission denied when creating function in hive

Super Guru

@jeannie tan do you have ranger enabled? if so verify you (userid) has access to create and execute UDF

View solution in original post

3 REPLIES 3
Highlighted

Re: permission denied when creating function in hive

Super Guru

@jeannie tan do you have ranger enabled? if so verify you (userid) has access to create and execute UDF

View solution in original post

Highlighted

Re: permission denied when creating function in hive

Explorer

@Sunile Manjee, sorry I'm new to ranger security, what is the command to check the access?

Highlighted

Re: permission denied when creating function in hive

Super Guru

Go to ranger UI. the link is found by going to ambari, then to ranger, and click on quick links. that will give you ranger ui. go to hive. check the user policy to determine if there are any policies give you access to UDF.

Another quick way to check if you have ranger enabled is by going to ranger config via ambari and determine if hive plugin is enabled.

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