error received when trying to create UDF function:
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.
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.