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)

Reply via email to