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

["gaoxiaoqing (Jira)" <ji...@apache.org>]

gaoxiaoqing created IMPALA-11728:
------------------------------------

             Summary: 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


{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 rawdata.{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