Hbase table querying using 'like' concept of SQL

[Sriram Muthuswamy Chittathoor <sr...@ivycomptech.com>]

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.

Re: Hbase table querying using 'like' concept of SQL

[Jeff Zhang <zj...@gmail.com>]

I think you can use PrefixFilter to do the like operation.



On Fri, Jan 8, 2010 at 2:27 PM, Sriram Muthuswamy Chittathoor <
sriramc@ivycomptech.com> 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