[
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)
