Details
-
Task
-
Status: Open
-
Major
-
Resolution: Unresolved
-
0.13.1, 1.1.0
-
None
-
None
Description
SQLStandardAuthorization require ADMIN PRIVILEGE need for creating and dropping temporary function as the following:
> create function example_add AS 'org.apache.hadoop.hive.contrib.udf.example.UDFExampleAdd';
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=admin, type=USER] does not have following privileges for operation CREATEFUNCTION [[ADMIN PRIVILEGE] on Object [type=DATABASE, name=default], [ADMIN PRIVILEGE] on Object [type=FUNCTION, name=default.example_add]] (state=42000,code=40000)
> drop function example_add;
Error: Error while compiling statement: FAILED: HiveAccessControlException Permission denied: Principal [name=admin, type=USER] does not have following privileges for operation DROPFUNCTION [[ADMIN PRIVILEGE] on Object [type=DATABASE, name=default], [ADMIN PRIVILEGE] on Object [type=FUNCTION, name=default.example_add]] (state=42000,code=40000)
But we think it is unnecessary to create and drop temporary function.