You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Robin Qiu (Jira)" <ji...@apache.org> on 2020/09/02 21:10:00 UTC

[jira] [Commented] (BEAM-10459) Support ZetaSQL aggregate functions for NUMERIC type

    [ 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)