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

Julian Hyde commented on CALCITE-2046:
--------------------------------------

Maybe we don't need JAR or JARS. Following 
[Vertica|https://my.vertica.com/docs/7.2.x/HTML/index.htm#Authoring/SQLReferenceManual/Statements/CREATELIBRARY.htm],
 let's have:

{code}CREATE [OR REPLACE] LIBRARY 
    [schema.]library-name 
    AS 'library-path'
    [ DEPENDS 'support-path'  [, 'support-path' ]* ]
    [ LANGUAGE 'language' ]{code}

(as Vertica, but allowing more than one support path) for example:

{code}CREATE OR REPLACE mySchema.myLib
  AS '/foo/myLib.jar'
  DEPENDS '/foo/guava-23.0.jar', '/foo/jackson-2.9.jar'
  LANGUAGE 'Java'{code}

> Support "CREATE FUNCTION" DDL
> -----------------------------
>
>                 Key: CALCITE-2046
>                 URL: https://issues.apache.org/jira/browse/CALCITE-2046
>             Project: Calcite
>          Issue Type: New Feature
>            Reporter: Shuyi Chen
>            Assignee: Shuyi Chen
>            Priority: Major
>
> We want to add DDL support for creating external function like Apache Drill 
> ([https://drill.apache.org/docs/create-function-using-jar/]). 
> {code:java}
> CREATE FUNCTION USING JAR '<jar_name>.jar';
> {code}



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

Reply via email to