[
https://issues.apache.org/jira/browse/BEAM-12100?focusedWorklogId=623153&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-623153
]
ASF GitHub Bot logged work on BEAM-12100:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 15/Jul/21 16:20
Start Date: 15/Jul/21 16:20
Worklog Time Spent: 10m
Work Description: benWize commented on pull request #15174:
URL: https://github.com/apache/beam/pull/15174#issuecomment-880835480
Hi @ibzib, I am working on a group of related issues using some of your work
in #14392. Could you help me to take a look at the progress so far and provide
some guidance on the next steps?
I am planning to include
[BEAM-12098](https://issues.apache.org/jira/browse/BEAM-12098) and
[BEAM-12099](https://issues.apache.org/jira/browse/BEAM-12099) in this PR, but
for those, I have a problem, in the transformation related to UNNEST, when it
receives an empty array, does not return anything so it fails before
aggregation transforms (COUNT, BIT_OR).
I think the problem could be in this part
https://github.com/apache/beam/blob/master/sdks/java/extensions/sql/zetasql/src/main/java/org/apache/beam/sdk/extensions/sql/zetasql/unnest/BeamZetaSqlUncollectRel.java#L115
because when the array is empty, this transform does not output anything.
Any guidance on this would be appreciated.
Thanks!
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 623153)
Time Spent: 20m (was: 10m)
> SUM should error when overflow/underflow occurs.
> ------------------------------------------------
>
> Key: BEAM-12100
> URL: https://issues.apache.org/jira/browse/BEAM-12100
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql-zetasql
> Reporter: Kyle Weaver
> Assignee: Benjamin Gonzalez
> Priority: P3
> Time Spent: 20m
> Remaining Estimate: 0h
>
> SELECT SUM(col1) FROM (SELECT CAST(9223372036854775807 as int64) as col1
> UNION ALL SELECT CAST(1 as int64))
> should return an error.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
