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