I think Ted is looking for the SingleColumnValueFilter.setFilterIfMissing() method. Try setting that to true.
Toby ******************************* Toby Lazar Capital Technology Group Email: [email protected] Mobile: 646-469-5865 ******************************* On Thu, Oct 24, 2013 at 9:23 AM, Jean-Marc Spaggiari < [email protected]> 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 <[email protected]> > > > 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. > > >
