[
https://issues.apache.org/jira/browse/BEAM-10459?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17189710#comment-17189710
]
Robin Qiu commented on BEAM-10459:
----------------------------------
The type mismatch might come from how the Calcite SUM operator
(SqlStdOperatorTable.SUM) infer its return type:
https://github.com/apache/calcite/blob/88d18185e6177c9df587bdd23dd4049f59adc2e4/core/src/main/java/org/apache/calcite/sql/type/ReturnTypes.java#L846
> Support ZetaSQL aggregate functions for NUMERIC type
> ----------------------------------------------------
>
> Key: BEAM-10459
> URL: https://issues.apache.org/jira/browse/BEAM-10459
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql-zetasql
> Reporter: Zijie Song
> Assignee: Robin Qiu
> Priority: P2
>
> Currently, Sum and Avg are not supported for ZetaSQL NUMERIC type due to type
> mismatch.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
