[ 
https://issues.apache.org/jira/browse/HIVE-26259?focusedWorklogId=785037&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-785037
 ]

ASF GitHub Bot logged work on HIVE-26259:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 27/Jun/22 11:12
            Start Date: 27/Jun/22 11:12
    Worklog Time Spent: 10m 
      Work Description: wecharyu commented on PR #3316:
URL: https://github.com/apache/hive/pull/3316#issuecomment-1167220190

   Hi @pvary thanks for your concern. It is indeed important to do 
authorization for operating UDF. 
   But I do not think it should be an admin privilege for the user level 
function, user should be able to create or alter their UDF, so an `OWNER_PRIV` 
is enough just like #3360.
   Also, we can achieve the authorization in Hive MetaStore by 
`MetaStorePreEventListener`, I think it can be done after #3360 because there 
will be some similar code.
   




Issue Time Tracking
-------------------

    Worklog Id:     (was: 785037)
    Time Spent: 1h  (was: 50m)

> Alter Function does not update resource uris
> --------------------------------------------
>
>                 Key: HIVE-26259
>                 URL: https://issues.apache.org/jira/browse/HIVE-26259
>             Project: Hive
>          Issue Type: Bug
>          Components: Hive
>    Affects Versions: 3.1.2
>            Reporter: Wechar
>            Assignee: Wechar
>            Priority: Major
>              Labels: pull-request-available
>             Fix For: 4.0.0-alpha-2
>
>          Time Spent: 1h
>  Remaining Estimate: 0h
>
> *Bug Description:*
> The jar of Hive permanent UDF can be loaded based on the resource uris, but 
> we encountered an issue after changing the resource uris through spark-sql:
> {code:sql}
> CREATE OR REPLACE FUNCTION test_db.test_udf AS 'com.xxx.xxx'
> USING JAR 'hdfs://path/to/jar';
> {code}
> Then when we use the UDF `test_db.test_udf`, an error occured like this:
> {code:sh}
> Error in query: Can not load class 'com.xxx.xxx' when registering the 
> function 'test_db.test_udf'...
> {code}
> *Root Cause:*
> Hive metastore does not update resource uris while executing 
> `alter_function()`, which should be included and will not make any side 
> effect.



--
This message was sent by Atlassian Jira
(v8.20.7#820007)

Reply via email to