hbase-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jean-Marc Spaggiari <jean-m...@spaggiari.org>
Subject Re: filtering rows for column values not null
Date Thu, 24 Oct 2013 13:31:10 GMT
Got it! I looked at the opposite way: "How to get only the row where it's
null". Toby is correct.

JM


2013/10/24 Toby Lazar <tlazar@capitaltg.com>

> I think Ted is looking for the SingleColumnValueFilter.setFilterIfMissing()
> method.  Try setting that to true.
>
> Toby
>
> *******************************
>   Toby Lazar
>   Capital Technology Group
>   Email: tlazar@capitaltg.com
>   Mobile: 646-469-5865
> *******************************
>
>
> On Thu, Oct 24, 2013 at 9:23 AM, Jean-Marc Spaggiari <
> jean-marc@spaggiari.org> wrote:
>
> > Hi Ted,
> >
> > I'm not sure to get you. HBase will not store any cell in the system if
> > there is no content. So if you do a scan, you will get only the cells
> where
> > the content is not null. There is no need to have any filter here. Can
> you
> > please detail what you put in the table and what cells you are trying to
> > NOT read?
> >
> > JM
> >
> >
> > 2013/10/24 Ted <r6squeegee@gmail.com>
> >
> > > Hi I have a relatively simple situation,
> > >
> > > As an example I have a table of Users, with first and last name.
> > >
> > > I set a scan a FilterList and I add a SingleColumnValueFilter, with
> > > column qualifier=firstName, CompareOp.EQUAL, and value="bob".
> > >
> > > The problem is, I'm getting "bob" as well as anyone with out a
> firstName.
> > >
> > > I tried adding NOT_EQUALS null and NOT_EQUALS (new byte[0]) and neither
> > > helped.
> > >
> > > Does anyone know of how to filter on a column value not null?
> > > --
> > > Ted.
> > >
> >
>

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