hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jyothi Mandava <jyothi.Mand...@huawei.com>
Subject RE: about schema design problem
Date Fri, 28 Jun 2013 08:28:41 GMT

If you add both(id+token) to the row key and if you want to search with any one of these (id
, token), giving only id in row key can use prefix filter to get the rows. giving only token
can use FuzzyRowFilter ( ????Token) but here id length should be fixed length to use FuzzyRowFilter

If your id is unique you can have id as the row key and token as value. search query with
id ( row key) as input will be faster as you can get the row directly with row key. if you
want to search with the token , you can apply filter on the single column to read the rows.
Having secondary index on the column value gives best performance in this case ( id as row
key and token as column).

Jyothi
________________________________________
From: ch huang [justlooks@gmail.com]
Sent: Friday, June 28, 2013 1:07 PM
To: user@hbase.apache.org
Subject: Re: about schema design problem

no , i have a old RDMS(mysql) table ,have two search pattern , i want to
change to HBase schema,i do not know how to design to get
best performance (can i put id and token together into rowkey?)

On Fri, Jun 28, 2013 at 2:55 PM, Jyothi Mandava
<jyothi.Mandava@huawei.com>wrote:

> HI,
> do you mean search wuth id is Search with row key and search with token is
> search with column value?
>
> Jyothi
> ________________________________________
> From: ch huang [justlooks@gmail.com]
> Sent: Friday, June 28, 2013 12:11 PM
> To: user@hbase.apache.org
> Subject: about schema design problem
>
> hi,all:
>       i have two search pattern , search for row with specific id ,and
> search for row with specific token,how can i design schema fit two search
> pattern effectly?
>

Mime
View raw message