yes! that was exactly what I was looking for. thanks. Ted
On 10/24/13, Toby Lazar <[email protected]> wrote: > 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. >> > >> > -- Ted.
