You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Yu Li (Jira)" <ji...@apache.org> on 2019/12/10 07:53:00 UTC

[jira] [Updated] (FLINK-7151) Support function DDL

     [ https://issues.apache.org/jira/browse/FLINK-7151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yu Li updated FLINK-7151:
-------------------------
    Fix Version/s:     (was: 1.10.0)
                   1.11.0

Change the fix version to 1.11.0 since we already reached feature freeze for 1.10.0.

On the other hand, since many sub-tasks have been completed, can we call this a "preview" feature for 1.10.0? If so, could you supply some documentation about where we are now and what's missing? [~ZhenqiuHuang] [~phoenixjiangnan] Thanks.

> Support function DDL
> --------------------
>
>                 Key: FLINK-7151
>                 URL: https://issues.apache.org/jira/browse/FLINK-7151
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table SQL / API
>            Reporter: yuemeng
>            Assignee: Zhenqiu Huang
>            Priority: Critical
>              Labels: pull-request-available
>             Fix For: 1.11.0
>
>          Time Spent: 0.5h
>  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)