AndrewTavis_WMDE added a comment.
@Manuel, just a note on using the `wmf.webrequest` table: now that I'm using
Spark a bit more and can see the number of steps, it's definitely worth it to
try to restrict the data based on the year and month as we're doing. Selecting
30 days over two months takes dramatically longer than if we set the month
column in the `WHERE` clause - roughly three times longer based on number of
steps.
Some bad news, the following query returns no distinct values for the
`ch_ua_mobile` column:
SELECT
DISTINCT(ch_ua_mobile) AS ch_ua_mobile_values
FROM
wmf.webrequest
WHERE
year = 2023
AND month = 7
AND '2023-07-01' <= dt
AND dt < '2023-08-01'
AND uri_host = 'www.wikidata.org'
I've asked in `working-with-data` as we discussed :)
TASK DETAIL
https://phabricator.wikimedia.org/T336361
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: AndrewTavis_WMDE
Cc: AndrewTavis_WMDE, Michael, Manuel, Aklapper, 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
