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 [justlo...@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.mand...@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 [justlo...@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? >
