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/22 17:41:00 UTC

[jira] [Commented] (BEAM-10915) AVG(INT64) suggests using DOUBLE, which isn't a supported type.

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

Robin Qiu commented on BEAM-10915:
----------------------------------

YES I think LONG should be INT64, but I believe DOUBLE is ok to use (it is a valid alias for FLOAT64)

> AVG(INT64) suggests using DOUBLE, which isn't a supported type.
> ---------------------------------------------------------------
>
>                 Key: BEAM-10915
>                 URL: https://issues.apache.org/jira/browse/BEAM-10915
>             Project: Beam
>          Issue Type: Bug
>          Components: dsl-sql-zetasql
>            Reporter: Kyle Weaver
>            Assignee: Kyle Weaver
>            Priority: P2
>          Time Spent: 40m
>  Remaining Estimate: 0h
>
> I tried averaging an INT64 field, and got this error message:
> "AVG(LONG) is not supported. You might want to use AVG(CAST(expression AS DOUBLE)."
> LONG should be INT64, and DOUBLE should be FLOAT64.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)