permission denied when creating function in hive

[#1]

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.

[#2 · Accepted solution]

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

[#3]

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

[#4]

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.