I don't need, nor want, access to any data about unique readers/viewers. Is there a way of sanitizing the data? There is public data about pageviews so it seems to me that there should also be public data about media playback.Alternatively, is there a way that I can file a request with someone who has the correct permissions to ask them to run the appropriate query?PineOn Mon, Dec 14, 2015 at 2:55 PM, Oliver Keyes <okeyes@wikimedia.org> wrote:I should caution that for idle questions I sincerely doubt cluster
access will be given; there's no way of partitioning it so that you
can't access, say, random readers' IP addresses ;p
On 14 December 2015 at 17:54, Madhumitha Viswanathan
Oliver Keyes<mviswanathan@wikimedia.org> wrote:
> 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 :)
>
> _______________________________________________
> Analytics mailing list
> Analytics@lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/analytics
>
--
Count Logula
Wikimedia Foundation
_______________________________________________
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