[jira] [Created] (CALCITE-3624) Getting java.lang.NullPointerException at org.apache.calcite.schema.Schemas.queryable(Schemas.java:211)

["anjali shrishrimal (Jira)" <ji...@apache.org>]

anjali shrishrimal created CALCITE-3624:
-------------------------------------------

             Summary: 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


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());
 }

}

 

 

 

 

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)