phoenix-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rajeshbabu Chintaguntla (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PHOENIX-3674) Upsert or Delele queries failing to translate LogicalTableModify into MutableRel in Phoenix-Calcite
Date Wed, 15 Feb 2017 08:07:42 GMT

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

Rajeshbabu Chintaguntla updated PHOENIX-3674:
---------------------------------------------
    Attachment: PHOENIX-3674.patch

Here is the patch skips to get materialized views in case of table updates like upsert, delete
cases. 
[~maryannxue] Is this patch fine? 
There are around 70 tests failing with the issue.

> Upsert or Delele queries failing to translate LogicalTableModify into MutableRel in Phoenix-Calcite

> ----------------------------------------------------------------------------------------------------
>
>                 Key: PHOENIX-3674
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-3674
>             Project: Phoenix
>          Issue Type: Sub-task
>            Reporter: Rajeshbabu Chintaguntla
>            Assignee: Rajeshbabu Chintaguntla
>              Labels: calcite
>         Attachments: PHOENIX-3674.patch
>
>
> Here are the tests failing 
> {noformat}
> testDeleteAllFromTableWithLocalIndexNoAutoCommitSalted(org.apache.phoenix.end2end.DeleteIT)
 Time elapsed: 8.99 sec  <<< ERROR!
> java.sql.SQLException: Error while executing SQL "DELETE FROM T000139": cannot translate
rel#7748:LogicalTableModify.NONE.[](input=rel#7735:PhoenixTableScan.SERVER.[](table=[phoenix,
T000139]),table=[phoenix, T000139],operation=DELETE,flattened=false) to MutableRel
> 	at org.apache.phoenix.end2end.DeleteIT.testDeleteAllFromTableWithIndex(DeleteIT.java:332)
> 	at org.apache.phoenix.end2end.DeleteIT.testDeleteAllFromTableWithLocalIndexNoAutoCommitSalted(DeleteIT.java:283)
> Caused by: java.lang.RuntimeException: cannot translate rel#7748:LogicalTableModify.NONE.[](input=rel#7735:PhoenixTableScan.SERVER.[](table=[phoenix,
T000139]),table=[phoenix, T000139],operation=DELETE,flattened=false) to MutableRel
> 	at org.apache.phoenix.end2end.DeleteIT.testDeleteAllFromTableWithIndex(DeleteIT.java:332)
> 	at org.apache.phoenix.end2end.DeleteIT.testDeleteAllFromTableWithLocalIndexNoAutoCommitSalted(DeleteIT.java:283)
> {noformat}
> {noformat}
> java.sql.SQLException: Error while executing SQL "UPSERT INTO atable(organization_id,entity_id,a_integer)
SELECT organization_id, entity_id, CAST(null AS integer) FROM atable": cannot translate rel#25411:LogicalTableModify.NONE.[](input=rel#25415:LogicalProject.NONE.[](input=rel#25389:PhoenixTableScan.SERVER.[](table=[phoenix,
ATABLE]),ORGANIZATION_ID=$0,ENTITY_ID=$1,A_STRING=null,B_STRING=null,A_INTEGER=null,A_DATE=null,A_TIME=null,A_TIMESTAMP=null,X_DECIMAL=null,X_LONG=null,X_INTEGER=null,Y_INTEGER=null,A_BYTE=null,A_SHORT=null,A_FLOAT=null,A_DOUBLE=null,A_UNSIGNED_FLOAT=null,A_UNSIGNED_DOUBLE=null),table=[phoenix,
ATABLE],operation=INSERT,flattened=false) to MutableRel
> 	at org.apache.phoenix.end2end.AggregateQueryIT.testSumOverNullIntegerColumn(AggregateQueryIT.java:80)
> Caused by: java.lang.RuntimeException: cannot translate rel#25411:LogicalTableModify.NONE.[](input=rel#25415:LogicalProject.NONE.[](input=rel#25389:PhoenixTableScan.SERVER.[](table=[phoenix,
ATABLE]),ORGANIZATION_ID=$0,ENTITY_ID=$1,A_STRING=null,B_STRING=null,A_INTEGER=null,A_DATE=null,A_TIME=null,A_TIMESTAMP=null,X_DECIMAL=null,X_LONG=null,X_INTEGER=null,Y_INTEGER=null,A_BYTE=null,A_SHORT=null,A_FLOAT=null,A_DOUBLE=null,A_UNSIGNED_FLOAT=null,A_UNSIGNED_DOUBLE=null),table=[phoenix,
ATABLE],operation=INSERT,flattened=false) to MutableRel
> 	at org.apache.phoenix.end2end.AggregateQueryIT.testSumOverNullIntegerColumn(AggregateQueryIT.java:80)
> {noformat}



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Mime
View raw message