Hi Pine,
Yes, you need stat1002 access to run Hive queries. It's not the same as Labs. There's plenty of documentation here, on how to request access, and how to query data - https://wikitech.wikimedia.org/wiki/Analytics/Cluster/Hive.
On Mon, Dec 14, 2015 at 2:42 PM, Pine W wiki.pine@gmail.com wrote:
Hi Dan,
I have a Labs account which I've barely used. Is access to the cluster a separate step from having access to Labs?
Also, is there a "how to" guide somewhere for how to query the cluster?
Thanks, Pine
On Mon, Dec 14, 2015 at 2:11 PM, Dan Andreescu dandreescu@wikimedia.org wrote:
Pine, right now you can either query Hive if you have access to the cluster, or you can download the days you're interested from here: http://dumps.wikimedia.org/other/mediacounts/daily/2015/ and crunch the numbers for the articles you're interested in (not too bad)
On Mon, Dec 14, 2015 at 5:01 PM, Pine W wiki.pine@gmail.com wrote:
Hi Analytics,
How do I determine how many times this video https://commons.wikimedia.org/wiki/File:Wikipedia_5_million_articles_milestone_video_November_2015.ogv has been played in the last 90 days?
Thanks,
Pine
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics
Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics