[
https://issues.apache.org/jira/browse/HIVE-26259?focusedWorklogId=785045&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-785045
]
ASF GitHub Bot logged work on HIVE-26259:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 27/Jun/22 11:40
Start Date: 27/Jun/22 11:40
Worklog Time Spent: 10m
Work Description: pvary commented on PR #3316:
URL: https://github.com/apache/hive/pull/3316#issuecomment-1167246761
> 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.
Makes sense
> 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.
I would prefer to have a security check already at hand when we enable the
alter function.
Issue Time Tracking
-------------------
Worklog Id: (was: 785045)
Time Spent: 1h 10m (was: 1h)
> 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 10m
> 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)
