[
https://issues.apache.org/jira/browse/CALCITE-1882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
yuemeng updated CALCITE-1882:
-----------------------------
Description:
If we want to register a sum or avg aggregate function to deal with different
data type such as sum(double) ,we implement a SqlUserDefinedAggFunction and
register with name sum,but when we execute a sql like:
{code}
select id,sum(payment) from table test group by id
{code}
in fact,it always give the SqlSumAggFunction function which buidin by
calcite,never find the exactly function which we register by ourself.
was:
If we want to register a sum or avg aggregate function to deal with different
data type such as sum(double) ,we implement a SqlUserDefinedAggFunction and
register with name sum,but when we execute a sql like:
{code}
select id,sum(payment) from table test group by id
{/code}
in fact,it always give the SqlSumAggFunction function which buidin by
calcite,never find the exactly function which we register by ourself.
> Can't obtain the user defined aggregate function such as sum,avg by calcite
> ---------------------------------------------------------------------------
>
> Key: CALCITE-1882
> URL: https://issues.apache.org/jira/browse/CALCITE-1882
> Project: Calcite
> Issue Type: Bug
> Affects Versions: 1.12.0
> Reporter: yuemeng
> Assignee: yuemeng
> Priority: Critical
>
> If we want to register a sum or avg aggregate function to deal with different
> data type such as sum(double) ,we implement a SqlUserDefinedAggFunction and
> register with name sum,but when we execute a sql like:
> {code}
> select id,sum(payment) from table test group by id
> {code}
> in fact,it always give the SqlSumAggFunction function which buidin by
> calcite,never find the exactly function which we register by ourself.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
