Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of mlortiz@uci.cu designates
 200.55.140.180 as permitted sender)
Message-ID: <4F7A1182.1060408@uci.cu>
Date: Mon, 02 Apr 2012 16:52:18 -0400
From: Marcos Ortiz <mlortiz@uci.cu>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
To: user@hbase.apache.org
CC: Bryan Beaudreault <bbeaudreault@hubspot.com>
Subject: Re: Search by name
References: <snt0-eas292E457B09A2EDEA0320514854C0@phx.gbl>
 <CANZDn9vpFWN-=tuMUzDJJPQPka-=xUbBUgKKOnJap6yeaju0kA@mail.gmail.com>
In-Reply-To: 
 <CANZDn9vpFWN-=tuMUzDJJPQPka-=xUbBUgKKOnJap6yeaju0kA@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------050600060904020000020900"

--------------050600060904020000020900
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit

HBasene?
https://github.com/akkumar/hbasene

On 04/02/2012 04:46 PM, Bryan Beaudreault 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 ;)
>
> 10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
> CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION
>
> http://www.uci.cu
> http://www.facebook.com/universidad.uci
> http://www.flickr.com/photos/universidad_uci

-- 
Marcos Luis Ort�z Valmaseda (@marcosluis2186)
  Data Engineer at UCI
  http://marcosluis2186.posterous.com


10mo. ANIVERSARIO DE LA CREACION DE LA UNIVERSIDAD DE LAS CIENCIAS INFORMATICAS...
CONECTADOS AL FUTURO, CONECTADOS A LA REVOLUCION

http://www.uci.cu
http://www.facebook.com/universidad.uci
http://www.flickr.com/photos/universidad_uci
--------------050600060904020000020900--