[ https://issues.apache.org/jira/browse/CALCITE-3624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17002675#comment-17002675 ]
anjali shrishrimal edited comment on CALCITE-3624 at 12/24/19 6:03 AM: ----------------------------------------------------------------------- {code:java} public static Frameworks.ConfigBuilder config() { CalciteSchema rootSchema1 = CalciteSchema.createRootSchema(true); rootSchema1.add("ITEM", new MySchema()); /* MySchema consists of Map of MyTable which extends AbstractQueryableTable and implements TranslatableTable */ return Frameworks.newConfigBuilder().defaultSchema(rootSchema1.plus()); } {code} {code:java} @Test public void testRun() throws Exception { FrameworkConfig frameworkConfig = config().build(); final RelBuilder builder = RelBuilder.create(frameworkConfig); String[] name = new String[]{"ITEM", "ITEM"}; RelNode scan = builder.scan(name).build(); TranslatableTable items = (TranslatableTable) frameworkConfig.getDefaultSchema().getSubSchema("ITEM").getTable("ITEM"); scan = items.toRel(ViewExpanders.simpleContext(scan.getCluster()), scan.getTable()); RelNode level0RelNode = builder.push(scan) .filter(builder.call(SqlStdOperatorTable.AND, builder.call(SqlStdOperatorTable.EQUALS, builder.field("ITEM_ID"), builder.literal("AM_TestItem_21Aug17_0614")), builder.call(SqlStdOperatorTable.EQUALS, builder.field("OBJECT_TYPE"), builder.literal("Item")))) .build(); try (PreparedStatement preparedStatement = RelRunners.run(level0RelNode)) { System.out.println(preparedStatement.toString()); String s = CalciteAssert.toString(preparedStatement.executeQuery()); System.out.println(s); } } {code} was (Author: anjalishrishrimal): {code:java} public static Frameworks.ConfigBuilder config() { CalciteSchema rootSchema1 = CalciteSchema.createRootSchema(true); rootSchema1.add("ITEM", new MySchema()); /* MySchema consists of Map of MyTable which extends AbstractQueryableTable and implements TranslatableTable */ return Frameworks.newConfigBuilder().defaultSchema(rootSchema1.plus()); } {code} {code:java} @Test public void testRun() throws Exception { FrameworkConfig frameworkConfig = config().build(); final RelBuilder builder = RelBuilder.create(frameworkConfig); String[] name = new String[]\{"ITEM", "ITEM"}; RelNode scan = builder.scan(name).build(); TranslatableTable items = (TranslatableTable) frameworkConfig.getDefaultSchema().getSubSchema("ITEM").getTable("ITEM"); scan = items.toRel(ViewExpanders.simpleContext(scan.getCluster()), scan.getTable()); RelNode level0RelNode = builder.push(scan) .filter(builder.call(SqlStdOperatorTable.AND, builder.call(SqlStdOperatorTable.EQUALS, builder.field("ITEM_ID"), builder.literal("AM_TestItem_21Aug17_0614")), builder.call(SqlStdOperatorTable.EQUALS, builder.field("OBJECT_TYPE"), builder.literal("Item")))) .build(); try (PreparedStatement preparedStatement = RelRunners.run(level0RelNode)) { System.out.println(preparedStatement.toString()); String s = CalciteAssert.toString(preparedStatement.executeQuery()); System.out.println(s); } } {code} > Getting java.lang.NullPointerException at > org.apache.calcite.schema.Schemas.queryable(Schemas.java:211) > ------------------------------------------------------------------------------------------------------- > > Key: CALCITE-3624 > URL: https://issues.apache.org/jira/browse/CALCITE-3624 > Project: Calcite > Issue Type: Bug > Reporter: anjali shrishrimal > Priority: Minor > > I am creating a RelNode using RelBuilder. > > @Test > public void testRun() throws Exception > { > FrameworkConfig frameworkConfig = config().build(); > final RelBuilder builder = RelBuilder.create(frameworkConfig); > String[] name = new String[]\{"ITEM", "ITEM"}; > RelNode scan = builder.scan(name).build(); > TranslatableTable items = > (TranslatableTable)frameworkConfig.getDefaultSchema().getSubSchema("ITEM").getTable("ITEM"); > scan = items.toRel(ViewExpanders.simpleContext(scan.getCluster()), > scan.getTable()); > > RelNode level0RelNode = > builder.push(scan) > .filter( > builder.call(SqlStdOperatorTable.AND, > builder.call(SqlStdOperatorTable.EQUALS, builder.field("ITEM_ID"), > builder.literal("AM_TestItem_21Aug17_0614")), > builder.call(SqlStdOperatorTable.EQUALS, builder.field("OBJECT_TYPE"), > builder.literal("Item")) > ) > ).build(); > > System.out.println(level0RelNode); > try (PreparedStatement preparedStatement = RelRunners.run(level0RelNode)) > { System.out.println("------------------------"); > System.out.println(preparedStatement.toString()); > System.out.println("------------------------"); > String s = CalciteAssert.toString(preparedStatement.executeQuery()); > System.out.println("------------------------"); > System.out.println(s); > } > } > > > public static Frameworks.ConfigBuilder config() > { > CalciteSchema rootSchema1 = CalciteSchema.createRootSchema(true); > rootSchema1 = rootSchema1.add("ITEM", new MySchema()); > /* MySchema consists of Map of MyTable which extends AbstractQueryableTable > and implements TranslatableTable */ > > return Frameworks.newConfigBuilder().defaultSchema(rootSchema1.plus()); > } > > > I am getting following exception while executing a query. > > java.sql.SQLException: exception while executing query: > nulljava.sql.SQLException: exception while executing query: null 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.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:577) > at > org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:137) > at org.apache.calcite.test.TeamcenterTest.testRun2(TeamcenterTest.java:372) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:498) at > org.junit.runners.model.FrameworkMethod$1.runReflectiveCall(FrameworkMethod.java:50) > at > org.junit.internal.runners.model.ReflectiveCallable.run(ReflectiveCallable.java:12) > at > org.junit.runners.model.FrameworkMethod.invokeExplosively(FrameworkMethod.java:47) > at > org.junit.internal.runners.statements.InvokeMethod.evaluate(InvokeMethod.java:17) > at org.junit.runners.ParentRunner.runLeaf(ParentRunner.java:325) at > org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:78) > at > org.junit.runners.BlockJUnit4ClassRunner.runChild(BlockJUnit4ClassRunner.java:57) > at org.junit.runners.ParentRunner$3.run(ParentRunner.java:290) at > org.junit.runners.ParentRunner$1.schedule(ParentRunner.java:71) at > org.junit.runners.ParentRunner.runChildren(ParentRunner.java:288) at > org.junit.runners.ParentRunner.access$000(ParentRunner.java:58) at > org.junit.runners.ParentRunner$2.evaluate(ParentRunner.java:268) at > org.junit.runners.ParentRunner.run(ParentRunner.java:363) at > org.eclipse.jdt.internal.junit4.runner.JUnit4TestReference.run(JUnit4TestReference.java:86) > at > org.eclipse.jdt.internal.junit.runner.TestExecution.run(TestExecution.java:38) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:539) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.runTests(RemoteTestRunner.java:761) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.run(RemoteTestRunner.java:461) > at > org.eclipse.jdt.internal.junit.runner.RemoteTestRunner.main(RemoteTestRunner.java:207)Caused > by: java.lang.NullPointerException at > org.apache.calcite.schema.Schemas.queryable(Schemas.java:211) at > Baz.bind(Unknown Source) at > org.apache.calcite.jdbc.CalcitePrepare$CalciteSignature.enumerable(CalcitePrepare.java:355) > at > org.apache.calcite.jdbc.CalciteConnectionImpl.enumerable(CalciteConnectionImpl.java:316) > at > org.apache.calcite.jdbc.CalciteMetaImpl._createIterable(CalciteMetaImpl.java:506) > at > org.apache.calcite.jdbc.CalciteMetaImpl.createIterable(CalciteMetaImpl.java:497) > at > org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:182) > at > org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:64) at > org.apache.calcite.jdbc.CalciteResultSet.execute(CalciteResultSet.java:43) at > org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:573) > ... 25 more -- This message was sent by Atlassian Jira (v8.3.4#803005)