Query to fetch sample of cirrussearch hastemplate requests from hive logs
ActivePublic
Actions

Authored by EBernhardson on Feb 7 2020, 1:54 AM.

Tags

None

Referenced Files

	F31553042: raw.txt
	Feb 7 2020, 1:54 AM

Subscribers

None

	select mediawiki_host, elasticsearch_requests[0].query
	from event.mediawiki_cirrussearch_request
	where year=2020 and month=2 and day=2 and hour=2 and
	array_contains(elasticsearch_requests[0].syntax, "hastemplate")
	distribute by rand()
	sort by rand()
	limit 500;

Query to fetch sample of cirrussearch hastemplate requests from hive logsActivePublicActions