Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Paste
P5443
Data Lake query—no results
Active
Public
Actions
Authored by
nshahquinn-wmf
on May 13 2017, 6:38 AM.
Edit Paste
Archive Paste
View Raw File
Subscribe
Mute Notifications
Award Token
Flag For Later
Tags
None
Referenced Files
F8059106: Data Lake query—no results
May 13 2017, 6:38 AM
2017-05-13 06:38:26 (UTC+0)
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
Event Timeline
nshahquinn-wmf
created this paste.
May 13 2017, 6:38 AM
2017-05-13 06:38:26 (UTC+0)
Log In to Comment