AndrewTavis_WMDE added a comment.
The above `LATERAL VIEW EXPLODE` method came up with `40,529,640` scholarly articles via the claims, @dcausse. I think that that's close enough to the amount from `discovery.wikibase_rdf` that we don't need to dig more into expanding the `WHERE` clause :) Thanks again for your help! For the call we have later today - just as a reminder to myself to ask you as well - let me know if you have an idea for why the claims column output is different based on Presto or Spark being used. TASK DETAIL https://phabricator.wikimedia.org/T342111 EMAIL PREFERENCES https://phabricator.wikimedia.org/settings/panel/emailpreferences/ To: AndrewTavis_WMDE Cc: mpopov, JAllemandou, Lydia_Pintscher, dcausse, Gehel, dr0ptp4kt, AndrewTavis_WMDE, Aklapper, Manuel, Danny_Benjafield_WMDE, Astuthiodit_1, karapayneWMDE, Invadibot, maantietaja, ItamarWMDE, Akuckartz, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer, _jensen, rosalieper, Scott_WUaS, Wikidata-bugs, aude, Mbch331
_______________________________________________ Wikidata-bugs mailing list -- wikidata-bugs@lists.wikimedia.org To unsubscribe send an email to wikidata-bugs-le...@lists.wikimedia.org