Carter Shanklin created HIVE-15461: -------------------------------------- Summary: Proposal: Search the default database for UDFs in addition to the current database. Key: HIVE-15461 URL: https://issues.apache.org/jira/browse/HIVE-15461 Project: Hive Issue Type: Improvement Reporter: Carter Shanklin Priority: Minor
HIVE-6167 introduces the ability for UDFs to be qualified with a database name. There was also discussion there of having "global" UDFs but this was not implemented, possibly an accident. Right now the closest thing you can do is put UDFs in the default database and then run "default.UDF(...)". In some cases this is not practical because tools may generate the SQL or user education may be impractical. I propose we consider that when a UDF is invoked Hive should search the current database and if it is not there, search the default database. This would be a hard-coded rule. One alternative approach would be to have a Postgres style search path. This is very powerful but is complex. The suggestion here is meant to be simple and it doesn't prevent a more full featured approach in the future. -- This message was sent by Atlassian JIRA (v6.3.4#6332)