ERROR 2020-07-07 09:46:50,230 [stardog-user-5] com.complexible.stardog.QueryManager:exceptionTriggered(481): Error during execution of the query SELECT ?metro ?country { GRAPH { ?metro a loc:Metro . ?country a loc:Country . ?metro loc:LocatedIn ?country . } } with query plan prefix : prefix rdf: prefix rdfs: prefix xsd: prefix owl: prefix stardog: VirtualGraphSql [#1000] { +─ RelNode= +─ LogicalSort(fetch=[1000]) +─ LogicalAggregate(group=[{0, 1}]) +─ LogicalUnion(all=[true]) +─ LogicalProject(metro=[$0], country0=[$14]) +─ LogicalJoin(condition=[AND(=($29, ||('http://test.akamai.com/location/entities#Metro_', $0)), =($27, ||('http://test.akamai.com/location/entities#Country_', $14)))], joinType=[inner]) +─ LogicalJoin(condition=[AND(IS NOT NULL($0), IS NOT NULL($14))], joinType=[inner]) +─ JdbcTableScan(table=[[default, metros]]) +─ JdbcTableScan(table=[[default, metros]]) +─ ExprTableScan(table=[[pp]]) +─ LogicalProject(metro=[$0], country0=[$14]) +─ LogicalJoin(condition=[AND(=($27, ||('http://test.akamai.com/location/entities#Metro_', $0)), =($29, ||('http://test.akamai.com/location/entities#Country_', $14)))], joinType=[inner]) +─ LogicalJoin(condition=[AND(IS NOT NULL($0), IS NOT NULL($14))], joinType=[inner]) +─ JdbcTableScan(table=[[default, metros]]) +─ JdbcTableScan(table=[[default, metros]]) +─ ExprTableScan(table=[[pp]]) +─ Vars= +─ ?metro <- TEMPLATE(http://test.akamai.com/location/entities#Metro_{metro/0}) `─ ?country <- TEMPLATE(http://test.akamai.com/location/entities#Country_{country/1}) } against database ak_location with reasoning schema default com.complexible.stardog.plan.eval.operator.OperatorException: Unable to execute virtual graph query. SQL string: SELECT `metro`, `country0` FROM (SELECT `metros`.`metro`, `metros0`.`country` `country0` FROM `default`.`metros` INNER JOIN `default`.`metros` `metros0` ON `metros`.`metro` IS NOT NULL AND `metros0`.`country` IS NOT NULL INNER JOIN `pp` ON `pp`.`pp_end_1` = CONCAT('http://test.akamai.com/location/entities#Metro_', `metros`.`metro`) AND `pp`.`pp_start_1` = CONCAT('http://test.akamai.com/location/entities#Country_', `metros0`.`country`) UNION ALL SELECT `metros1`.`metro`, `metros2`.`country` `country0` FROM `default`.`metros` `metros1` INNER JOIN `default`.`metros` `metros2` ON `metros1`.`metro` IS NOT NULL AND `metros2`.`country` IS NOT NULL INNER JOIN `pp` `pp0` ON `pp0`.`pp_start_1` = CONCAT('http://test.akamai.com/location/entities#Metro_', `metros1`.`metro`) AND `pp0`.`pp_end_1` = CONCAT('http://test.akamai.com/location/entities#Country_', `metros2`.`country`)) `t1` GROUP BY `metro`, `country0` LIMIT 1000 at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:107) ~[stardog-7.3.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:29) ~[stardog-7.3.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.3.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.3.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.AutoCloseOperator.computeNext(AutoCloseOperator.java:154) ~[stardog-7.3.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.AutoCloseOperator.computeNext(AutoCloseOperator.java:28) ~[stardog-7.3.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.tryToComputeNext(AbstractSkippingIterator.java:147) ~[stardog-utils-common-7.3.2.jar:?] at com.complexible.common.collect.AbstractSkippingIterator.hasNext(AbstractSkippingIterator.java:134) ~[stardog-utils-common-7.3.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.OpBasedBindingSetIteration.computeNext(OpBasedBindingSetIteration.java:119) ~[stardog-7.3.2.jar:?] at com.complexible.stardog.plan.eval.operator.util.OpBasedBindingSetIteration.computeNext(OpBasedBindingSetIteration.java:40) ~[stardog-7.3.2.jar:?] at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-27.0-jre.jar:?] at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-27.0-jre.jar:?] at com.complexible.common.base.CloseableIterator$2.computeNext(CloseableIterator.java:84) ~[stardog-utils-common-7.3.2.jar:?] at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-27.0-jre.jar:?] at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-27.0-jre.jar:?] at com.complexible.common.rdf.query.IteratorAsTupleQueryResult.computeNext(IteratorAsTupleQueryResult.java:81) ~[stardog-utils-rdf-7.3.2.jar:?] at com.complexible.common.rdf.query.IteratorAsTupleQueryResult.computeNext(IteratorAsTupleQueryResult.java:23) ~[stardog-utils-rdf-7.3.2.jar:?] at com.google.common.collect.AbstractIterator.tryToComputeNext(AbstractIterator.java:141) ~[guava-27.0-jre.jar:?] at com.google.common.collect.AbstractIterator.hasNext(AbstractIterator.java:136) ~[guava-27.0-jre.jar:?] at com.stardog.stark.query.ClosingSpliterator.forEachRemaining(ClosingSpliterator.java:37) ~[stardog-stark-query-api-7.3.2.jar:?] at java.util.stream.ReferencePipeline$Head.forEach(ReferencePipeline.java:580) ~[?:1.8.0_11] at com.stardog.stark.query.io.QueryResultWriters.write(QueryResultWriters.java:142) ~[stardog-stark-query-io-7.3.2.jar:?] at com.stardog.stark.query.io.QueryResultWriters.write(QueryResultWriters.java:127) ~[stardog-stark-query-io-7.3.2.jar:?] at com.complexible.stardog.protocols.http.server.ProtocolUtils.writeTupleResponse(ProtocolUtils.java:697) ~[stardog-protocols-http-server-7.3.2.jar:?] at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:589) ~[stardog-protocols-http-server-7.3.2.jar:?] at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:561) ~[stardog-protocols-http-server-7.3.2.jar:?] at com.complexible.stardog.protocols.http.server.ProtocolUtils.executeReadQuery(ProtocolUtils.java:522) ~[stardog-protocols-http-server-7.3.2.jar:?] at com.complexible.stardog.protocols.http.server.SPARQLProtocol.executeQuery(SPARQLProtocol.java:146) ~[stardog-protocols-http-server-7.3.2.jar:?] at com.complexible.stardog.protocols.http.server.SPARQLProtocol.post(SPARQLProtocol.java:106) ~[stardog-protocols-http-server-7.3.2.jar:?] at com.stardog.http.server.undertow.jaxrs.ExtractRoutes.lambda$handleIt$5(ExtractRoutes.java:192) [stardog-protocols-http-server-7.3.2.jar:?] at com.stardog.http.server.undertow.jaxrs.ExtractRoutes$$Lambda$1015/1049748928.run(Unknown Source) [stardog-protocols-http-server-7.3.2.jar:?] at org.apache.shiro.subject.support.SubjectRunnable.doRun(SubjectRunnable.java:120) [shiro-core-1.3.0.jar:1.3.0] at org.apache.shiro.subject.support.SubjectRunnable.run(SubjectRunnable.java:108) [shiro-core-1.3.0.jar:1.3.0] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [?:1.8.0_11] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [?:1.8.0_11] at java.lang.Thread.run(Thread.java:745) [?:1.8.0_11] Caused by: com.complexible.stardog.StardogException: Unable to execute virtual graph query. SQL string: SELECT `metro`, `country0` FROM (SELECT `metros`.`metro`, `metros0`.`country` `country0` FROM `default`.`metros` INNER JOIN `default`.`metros` `metros0` ON `metros`.`metro` IS NOT NULL AND `metros0`.`country` IS NOT NULL INNER JOIN `pp` ON `pp`.`pp_end_1` = CONCAT('http://test.akamai.com/location/entities#Metro_', `metros`.`metro`) AND `pp`.`pp_start_1` = CONCAT('http://test.akamai.com/location/entities#Country_', `metros0`.`country`) UNION ALL SELECT `metros1`.`metro`, `metros2`.`country` `country0` FROM `default`.`metros` `metros1` INNER JOIN `default`.`metros` `metros2` ON `metros1`.`metro` IS NOT NULL AND `metros2`.`country` IS NOT NULL INNER JOIN `pp` `pp0` ON `pp0`.`pp_start_1` = CONCAT('http://test.akamai.com/location/entities#Metro_', `metros1`.`metro`) AND `pp0`.`pp_end_1` = CONCAT('http://test.akamai.com/location/entities#Country_', `metros2`.`country`)) `t1` GROUP BY `metro`, `country0` LIMIT 1000 at com.complexible.stardog.virtual.vega.rdbms.RdbmsRelExecutor.execute(RdbmsRelExecutor.java:65) ~[stardog-virtual-core-7.3.2.jar:?] at com.complexible.stardog.virtual.vega.VirtualServiceQuery.execute(VirtualServiceQuery.java:187) ~[stardog-virtual-core-7.3.2.jar:?] at com.complexible.stardog.virtual.vega.VirtualServiceQuery.evaluate(VirtualServiceQuery.java:200) ~[stardog-virtual-core-7.3.2.jar:?] at com.complexible.stardog.plan.eval.operator.impl.ServiceOperatorImpl.computeNext(ServiceOperatorImpl.java:93) ~[stardog-7.3.2.jar:?] ... 35 more Caused by: org.apache.hive.service.cli.HiveSQLException: Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 5:11 Table not found 'pp'