[
https://issues.apache.org/jira/browse/IMPALA-11728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
gaoxiaoqing updated IMPALA-11728:
---------------------------------
Description:
{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}
was:
{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}
> 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: [email protected]
For additional commands, e-mail: [email protected]
