[Wikidata-bugs] [Maniphest] T274519: timeout on geospatial query; resolved by OPTIONAL?

2021-02-15 Thread dcausse 
dcausse closed this task as "Declined".
dcausse added a comment.


  Definitely a blazegraph opitimization issue.
  Disabling the optimizer seems to also help:
  
SELECT ?place ?placeLabel ?page ?location ?dist WHERE
{
  hint:Query hint:optimizer "None".
  wd:Q84 wdt:P625 ?loc .
  SERVICE wikibase:around {
  ?place wdt:P625 ?location .
  bd:serviceParam wikibase:center ?loc .
  bd:serviceParam wikibase:radius "1" .
  }
  ?page schema:about ?place;
schema:isPartOf  ###
  BIND(geof:distance(?loc, ?location) as ?dist)
  SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
  }
} order by ?dist
  
  I'm closing since I think this is unlikely we have the expertise/bandwidth to 
address such complex issue related to blazegraph internals.

TASK DETAIL
  https://phabricator.wikimedia.org/T274519

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: dcausse
Cc: dcausse, Aklapper, VladimirAlexiev, MPhamWMF, CBogen, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T274519: timeout on geospatial query; resolved by OPTIONAL?

2021-02-12 Thread Lydia_Pintscher 
Lydia_Pintscher removed a subscriber: Wikidata-Query-Service.
Lydia_Pintscher added a project: Wikidata-Query-Service.
Restricted Application added a project: Wikidata.

TASK DETAIL
  https://phabricator.wikimedia.org/T274519

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: Lydia_Pintscher
Cc: Aklapper, VladimirAlexiev, MPhamWMF, CBogen, Akuckartz, Nandana, 
Namenlos314, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, 
EBjune, merbst, LawExplorer, _jensen, rosalieper, Scott_WUaS, Jonas, Xmlizer, 
jkroll, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331, 
#wikidata-query-service
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T274519: timeout on geospatial query; resolved by OPTIONAL?

2021-02-11 Thread VladimirAlexiev 
VladimirAlexiev added a comment.


  The following equivalent query works fine:
  
SELECT ?place ?placeLabel ?page ?location ?dist WHERE
{
  wd:Q84 wdt:P625 ?loc .
  SERVICE wikibase:around {
  ?place wdt:P625 ?location .
  bd:serviceParam wikibase:center ?loc .
  bd:serviceParam wikibase:radius "1" .
  }
  optional {?page schema:about ?place; schema:isPartOf 
} ###
  filter(bound(?page))  ###
  BIND(geof:distance(?loc, ?location) as ?dist)
  SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
  }
} order by ?dist
  
  So the original query does some stupid reordering: probably tries `?page 
schema:about ?place` before binding `?place`

TASK DETAIL
  https://phabricator.wikimedia.org/T274519

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: VladimirAlexiev
Cc: #wikidata-query-service, Aklapper, VladimirAlexiev
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

[Wikidata-bugs] [Maniphest] T274519: timeout on geospatial query; resolved by OPTIONAL?

2021-02-11 Thread VladimirAlexiev 
VladimirAlexiev created this task.
Restricted Application added a subscriber: Aklapper.

TASK DESCRIPTION
  This query times out because of the clause marked `###`
  
SELECT ?place ?placeLabel ?page ?location ?dist WHERE
{
  wd:Q84 wdt:P625 ?loc .
  SERVICE wikibase:around {
  ?place wdt:P625 ?location .
  bd:serviceParam wikibase:center ?loc .
  bd:serviceParam wikibase:radius "1" .
  }
  ?page schema:about ?place; schema:isPartOf  ###
  BIND(geof:distance(?loc, ?location) as ?dist)
  SERVICE wikibase:label {
bd:serviceParam wikibase:language "en" .
  }
} order by ?dist
  
  If you put the clause in `optional {...}` it runs ok: https://w.wiki/yrX
  
  The former query should return a subset of the latter query (about half of 
1600 results), so why does it time out?

TASK DETAIL
  https://phabricator.wikimedia.org/T274519

EMAIL PREFERENCES
  https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: VladimirAlexiev
Cc: #wikidata-query-service, Aklapper, VladimirAlexiev
___
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs