Paste P5834

Hive query for userAgents of wbeditentity passing a clear parameter in July 2017
ActivePublic
Actions

Authored by Addshore on Aug 1 2017, 10:28 AM.

Tags

None

Referenced Files

	F8921739: Hive query for userAgents of wbeditentity passing a clear parameter in July 2017
	Aug 1 2017, 10:28 AM

Subscribers

None

	SELECT
	count(*) as count, userAgent
	FROM wmf_raw.apiaction
	WHERE wiki = "wikidatawiki"
	AND array_contains(map_keys(params),'action')
	AND params["action"] = "wbeditentity"
	AND array_contains(map_keys(params),'clear')
	AND year = 2017
	AND month = 7
	GROUP BY userAgent
	ORDER BY count
	LIMIT 999999;

Event Timeline

Addshore created this paste.Aug 1 2017, 10:28 AM

Addshore mentioned this in T172100: get list of users of API module wbeditentity with clear flag.Aug 1 2017, 10:31 AM