hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dalia Sobhy <dalia.mohso...@hotmail.com>
Subject Re: Search by name
Date Mon, 02 Apr 2012 20:55:26 GMT
Thanks Bryan I will try it it sounds good.

But another question how could I make a table with 2 row keys: name, date ???

Sent from my iPad

On Apr 2, 2012, at 10:47 PM, "Bryan Beaudreault" <bbeaudreault@hubspot.com> wrote:

> I imagine you don't want this search to have to scan the entire patients
> table to find someone by their name, assuming there could be many many
> patients.  It may be a better idea to create a search table.  The search
> table could have search terms in the row key, and the columns could be
> profileIds.  Then your query execution would be:
> 1) do a multiGet of the search table, for row keys 'bryan' and '01-01-2012'.
> 2) intersect the returned columns
> 2) do a multiGet using the profileIds from the intersection as the row keys
> for the various gets
> If you want to partial match on names you could do a scan from 'bryan' to
> 'bryao' (n+1) and union all of the columns in each returned row before
> intersecting with the date search.
> This just requires you to keep the index up to date when users get added,
> deleted, and updated.
> On Mon, Apr 2, 2012 at 4:26 PM, Dalia Sobhy <dalia.mohsobhy@hotmail.com>wrote:
>> Helllooo,
>> I am using hbase thrift for my app. I have made a table for patient which
>> has first a column family called info which contains his/her general info.
>> I want to make a method to search for a patient by his name and date of
>> birth. I didn't find any method for search all requires the row key and I
>> instead need to method which returns the row key.
>> So any ideasss ???
>> Thx ;)

View raw message