[
https://issues.apache.org/jira/browse/BEAM-8075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17547881#comment-17547881
]
Kenneth Knowles commented on BEAM-8075:
---------------------------------------
This issue has been migrated to https://github.com/apache/beam/issues/19592
> IndexOutOfBounds in LogicalProject
> ----------------------------------
>
> Key: BEAM-8075
> URL: https://issues.apache.org/jira/browse/BEAM-8075
> Project: Beam
> Issue Type: Improvement
> Components: dsl-sql-zetasql
> Reporter: Rui Wang
> Priority: P3
>
> {code}
> SELECT payload.bankId,
> SUM(payload.purchaseAmountCents) / 100 AS totalPurchase
> FROM pubsub.topic.`instant-insights`.`retaildemo-online-transactions-json`
> GROUP BY payload.bankId
> {code}
> Causes the workers to fail with:
> {code}
> Exception in thread "main" java.lang.RuntimeException: Error while applying
> rule ProjectToCalcRule, args
> [rel#9:LogicalProject.NONE(input=RelSubset#8,bankId=$0,totalPurchase=/(CAST($3):DOUBLE
> NOT NULL, 1E2))]
> at org.apache
> {code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
