hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ajo Fod <ajo....@gmail.com>
Subject Re: calculating unique views based on ip, session_id
Date Mon, 21 Feb 2011 16:28:42 GMT
You can group by item_sid (drop session_id and ip_number from group by
clause) and then join with the parent table to get session_id  and
ip_number.

-Ajo

On Mon, Feb 21, 2011 at 3:07 AM, Cam Bazz <cambazz@gmail.com> wrote:

> Hello,
>
> So I have table of item views with item_sid, ip_number, session_id
>
> I know it will not be that exact, but I want to get unique views per
> item, and i will accept ip_number, session_id tuple as an unique view.
>
> when I want to query just item hits I say: select item_sid, count(*)
> from item_raw group by item_sid;
>
> but if I say:
>
> select item_sid, count(*) from item_raw group by item_sid, ip_number,
> session_id;
>
> it will give me duplicate item sids.
>
> how can I query per unique tuple of ip_number, session_id per item_sid?
>
> best regards,
> c.b.
>

Mime
View raw message