[ https://issues.apache.org/jira/browse/BEAM-8075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gleb Kanterov updated BEAM-8075: -------------------------------- Description: {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} was: SELECT payload.bankId, SUM(payload.purchaseAmountCents) / 100 AS totalPurchase FROM pubsub.topic.`instant-insights`.`retaildemo-online-transactions-json` GROUP BY payload.bankId Causes the workers to fail with: 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 > IndexOutOfBounds in LogicalProject > ---------------------------------- > > Key: BEAM-8075 > URL: https://issues.apache.org/jira/browse/BEAM-8075 > Project: Beam > Issue Type: Sub-task > Components: dsl-sql-zetasql > Reporter: Rui Wang > Priority: Major > > {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.3.2#803003)