[ 
https://issues.apache.org/jira/browse/HIVE-23858?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17159201#comment-17159201
 ] 

Zhihua Deng commented on HIVE-23858:
------------------------------------

Hi [~adeshrao], to my knowledge,  this can be achived by enable 
hive.allow.udf.load.on.demand in HS2, if the current HS2 doesn't find the 
permenant function registered by other instances in his registry,  he will 
refer to metastore for the function definition.  There has seen some potential 
npe problem when ontaining functions from metastore as described in 
[HIVE-20441|https://issues.apache.org/jira/browse/HIVE-20441].

> In multi-HS2 setup, if a new function is registered on one of them, it is not 
> available on remaining HS2's unless reload-function is run 
> -----------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-23858
>                 URL: https://issues.apache.org/jira/browse/HIVE-23858
>             Project: Hive
>          Issue Type: Improvement
>          Components: HiveServer2
>            Reporter: Adesh Kumar Rao
>            Assignee: Adesh Kumar Rao
>            Priority: Minor
>
> When multiple HS2's are running and a function is registered on one of them, 
> we need to connect to each of remaining HS2's explicitly and run 
> reload-functions command. 
>  
> Without doing reload-function, if we try using the function in any of the 
> remaining HS2's, the command will fail saying invalid function. 
>  
> The idea here is to check for function existence, not only in 
> functionRegistry but also from metastore if the function does not exists in 
> registry.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to