[jira] [Resolved] (IMPALA-11728) Set fallback database for functions

["Fang-Yu Rao (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-11728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fang-Yu Rao resolved IMPALA-11728.
----------------------------------
    Resolution: Fixed

Resolve the patch since the fix has been merged.

> Set fallback database for functions
> -----------------------------------
>
>                 Key: IMPALA-11728
>                 URL: https://issues.apache.org/jira/browse/IMPALA-11728
>             Project: IMPALA
>          Issue Type: New Feature
>            Reporter: gaoxiaoqing
>            Assignee: gaoxiaoqing
>            Priority: Major
>
> {code:java}
> CREATE FUNCTION default.function_name([arg_type[, arg_type...])
>   RETURNS return_type
>   LOCATION 'hdfs_path_to_dot_so'
>   SYMBOL='symbol_name' {code}
>  
> {noformat}
> use functional;
> select function_name();
> ERROR: AnalysisException: functional.function_name() unknown for database functional.{noformat}
>  
> The create function statement can only works on specified default database.
> Add a fallback database for functions as query option. It works on all database without changing query. 
> {noformat}
> use functional;
> set db_name_with_global_udf=default;
> select function_name(); // It works.{noformat}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org