Thanks will check it out.
Also if my key is a compound key and I do a scan on a partial key range
will it work. Meaning key is a concat of {a,b} and my scan
specifies "get me all rows between {a1,a2}. Is this still as fast as
doing {a1b1 , a2b2}
-----Original Message-----
From: Marc Limotte [mailto:[email protected]]
Sent: Tuesday, January 19, 2010 10:26 PM
To: [email protected]
Subject: Re: Support for MultiGet / SQL In clause
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.
>
>
