How about SELECT day, COUNT(DISTINCT(userid)) FROM logins WHERE day - logins.day < 30 GROUP BY day;
On Thu, Oct 11, 2012 at 6:05 AM, Tom Hubina <t...@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 >
