I think you can use PrefixFilter to do the like operation.
On Fri, Jan 8, 2010 at 2:27 PM, Sriram Muthuswamy Chittathoor < [email protected]> wrote: > 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. > > -- Best Regards Jeff Zhang
