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 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




--
--Madhu :)