Sriram, Would a secondary index help you: http://hadoop.apache.org/hbase/docs/r0.20.2/api/org/apache/hadoop/hbase/client/tableindexed/package-summary.html#package_description .
The index is stored in a separate table, but the index is managed for you. I don't think you can do an arbitrary "in" query, though. If the keys that you want to include in the "in" are reasonably close neighbors, you could do a scan and skip ones that are uninteresting. You could also try a batch Get by applying a separate patch, see http://issues.apache.org/jira/browse/HBASE-1845. Marc Limotte On Tue, Jan 19, 2010 at 8:45 AM, Sriram Muthuswamy Chittathoor < [email protected]> wrote: > Is there any support for this. I want to do this > > 1. Create a second table to maintain mapping between secondary column > and the rowid's of the primary table > > 2. Use this second table to get the rowid's to lookup from the primary > table using a SQL In like clause --- > > Basically I am doing this to speed up querying by Non-row key columns. > > Thanks > > 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. > >
