hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ch huang <justlo...@gmail.com>
Subject Re: issue about rowkey design
Date Mon, 19 Aug 2013 01:05:19 GMT
what you mean secondary index? has hbase secondary index?

On Sat, Aug 17, 2013 at 12:48 AM, Kiru Pakkirisamy <
kirupakkirisamy@yahoo.com> wrote:

> We did design with something equivalent to userid as the key and all the
> user sessions in there.
> But when we tried to look for particular user sessions within a time
> range, we found the ColumnPrefixFilter (say on the timerange) did not give
> us much performance.
> So we ended up creating another table with time-range as key and all the
> user sessions ids in it (equivalent).
> I am pretty much repeating Bryan, but if you just use the ids, you do not
> duplicate that much data (called secondary index ?)
>
> Regards,
> - kiru
>
>
> Kiru Pakkirisamy | webcloudtech.wordpress.com
>
>
> ________________________________
>  From: Bryan Beaudreault <bbeaudreault@hubspot.com>
> To: user@hbase.apache.org
> Sent: Friday, August 16, 2013 8:06 AM
> Subject: Re: issue about rowkey design
>
>
> HBase is all about denormalization and designing for the usecase/query
> pattern.   If it's possible for your application it will be better to
> provide three different indexes, as opposed to fitting them all into one
> rowkey design.
>
>
> On Fri, Aug 16, 2013 at 5:33 AM, ch huang <justlooks@gmail.com> wrote:
>
> > hi,all
> >      i have data (data  is very huge) with user id ,session id ,and visit
> > time. my query pattern is ,"find all user id in certain time range,find
> one
> > user's all session id ,and find all session id in certain time range".
> >    my difficult is that i can not find a rowkey that good for all the
> > search pattern, i wonder if i need set three rowkey for these search
> > patterns,it's say i need triple my data storage ,any good idea?
> >
>

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