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)