(wdt:P1344/wdt:P31) wd:Q1344963 timeout
ActivePublic
Actions

Authored by Nemo_bis on Jan 14 2018, 7:19 PM.

Tags

Referenced Files

	F12554534: (wdt:P1344/wdt:P31) wd:Q1344963 timeout
	Jan 14 2018, 7:19 PM

Subscribers

matej_suchanek

	PREFIX schema: <http://schema.org/>

	SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
	?item wdt:P31 wd:Q5.
	?item wdt:P21 wd:Q6581072.
	?item (wdt:P1344/wdt:P31) wd:Q1344963 .
	?sitelink schema:about ?item.
	FILTER(NOT EXISTS {
	?wfr schema:about ?item.
	?wfr schema:inLanguage "it".
	})
	}
	GROUP BY ?item ?itemLabel
	HAVING (?count > 0)
	LIMIT 100

	EXPLAIN:

	<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html><head><meta http-equiv="Content-Type" content="text/html;charset=UTF-8"><title>blazegraph™ by SYSTAP</title
	></head
	><body<h1>Query</h1
	><h2>SPARQL</h2
	><pre>PREFIX schema: <http://schema.org/>

	SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
	?item wdt:P31 wd:Q5.
	?item wdt:P21 wd:Q6581072.
	?item (wdt:P1344/wdt:P31) wd:Q1344963 .
	?sitelink schema:about ?item.
	FILTER(NOT EXISTS {
	?wfr schema:about ?item.
	?wfr schema:inLanguage "it".
	})
	}
	GROUP BY ?item ?itemLabel
	HAVING (?count > 0)
	LIMIT 100</pre
	><h2>Parse Tree</h2
	><pre>QueryContainer
	PrefixDecl (prefix=schema)
	IRI (http://schema.org/)
	SelectQuery
	Select
	ProjectionElem
	Var (item)
	ProjectionElem
	Count
	Var (sitelink)
	Var (count)
	WhereClause
	GraphPatternGroup
	BasicGraphPattern
	TriplesSameSubjectPath
	Var (item)
	PropertyListPath
	PathAlternative
	PathSequence
	PathElt
	IRI (http://www.wikidata.org/prop/direct/P31)
	ObjectList
	IRI (http://www.wikidata.org/entity/Q5)
	TriplesSameSubjectPath
	Var (item)
	PropertyListPath
	PathAlternative
	PathSequence
	PathElt
	IRI (http://www.wikidata.org/prop/direct/P21)
	ObjectList
	IRI (http://www.wikidata.org/entity/Q6581072)
	TriplesSameSubjectPath
	Var (item)
	PropertyListPath
	PathAlternative
	PathSequence
	PathElt
	PathAlternative
	PathSequence
	PathElt
	IRI (http://www.wikidata.org/prop/direct/P1344)
	PathElt
	IRI (http://www.wikidata.org/prop/direct/P31)
	ObjectList
	IRI (http://www.wikidata.org/entity/Q1344963)
	TriplesSameSubjectPath
	Var (sitelink)
	PropertyListPath
	PathAlternative
	PathSequence
	PathElt
	IRI (http://schema.org/about)
	ObjectList
	Var (item)
	Constraint
	NotExistsFunc
	GraphPatternGroup
	BasicGraphPattern
	TriplesSameSubjectPath
	Var (wfr)
	PropertyListPath
	PathAlternative
	PathSequence
	PathElt
	IRI (http://schema.org/about)
	ObjectList
	Var (item)
	TriplesSameSubjectPath
	Var (wfr)
	PropertyListPath
	PathAlternative
	PathSequence
	PathElt
	IRI (http://schema.org/inLanguage)
	ObjectList
	RDFLiteral
	String (it)
	GroupClause
	GroupCondition
	Var (item)
	GroupCondition
	Var (itemLabel)
	HavingClause
	Constraint
	Compare (GT)
	Var (count)
	NumericLiteral (value=0, datatype=http://www.w3.org/2001/XMLSchema#integer)
	Limit (100)</pre
	><h2>Original AST</h2
	><pre>
	PREFIX schema: <http://schema.org/>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
	PREFIX sesame: <http://www.openrdf.org/schema/sesame#>
	PREFIX owl: <http://www.w3.org/2002/07/owl#>
	PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
	PREFIX fn: <http://www.w3.org/2005/xpath-functions#>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX dc: <http://purl.org/dc/elements/1.1/>
	PREFIX hint: <http://www.bigdata.com/queryHints#>
	PREFIX bd: <http://www.bigdata.com/rdf#>
	PREFIX bds: <http://www.bigdata.com/rdf/search#>
	PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
	PREFIX pqn: <http://www.wikidata.org/prop/qualifier/value-normalized/>
	PREFIX prn: <http://www.wikidata.org/prop/reference/value-normalized/>
	PREFIX mwapi: <https://www.mediawiki.org/ontology#API/>
	PREFIX gas: <http://www.bigdata.com/rdf/gas#>
	PREFIX wdt: <http://www.wikidata.org/prop/direct/>
	PREFIX wdtn: <http://www.wikidata.org/prop/direct-normalized/>
	PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
	PREFIX ps: <http://www.wikidata.org/prop/statement/>
	PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
	PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
	PREFIX prv: <http://www.wikidata.org/prop/reference/value/>
	PREFIX pr: <http://www.wikidata.org/prop/reference/>
	PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
	PREFIX p: <http://www.wikidata.org/prop/>
	PREFIX wikibase: <http://wikiba.se/ontology#>
	PREFIX wd: <http://www.wikidata.org/entity/>
	PREFIX wds: <http://www.wikidata.org/entity/statement/>
	PREFIX wdv: <http://www.wikidata.org/value/>
	PREFIX wdref: <http://www.wikidata.org/reference/>
	PREFIX wdata: <http://www.wikidata.org/wiki/Special:EntityData/>
	PREFIX prov: <http://www.w3.org/ns/prov#>
	PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
	PREFIX geo: <http://www.opengis.net/ont/geosparql#>
	PREFIX geof: <http://www.opengis.net/def/geosparql/function/>
	PREFIX mediawiki: <https://www.mediawiki.org/ontology#>
	QueryType: SELECT
	includeInferred=true
	timeout=60000
	SELECT VarNode(item) ( com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(sitelink))[ FunctionNode.scalarVals={com.bigdata.bop.aggregate.AggregateBase.distinct=true}, FunctionNode.functionURI=http://www.w3.org/2006/sparql-functions#count, valueExpr=com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true]] AS VarNode(count) )
	JoinGroupNode {
	StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31)), ConstantNode(Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedByte(5))) [scope=DEFAULT_CONTEXTS]
	StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(21)), ConstantNode(Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedInt(6581072))) [scope=DEFAULT_CONTEXTS]
	PropertyPathNode(VarNode(item), com.bigdata.rdf.sparql.ast.PathNode(PathAlternative), ConstantNode(Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedInt(1344963))) [scope=DEFAULT_CONTEXTS]
	StatementPatternNode(VarNode(sitelink), ConstantNode(Vocab(40)[http://schema.org/about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
	FILTER( NotExistsNode(VarNode(-exists-1))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http://www.bigdata.com/sparql-1.1-undefined-functionsnot-exists, graphPattern=
	JoinGroupNode {
	StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http://schema.org/about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
	StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http://schema.org/inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
	}, valueExpr=com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1))] )
	}
	group by VarNode(item) VarNode(itemLabel)
	having com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(count),ConstantNode(XSDInteger(0)))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http://www.w3.org/2005/xpath-functions#greater-than, valueExpr=com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT]]
	slice(limit=100)</pre
	><h2>Static Analysis Statistics</h2
	><table><tr><th>object</th
	><th>category</th
	><th>elapsed [ms]</th
	><th>elapsed [us]</th
	><th>numCalls</th
	></tr
	><tr><td>ParseTime</td
	><td>Parser</td
	><td>1</td
	><td>1478</td
	><td>1</td
	></tr
	><tr><td>ResolveValues</td
	><td>Resolve Values</td
	><td>0</td
	><td>770</td
	><td>1</td
	></tr
	><tr><td>Optimizers</td
	><td>Optimizers (all)</td
	><td>3</td
	><td>3863</td
	><td>1</td
	></tr
	><tr><td>ASTOrderByAggregateFlatteningOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>4</td
	><td>1</td
	></tr
	><tr><td>ASTQueryHintOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>414</td
	><td>1</td
	></tr
	><tr><td>LabelServicePlacementOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>6</td
	><td>1</td
	></tr
	><tr><td>ASTFilterNormalizationOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>ASTStaticBindingsOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>44</td
	><td>1</td
	></tr
	><tr><td>ASTSearchInSearchOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>5</td
	><td>1</td
	></tr
	><tr><td>ASTPropertyPathOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>26</td
	><td>1</td
	></tr
	><tr><td>ASTSetValueExpressionsOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>436</td
	><td>1</td
	></tr
	><tr><td>ASTFlattenUnionsOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>ASTUnionFiltersOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>ASTEmptyGroupOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>ASTWildcardProjectionOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>146</td
	><td>1</td
	></tr
	><tr><td>ASTSearchOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>6</td
	><td>1</td
	></tr
	><tr><td>ASTFulltextSearchOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>4</td
	><td>1</td
	></tr
	><tr><td>ASTGeoSpatialSearchOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>5</td
	><td>1</td
	></tr
	><tr><td>AskOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>1</td
	><td>1</td
	></tr
	><tr><td>ASTDescribeOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>1</td
	><td>1</td
	></tr
	><tr><td>ASTConstructOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>3</td
	><td>1</td
	></tr
	><tr><td>ASTExistsOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>47</td
	><td>1</td
	></tr
	><tr><td>ASTGraphGroupOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>3</td
	><td>1</td
	></tr
	><tr><td>ASTLiftPreFiltersOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>1</td
	><td>1</td
	></tr
	><tr><td>ASTALPServiceOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>4</td
	><td>1</td
	></tr
	><tr><td>ASTBottomUpOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>687</td
	><td>1</td
	></tr
	><tr><td>ASTSimpleOptionalOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>ASTFlattenJoinGroupsOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>3</td
	><td>1</td
	></tr
	><tr><td>ASTServiceNodeOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>LabelServiceExtractOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>5</td
	><td>1</td
	></tr
	><tr><td>ASTJoinGroupOrderOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>401</td
	><td>2</td
	></tr
	><tr><td>ASTRunFirstRunLastOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>8</td
	><td>2</td
	></tr
	><tr><td>ASTRangeOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>4</td
	><td>1</td
	></tr
	><tr><td>ASTRangeCountOptimizer</td
	><td>Optimizer</td
	><td>1</td
	><td>1212</td
	><td>1</td
	></tr
	><tr><td>ASTCardinalityOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>6</td
	><td>1</td
	></tr
	><tr><td>ASTFastRangeCountOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>12</td
	><td>1</td
	></tr
	><tr><td>ASTSimpleGroupByAndCountOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>2</td
	><td>1</td
	></tr
	><tr><td>ASTDistinctTermScanOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>4</td
	><td>1</td
	></tr
	><tr><td>ASTStaticJoinOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>84</td
	><td>1</td
	></tr
	><tr><td>ASTAttachJoinFiltersOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>83</td
	><td>1</td
	></tr
	><tr><td>ASTSparql11SubqueryOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>4</td
	><td>1</td
	></tr
	><tr><td>ASTNamedSubqueryOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>1</td
	><td>1</td
	></tr
	><tr><td>ASTSubGroupJoinVarOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>3</td
	><td>1</td
	></tr
	><tr><td>EmptyLabelServiceOptimizer</td
	><td>Optimizer</td
	><td>0</td
	><td>6</td
	><td>1</td
	></tr
	><tr><td>RangeCount</td
	><td>Range Count</td
	><td>3</td
	><td>3076</td
	><td>7</td
	></tr
	></table
	><h2>Optimized AST</h2
	><pre>
	PREFIX schema: <http://schema.org/>
	PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
	PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
	PREFIX sesame: <http://www.openrdf.org/schema/sesame#>
	PREFIX owl: <http://www.w3.org/2002/07/owl#>
	PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
	PREFIX fn: <http://www.w3.org/2005/xpath-functions#>
	PREFIX foaf: <http://xmlns.com/foaf/0.1/>
	PREFIX dc: <http://purl.org/dc/elements/1.1/>
	PREFIX hint: <http://www.bigdata.com/queryHints#>
	PREFIX bd: <http://www.bigdata.com/rdf#>
	PREFIX bds: <http://www.bigdata.com/rdf/search#>
	PREFIX psn: <http://www.wikidata.org/prop/statement/value-normalized/>
	PREFIX pqn: <http://www.wikidata.org/prop/qualifier/value-normalized/>
	PREFIX prn: <http://www.wikidata.org/prop/reference/value-normalized/>
	PREFIX mwapi: <https://www.mediawiki.org/ontology#API/>
	PREFIX gas: <http://www.bigdata.com/rdf/gas#>
	PREFIX wdt: <http://www.wikidata.org/prop/direct/>
	PREFIX wdtn: <http://www.wikidata.org/prop/direct-normalized/>
	PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
	PREFIX ps: <http://www.wikidata.org/prop/statement/>
	PREFIX pqv: <http://www.wikidata.org/prop/qualifier/value/>
	PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
	PREFIX prv: <http://www.wikidata.org/prop/reference/value/>
	PREFIX pr: <http://www.wikidata.org/prop/reference/>
	PREFIX wdno: <http://www.wikidata.org/prop/novalue/>
	PREFIX p: <http://www.wikidata.org/prop/>
	PREFIX wikibase: <http://wikiba.se/ontology#>
	PREFIX wd: <http://www.wikidata.org/entity/>
	PREFIX wds: <http://www.wikidata.org/entity/statement/>
	PREFIX wdv: <http://www.wikidata.org/value/>
	PREFIX wdref: <http://www.wikidata.org/reference/>
	PREFIX wdata: <http://www.wikidata.org/wiki/Special:EntityData/>
	PREFIX prov: <http://www.w3.org/ns/prov#>
	PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
	PREFIX geo: <http://www.opengis.net/ont/geosparql#>
	PREFIX geof: <http://www.opengis.net/def/geosparql/function/>
	PREFIX mediawiki: <https://www.mediawiki.org/ontology#>
	QueryType: SELECT
	includeInferred=true
	timeout=60000
	SELECT ( VarNode(item) AS VarNode(item) ) ( com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(sitelink))[ FunctionNode.scalarVals={com.bigdata.bop.aggregate.AggregateBase.distinct=true}, FunctionNode.functionURI=http://www.w3.org/2006/sparql-functions#count, valueExpr=com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true]] AS VarNode(count) )
	JoinGroupNode {
	StatementPatternNode(VarNode(--pp-anon-d7785ce1-fb55-4cbd-9f53-6d8d8de0f74c)[anonymous], ConstantNode(Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31)), ConstantNode(Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedInt(1344963))) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=661
	AST2BOpBase.originalIndex=POS
	StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedShort(1344)), VarNode(--pp-anon-d7785ce1-fb55-4cbd-9f53-6d8d8de0f74c)[anonymous]) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=304519
	AST2BOpBase.originalIndex=POS
	QueryType: ASK
	SELECT VarNode(item) VarNode(-exists-1)[anonymous]
	JoinGroupNode {
	StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http://schema.org/inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=1923821
	AST2BOpBase.originalIndex=POS
	StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http://schema.org/about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=61377603
	AST2BOpBase.originalIndex=POS
	}
	@askVar=-exists-1
	FILTER( NotExistsNode(VarNode(-exists-1))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http://www.bigdata.com/sparql-1.1-undefined-functionsnot-exists, graphPattern=
	JoinGroupNode {
	StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(42)[http://schema.org/inLanguage]), ConstantNode(TermId(16671L)[it])) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=1923821
	AST2BOpBase.originalIndex=POS
	StatementPatternNode(VarNode(wfr), ConstantNode(Vocab(40)[http://schema.org/about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=61377603
	AST2BOpBase.originalIndex=POS
	}, valueExpr=com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1))] )
	StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(21)), ConstantNode(Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedInt(6581072))) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=624933
	AST2BOpBase.originalIndex=POS
	StatementPatternNode(VarNode(item), ConstantNode(Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31)), ConstantNode(Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedByte(5))) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=4085615
	AST2BOpBase.originalIndex=POS
	StatementPatternNode(VarNode(sitelink), ConstantNode(Vocab(40)[http://schema.org/about]), VarNode(item)) [scope=DEFAULT_CONTEXTS]
	AST2BOpBase.estimatedCardinality=61377603
	AST2BOpBase.originalIndex=POS
	}
	group by ( VarNode(item) AS VarNode(item) ) ( VarNode(itemLabel) AS VarNode(itemLabel) )
	having com.bigdata.rdf.sparql.ast.FunctionNode(VarNode(count),ConstantNode(XSDInteger(0)))[ FunctionNode.scalarVals=null, FunctionNode.functionURI=http://www.w3.org/2005/xpath-functions#greater-than, valueExpr=com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT]]
	slice(limit=100)

	with static (exogeneous) bindings defined as follows:
	{
	{ }
	}
	</pre
	><h2>Query Plan</h2
	><pre>com.bigdata.bop.solutions.SliceOp[24](ProjectionOp[23])[ BOp.bopId=24, SliceOp.offset=0, SliceOp.limit=100, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=true, PipelineOp.maxParallel=1, PipelineOp.reorderSolutions=false, PipelineOp.sharedState=true, BOp.timeout=60000, BOp.namespace=wdq, QueryEngine.queryId=222f3cf9-7789-4e1f-9c50-82d808e5e96e, QueryEngine.chunkHandler=com.bigdata.bop.engine.NativeHeapStandloneChunkHandler@39dafcfa]
	com.bigdata.bop.solutions.ProjectionOp[23](MemoryGroupByOp[22])[ BOp.bopId=23, BOp.evaluationContext=CONTROLLER, PipelineOp.sharedState=true, JoinAnnotations.select=[item, count]]
	com.bigdata.bop.solutions.MemoryGroupByOp[22](ChunkedMaterializationOp[21])[ BOp.bopId=22, BOp.evaluationContext=CONTROLLER, PipelineOp.pipelined=false, PipelineOp.maxMemory=0, GroupByOp.groupByState=GroupByState{select=[com.bigdata.bop.Bind(item,item), com.bigdata.bop.Bind(count,com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true])],groupBy=[com.bigdata.bop.Bind(item,item), com.bigdata.bop.Bind(itemLabel,itemLabel)],having=[com.bigdata.rdf.internal.constraints.SPARQLConstraint(com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT])]}, GroupByOp.groupByRewrite=GroupByRewriter{aggExpr={com.bigdata.bop.rdf.aggregate.COUNT(sitelink)[ AggregateBase.distinct=true]=ef05773f-eea0-4699-9d87-4a74e40f563d},select2=[com.bigdata.bop.Bind(item,item), com.bigdata.bop.Bind(count,ef05773f-eea0-4699-9d87-4a74e40f563d)],having2=[com.bigdata.rdf.internal.constraints.SPARQLConstraint(com.bigdata.rdf.internal.constraints.CompareBOp(count,XSDInteger(0))[ CompareBOp.op=GT])]}]
	com.bigdata.bop.rdf.join.ChunkedMaterializationOp[21](DropOp[20])[ ChunkedMaterializationOp.vars=[count], IPredicate.relationName=[wdq.lex], IPredicate.timestamp=1515957318305, ChunkedMaterializationOp.materializeAll=false, PipelineOp.sharedState=true, PipelineOp.reorderSolutions=true, PipelineOp.maxParallel=5, BOp.bopId=21]
	com.bigdata.bop.solutions.DropOp[20](PipelineJoin[19])[ BOp.bopId=20, DropOp.dropVars=[-exists-1]]
	com.bigdata.bop.join.PipelineJoin[19](PipelineJoin[17])[ BOp.bopId=19, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[18](sitelink=null, Vocab(40)[http://schema.org/about], item=null)[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1515957318305, BOp.bopId=18, AST2BOpBase.estimatedCardinality=61377603, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
	com.bigdata.bop.join.PipelineJoin[17](PipelineJoin[15])[ BOp.bopId=17, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[16](item=null, Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(31), Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedByte(5))[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1515957318305, BOp.bopId=16, AST2BOpBase.estimatedCardinality=4085615, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
	com.bigdata.bop.join.PipelineJoin[15](ConditionalRoutingOp[11])[ BOp.bopId=15, JoinAnnotations.constraints=null, AST2BOpBase.simpleJoin=true, BOp.evaluationContext=ANY, AccessPathJoinAnnotations.predicate=com.bigdata.rdf.spo.SPOPredicate[14](item=null, Vocab(6)[http://www.wikidata.org/prop/direct/P]:XSDUnsignedByte(21), Vocab(2)[http://www.wikidata.org/entity/Q]:XSDUnsignedInt(6581072))[ IPredicate.relationName=[wdq.spo], IPredicate.timestamp=1515957318305, BOp.bopId=14, AST2BOpBase.estimatedCardinality=624933, AST2BOpBase.originalIndex=POS, IPredicate.flags=[KEYS,VALS,READONLY,PARALLEL]]]
	com.bigdata.bop.bset.ConditionalRoutingOp[11](ChunkedMaterializationOp[13])[ BOp.bopId=11, ConditionalRoutingOp.condition=com.bigdata.rdf.internal.constraints.SPARQLConstraint(com.bigdata.rdf.internal.constraints.NotBOp(com.bigdata.rdf.internal.constraints.EBVBOp(-exists-1)))]
	com.bigdata.bop.rdf.join.ChunkedMaterializationOp[13](ConditionalRoutingOp[12])[ ChunkedMaterializationOp.vars=[-exists-1], IPredicate.relationName=[wdq.lex], IPredicate.timestamp=1515957318305, ChunkedMaterializationOp.materializeAll=false, PipelineOp.sharedState=true, PipelineOp.reorderSolutions=true, PipelineOp.maxParallel=5, BOp.bopId=13]
	SPARQL-QUERY: queryStr=PREFIX schema: <http://schema.org/>

	SELECT ?item (COUNT(DISTINCT ?sitelink) AS ?count) WHERE {
	?item wdt:P31 wd:Q5.
	?item wdt:P21 wd:Q6581072.
	?item (wdt:P1344/wdt:P31) wd:Q1344963 .
	?sitelink schema:about ?item.
	FILTER(NOT EXISTS {
	?wfr schema:about ?item.
	?wfr schema:inLanguage "it".
	})
	}
	GROUP BY ?item ?itemLabel
	HAVING (?count > 0)
	LIMIT 100
	java.util.concurrent.TimeoutException
	at java.util.concurrent.FutureTask.get(FutureTask.java:205)
	at com.bigdata.rdf.sail.webapp.BigdataServlet.submitApiTask(BigdataServlet.java:293)
	at com.bigdata.rdf.sail.webapp.QueryServlet.doSparqlQuery(QueryServlet.java:654)
	at com.bigdata.rdf.sail.webapp.QueryServlet.doGet(QueryServlet.java:288)
	at com.bigdata.rdf.sail.webapp.RESTServlet.doGet(RESTServlet.java:240)
	at com.bigdata.rdf.sail.webapp.MultiTenancyServlet.doGet(MultiTenancyServlet.java:271)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:687)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:790)
	at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:769)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1667)
	at org.wikidata.query.rdf.blazegraph.throttling.ThrottlingFilter.doFilter(ThrottlingFilter.java:304)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
	at ch.qos.logback.classic.helpers.MDCInsertingServletFilter.doFilter(MDCInsertingServletFilter.java:49)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
	at org.wikidata.query.rdf.blazegraph.filters.ClientIPFilter.doFilter(ClientIPFilter.java:43)
	at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1650)
	at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:583)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
	at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:577)
	at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:223)
	at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1125)
	at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:515)
	at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:185)
	at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1059)
	at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
	at org.eclipse.jetty.server.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:215)
	at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:110)
	at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
	at org.eclipse.jetty.server.Server.handle(Server.java:497)
	at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
	at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:248)
	at org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:540)
	at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:610)
	at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:539)
	at java.lang.Thread.run(Thread.java:748)

Event Timeline

Nemo_bis created this paste.Jan 14 2018, 7:19 PM

SELECT DISTINCT ?item ?count WHERE {
  ?item wdt:P31 wd:Q5;
        wdt:P21 wd:Q6581072;
        wdt:P1344/wdt:P31 wd:Q1344963;
        wikibase:sitelinks ?count .
  FILTER( ?count > 0 ) .
  MINUS { ?item ^schema:about/schema:inLanguage "it" } .
}
LIMIT 100

(wdt:P1344/wdt:P31) wd:Q1344963 timeoutActivePublicActions

Event Timeline

(wdt:P1344/wdt:P31) wd:Q1344963 timeout
ActivePublic
Actions