[jira] [Updated] (BEAM-8075) IndexOutOfBounds in LogicalProject

2020-06-01 Thread Beam JIRA Bot (Jira) 


 [ 
https://issues.apache.org/jira/browse/BEAM-8075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Beam JIRA Bot updated BEAM-8075:

Labels: stale-P2  (was: )

> 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: P2
>  Labels: stale-P2
>
> {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.4#803005)

[jira] [Updated] (BEAM-8075) IndexOutOfBounds in LogicalProject

2019-08-27 Thread Jira 


 [ 
https://issues.apache.org/jira/browse/BEAM-8075?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Ismaël Mejía updated BEAM-8075:
---
Status: Open  (was: Triage Needed)

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

[jira] [Updated] (BEAM-8075) IndexOutOfBounds in LogicalProject

2019-08-23 Thread Gleb Kanterov (Jira) 


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