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 ramon@appannie.com designates
 209.85.215.42 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <5A5AB29C-A0B0-4497-AB5F-83FD04CF1E44@gmail.com>
References: 
 <CAPBuyHQVoN4hv-oUU9JxkDB1LCLGtwXBNPjyPz0Np4t+NfG4cQ@mail.gmail.com>
	<5A5AB29C-A0B0-4497-AB5F-83FD04CF1E44@gmail.com>
Date: Wed, 15 Jan 2014 15:08:08 +0800
Message-ID: 
 <CAPBuyHQ=pfDop3wB+VsnPF7ZFgJ50NDGV4iF9J0OsOy5ZNR68Q@mail.gmail.com>
Subject: Re: Fast scan with PrefixFilter?
From: Ramon Wang <ramon@appannie.com>
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=001a11336c569ff1c904effcf86b

--001a11336c569ff1c904effcf86b
Content-Type: text/plain; charset=ISO-8859-1

Hi Ted

Thanks for the quick reply.

With this FuzzyRowFilter, do i still need to pass in startRow and stopRow
like below when constructing a Scan object?

> Scan(byte [] startRow, byte [] stopRow)


Will the FuzzyRowFilter provide us performance like a directly get by row
when we pass something like "20140101_EN_?"

Cheers
Ramon


On Wed, Jan 15, 2014 at 2:22 PM, Ted Yu <yuzhihong@gmail.com> wrote:

> Please take a look at
> http://hbase.apache.org/0.94/apidocs/org/apache/hadoop/hbase/filter/FuzzyRowFilter.html
>
> Cheers
>
> On Jan 14, 2014, at 10:16 PM, Ramon Wang <ramon@appannie.com> wrote:
>
> > Hi Folks
> >
> > We have a table with fixed pattern row key design, the format for the row
> > key is YEAR_COUNTRY_randomNumber, for example:
> >
> > 20140101_EN_1
> > 20140101_EN_2
> > 20140101_EN_3
> > 20140101_US_1
> > 20140101_US_2
> > 20140101_US_3
> > ...
> >
> > Is there a way i can quickly get the data for "20140101_EN_*" by using
> Scan
> > without scan the full table? I think we are probably going to use
> > the PrefixFilter filter with the Scan object, but the problem is that we
> > don't know the "startRow" for each scan, any ideas?
> >
> > Thanks
> > Ramon
>

--001a11336c569ff1c904effcf86b--