Hi Analytics people,

Three new fields are available in the hive table wmf.webrequest (as per the documentation):

user_agent_map      	map<string,string>  	User-agent map with browser_name, browser_major, device, os_name, os_minor, os_major keys and associated values
x_analytics_map     	map<string,string>  	X_analytics map view of the x_analytics field
webrequest_source   	string              	Source cluster

You can access map values using this syntax: user_agent_map['browser_name'].

Documentation has been updated here: https://wikitech.wikimedia.org/wiki/Analytics/Data/Webrequest

Enjoy :)

--

Joseph Allemandou

Data Engineer @ Wikimedia Foundation

IRC: joal