View source for Wikidata Import 2018-01-05

{{Import
}}
= First Attempt 2018-01 =
The start of this attempt was on 2018-01-05. 

I tried to follow the procedure at:
* https://github.com/wikimedia/wikidata-query-rdf/blob/master/docs/getting-started.md
<source lang='bash'>
~/wikidata/wikidata-query-rdf/dist/target/service-0.3.0-SNAPSHOT$nohup ./munge.sh -f data/latest-all.ttl.gz -d data/split -l en,de &
#logback.classic pattern: %d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n
08:23:02.391 [main] INFO  org.wikidata.query.rdf.tool.Munge - Switching to data/split/wikidump-000000001.ttl.gz
08:24:21.249 [main] INFO  org.wikidata.query.rdf.tool.Munge - Processed 10000 entities at (105, 47, 33)
08:25:07.369 [main] INFO  org.wikidata.query.rdf.tool.Munge - Processed 20000 entities at (162, 70, 41)
08:25:56.862 [main] INFO  org.wikidata.query.rdf.tool.Munge - Processed 30000 entities at (186, 91, 50)
08:26:43.594 [main] INFO  org.wikidata.query.rdf.tool.Munge - Processed 40000 entities at (203, 109, 59)
08:27:24.042 [main] INFO  org.wikidata.query.rdf.tool.Munge - Processed 50000 entities at (224, 126, 67)
...
</source>
<source lang='bash'>
java.nio.file.NoSuchFileException: ./mwservices.json
</source>

== Import issues ==
* https://phabricator.wikimedia.org/T164773
* https://phabricator.wikimedia.org/p/Yurik/
* https://www.mediawiki.org/wiki/User:AKlapper_(WMF)
== Success ==
With the use of a 512 GByte SSD disk and carefully monitoring the progress of the import the import succeeded after some 3.8 days.

== Queries after import ==
=== Number of Triples ===
<source lang='sparql' highlight='1'>
SELECT (COUNT(*) as ?Triples) WHERE { ?s ?p ?o}
Triples
3.019.914.549
</source>
[https://query.wikidata.org/#SELECT%20%28COUNT%28%2a%29%20as%20%3FTriples%29%20WHERE%20%7B%20%3Fs%20%3Fp%20%3Fo%7D try it on original WikiData Query Service!]
Result as of 2020-07-17
<pre>
Triples
11308353390
</pre>

Result as of 2022-01-28
<pre>13.598.333.948</pre>

=== TypeCount ===
<source lang='sparql' highlight='1-7>
SELECT ?type (COUNT(?type) AS ?typecount)
WHERE {
  ?subject a ?type.
}
GROUP by ?type
ORDER by desc(?typecount)
LIMIT 7
<http://wikiba.se/ontology#BestRank>	369637917
schema:Article	61229687
<http://wikiba.se/ontology#GlobecoordinateValue>	5379022
<http://wikiba.se/ontology#QuantityValue>	697187
<http://wikiba.se/ontology#TimeValue>	234556
<http://wikiba.se/ontology#GeoAutoPrecision>	101897
<http://www.wikidata.org/prop/novalue/P17>	37884
</source>