hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Roberto Sanabria <robe...@stumbleupon.com>
Subject Re: Rolling MAU computation
Date Wed, 10 Oct 2012 22:59:31 GMT
I've done this with a map side join using a table that stores days of the
week. I use that to drive the day im calculating the count for. Let me know
if you need an example.

Cheers,
R

On Wed, Oct 10, 2012 at 3:05 PM, Tom Hubina <tom@z2live.com> wrote:

> I'm trying to compute the number of active users in the previous 30 days
> for each day over a date range. I can't think of any way to do it directly
> within Hive so I'm wondering if you guys have any ideas.
>
> Basically the algorithm is something like:
>
> For each day in date range:
>    SELECT day, COUNT(DISTINCT(userid)) FROM logins WHERE day - logins.day
> < 30;
>
> Thanks for your help!
>
> Tom
>
>

Mime
View raw message