dcausse assigned this task to JAllemandou.
dcausse added a subscriber: JAllemandou.
dcausse added a comment.
@JAllemandou did some work and could extract some numbers from a dump
imported to hadoop:
SELECT ?property (COUNT(*) AS ?count) WHERE {
?statement ps:P20 ?unknown.
FILTER(ISBLANK(?unknown))
?statement ?pq ?qualifier.
?property wikibase:qualifier ?pq.
}
GROUP BY ?property
ORDER BY DESC(?count)
+------------------------------------+-----+
|s1 |count|
+------------------------------------+-----+
|http://www.wikidata.org/entity/P1319|7 |
|http://www.wikidata.org/entity/P17 |5 |
|http://www.wikidata.org/entity/P131 |4 |
|http://www.wikidata.org/entity/P1476|1 |
+------------------------------------+-----+
SELECT ?mainProperty ?qualifierProperty (COUNT(*) AS ?count) WHERE {
?mainProperty wikibase:claim ?p;
wikibase:statementProperty ?ps.
?qualifierProperty wikibase:qualifier ?pq.
?subject ?p ?statement.
?statement ?ps ?unknown. FILTER(isBlank(?unknown))
?statement ?pq ?qualifier.
}
GROUP BY ?mainProperty ?qualifierProperty
+------------------------------------+------------------------------------+-----+
|mp |qp
|count|
+------------------------------------+------------------------------------+-----+
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P1810|77855|
|http://www.wikidata.org/entity/P123
|http://www.wikidata.org/entity/P1932|56081|
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P459
|29573|
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P3519|24827|
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P3382|15795|
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P352
|9593 |
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P2926|7310
|
|http://www.wikidata.org/entity/P570
|http://www.wikidata.org/entity/P1319|4143 |
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P973
|2233 |
|http://www.wikidata.org/entity/P98
|http://www.wikidata.org/entity/P1932|2192 |
|http://www.wikidata.org/entity/P98
|http://www.wikidata.org/entity/P1545|1630 |
|http://www.wikidata.org/entity/P393
|http://www.wikidata.org/entity/P1932|1356 |
|http://www.wikidata.org/entity/P110
|http://www.wikidata.org/entity/P1932|1334 |
|http://www.wikidata.org/entity/P110
|http://www.wikidata.org/entity/P1545|1302 |
|http://www.wikidata.org/entity/P559 |http://www.wikidata.org/entity/P131
|957 |
|http://www.wikidata.org/entity/P655
|http://www.wikidata.org/entity/P1932|952 |
|http://www.wikidata.org/entity/P655
|http://www.wikidata.org/entity/P1545|879 |
|http://www.wikidata.org/entity/P570
|http://www.wikidata.org/entity/P1326|864 |
|http://www.wikidata.org/entity/P569
|http://www.wikidata.org/entity/P1326|690 |
|http://www.wikidata.org/entity/P5202|http://www.wikidata.org/entity/P1932|627
|
|http://www.wikidata.org/entity/P5202|http://www.wikidata.org/entity/P1545|615
|
|http://www.wikidata.org/entity/P50
|http://www.wikidata.org/entity/P1932|542 |
|http://www.wikidata.org/entity/P569
|http://www.wikidata.org/entity/P1319|384 |
|http://www.wikidata.org/entity/P2093|http://www.wikidata.org/entity/P1545|380
|
|http://www.wikidata.org/entity/P1343|http://www.wikidata.org/entity/P3523|369
|
|http://www.wikidata.org/entity/P571
|http://www.wikidata.org/entity/P1326|336 |
|http://www.wikidata.org/entity/P571
|http://www.wikidata.org/entity/P1319|273 |
|http://www.wikidata.org/entity/P3872|http://www.wikidata.org/entity/P137
|223 |
|http://www.wikidata.org/entity/P3872|http://www.wikidata.org/entity/P580
|206 |
|http://www.wikidata.org/entity/P3872|http://www.wikidata.org/entity/P582
|206 |
|http://www.wikidata.org/entity/P26 |http://www.wikidata.org/entity/P580
|199 |
|http://www.wikidata.org/entity/P816 |http://www.wikidata.org/entity/P817
|192 |
|http://www.wikidata.org/entity/P921
|http://www.wikidata.org/entity/P1545|158 |
|http://www.wikidata.org/entity/P816
|http://www.wikidata.org/entity/P1107|139 |
|http://www.wikidata.org/entity/P2679|http://www.wikidata.org/entity/P1932|137
|
|http://www.wikidata.org/entity/P3383|http://www.wikidata.org/entity/P805
|135 |
|http://www.wikidata.org/entity/P921
|http://www.wikidata.org/entity/P1559|131 |
|http://www.wikidata.org/entity/P625 |http://www.wikidata.org/entity/P828
|126 |
|http://www.wikidata.org/entity/P629 |http://www.wikidata.org/entity/P407
|114 |
|http://www.wikidata.org/entity/P1181|http://www.wikidata.org/entity/P2241|101
|
|http://www.wikidata.org/entity/P2679|http://www.wikidata.org/entity/P1545|100
|
full list here <https://phabricator.wikimedia.org/P10540$200>
For future reference the technique used was to manually transpile the sparql
into spark joins, see P10540 <https://phabricator.wikimedia.org/P10540>.
Since we did not know what to expect it was to assert the validity of the
results but results from query one are found in the output of the generalized
query.
TASK DETAIL
https://phabricator.wikimedia.org/T246238
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: JAllemandou, dcausse
Cc: JAllemandou, Lea_Lacroix_WMDE, Gehel, Aklapper, dcausse, Igorkim78,
Lucas_Werkmeister_WMDE, Jheald, darthmon_wmde, Nandana, Lahi, Gq86,
GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, rosalieper,
Scott_WUaS, Jonas, Xmlizer, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude,
Tobias1984, Manybubbles, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
