Hello 

I have some problem request , about refine_webrequest.hql 

In this file timestamp is use utc ? 

This file is it connect wmf_raw.webrequest and wmf.webrequest ?

Because i can't read the code have add Z / +/- zone time

 -- Hack to get a correct timestamp because of hive inconsistent conversion

 CAST(unix_timestamp(dt, "yyyy-MM-dd'T'HH:mm:ss") * 1.0 as timestamp) as ts,

https://github.com/wikimedia/analytics-refinery/blob/master/oozie/webrequest/load/refine_webrequest.hql

I emailed wiki legal request 3 month they not sure , can you clearly ask me .

If not use utc, is use your server clock or  , my computer clock?