[ 
https://issues.apache.org/jira/browse/CALCITE-1527?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15727791#comment-15727791
 ] 

Prasad V S commented on CALCITE-1527:
-------------------------------------

Imgetting below exception.

Exception in thread "main" java.sql.SQLException: Error while executing SQL 
"INSERT INTO "DevRelease_1.8_98.dbo"."survey" (
"id","name" ) values (1,'nameValue')": Node [rel#9:Subset#1.ENUMERABLE.[]] 
could not be implemented; planner state:

Root: rel#9:Subset#1.ENUMERABLE.[]
Original rel:

Sets:
Set#0, type: RecordType(INTEGER id, VARCHAR(30) name)
        rel#2:Subset#0.NONE.[], best=null, importance=0.81
                rel#0:LogicalValues.NONE.[[0, 1], [1]](type=RecordType(INTEGER 
id, VARCHAR(30) name),tuples=[{ 1, 'nameValue' }]), rowcount=1.0, cumulative 
cost={inf}
        rel#12:Subset#0.ENUMERABLE.[], best=rel#11, importance=0.405
                rel#11:EnumerableValues.ENUMERABLE.[[0, 1], 
[1]](type=RecordType(INTEGER id, VARCHAR(30) name),tuples=[{ 1, 'nameValue' 
}]), rowcount=1.0, cumulative cost={1.0 rows, 1.0 cpu, 0.0 io}
Set#1, type: RecordType(BIGINT ROWCOUNT)
        rel#4:Subset#1.NONE.[], best=null, importance=0.9
                
rel#3:LogicalTableModify.NONE.[](input=rel#2:Subset#0.NONE.[],table=[DevRelease_1.8_98.dbo,
 survey],operation=INSERT,updateColumnList=[],flattened=false), rowcount=1.0, 
cumulative cost={inf}
        rel#9:Subset#1.ENUMERABLE.[], best=null, importance=1.0
                
rel#10:AbstractConverter.ENUMERABLE.[](input=rel#4:Subset#1.NONE.[],convention=ENUMERABLE,sort=[]),
 rowcount=1.0, cumulative cost={inf}


        at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
        at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeLargeUpdate(AvaticaStatement.java:236)
        at 
org.apache.calcite.avatica.AvaticaStatement.executeUpdate(AvaticaStatement.java:231)
        at com.nanobi.calcite.CalciteMSSQL.main(CalciteMSSQL.java:133)
Caused by: org.apache.calcite.plan.RelOptPlanner$CannotPlanException: Node 
[rel#9:Subset#1.ENUMERABLE.[]] could not be implemented; planner state:


> Support DML in the JDBC adapter
> -------------------------------
>
>                 Key: CALCITE-1527
>                 URL: https://issues.apache.org/jira/browse/CALCITE-1527
>             Project: Calcite
>          Issue Type: Bug
>          Components: jdbc-adapter
>            Reporter: Christian Tzolov
>            Assignee: Julian Hyde
>
> Currently the JDBC adapter does not support the DML operations: *INSERT*, 
> *DELETE* and  *UPDATE*.
> Solution needs to convert the parsed *Modify* and *Values* RelNodes into 
> *JdbcTableModify*, *JdbcValues* ... such and then in turn into corresponding 
> SqlInsert, SqlUpdate and SqlDelete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to