The spark job ScholarlyArticleSplitter should be generalized to support the general case with n subgraphs, a wider variety of rules and stubs.
AC:
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T335067 Epic: Wikidata Query Service stabilization | |||
| Open | None | T337013 [Epic] Splitting the graph in WDQS | |||
| Resolved | • dcausse | T362060 Generalize ScholarlyArticleSplitter |
Change #1019052 had a related patch set uploaded (by DCausse; author: DCausse):
[wikidata/query/rdf@master] Generalize ScholarlyArticleSplitter
I kicked off a run using the current version of the patch with the following command and backing table, and its status should be able to be followed here: https://yarn.wikimedia.org/cluster/app/application_1713178047802_16409
So long as I haven't made an error somewhere in here that produces a runtime exception (e.g., pathing), we should be able to see after a couple hours how it's going.
spark3-submit --master yarn --driver-cores 2 --conf spark.sql.autoBroadcastJoinThreshold=-1 --conf spark.dynamicAllocation.maxExecutors=128 --conf spark.sql.shuffle.partitions=512 --conf spark.executor.memoryOverhead=4g --executor-cores 4 --executor-memory 12g --driver-memory 16g --name scholarly_article_split_manual__scholarly_article_split_triples__T362060_personal_namespace --conf spark.yarn.maxAppAttempts=1 --class org.wikidata.query.rdf.spark.transform.structureddata.dumps.ScholarlyArticleSplit --deploy-mode cluster /home/dr0ptp4kt/rdf-spark-tools-0.3.138-SNAPSHOT-jar-with-dependencies-T362060.jar --input-table-partition-spec discovery.wikibase_rdf_t337013/date=20231016/wiki=wikidata --output-table-partition-spec dr0ptp4kt.wikibase_rdf_scholarly_split_T362060/snapshot=20231016/wiki=wikidata
Here was the manual table creation I did while useing the dr0ptp4kt namespace.
CREATE TABLE IF NOT EXISTS dr0ptp4kt.wikibase_rdf_scholarly_split_T362060 ( `subject` string, `predicate` string, `object` string, `context` string ) PARTITIONED BY ( `snapshot` string, `wiki` string, `scope` string ) STORED AS PARQUET LOCATION 'hdfs://analytics-hadoop/user/dr0ptp4kt/wikibase_rdf_scholarly_split_T362060/wikidata/rdf_scholarly_split_T362060/' ;
Running time
Total Uptime: 55 min
This was faster than in T347989#9335980. Nice!
Counts
To be discussed in code review.
Samples
These look similar to about what we'd expect based on T347989#9346038 .
select "| " || concat_ws(" | ", subject, predicate, object, context) from dr0ptp4kt.wikibase_rdf_scholarly_split_t362060 where snapshot = '20231016' and wiki = 'wikidata' and scope = 'scholarly_articles' and rand() <= (30/7643858365) distribute by rand() sort by rand() limit 30;
select "| " || concat_ws(" | ", subject, predicate, object, context) from dr0ptp4kt.wikibase_rdf_scholarly_split_t362060 where snapshot = '20231016' and wiki = 'wikidata' and scope = 'wikidata_main' and rand() <= (30/7677112695) distribute by rand() sort by rand() limit 30;
Note the denominator here for the random function is slightly off because of copy-paste (it should have been 7677110614 instead of 7677112695), but the output gives a rough idea, anyway.
Change #1020871 had a related patch set uploaded (by DCausse; author: DCausse):
[wikidata/query/rdf@master] Split based on subgraph rules
Change #1024414 had a related patch set uploaded (by DCausse; author: DCausse):
[wikidata/query/rdf@master] ScholarlyArticleSplit: add support for stubs
Change #1019052 merged by jenkins-bot:
[wikidata/query/rdf@master] Generalize ScholarlyArticleSplitter
Change #1020871 merged by jenkins-bot:
[wikidata/query/rdf@master] Split based on subgraph rules
Change #1024414 merged by jenkins-bot:
[wikidata/query/rdf@master] ScholarlyArticleSplit: add support for stubs