Difference between revisions of "Snapquery Evaluation 2024-07"

From BITPlan cr Wiki
Jump to navigation Jump to search
(Created page with "= Duration long tail = show cut off by query time out. <source lang='sql'> SELECT duration,nq.name FROM QueryStats qs JOIN NamedQuery nq ON qs.query_id=nq.query_id WHERE nq....")
 
Line 9: Line 9:
 
ORDER BY 1 DESC
 
ORDER BY 1 DESC
 
</source>
 
</source>
 +
named query query_failures_by_category:
 +
 +
sql:
 +
SELECT
 +
count(*) as count,
 +
nq.domain,
 +
nq.namespace,
 +
error_category
 +
FROM QueryStats qs
 +
JOIN NamedQuery nq
 +
ON qs.query_id=nq.query_id
 +
WHERE error_category IS NOT NULL
 +
 +
GROUP BY error_category,nq.namespace,nq.domain
 +
ORDER BY 1 DESC
 +
 +
== query_failures_by_category ==
 +
 +
=== query ===
 +
<source lang='sql'>
 +
SELECT
 +
count(*) as count,
 +
nq.domain,
 +
nq.namespace,
 +
error_category
 +
FROM QueryStats qs
 +
JOIN NamedQuery nq
 +
ON qs.query_id=nq.query_id
 +
WHERE error_category IS NOT NULL
 +
 +
GROUP BY error_category,nq.namespace,nq.domain
 +
ORDER BY 1 DESC
 +
 +
</source>
 +
 +
 +
=== result ===
 +
{| class="wikitable" style="text-align: left;"
 +
|+ <!-- caption -->
 +
|-
 +
! align="right"|  count !! domain                    !! namespace          !! error_category
 +
|-
 +
| align="right"|    2044 || scholia.toolforge.org    || named_queries      || Syntax Error
 +
|-
 +
| align="right"|    788 || wikidata.org              || examples          || Syntax Error
 +
|-
 +
| align="right"|    624 || wikidata.org              || examples          || EndPointInternalError
 +
|-
 +
| align="right"|    612 || qlever.cs.uni-freiburg.de || issues.wikidata    || Syntax Error
 +
|-
 +
| align="right"|    242 || wikidata.org              || short_url          || EndPointInternalError
 +
|-
 +
| align="right"|    208 || wikidata.org              || short_url          || Syntax Error
 +
|-
 +
| align="right"|    180 || wikidata.org              || examples          || Timeout
 +
|-
 +
| align="right"|    148 || qlever.cs.uni-freiburg.de || issues.wikidata    || Timeout
 +
|-
 +
| align="right"|    140 || scholia.toolforge.org    || named_queries      || EndPointInternalError
 +
|-
 +
| align="right"|    102 || ceur-ws.org              || challenge          || Syntax Error
 +
|-
 +
| align="right"|      74 || qlever.cs.uni-freiburg.de || issues.wikidata    || EndPointInternalError
 +
|-
 +
| align="right"|      46 || ceur-ws.org              || challenge          || EndPointInternalError
 +
|-
 +
| align="right"|      42 || wikidata.org              || short_url          || Timeout
 +
|-
 +
| align="right"|      28 || scholia.toolforge.org    || named_queries      || Other
 +
|-
 +
| align="right"|      26 || qlever.cs.uni-freiburg.de || issues.wikidata    || Service Unavailable
 +
|-
 +
| align="right"|      24 || wikidata.org              || examples          || Other
 +
|-
 +
| align="right"|      24 || scholia.toolforge.org    || named_queries      || Timeout
 +
|-
 +
| align="right"|      20 || wikidata.org              || examples          || Service Unavailable
 +
|-
 +
| align="right"|      20 || qlever.cs.uni-freiburg.de || performance-dblp  || Syntax Error
 +
|-
 +
| align="right"|      18 || wikidata.org              || short_url          || Service Unavailable
 +
|-
 +
| align="right"|      16 || bitplan.com              || federated-queries  || Syntax Error
 +
|-
 +
| align="right"|      14 || scholia.toolforge.org    || named_queries      || Service Unavailable
 +
|-
 +
| align="right"|      12 || bitplan.com              || federated-queries  || EndPointInternalError
 +
|-
 +
| align="right"|      12 || scholia.toolforge.org    || named_queries      || Too Many Requests
 +
|-
 +
| align="right"|      5 || wikidata.org              || snapquery-examples || Timeout
 +
|-
 +
| align="right"|      4 || wikidata.org              || snapquery-examples || EndPointInternalError
 +
|-
 +
| align="right"|      4 || wikidata.org              || examples          || Too Many Requests
 +
|-
 +
| align="right"|      2 || qlever.cs.uni-freiburg.de || issues.wikidata    || Authorization Error
 +
|-
 +
| align="right"|      2 || ceur-ws.org              || challenge          || Other
 +
|-
 +
| align="right"|      2 || qlever.cs.uni-freiburg.de || issues.wikidata    || Other
 +
|-
 +
| align="right"|      2 || ceur-ws.org              || challenge          || Service Unavailable
 +
|-
 +
| align="right"|      2 || qlever.cs.uni-freiburg.de || performance-dblp  || Service Unavailable
 +
|-
 +
| align="right"|      2 || qlever.cs.uni-freiburg.de || issues.wikidata    || Too Many Requests
 +
|-
 +
| align="right"|      2 || wikidata.org              || short_url          || Too Many Requests
 +
|}

Revision as of 10:54, 10 July 2024

Duration long tail

show cut off by query time out. 

SELECT duration,nq.name
FROM QueryStats qs
JOIN NamedQuery nq 
ON qs.query_id=nq.query_id
WHERE nq.domain="wikidata.org"
ORDER BY 1 DESC

named query query_failures_by_category:

sql: SELECT count(*) as count, nq.domain, nq.namespace, error_category FROM QueryStats qs JOIN NamedQuery nq ON qs.query_id=nq.query_id WHERE error_category IS NOT NULL

GROUP BY error_category,nq.namespace,nq.domain ORDER BY 1 DESC

query_failures_by_category

query

SELECT 
count(*) as count,
nq.domain,
nq.namespace,
error_category
FROM QueryStats qs
JOIN NamedQuery nq
ON qs.query_id=nq.query_id
WHERE error_category IS NOT NULL 

GROUP BY error_category,nq.namespace,nq.domain
ORDER BY 1 DESC


result

count domain namespace error_category
2044 scholia.toolforge.org named_queries Syntax Error
788 wikidata.org examples Syntax Error
624 wikidata.org examples EndPointInternalError
612 qlever.cs.uni-freiburg.de issues.wikidata Syntax Error
242 wikidata.org short_url EndPointInternalError
208 wikidata.org short_url Syntax Error
180 wikidata.org examples Timeout
148 qlever.cs.uni-freiburg.de issues.wikidata Timeout
140 scholia.toolforge.org named_queries EndPointInternalError
102 ceur-ws.org challenge Syntax Error
74 qlever.cs.uni-freiburg.de issues.wikidata EndPointInternalError
46 ceur-ws.org challenge EndPointInternalError
42 wikidata.org short_url Timeout
28 scholia.toolforge.org named_queries Other
26 qlever.cs.uni-freiburg.de issues.wikidata Service Unavailable
24 wikidata.org examples Other
24 scholia.toolforge.org named_queries Timeout
20 wikidata.org examples Service Unavailable
20 qlever.cs.uni-freiburg.de performance-dblp Syntax Error
18 wikidata.org short_url Service Unavailable
16 bitplan.com federated-queries Syntax Error
14 scholia.toolforge.org named_queries Service Unavailable
12 bitplan.com federated-queries EndPointInternalError
12 scholia.toolforge.org named_queries Too Many Requests
5 wikidata.org snapquery-examples Timeout
4 wikidata.org snapquery-examples EndPointInternalError
4 wikidata.org examples Too Many Requests
2 qlever.cs.uni-freiburg.de issues.wikidata Authorization Error
2 ceur-ws.org challenge Other
2 qlever.cs.uni-freiburg.de issues.wikidata Other
2 ceur-ws.org challenge Service Unavailable
2 qlever.cs.uni-freiburg.de performance-dblp Service Unavailable
2 qlever.cs.uni-freiburg.de issues.wikidata Too Many Requests
2 wikidata.org short_url Too Many Requests
Retrieved from "https://cr.bitplan.com/index.php?title=Snapquery_Evaluation_2024-07&oldid=2435"