Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> Search by name


+
Dalia Sobhy 2012-04-02, 20:26
+
Bryan Beaudreault 2012-04-02, 20:46
+
Dalia Sobhy 2012-04-02, 20:55
+
Bryan Beaudreault 2012-04-02, 21:04
Copy link to this message
-
Re: Search by name
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<[EMAIL PROTECTED]>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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB