Page MenuHomePhabricator
Paste P13106

(An Untitled Masterwork)
ActivePublic

Authored by EBernhardson on Oct 29 2020, 8:32 PM.
Tags
None
Referenced Files
F32418973: raw-paste-data.txt
Oct 29 2020, 8:32 PM
Subscribers
None
0: jdbc:hive2://an-coord1001.eqiad.wmnet:1000> select year, month, day, count(distinct event.searchSessionId) as num_sessions, count(distinct trim(regexp_replace(regexp_replace(lower(even
t.query), '[\\s\\p{Punct}]', ' '), ' +', ' '))) as num_norm_query from event.SearchSatisfaction where event.source == 'fulltext' and event.action == 'searchResultPage' and
year = 2020 and month = 10 and day >= 10 and day < 20 and wiki == 'enwiki' group by year, month, day order by year, month, day limit 1000;
...
year month day num_sessions num_norm_query
2020 10 10 311762 479951
2020 10 11 331902 508682
2020 10 12 416708 620838
2020 10 13 418413 630173
2020 10 14 408218 624146
2020 10 15 402864 600253
2020 10 16 379586 570068
2020 10 17 311356 480712
2020 10 18 333888 515529
2020 10 19 425513 636372