[ 
https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16687470#comment-16687470
 ] 

ambition commented on CALCITE-2663:
-----------------------------------

sorry, I have two pull request, [PR 
#913|https://github.com/apache/calcite/pull/913] based branch-1.16  and 

[PR 
#920|[https://github.com/apache/calcite/pull/913|https://github.com/apache/calcite/pull/920]]
 based branch-1.17, so I modified PR #913 or PR #920, not modified PR I close 
pull request.

I can fix parse return like: 
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
but original return is good to understand :
{code:java}
CREATE OR REPLACE FUNCTION IF NOT EXISTS `X`.`UDF` AS 
'org.apache.calcite.udf.TableFun.demoUdf' USING 
('file:/path/udf/udf-0.0.1-SNAPSHOT.jar', 'file:/path/udf/logback.xml')
{code}
 

> create function and drop function SQL statement
> -----------------------------------------------
>
>                 Key: CALCITE-2663
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2663
>             Project: Calcite
>          Issue Type: Improvement
>          Components: server
>    Affects Versions: 1.16.0, 1.17.0
>            Reporter: ambition
>            Assignee: Julian Hyde
>            Priority: Minor
>             Fix For: 1.18.0
>
>
> support create function and drop function statement like apache hive:
> {code:java}
> CREATE [OR REPLACE] FUNCTION [IF NOT EXISTS] [db_name.]function_name AS 
> class_name
>   [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ];
> DROP FUNCTION [IF EXISTS] function_name; 
> {code}
>  
>  



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

Reply via email to