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