[
https://issues.apache.org/jira/browse/FLINK-7151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16944599#comment-16944599
]
Zhenqiu Huang commented on FLINK-7151:
--------------------------------------
[~twalthr]
Thanks for bringing this up. I join the discussion on FLIP-69, and also aligned
with [~Terry1897] to put this effort into FLIP-69. Basically, Terry and I will
cooperate on the Flink SQL DDL Enhancement. For the concern of handling type
extraction in Scala and Java API, I am sorry that I am indeed not aware of
this. I agree to disable CREATE FUNCTION syntax for Scala table environments as
a temporary solution. We can revisit it after FLIP-57 solution is finalized.
How do you think?
[~suez1224] [~danny0405][~phoenixjiangnan]
> Add a basic 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: Zhenqiu Huang
> Priority: Critical
> Labels: pull-request-available
> Fix For: 1.10.0
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> 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;
> 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.4#803005)
