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