hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ted Yu <yuzhih...@gmail.com>
Subject Re: Hbase: Is possible to filter by integer value if the value is saved as string?
Date Fri, 19 Jul 2013 01:03:06 GMT
What would happen to this ?

        System.out.println(c.compareTo(Bytes.toBytes("30")));

On Thu, Jul 18, 2013 at 5:55 PM, Kevin <kevin.macksamie@gmail.com> wrote:

> Sure, try using the BinaryComparator. For example,
>
>         BinaryComparator c = new BinaryComparator(Bytes.toBytes("200"));
>         System.out.println(c.compareTo(Bytes.toBytes("201"))); // returns
> -1
>
>
> On Thu, Jul 18, 2013 at 4:28 PM, Frank Luo <jluo@merkleinc.com> wrote:
>
> > That requires creating my own ByteArrayComparable class and deploy to all
> > servers, right?
> >
> > My company doesn't want to "customize" hbase, hence is not an option to
> me.
> >
> > -----Original Message-----
> > From: Ted Yu [mailto:yuzhihong@gmail.com]
> > Sent: Thursday, July 18, 2013 3:25 PM
> > To: user@hbase.apache.org
> > Subject: Re: Hbase: Is possible to filter by integer value if the value
> is
> > saved as string?
> >
> > Looks like you should be able to do so by passing your own comparator to:
> >
> >   public SingleColumnValueFilter(final byte [] family, final byte []
> > qualifier,
> >
> >       final CompareOp compareOp, final ByteArrayComparable comparator) {
> > Cheers
> >
> > On Thu, Jul 18, 2013 at 1:20 PM, Frank Luo <jluo@merkleinc.com> wrote:
> >
> > > I don't think it is possible, but would like to confirm with smart
> > > folks out there.
> > >
> > > Supposing I have a cell storing an integer but in string presentation.
> > > For example, here is how I put a value of 200:
> > >
> > >         put.add(family, qualifier, Bytes.toBytes("200"));
> > >
> > > Now, I want to scan with a filter that only return if the value is
> > > larger than 250. Is that possible?
> > >
> > > Thanks in advance
> > >
> > > Frank
> > >
> >
> >
>

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