You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@calcite.apache.org by xiaobo <gu...@qq.com.INVALID> on 2022/03/14 00:47:15 UTC
applying the wrong rule for calculated columns
@Test
public void test1_2()throws SQLException{
Map<String, List<JSONObject>> map = makeJsonMap();
Schema schema = new JsonSchema<>("js", map);
CalciteConnection conn = this.openConn1(schema, "js");
System.out.println("c1 + c11 = " + exeGetLong(conn, "select c1 + c11 from js.t1"));
conn.close();
}
For the above simple calculated sql, calcite throws the following error, it seems calcite refers to our Table class to return data type information for c1 + c11, which we think calcite should infer itself.
calcite calls deriveRowType() of our JsonTableScan class with field [EXPR$0] which is not a field of our table.
test1_2(org.apache.calcite.adapter.json.test.JsonSchemaTest) Time elapsed: 0.039 sec <<< ERROR!
java.sql.SQLException: Error while executing SQL "select c1 + c11 from js.t1": Error while applying rule JsonProjectTableScanRule, args [rel#498:LogicalProject.NONE.[](input=RelSubset#497,exprs=[+($9, $3)]), rel#488:JsonTableScan.ENUMERABLE.[](table=[js, t1])]
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:163)
at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:227)
at org.apache.calcite.adapter.json.test.BaseTest.exeGetLong(BaseTest.java:37)
at org.apache.calcite.adapter.json.test.JsonSchemaTest.test1_2(JsonSchemaTest.java:76)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:59)
at org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12)
at org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:56)
at org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.BlockJUnit4ClassRunner$1.evaluate(BlockJUnit4ClassRunner.java:100)
at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:366)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:103)
at org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:63)
at org.junit.runners.ParentRunner$4.run(ParentRunner.java:331)
at org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:79)
at org.junit.runners.ParentRunner.runChildren(ParentRunner.java:329)
at org.junit.runners.ParentRunner.access$100(ParentRunner.java:66)
at org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:293)
at org.junit.runners.ParentRunner$3.evaluate(ParentRunner.java:306)
at org.junit.runners.ParentRunner.run(ParentRunner.java:413)
at org.apache.maven.surefire.junit4.JUnit4Provider.execute(JUnit4Provider.java:252)
at org.apache.maven.surefire.junit4.JUnit4Provider.executeTestSet(JUnit4Provider.java:141)
at org.apache.maven.surefire.junit4.JUnit4Provider.invoke(JUnit4Provider.java:112)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.apache.maven.surefire.util.ReflectionUtils.invokeMethodWithArray(ReflectionUtils.java:189)
at org.apache.maven.surefire.booter.ProviderFactory$ProviderProxy.invoke(ProviderFactory.java:165)
at org.apache.maven.surefire.booter.ProviderFactory.invokeProvider(ProviderFactory.java:85)
at org.apache.maven.surefire.booter.ForkedBooter.runSuitesInProcess(ForkedBooter.java:115)
at org.apache.maven.surefire.booter.ForkedBooter.main(ForkedBooter.java:75)
Caused by: java.lang.RuntimeException: Error while applying rule JsonProjectTableScanRule, args [rel#498:LogicalProject.NONE.[](input=RelSubset#497,exprs=[+($9, $3)]), rel#488:JsonTableScan.ENUMERABLE.[](table=[js, t1])]
at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:250)
at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:59)
at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:523)
at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:276)
at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:336)
at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:177)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:312)
at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:647)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:513)
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:483)
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:249)
at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:623)
at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:674)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:156)
... 35 more
Caused by: java.lang.RuntimeException: Error occurred while applying rule JsonProjectTableScanRule
at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:157)
at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:269)
at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:284)
at org.apache.calcite.adapter.json.JsonProjectTableScanRule.onMatch(JsonProjectTableScanRule.java:80)
at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223)
... 49 more
Caused by: java.lang.NullPointerException
at org.apache.calcite.rel.type.RelDataTypeFactory$Builder.add(RelDataTypeFactory.java:533)
at org.apache.calcite.rel.type.RelDataTypeFactory$FieldInfoBuilder.add(RelDataTypeFactory.java:403)
at org.apache.calcite.rel.type.RelDataTypeFactory$FieldInfoBuilder.add(RelDataTypeFactory.java:367)
at org.apache.calcite.adapter.json.JsonTableScan.lambda$0(JsonTableScan.java:42)
at java.base/java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948)
at java.base/java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658)
at org.apache.calcite.adapter.json.JsonTableScan.deriveRowType(JsonTableScan.java:42)
at org.apache.calcite.rel.AbstractRelNode.getRowType(AbstractRelNode.java:173)
at org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:587)
at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:613)
at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:144)
... 53 more
re：applying the wrong rule for calculated columns
Posted by xiaobo <gu...@qq.com.INVALID>.
our runnable test is at https://github.com/guxiaobo/calcite-json-adapter/blob/main/src/test/java/org/apache/calcite/adapter/json/test/JsonSchemaTest.java
------------------ original mail ------------------
@Test
public void test1_2()throws SQLException{
Map<string, list<jsonobject="">> map = makeJsonMap();
Schema schema = new JsonSchema<>("js", map);
CalciteConnection conn = this.openConn1(schema, "js");
System.out.println("c1 + c11 = " + exeGetLong(conn, "select c1 + c11 from js.t1"));
conn.close();
}
For the above simple calculated sql, calcite throws the following error, it seems calcite refers to our Table class to return data type information for c1 + c11, which we think calcite should infer itself. calcite calls deriveRowType() of our JsonTableScan class with field [EXPR$0] which is not a field of ourtable.test1_2(org.apache.calcite.adapter.json.test.JsonSchemaTest)
Error while preparing plan [LogicalProject(EXPR$0=[+($1, $0)])
JsonTableScan(table=[[vars, vars]])
]
at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:65) ~[classes/:?]
at com.xsmartware.pbcm.thread.VarGenThread.doCompute(VarGenThread.java:24) ~[classes/:?]
at com.xsmartware.pbcm.thread.VarGenThread.doCompute(VarGenThread.java:10) ~[classes/:?]
at com.xsmartware.pbcm.thread.PBCMBaseThread.run(PBCMBaseThread.java:38) [classes/:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:834) [?:?]
Caused by: java.sql.SQLException: Error while preparing plan [LogicalProject(EXPR$0=[+($1, $0)])
JsonTableScan(table=[[vars, vars]])
]
at org.apache.calcite.avatica.Helper.createException(Helper.java:56) ~[avatica-core-1.20.0.jar:1.20.0]
at org.apache.calcite.avatica.Helper.createException(Helper.java:41) ~[avatica-core-1.20.0.jar:1.20.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:239) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.access$100(CalciteConnectionImpl.java:101) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl$2.prepareStatement(CalciteConnectionImpl.java:188) ~[calcite-core-1.29.0.jar:1.29.0]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:109) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:103) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:138) ~[classes/:?]
at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:43) ~[classes/:?]
... 8 more
Caused by: java.lang.RuntimeException: Error while applying rule JsonProjectTableScanRule, args [rel#500:LogicalProject.NONE.[](input=RelSubset#499,exprs=[+($1, $0)]), rel#494:JsonTableScan.ENUMERABLE.[](table=[vars, vars])]
at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:250) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:59) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:523) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:276) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:336) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:177) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.prepare_(CalcitePrepareImpl.java:1026) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.prepareRel(CalcitePrepareImpl.java:988) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:668) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:513) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:483) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:249) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:229) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.access$100(CalciteConnectionImpl.java:101) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl$2.prepareStatement(CalciteConnectionImpl.java:188) ~[calcite-core-1.29.0.jar:1.29.0]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:109) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:103) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:138) ~[classes/:?]
at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:43) ~[classes/:?]
... 8 more
Caused by: java.lang.RuntimeException: Error occurred while applying rule JsonProjectTableScanRule
at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:157) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:269) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:284) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.adapter.json.JsonProjectTableScanRule.onMatch(JsonProjectTableScanRule.java:80) ~[classes/:?]
at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:59) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:523) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:276) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:336) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:177) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.prepare_(CalcitePrepareImpl.java:1026) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.prepareRel(CalcitePrepareImpl.java:988) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:668) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:513) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:483) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:249) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:229) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.access$100(CalciteConnectionImpl.java:101) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl$2.prepareStatement(CalciteConnectionImpl.java:188) ~[calcite-core-1.29.0.jar:1.29.0]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:109) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:103) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:138) ~[classes/:?]
at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:43) ~[classes/:?]
... 8 more
Caused by: java.lang.NullPointerException
at org.apache.calcite.rel.type.RelDataTypeFactory$Builder.add(RelDataTypeFactory.java:533) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.rel.type.RelDataTypeFactory$FieldInfoBuilder.add(RelDataTypeFactory.java:403) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.rel.type.RelDataTypeFactory$FieldInfoBuilder.add(RelDataTypeFactory.java:367) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.adapter.json.JsonTableScan.lambda$0(JsonTableScan.java:42) ~[classes/:?]
at java.util.Spliterators$ArraySpliterator.forEachRemaining(Spliterators.java:948) ~[?:?]
at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:658) ~[?:?]
at org.apache.calcite.adapter.json.JsonTableScan.deriveRowType(JsonTableScan.java:42) ~[classes/:?]
at org.apache.calcite.rel.AbstractRelNode.getRowType(AbstractRelNode.java:173) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.VolcanoPlanner.register(VolcanoPlanner.java:587) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.VolcanoPlanner.ensureRegistered(VolcanoPlanner.java:613) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.VolcanoRuleCall.transformTo(VolcanoRuleCall.java:144) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:269) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.RelOptRuleCall.transformTo(RelOptRuleCall.java:284) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.adapter.json.JsonProjectTableScanRule.onMatch(JsonProjectTableScanRule.java:80) ~[classes/:?]
at org.apache.calcite.plan.volcano.VolcanoRuleCall.onMatch(VolcanoRuleCall.java:223) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.IterativeRuleDriver.drive(IterativeRuleDriver.java:59) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.plan.volcano.VolcanoPlanner.findBestExp(VolcanoPlanner.java:523) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.tools.Programs.lambda$standard$3(Programs.java:276) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.tools.Programs$SequenceProgram.run(Programs.java:336) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.Prepare.optimize(Prepare.java:177) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.prepare_(CalcitePrepareImpl.java:1026) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.prepareRel(CalcitePrepareImpl.java:988) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:668) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:513) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:483) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:249) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:229) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl.access$100(CalciteConnectionImpl.java:101) ~[calcite-core-1.29.0.jar:1.29.0]
at org.apache.calcite.jdbc.CalciteConnectionImpl$2.prepareStatement(CalciteConnectionImpl.java:188) ~[calcite-core-1.29.0.jar:1.29.0]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:109) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.executeQuery(CalciteDatabase.java:103) ~[classes/:?]
at com.xsmartware.common.calcite.CalciteDatabase.exeGetLong(CalciteDatabase.java:138) ~[classes/:?]
at com.xsmartware.pbcm.policy.CalciteBasedVarGenerator.generateVariable(CalciteBasedVarGenerator.java:43) ~[classes/:?]
... 8 more</string,>