Analytics/Cluster/Hive/Queries/Wikidata
Special:EntityData calls per user agent in a given hour
SELECT
count(*) as count, user_agent
FROM
webrequest
WHERE
year = 2015
AND month = 10
AND day = 12
AND hour = 1
AND uri_host = "www.wikidata.org"
AND http_status = 200
AND http_method = "GET"
AND uri_path LIKE "/wiki/Special:EntityData%"
GROUP BY user_agent
ORDER BY count
LIMIT 999999;