988472 - Access to peach-gw.peach.metrics.scl3.mozilla.com

Status: RESOLVED FIXED

(Infrastructure & Operations :: Corporate VPN: ACL requests, task)

Description

[Chris AtLee [:catlee]]

I'd like ssh access to peach-gw.peach.metrics.scl3.mozilla.com please!

Comment 1

[Anurag Phadke[:[e-mail]]]

catlee - once u have access to peach, login an type "hive" on shell
describe v2_anonymous_logs; //gives table structure

select * from v2_anonymous_logs where domain='download.mozilla.org' and ds='2014-03-20' limit 5; //selects 5 lines from the table. 

the v2_anonymous_logs table is partitioned by ds and domain, please ensure that your queries have these clauses, else the query will run forever.

You can monitor the progress of your query @ http://node3.admin.peach.metrics.scl3.mozilla.com:50030/jobtracker.jsp

to know # of downloads coming from just "firefox" to firefox by Fx version.

select ds, ua_major, ua_minor, count(1) from v2_anonymous_logs where domain='download.mozilla.org' and ds >= '2014-03-20' and ua_major = 'Firefox' and request_url like '/?product=firefox%' group by ds, ua_major, ua_minor order by ds;

-anurag

Comment 2

[Justin Dow [:jabba]]

Should be good to go here.