[
https://issues.apache.org/jira/browse/HIVE-6167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13868476#comment-13868476
]
Alan Gates commented on HIVE-6167:
----------------------------------
There's no need to add it to every database. Users can invoked the function
across database. So it would be
{code}
use DB1;
create function a();
use DB2;
select DB1.a() from T;
{code}
I disagree that this is a usability issue. I think it's much more usable to
give users namespaces then to push them into one flat namespace.
> Allow user-defined functions to be qualified with database name
> ---------------------------------------------------------------
>
> Key: HIVE-6167
> URL: https://issues.apache.org/jira/browse/HIVE-6167
> Project: Hive
> Issue Type: Sub-task
> Components: UDF
> Reporter: Jason Dere
> Assignee: Jason Dere
>
> Function names in Hive are currently unqualified and there is a single
> namespace for all function names. This task would allow users to define
> temporary UDFs (and eventually permanent UDFs) with a database name, such as:
> CREATE TEMPORARY FUNCTION userdb.myfunc 'myudfclass';
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
