[IMPALA-11728] Set fallback database for functions

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: Impala 4.3.0
• Epic Color: ghx-label-10
• Assignee: gaoxiaoqing
• Reporter: gaoxiaoqing
• Created: 16/Nov/22 12:06
• Updated: 20/Jan/23 22:14
• Resolved: 20/Jan/23 22:03

Description

CREATE FUNCTION default.function_name([arg_type[, arg_type...])
  RETURNS return_type
  LOCATION 'hdfs_path_to_dot_so'
  SYMBOL='symbol_name' 

 

use functional;
select function_name();
ERROR: AnalysisException: functional.function_name() unknown for database functional.

 

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. 

use functional;
set db_name_with_global_udf=default;
select function_name(); // It works.