[
https://issues.apache.org/jira/browse/FLINK-7151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16926733#comment-16926733
]
Fabian Hueske commented on FLINK-7151:
--------------------------------------
Hi [~ZhenqiuHuang], thanks for sharing the proposal!
Just a few remarks:
* the proposal assumes that the client side (the one submitting the SQL / Table
API query) can access the external library. It would first be downloaded to the
client and from there shipped to the Flink master and from there distributed
via the blob service
* downloading external code (possibly from a public network) is a security
risk. We should probably add a switch to disable this feature.
* Do we need to think about how to load libraries (JARs) from external catalogs
(like Metastore) or is this is a separate discussion?
Thanks, Fabian
> Add a function SQL DDL
> ----------------------
>
> Key: FLINK-7151
> URL: https://issues.apache.org/jira/browse/FLINK-7151
> Project: Flink
> Issue Type: Sub-task
> Components: Table SQL / API
> Reporter: yuemeng
> Assignee: Shuyi Chen
> Priority: Critical
> Fix For: 1.10.0
>
>
> Based on create function and table.we can register a udf,udaf,udtf use sql:
> {code}
> CREATE FUNCTION [IF NOT EXISTS] [catalog_name.db_name.]function_name AS
> class_name [WITH (properties.....)];
> DROP FUNCTION [IF EXISTS] [catalog_name.db_name.]function_name;
> ALTER FUNCTION [IF EXISTS] [catalog_name.db_name.]function_name RENAME TO
> new_name;
> {code}
> {code}
> CREATE function 'TOPK' AS
> 'com.xxxx.aggregate.udaf.distinctUdaf.topk.ITopKUDAF';
> INSERT INTO db_sink SELECT id, TOPK(price, 5, 'DESC') FROM kafka_source GROUP
> BY id;
> {code}
> This ticket can assume that the function class is already loaded in classpath
> by users. Advanced syntax like to how to dynamically load udf libraries from
> external locations can be on a separate ticket.
--
This message was sent by Atlassian Jira
(v8.3.2#803003)
