Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P10327
Query to fetch sample of cirrussearch hastemplate requests from hive logs
Active
Public
Actions
Authored by
EBernhardson
on Feb 7 2020, 1:54 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F31553042: raw.txt
Feb 7 2020, 1:54 AM
2020-02-07 01:54:12 (UTC+0)
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;
Event Timeline
EBernhardson
created this paste.
Feb 7 2020, 1:54 AM
2020-02-07 01:54:12 (UTC+0)
Log In to Comment