[
https://issues.apache.org/jira/browse/CALCITE-1528?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Prasad V S updated CALCITE-1528:
--------------------------------
Comment: was deleted
(was: 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.executeQuery(AvaticaStatement.java:218)
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:
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.plan.volcano.RelSubset$CheapestPlanReplacer.visit(RelSubset.java:443)
at
org.apache.calcite.plan.volcano.RelSubset.buildCheapestPlan(RelSubset.java:293)
at
org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:819)
at org.apache.calcite.tools.Programs$5.run(Programs.java:300)
at
org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:351)
at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:155)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:286)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:195)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:737)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:600)
at
org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:570)
at
org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:215)
at
org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:594)
at
org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:615)
at
org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:148)
... 2 more
)
> Not able to insert into Database table
> ---------------------------------------
>
> Key: CALCITE-1528
> URL: https://issues.apache.org/jira/browse/CALCITE-1528
> Project: Calcite
> Issue Type: Bug
> Components: jdbc-adapter
> Reporter: Prasad V S
> Assignee: Julian Hyde
>
> Im getting 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:
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
