[ https://issues.apache.org/jira/browse/PHOENIX-3674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15893133#comment-15893133 ]
Maryann Xue commented on PHOENIX-3674: -------------------------------------- I checked searched for this error in our latest jenkins build but did not find any. Could you please check if the problem has been fixed or is still there? > 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)