Page MenuHomePhabricator
Paste P5443

Data Lake query—no results
ActivePublic

Authored by nshahquinn-wmf on May 13 2017, 6:38 AM.
Tags
None
Referenced Files
F8059106: Data Lake query—no results
May 13 2017, 6:38 AM
Subscribers
None
select event_user_text_latest, count(*) as talk_creations
from wmf.mediawiki_history
where
snapshot = "2017-04" and
wiki_db = "kowiki" and
event_entity = "revision" and
event_type = "create" and
revision_parent_id = 0 and
page_namespace = 3 and
event_timestamp > "201611"
group by event_user_text_latest