Difference between revisions of "Wikidata Import 2023-05-05"

From BITPlan Wiki
Jump to navigation Jump to search
Line 76: Line 76:
 
...
 
...
 
20:10:35.985 [org.wikidata.query.rdf.tool.rdf.AsyncRDFHandler$RDFActionsReplayer] INFO  o.w.q.r.t.r.EntityMungingRdfHandler - Processed 105840000 entities at (2251, 1708, 1420)
 
20:10:35.985 [org.wikidata.query.rdf.tool.rdf.AsyncRDFHandler$RDFActionsReplayer] INFO  o.w.q.r.t.r.EntityMungingRdfHandler - Processed 105840000 entities at (2251, 1708, 1420)
 +
</source>
 +
= Loading =
 +
== move files to split directory ==
 +
We didn't quite follow the getting started - so fix the location of the munged files
 +
<source lang='bash'>
 +
mkdir split
 +
wikidata/data$ mv wiki* split
 
</source>
 
</source>

Revision as of 07:41, 7 May 2023

Download ~6h:30

Download Options

https://dumps.wikimedia.org/wikidatawiki/entities

dcatap.rdf                                         04-May-2023 18:19               84753
latest-all.json.bz2                                03-May-2023 21:06         81640390615
latest-all.json.gz                                 03-May-2023 12:47        123885468527
latest-all.nt.bz2                                  04-May-2023 16:07        158382342866
latest-all.nt.gz                                   03-May-2023 22:23        205171447838
latest-all.ttl.bz2                                 04-May-2023 03:24        101606862077
latest-all.ttl.gz                                  03-May-2023 17:08        124093922794
latest-lexemes.json.bz2                            03-May-2023 03:53           305234182
latest-lexemes.json.gz                             03-May-2023 03:51           416121890
latest-lexemes.nt.bz2                              28-Apr-2023 23:34           778797047
latest-lexemes.nt.gz                               28-Apr-2023 23:29          1019519966
latest-lexemes.ttl.bz2                             28-Apr-2023 23:30           440519100
latest-lexemes.ttl.gz                              28-Apr-2023 23:26           548481488
latest-truthy.nt.bz2                               28-Apr-2023 22:23         36023954950
latest-truthy.nt.gz                                28-Apr-2023 19:07         59758277315

download script

cat download.sh 
#/bin/bash
# WF 2023-04-26
# download wikidata dumps
baseurl=https://dumps.wikimedia.org/wikidatawiki/entities/
for file in latest-all latest-lexemes
do
  for ext in ttl.bz2
  do
    url=$baseurl/$file.$ext
    log=$file-$ext.log
    nohup wget $url >> $log&
  done
done

Download logs

--2023-05-05 08:09:14--  https://dumps.wikimedia.org/wikidatawiki/entities//latest-all.ttl.bz2
Resolving dumps.wikimedia.org (dumps.wikimedia.org)... 208.80.154.142, 2620:0:861:2:208:80:154:142
Connecting to dumps.wikimedia.org (dumps.wikimedia.org)|208.80.154.142|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 101606862077 (95G) [application/octet-stream]
Saving to: ‘latest-all.ttl.bz2’

     0K .......... .......... .......... .......... ..........  0%  400K 2d20h
    50K .......... .......... .......... .......... ..........  0%  222K 4d0h
   100K .......... .......... .......... .......... ..........  0%  399K 3d15h
99225450K .                                                     100% 2.32T=6h50m

2023-05-05 15:00:04 (3.93 MB/s) - ‘latest-all.ttl.bz2’ saved [101606862077/101606862077]

Munging ~29 h

Preparation

see Wikidata_Import_2023-04-26#Preparation_.7E20-30_min

calling munge.sh

domunge.sh

#!/bin/bash
# WF 2023-04-29
# start munge in background
bzcat latest-all.ttl.bz2 | service/munge.sh -f - -d data -- --skolemize

start domunge.sh and show nohup.out log

nohup ./domunge.sh &
tail -f  nohup.out
#logback.classic pattern: %d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n
15:51:26.169 [org.wikidata.query.rdf.tool.rdf.AsyncRDFHandler$RDFActionsReplayer] INFO  org.wikidata.query.rdf.tool.Munge - Switching to data/wikidump-000000001.ttl.gz
...
07:25:27.152 [org.wikidata.query.rdf.tool.rdf.AsyncRDFHandler$RDFActionsReplayer] INFO  o.w.q.r.t.r.EntityMungingRdfHandler - Processed 57640000 entities at (751, 658, 702)
...
20:10:35.985 [org.wikidata.query.rdf.tool.rdf.AsyncRDFHandler$RDFActionsReplayer] INFO  o.w.q.r.t.r.EntityMungingRdfHandler - Processed 105840000 entities at (2251, 1708, 1420)

Loading

move files to split directory

We didn't quite follow the getting started - so fix the location of the munged files

mkdir split
wikidata/data$ mv wiki* split