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.
