hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manjeet Singh <manjeet.chand...@gmail.com>
Subject Re: How to improve filter based scan
Date Thu, 21 Sep 2017 19:06:25 GMT
Salt is one char and generated on subscriber number, we are using pre
splitting each salt is representing one region

On 22 Sep 2017 12:33 am, "Ted Yu" <yuzhihong@gmail.com> wrote:

> Have you looked at FuzzyRowFilter (assuming salt is of fixed width) ?
>
> On Thu, Sep 21, 2017 at 11:59 AM, Manjeet Singh <
> manjeet.chandhok@gmail.com>
> wrote:
>
> > Hi
> >
> > We are using hbase 1.2 version
> > Our usecase is to get all the subscribe who have used xyz application for
> > this we have rk as below
> >
> > Salt_subscriber_application_usecasenumber
> > Example
> > #_77777777_facebook_50
> >
> > Thanks
> > Manjeet singh
> >
> > On 22 Sep 2017 12:19 am, "Ted Yu" <yuzhihong@gmail.com> wrote:
> >
> > > bq. how can you get stop key.
> > >
> > > This would depend on your use case(s).
> > > Can you tell us more about your schema ?
> > >
> > > BTW which release are you using ?
> > >
> > > On Thu, Sep 21, 2017 at 11:43 AM, Manjeet Singh <
> > > manjeet.chandhok@gmail.com>
> > > wrote:
> > >
> > > > Hi All
> > > >
> > > > This is old question but first time I feel the pain.
> > > > In hbase we have filters I am using substring and value filter .
> > > > Problem is that it's took around 10  minutes to get the result.
> > > > I have found start and stop key is helpful but again how can you get
> > stop
> > > > key.
> > > >
> > > > Anyway can anyone tell me how can I take my scan in 1 or 2 second?  I
> > > have
> > > > tried page filter caching setmaxresult etc.
> > > >
> > > > Thanks
> > > > Manjeet Singh
> > > >
> > >
> >
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message