Page MenuHomePhabricator
Paste P10327

Query to fetch sample of cirrussearch hastemplate requests from hive logs

Authored by EBernhardson on Fri, Feb 7, 1:54 AM.
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;

Event Timeline