Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
Received-SPF: pass (athena.apache.org: domain of yuzhihong@gmail.com
 designates 209.85.160.174 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAAMYKhpa40d25x6pvZm46f_yd0K4rcLMV6fn8b28C5L7xrUQfw@mail.gmail.com>
References: 
 <CAAMYKho1U3ST7kegK3QGBPbGTpM9W88kjptkkV1DTYCsFVNJSA@mail.gmail.com>
	<CAFWiQHbzdrkxRGGhP6kbCrqcmPHVurJEvg_zSKv8sGEje8jPgQ@mail.gmail.com>
	<CAAMYKhpa40d25x6pvZm46f_yd0K4rcLMV6fn8b28C5L7xrUQfw@mail.gmail.com>
Date: Mon, 10 Mar 2014 07:47:35 -0700
Message-ID: 
 <CALte62z0Yf-qMfQUB8XBSSsXGkrOVRvK=A8hqcqcCe8jEKmg2A@mail.gmail.com>
Subject: Re: FuzzyRowFilter missing keys
From: Ted Yu <yuzhihong@gmail.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=20cf3011dba929a9ac04f441afba

--20cf3011dba929a9ac04f441afba
Content-Type: text/plain; charset=ISO-8859-1

Amit:
Can you put your scenario in a unit test so that it is easier to pinpoint
where the issue is ?

Thanks


On Mon, Mar 10, 2014 at 5:25 AM, Amit Sela <amits@infolinks.com> wrote:

> My table contains keys of this kind over an entire month but the scan
> returns only for a some fo the days.
> I have 2010101-20140131 but the scan returns only for:
> 20140104, 20140110, 20140111, 20140118, 20140120, 20140125, 20140128
>
> Using get or scan with no fuzzy filter works...
>
>
> On Mon, Mar 10, 2014 at 1:59 PM, Bharath Vissapragada <
> bharathv@cloudera.com
> > wrote:
>
> > Is it because you fixed "_US_product1___" part of the key?  From your
> > definition of filter you should get as output all keys of form
> > "yyyyMMdd_US_product1___".
> > can you share a key thats of this format and missing in the output?
> >
> >
> > On Mon, Mar 10, 2014 at 3:38 PM, Amit Sela <amits@infolinks.com> wrote:
> >
> > > Hi all,
> > > I'm using HBase 0.94.12 + Hadoop 1.0.4.
> > > Trying to use FuzzyRowFilter looks like it's missing keys in the scan.
> > >
> > > Row key structure:
> > > yyyyMMdd_Country_Product_Category1_Category2_
> > > Where the date is mandatory and all other fields may be "".
> > > Examples:
> > > 20140101_US_product1___
> > > 20140102__product1_bla__
> > > 20140103_____
> > >
> > > Supplying the filter with row key:
> > > \x00\x00\x00\x00\x00\x00\x00\x00_US_product1___
> > > and fuzzy info:
> > > {1,1,1,1,1,1,1,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0}
> > >
> > > Over a range of a month, although the key exists for every day in the
> > > month, I get result only for some of the days.
> > >
> > > I tried it on another table and the same happens, I'll mention that
> both
> > > tables have keys that start with yyyyMMdd.
> > >
> > > Anyone had a similar issue before ? I saw something in the mailing list
> > > archives but no results there...
> > >
> > > Thanks,
> > > Amit.
> > >
> >
> >
> >
> > --
> > Bharath Vissapragada
> > <http://www.cloudera.com>
> >
>

--20cf3011dba929a9ac04f441afba--