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 jtaylor@salesforce.com
 designates 209.85.215.43 as permitted sender)
MIME-Version: 1.0
In-Reply-To: 
 <CAH72Ak_ZLS70xiECe8kWpcxW6DYUHXR4ZsqaC4caY1jC4FwPkQ@mail.gmail.com>
References: 
 <CAJLyKy2UDxV=Rb6-Yo+a5EZvjSqO8oftURBRr5ebF7RaeLbbsg@mail.gmail.com>
	<1328812425.45012.YahooMailNeo@web121703.mail.ne1.yahoo.com>
	<CAJLyKy2-PYZa=9NVaqrLdUhENs_d8+HeaDaPZ6vKJ+HNrzoZ3A@mail.gmail.com>
	<1328814206.80929.YahooMailNeo@web121704.mail.ne1.yahoo.com>
	<CAJLyKy0POoYZdp=fASbE+OPsGZj5PBKVJ-JGR=Qs1B-YVqbm7A@mail.gmail.com>
	<loom.20131021T060128-995@post.gmane.org>
	<CAH72Ak_ZLS70xiECe8kWpcxW6DYUHXR4ZsqaC4caY1jC4FwPkQ@mail.gmail.com>
Date: Sun, 20 Oct 2013 23:05:24 -0700
Message-ID: 
 <CAG_TOPCsj5BDYgOqNhMVKnbdyHxfq52fny=XEv+5YVWNAyA=kw@mail.gmail.com>
Subject: Re: row filter - binary comparator at certain range
From: James Taylor <jtaylor@salesforce.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a11c238e8ed732e04e93a11d5

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

Take a look at Phoenix(https://github.com/forcedotcom/phoenix). It supports
both salting and fuzzy row filtering through its skip scan.


On Sun, Oct 20, 2013 at 10:42 PM, Premal Shah <premal.j.shah@gmail.com>wrote:

> Have you looked at FuzzyRowFilter? Seems to me that it might satisfy your
> use-case.
>
> http://blog.sematext.com/2012/08/09/consider-using-fuzzyrowfilter-when-in-need-for-secondary-indexes-in-hbase/
>
>
> On Sun, Oct 20, 2013 at 9:31 PM, Tony Duan <duanjianmin@126.com> wrote:
>
> > Alex Vasilenko <aa.vasilenko@...> writes:
> >
> > >
> > > Lars,
> > >
> > > But how it will behave, when I have salt at the beginning of the key to
> > > properly shard table across regions? Imagine row key of format
> > > salt:timestamp and rows goes like this:
> > > ...
> > > 1:15
> > > 1:16
> > > 1:17
> > > 1:23
> > > 2:3
> > > 2:5
> > > 2:12
> > > 2:15
> > > 2:19
> > > 2:25
> > > ...
> > >
> > > And I want to find all rows, that has second part (timestamp) in range
> > > 15-25. What startKey and endKey should be used?
> > >
> > > Alexandr Vasilenko
> > > Web Developer
> > > Skype:menterr
> > > mob: +38097-611-45-99
> > >
> > > 2012/2/9 lars hofhansl <lhofhansl@...>
> > Hi,
> > Alexandr Vasilenko
> > Have you ever resolved this issue?i am also facing this iusse.
> > i also want implement this functionality.
> > Imagine row key of format
> > salt:timestamp and rows goes like this:
> > ...
> > 1:15
> > 1:16
> > 1:17
> > 1:23
> > 2:3
> > 2:5
> > 2:12
> > 2:15
> > 2:19
> > 2:25
> > ...
> >
> > And I want to find all rows, that has second part (timestamp) in range
> > 15-25.
> >
> > Could you please tell me how you resolve this ?
> > thanks  in advance.
> >
> >
> > Tony duan
> >
> >
>
>
> --
> Regards,
> Premal Shah.
>

--001a11c238e8ed732e04e93a11d5--