isplendid / fbench Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/fbench
Automatically exported from code.google.com/p/fbench
What steps will reproduce the problem?
1. Use the latest built of Fedbench 3.0
2. Install and configure FedX 3.1 as a benchmark driver
3. Run a benchmark with chembl and drugbank with the following query (each
dataset on a seperate SPARQL endpoint)
SELECT ?val (COUNT(DISTINCT ?id) as ?vc)
WHERE
{
?original <http://rdf.ebi.ac.uk/terms/chembl#highestDevelopmentPhase> ?val.
{
SELECT ?original ?id
WHERE
{
?original <http://ns.ontoforce.com/2013/disqover#preferredUri> ?id.
?original_1 ?facet_source_1 ?facet_value_1.
FILTER(?facet_source_1 = <http://ns.ontoforce.com/ontologies/drugbank/manufacturer>)
FILTER(?facet_value_1 = "Sandoz inc"^^<http://www.w3.org/2001/XMLSchema#string>)
?original_2 ?facet_source_2 ?facet_value_2.
FILTER(?facet_source_2 = <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>)
FILTER (?facet_value_2 IN (<http://ns.ontoforce.com/ontologies/dailymed/Drug>, <http://ns.ontoforce.com/ontologies/unii/Substance>, <http://ns.ontoforce.com/ontologies/pubmed/Chemical>, <http://ns.ontoforce.com/ontologies/hsdb/Compound>, <http://ns.ontoforce.com/ontologies/drugbank/Drug>, <http://rdf.ebi.ac.uk/terms/chembl#SmallMoleculeTarget>, <http://rdf.ebi.ac.uk/terms/chembl#SmallMolecule>, <http://ns.ontoforce.com/ontologies/integration_ontology#DrugIntervention>, <http://rdf.ebi.ac.uk/terms/chembl#Synthetic>, <http://rdf.ebi.ac.uk/terms/chembl#NaturalProductDerived>, <http://rdf.ebi.ac.uk/terms/chembl#Inorganic>))
?original_3 <materialization:containsText> "migraine".
?original_1 <http://ns.ontoforce.com/2013/disqover#preferredUri> ?id.
?original_2 <http://ns.ontoforce.com/2013/disqover#preferredUri> ?id.
?original_3 <http://ns.ontoforce.com/2013/disqover#preferredUri> ?id.
}
}
UNION
{
SELECT ?original (?original as ?id)
WHERE
{
?original ?facet_source_3 ?facet_value_3.
FILTER(?facet_source_3 = <http://ns.ontoforce.com/ontologies/drugbank/manufacturer>)
FILTER(?facet_value_3 = "Sandoz inc"^^<http://www.w3.org/2001/XMLSchema#string>)
?original ?facet_source_4 ?facet_value_4.
FILTER(?facet_source_4 = <http://www.w3.org/1999/02/22-rdf-syntax-ns#type>)
FILTER (?facet_value_4 IN (<http://ns.ontoforce.com/ontologies/dailymed/Drug>, <http://ns.ontoforce.com/ontologies/unii/Substance>, <http://ns.ontoforce.com/ontologies/pubmed/Chemical>, <http://ns.ontoforce.com/ontologies/hsdb/Compound>, <http://ns.ontoforce.com/ontologies/drugbank/Drug>, <http://rdf.ebi.ac.uk/terms/chembl#SmallMoleculeTarget>, <http://rdf.ebi.ac.uk/terms/chembl#SmallMolecule>, <http://ns.ontoforce.com/ontologies/integration_ontology#DrugIntervention>, <http://rdf.ebi.ac.uk/terms/chembl#Synthetic>, <http://rdf.ebi.ac.uk/terms/chembl#NaturalProductDerived>, <http://rdf.ebi.ac.uk/terms/chembl#Inorganic>))
?original <materialization:containsText> "migraine".
OPTIONAL
{
?original <http://ns.ontoforce.com/2013/disqover#preferredUri> ?identifier.
}
FILTER(!BOUND(?identifier))
}
}
?original <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> <http://rdf.ebi.ac.uk/terms/chembl#SmallMolecule>.
}
GROUP BY ?val
ORDER BY DESC(?vc)
LIMIT 15
What is the expected output? What do you see instead?
# Get the number of drugs per development phase having "migraine"
# in their description, for manufacturer "Sandoz inc".
# Phases come from chembl, manufacturers come from drugbank.
#
# Time: ~0.4s
# Expected result:
# "val","vc"
# 4,11
# 0,1
This is the error, I see instead:
[EVAL] - executing query custom1_4 (#2) ...
WARN [main] (JoinOrderOptimizer.java:178) - No cost estimation for Projection available.
WARN [main] (JoinOrderOptimizer.java:178) - No cost estimation for Projection available.
WARN [main] (JoinOrderOptimizer.java:178) - No cost estimation for Projection available.
WARN [main] (JoinOrderOptimizer.java:178) - No cost estimation for Projection available.
ERROR [main] (FedXConnection.java:102) - Exception occured during optimization.
com.fluidops.fedx.exception.FedXRuntimeException: Type Projection not supported
for cost estimation. If you run into this, please report a bug.
at com.fluidops.fedx.optimizer.JoinOrderOptimizer.getFreeVars(JoinOrderOptimizer.java:158)
at com.fluidops.fedx.optimizer.JoinOrderOptimizer.getFreeVars(JoinOrderOptimizer.java:132)
at com.fluidops.fedx.optimizer.JoinOrderOptimizer.optimizeJoinOrder(JoinOrderOptimizer.java:80)
at com.fluidops.fedx.optimizer.StatementGroupOptimizer.meetNJoin(StatementGroupOptimizer.java:171)
at com.fluidops.fedx.optimizer.StatementGroupOptimizer.meetOther(StatementGroupOptimizer.java:79)
at com.fluidops.fedx.algebra.NJoin.visit(NJoin.java:49)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Group.visitChildren(Group.java:134)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:268)
at org.openrdf.query.algebra.Group.visit(Group.java:127)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Extension.visitChildren(Extension.java:112)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:244)
at org.openrdf.query.algebra.Extension.visit(Extension.java:101)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Order.visitChildren(Order.java:100)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:448)
at org.openrdf.query.algebra.Order.visit(Order.java:89)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Projection.visitChildren(Projection.java:87)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:460)
at org.openrdf.query.algebra.Projection.visit(Projection.java:79)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:520)
at org.openrdf.query.algebra.Slice.visit(Slice.java:96)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:478)
at org.openrdf.query.algebra.QueryRoot.visit(QueryRoot.java:57)
at com.fluidops.fedx.optimizer.StatementGroupOptimizer.optimize(StatementGroupOptimizer.java:66)
at com.fluidops.fedx.optimizer.Optimizer.optimize(Optimizer.java:108)
at com.fluidops.fedx.FedXConnection.evaluateInternal(FedXConnection.java:100)
at org.openrdf.sail.helpers.SailConnectionBase.evaluate(SailConnectionBase.java:292)
at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:60)
at org.semanticweb.fbench.evaluation.SesameEvaluation.runQuery(SesameEvaluation.java:67)
at org.semanticweb.fbench.evaluation.SesameSparqlEvaluation.runQuery(SesameSparqlEvaluation.java:81)
at org.semanticweb.fbench.evaluation.FedXSparqlEvaluation.runQuery(FedXSparqlEvaluation.java:119)
at org.semanticweb.fbench.evaluation.Evaluation.runMultiEval(Evaluation.java:160)
at org.semanticweb.fbench.evaluation.Evaluation.run(Evaluation.java:91)
at org.semanticweb.fbench.FederationEval.main(FederationEval.java:63)
[EVAL] - custom1_4 (#2, duration: -2ms, results -1)
ERROR [main] (Evaluation.java:167) - Error executing query custom1_4
(QueryEvaluationException): com.fluidops.fedx.exception.FedXRuntimeException:
Type Projection not supported for cost estimation. If you run into this, please
report a bug.
DEBUG [main] (Evaluation.java:168) - Exception details:
org.openrdf.query.QueryEvaluationException:
com.fluidops.fedx.exception.FedXRuntimeException: Type Projection not supported
for cost estimation. If you run into this, please report a bug.
at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:67)
at org.semanticweb.fbench.evaluation.SesameEvaluation.runQuery(SesameEvaluation.java:67)
at org.semanticweb.fbench.evaluation.SesameSparqlEvaluation.runQuery(SesameSparqlEvaluation.java:81)
at org.semanticweb.fbench.evaluation.FedXSparqlEvaluation.runQuery(FedXSparqlEvaluation.java:119)
at org.semanticweb.fbench.evaluation.Evaluation.runMultiEval(Evaluation.java:160)
at org.semanticweb.fbench.evaluation.Evaluation.run(Evaluation.java:91)
at org.semanticweb.fbench.FederationEval.main(FederationEval.java:63)
Caused by: org.openrdf.sail.SailException:
com.fluidops.fedx.exception.FedXRuntimeException: Type Projection not supported
for cost estimation. If you run into this, please report a bug.
at com.fluidops.fedx.FedXConnection.evaluateInternal(FedXConnection.java:103)
at org.openrdf.sail.helpers.SailConnectionBase.evaluate(SailConnectionBase.java:292)
at org.openrdf.repository.sail.SailTupleQuery.evaluate(SailTupleQuery.java:60)
... 6 more
Caused by: com.fluidops.fedx.exception.FedXRuntimeException: Type Projection
not supported for cost estimation. If you run into this, please report a bug.
at com.fluidops.fedx.optimizer.JoinOrderOptimizer.getFreeVars(JoinOrderOptimizer.java:158)
at com.fluidops.fedx.optimizer.JoinOrderOptimizer.getFreeVars(JoinOrderOptimizer.java:132)
at com.fluidops.fedx.optimizer.JoinOrderOptimizer.optimizeJoinOrder(JoinOrderOptimizer.java:80)
at com.fluidops.fedx.optimizer.StatementGroupOptimizer.meetNJoin(StatementGroupOptimizer.java:171)
at com.fluidops.fedx.optimizer.StatementGroupOptimizer.meetOther(StatementGroupOptimizer.java:79)
at com.fluidops.fedx.algebra.NJoin.visit(NJoin.java:49)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Group.visitChildren(Group.java:134)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:268)
at org.openrdf.query.algebra.Group.visit(Group.java:127)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Extension.visitChildren(Extension.java:112)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:244)
at org.openrdf.query.algebra.Extension.visit(Extension.java:101)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Order.visitChildren(Order.java:100)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:448)
at org.openrdf.query.algebra.Order.visit(Order.java:89)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.Projection.visitChildren(Projection.java:87)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:460)
at org.openrdf.query.algebra.Projection.visit(Projection.java:79)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetUnaryTupleOperator(QueryModelVisitorBase.java:690)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:520)
at org.openrdf.query.algebra.Slice.visit(Slice.java:96)
at org.openrdf.query.algebra.UnaryTupleOperator.visitChildren(UnaryTupleOperator.java:90)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meetNode(QueryModelVisitorBase.java:662)
at org.openrdf.query.algebra.helpers.QueryModelVisitorBase.meet(QueryModelVisitorBase.java:478)
at org.openrdf.query.algebra.QueryRoot.visit(QueryRoot.java:57)
at com.fluidops.fedx.optimizer.StatementGroupOptimizer.optimize(StatementGroupOptimizer.java:66)
at com.fluidops.fedx.optimizer.Optimizer.optimize(Optimizer.java:108)
at com.fluidops.fedx.FedXConnection.evaluateInternal(FedXConnection.java:100)
... 8 more
Original issue reported on code.google.com by [email protected]
on 29 Jan 2015 at 10:19
The link for nytimes-2010-01-13.zip file does not work.
Original issue reported on code.google.com by [email protected]
on 4 Sep 2012 at 12:28
Hi all
i just figured out that your namespace for the prefix skos is wrong in the
linked data queries
e.g.,
Query LD10
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
SELECT * WHERE {
?n skos:subject <http://dbpedia.org/resource/Category:Chancellors_of_Germany> .
?n owl:sameAs ?p2 .
?p2 <http://data.nytimes.com/elements/latest_use> ?u .
}
=> should be edit to
PREFIX skos: <http://purl.org/dc/terms/>
otherwise the explorative query processing will fail
Original issue reported on code.google.com by [email protected]
on 29 Nov 2011 at 2:57
A declarative, efficient, and flexible JavaScript library for building user interfaces.
๐ Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. ๐๐๐
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google โค๏ธ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.