Analytics/Systems/Cluster/Hive/Queries/Wikidata

From Wikitech
< Analytics‎ | Systems‎ | Cluster‎ | Hive‎ | Queries
Jump to: navigation, search

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;