[
https://issues.apache.org/jira/browse/FLINK-7145?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16081847#comment-16081847
]
yuemeng edited comment on FLINK-7145 at 7/11/17 8:20 AM:
---------------------------------------------------------
[~fhueske]
thanks a lot for reply.
some days ago, when i try to make flink udaf to support multiple parameters, i
match a problem
suppose we registered more than one function with same name topK to schema.
1)two function as follow with same name
Top10(INT,INT)
Top10(INT,DOUBLE)
2) execute sql
{code}
SELECT TUMBLE_END(rowtime, INTERVAL '10' MINUTE), top10(cnt, page) AS topPages
FROM pageVisits
GROUP BY TUMBLE(rowtime, INTERVAL '10' MINUTE);
{code}
suppose cnt is INT,page is Double,for now calcite can't find the exact
function.
3) you can check this pr
[https://issues.apache.org/jira/browse/CALCITE-1833]
was (Author: yuemeng):
[~fhueske]
thanks a lot for reply.
some days ago, when i try to make flink udaf to support multiple parameters, i
match a problem
suppose we registered more than one function with same name topK to schema.
1)two function as follow with same name
Top10(INT,INT)
Top10(INT,DOUBLE)
2) execute sql
{code}
SELECT TUMBLE_END(rowtime, INTERVAL '10' MINUTE), top10(cnt, page) AS topPages
FROM pageVisits
GROUP BY TUMBLE(rowtime, INTERVAL '10' MINUTE);
{code}
suppose cnt is INT,page is Double,for now calcite can't find the exact
function.
3) you can check this pr
[https://issues.apache.org/jira/browse/CALCITE-1833]
> Flink SQL API should support multiple parameters for UserDefinedAggFunction
> ---------------------------------------------------------------------------
>
> Key: FLINK-7145
> URL: https://issues.apache.org/jira/browse/FLINK-7145
> Project: Flink
> Issue Type: New Feature
> Components: Table API & SQL
> Reporter: yuemeng
> Priority: Critical
>
> UDAF such as topK and some other udaf with bloom filter need more than one
> parameters ,we should make flink sql support this.
> base on flink sql support DML and multiple parameters udaf,we can execute sql
> like:
> {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
(v6.4.14#64029)
