hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sriram Muthuswamy Chittathoor" <srir...@ivycomptech.com>
Subject Hbase table querying using 'like' concept of SQL
Date Fri, 08 Jan 2010 06:27:50 GMT
Hi:

 

I am trying to evaluate this for a hbase table which has around 30
million records.  The table stores user information like 

{accountName , screenName, firstName , lastName, dataOfBirth} etc.  The
idea is to be able to query the rows using  "like" clause.

 

So something like      select  * from userProfile  with ....  where
accountName like 'po*'  and  screenName like 'scr*'   

 

What would be the most performant way to do this --  can I use some
tricks or do I need to get the rows and filter it myself  or  not a good
use case for hbase ?

 

 

Thanks for the help

 

Sriram C

 


This email is sent for and on behalf of Ivy Comptech Private Limited. Ivy Comptech Private
Limited is a limited liability company.  

This email and any attachments are confidential, and may be legally privileged and protected
by copyright. If you are not the intended recipient dissemination or copying of this email
is prohibited. If you have received this in error, please notify the sender by replying by
email and then delete the email completely from your system. 
Any views or opinions are solely those of the sender.  This communication is not intended
to form a binding contract on behalf of Ivy Comptech Private Limited unless expressly indicated
to the contrary and properly authorised. Any actions taken on the basis of this email are
at the recipient's own risk.

Registered office:
Ivy Comptech Private Limited, Cyber Spazio, Road No. 2, Banjara Hills, Hyderabad 500 033,
Andhra Pradesh, India. Registered number: 37994. Registered in India. A list of members' names
is available for inspection at the registered office.


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message