You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "yinhua.dai (JIRA)" <ji...@apache.org> on 2018/03/16 07:39:00 UTC

[jira] [Commented] (FLINK-7151) FLINK SQL support create temporary function and table

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

yinhua.dai commented on FLINK-7151:
-----------------------------------

[~yuemeng]

Any update on this functionality, I would like to do something similar.

> FLINK SQL support create temporary function and table
> -----------------------------------------------------
>
>                 Key: FLINK-7151
>                 URL: https://issues.apache.org/jira/browse/FLINK-7151
>             Project: Flink
>          Issue Type: New Feature
>          Components: Table API &amp; SQL
>            Reporter: yuemeng
>            Assignee: yuemeng
>            Priority: Major
>
> Based on create temporary function and table.we can register a udf,udaf,udtf use sql:
> {code}
> CREATE TEMPORARY 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 message was sent by Atlassian JIRA
(v7.6.3#76005)