Hi Analytics people,

Today happens another bunch of addition to the refined webrequest table in hive.

Now the table contains:

ts - The unix timestamp (milliseconds) version of the dt date
access_method - The method used to access the site, being one of the three [mobile app | mobile web | desktop]
agent_type - To differentiate easily between spiders and users (more values may be added later).

These additions are based on the "tags", as defined here: https://meta.wikimedia.org/wiki/Research:Page_view

Have a good weekend !

Joseph Allemandou

Data Engineer @ Wikimedia Foundation

IRC: joal