question Re: permission denied when creating function in hive in Archives of Support Questions (Read Only)

permission denied when creating function in hive

xw0927 — Tue, 22 Nov 2016 11:33:44 GMT

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.

Re: permission denied when creating function in hive

sunile_manjee — Tue, 22 Nov 2016 11:36:58 GMT

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

Re: permission denied when creating function in hive

xw0927 — Tue, 22 Nov 2016 11:55:41 GMT

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

Re: permission denied when creating function in hive

sunile_manjee — Tue, 22 Nov 2016 11:58:14 GMT

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.