[ https://issues.apache.org/jira/browse/CALCITE-2663?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16683546#comment-16683546 ]
ambition commented on CALCITE-2663: ----------------------------------- Read view comments, I can support "CREATE FUNCTION" and "DROP FUNCTION" statement. Our online apache flink( uses the calcite SQL engine ) environment has stabilized the operation of this SQL syntax. File URI by URLClassLoader.loadClass(class_name) operator. I can try to modify code that accord to the comment requirements. > CREATE FUNCTION SQL statement > ----------------------------- > > Key: CALCITE-2663 > URL: https://issues.apache.org/jira/browse/CALCITE-2663 > Project: Calcite > Issue Type: Improvement > Components: core > Affects Versions: 1.16.0, 1.17.0 > Reporter: ambition > Assignee: Julian Hyde > Priority: Minor > Fix For: 1.16.0, 1.17.0 > > > support create function statement like hive: > > > {code:java} > CREATE FUNCTION [db_name.]function_name AS class_name > [USING JAR|FILE|ARCHIVE 'file_uri' [, JAR|FILE|ARCHIVE 'file_uri'] ]; > {code} > > -- This message was sent by Atlassian JIRA (v7.6.3#76005)