Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F34496830
raw-paste-data.txt
No One
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
Urbanecm
Jun 12 2021, 6:29 PM
2021-06-12 18:29:20 (UTC+0)
Size
750 B
Referenced Files
None
Subscribers
None
raw-paste-data.txt
View Options
SELECT
day, COUNT(*)
FROM event.mediawiki_api_request
WHERE
year=2021 AND
month=6 AND
day IN (9,10,11) AND
http.request_headers['user-agent'] LIKE "IABot/2.0%"
GROUP BY day
ORDER BY COUNT(*) DESC;
spark-sql (default)> SELECT
> day, COUNT(*)
> FROM event.mediawiki_api_request
> WHERE
> year=2021 AND
> month=6 AND
> day IN (9,10,11) AND
> http.request_headers['user-agent'] LIKE "IABot/2.0%"
> GROUP BY day
> ORDER BY day ASC;
day count(1)
9 9083927
10 9634733
11 10150667
Time taken: 119.645 seconds, Fetched 3 row(s)
File Metadata
Details
Attached
Mime Type
text/plain; charset=utf-8
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
9098749
Default Alt Text
raw-paste-data.txt (750 B)
Attached To
Mode
P16433 (An Untitled Masterwork)
Attached
Detach File
Event Timeline
Log In to Comment