[jira] [Resolved] (IMPALA-6724) Allow creating/dropping functions with the same name as built-ins

["Fredy Wijaya (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/IMPALA-6724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Fredy Wijaya resolved IMPALA-6724.
----------------------------------
       Resolution: Fixed
    Fix Version/s: Impala 3.0

> Allow creating/dropping functions with the same name as built-ins
> -----------------------------------------------------------------
>
>                 Key: IMPALA-6724
>                 URL: https://issues.apache.org/jira/browse/IMPALA-6724
>             Project: IMPALA
>          Issue Type: Bug
>          Components: Frontend
>    Affects Versions: Impala 2.8.0, Impala 2.9.0, Impala 2.10.0, Impala 2.11.0
>            Reporter: Fredy Wijaya
>            Assignee: Fredy Wijaya
>            Priority: Major
>             Fix For: Impala 3.0
>
>
> {noformat}
> [localhost:21000] > create function foo.sin() returns int location '/test-warehouse/libTestUdfs.so' symbol='NoArgs';
> Query: create function foo.sin() returns int location '/test-warehouse/libTestUdfs.so' symbol='NoArgs'
> Fetched 0 row(s) in 0.02s
> {noformat}
> To match the behavior above, the statement below should be allowed.
> {noformat}
> [localhost:21000] > use foo; Query: use foo [localhost:21000] > create function sin() returns int location '/test-warehouse/libTestUdfs.so' symbol='NoArgs'; Query: create function sin() returns int location '/test-warehouse/libTestUdfs.so' symbol='NoArgs' ERROR: AnalysisException: Function cannot have the same name as a builtin: sin
> {noformat}
> The statement below should trigger an AuthorizationException("Can not modify system database.")
> {noformat}
> [localhost:21000] > create function _impala_builtins.sin() returns int location '/test-warehouse/libTestUdfs.so' symbol='NoArgs';
> Query: create function _impala_builtins.sin() returns int location '/test-warehouse/libTestUdfs.so' symbol='NoArgs'
> ERROR: AnalysisException: Function cannot have the same name as a builtin: sin
> {noformat}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)