hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Amandeep Khurana <ama...@gmail.com>
Subject Re: table design suggestions...
Date Thu, 01 Oct 2009 20:58:18 GMT
On Tue, Sep 29, 2009 at 11:28 PM, Sujee Maniyam <sujee@sujee.net> wrote:

> > You can either create 2 tables. One can have the user as the key and the
> > other can have the country as the key..
> >
> > Or.. you can create a single table with user+country as the key.
> >
> > Third way is to have only one table with user as the key. For the country
> > query you can scan across the table and do aggregations.
> >
> > The choice will depend on whether these are batch processed queries or
> real
> > time.
> >
>
> Amandeep
> Thanks for your reply.
> If I have user as key, how would I store multiple records for the same
> user (as there would be multiple page views from a user).  I am
> thinking I need to couple it with timestamps?
>   userid_timestamp => { }
>
>
You can store in separate columns under the same family...

I'm not sure why you would want timestamp in the key.. Does it solve any
other issue?


> thanks
> SM
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message