Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

permission denied when creating function in hive

avatar
Contributor

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

avatar
Master 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

avatar
Master Guru

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

avatar
Contributor

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

avatar
Master 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.