[
https://issues.apache.org/jira/browse/CALCITE-2046?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16275138#comment-16275138
]
Julian Hyde commented on CALCITE-2046:
--------------------------------------
The functionality in {{CREATE FUNCTION USING JAR}} is reasonable but it's not
the syntax I would have chosen - because it creates lots of functions, not one.
Are there other DBs besides Drill that allow you to import functions (or other
plug-ins) from a JAR, and if so, what syntax do they use?
Also, how would you propose to implement this? Would you use a class-loader
which reads from a modified class-path, or would you copy from the jar into the
existing class-path?
How would Calcite scan the JAR file to find UDFs? Is some kind of manifest
required in the JAR file?
> 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: Julian Hyde
>
> 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
(v6.4.14#64029)
