Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (nike.apache.org: domain of jdcryans@gmail.com designates
 74.125.83.41 as permitted sender)
MIME-Version: 1.0
Sender: jdcryans@gmail.com
In-Reply-To: 
 <CALMfpjppwz3ZZ8R8e=c9Hmw0xGFBiZ=7vTKaF4fP6SObknX_2w@mail.gmail.com>
References: 
 <CALMfpjqrpcBM8jscJtf5MT+wM_+GBY=hwv4NMfNym6NPbrX-eg@mail.gmail.com>
	<CAGpTDNdkoyjpXF8SqNkVf4_bREtuOZxvokLru+frrTa3ixf2Xw@mail.gmail.com>
	<CALMfpjppwz3ZZ8R8e=c9Hmw0xGFBiZ=7vTKaF4fP6SObknX_2w@mail.gmail.com>
Date: Fri, 29 Jul 2011 11:15:12 -0700
Message-ID: 
 <CAGpTDNfJtebbAs=bp2PmEYbcP3oU0k-PRCZJvrebLaULXfEcUQ@mail.gmail.com>
Subject: Re: Filter Rows on last 4 bytes
From: Jean-Daniel Cryans <jdcryans@apache.org>
To: user@hbase.apache.org
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

You need to write your own comparator (sorry if I didn't say it
plainly like that the first time).

J-D

On Fri, Jul 29, 2011 at 12:15 AM, Shuja Rehman <shujamughal@gmail.com> wrot=
e:
> Yes, I have look that =A0But I did not find any comparator which takes
> starting index and length to match. I was thinking to have such type of
> comparator.
>
> Filter rf =3D new RowFilter(CompareOp.EQUAL, new
> BinaryComparator(Bytes.toBytes(ID), StartingIndex, Length);
>
> And, about restriction, yes first four bytes will give me a subset which
> further needs to filter on the basis of next 4 bytes.
>
>
> On Wed, Jul 27, 2011 at 11:45 PM, Jean-Daniel Cryans <jdcryans@apache.org=
>wrote:
>
>> You will need to use a RowFilter with a Comparator that only looks at
>> the last 4 bytes,
>>
>> http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/filter/RowFilter=
.html
>>
>> FYI unless you are restricting your scans on a few rows, doing this on
>> a whole table won't scale as it will do a full table scan.
>>
>> J-D
>>
>> On Wed, Jul 27, 2011 at 7:34 AM, Shuja Rehman <shujamughal@gmail.com>
>> wrote:
>> > Hi,
>> >
>> > I have the key consist of two integers (4+4=3D8 Bytes). and i want to
>> filter
>> > the rows on the basis of second integer which means need to compare la=
st
>> 4
>> > bytes of key. If last 4 bytes matched with input integer then row shou=
ld
>> > include in the return results. Can you ppl let me know how to do this
>> with
>> > java API.
>> >
>> > Thanks
>> >
>> > --
>> > Regards
>> > Shuja-ur-Rehman Baig
>> > <http://pk.linkedin.com/in/shujamughal>
>> >
>>
>
>
>
> --
> Regards
> Shuja-ur-Rehman Baig
> <http://pk.linkedin.com/in/shujamughal>
>