[
https://issues.apache.org/jira/browse/CALCITE-3624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
anjali shrishrimal updated CALCITE-3624:
----------------------------------------
Description:
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
was:
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
> 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)
