hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Carter Shanklin (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-15461) Proposal: Search the default database for UDFs in addition to the current database.
Date Sat, 17 Dec 2016 19:57:58 GMT
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)

Mime
View raw message