This will work ONLY if you add single column to scan. If you scan multiple columns you will need additional filter (reverse SkipFilter) which filter outs all rows (outputs of SingleColumnValueFilter) which do not have 'firstName' column. I do not think HBase provide similar filter but you can create it yourself.
See SkipFilter java source Best regards, Vladimir Rodionov Principal Platform Engineer Carrier IQ, www.carrieriq.com e-mail: vrodio...@carrieriq.com ________________________________________ From: Vladimir Rodionov Sent: Thursday, October 24, 2013 9:07 AM To: user@hbase.apache.org Subject: RE: filtering rows for column values not null If 'firstName' is NULL - it is missing completely from a row. Add explicitly this column to Scan you create: scan.addColumn(YOUR_CF, 'firstName'.getBytes()); Best regards, Vladimir Rodionov Principal Platform Engineer Carrier IQ, www.carrieriq.com e-mail: vrodio...@carrieriq.com ________________________________________ From: Ted [r6squee...@gmail.com] Sent: Thursday, October 24, 2013 1:54 AM To: user@hbase.apache.org Subject: filtering rows for column values not null 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. Confidentiality Notice: The information contained in this message, including any attachments hereto, may be confidential and is intended to be read only by the individual or entity to whom this message is addressed. If the reader of this message is not the intended recipient or an agent or designee of the intended recipient, please note that any review, use, disclosure or distribution of this message or its attachments, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or notificati...@carrieriq.com and delete or destroy any copy of this message and its attachments.