JAllemandou added a comment.
Hi @Lea_WMDE and @GoranSMilovanovic - I think the answer the your problem is
solved in this month snapshot with the `revision_tags` field of
mediawiki_history:
spark.sql("""
SELECT
substr(event_timestamp, 0, 4) as year,
array_contains(revision_tags, 'mobile edit') as mobile,
array_contains(revision_tags, 'mobile app edit') as mobile_app,
count(1) as c
FROM wmf.mediawiki_history
WHERE snapshot = '2019-04'
AND wiki_db = 'wikidatawiki'
AND event_entity = 'revision'
GROUP BY
substr(event_timestamp, 0, 4),
array_contains(revision_tags, 'mobile edit'),
array_contains(revision_tags, 'mobile app edit')
ORDER BY year, mobile, mobile_app desc
""").show(100, false)
+----+------+----------+---------+
|year|mobile|mobile_app|c |
+----+------+----------+---------+
|2004|null |null |146 |
|2005|null |null |495 |
|2006|null |null |1838 |
|2007|null |null |2814 |
|2008|null |null |2384 |
|2009|null |null |2175 |
|2010|null |null |1650 |
|2011|null |null |1354 |
|2012|null |null |2912961 |
|2012|false |false |4 |
|2013|null |null |94142292 |
|2013|false |false |181133 |
|2014|null |null |69236941 |
|2014|false |true |2 |
|2014|false |false |18174243 |
|2014|true |false |51 |
|2015|null |null |76088107 |
|2015|false |true |586 |
|2015|false |false |26269493 |
|2015|true |false |4058 |
|2016|null |null |82178134 |
|2016|false |false |53308675 |
|2016|true |true |618 |
|2016|true |false |24248 |
|2017|null |null |109041593|
|2017|false |false |83147234 |
|2017|true |true |114906 |
|2017|true |false |49836 |
|2018|null |null |141536855|
|2018|false |false |67149958 |
|2018|true |true |186065 |
|2018|true |false |71822 |
|2019|null |null |55814156 |
|2019|false |false |49994060 |
|2019|true |true |85968 |
|2019|true |false |23867 |
+----+------+----------+---------+
TASK DETAIL
https://phabricator.wikimedia.org/T220977
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: GoranSMilovanovic, JAllemandou
Cc: JAllemandou, Milimetric, RazShuty, Lea_WMDE, Aklapper, darthmon_wmde,
alaa_wmde, Nandana, Lahi, Gq86, GoranSMilovanovic, QZanden, LawExplorer,
_jensen, rosalieper, Wikidata-bugs, aude, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
