(An Untitled Masterwork)
ActivePublic
Actions

Authored by Urbanecm on Jun 12 2021, 6:29 PM.

Tags

None

Referenced Files

	F34496830: raw-paste-data.txt
	Jun 12 2021, 6:29 PM

Subscribers

None

	SELECT
	day, COUNT(*)
	FROM event.mediawiki_api_request
	WHERE
	year=2021 AND
	month=6 AND
	day IN (9,10,11) AND
	http.request_headers['user-agent'] LIKE "IABot/2.0%"
	GROUP BY day
	ORDER BY COUNT(*) DESC;

	spark-sql (default)> SELECT
	> day, COUNT(*)
	> FROM event.mediawiki_api_request
	> WHERE
	> year=2021 AND
	> month=6 AND
	> day IN (9,10,11) AND
	> http.request_headers['user-agent'] LIKE "IABot/2.0%"
	> GROUP BY day
	> ORDER BY day ASC;
	day count(1)
	9 9083927
	10 9634733
	11 10150667
	Time taken: 119.645 seconds, Fetched 3 row(s)

(An Untitled Masterwork)ActivePublicActions