Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Plain View
HBase >> mail # user >> filtering rows for column values not null


Copy link to this message
-
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.
+
Jean-Marc Spaggiari 2013-10-24, 13:23
+
Toby Lazar 2013-10-24, 13:26
+
Jean-Marc Spaggiari 2013-10-24, 13:31
+
Ted 2013-10-25, 00:53
+
Vladimir Rodionov 2013-10-24, 16:07
+
Jean-Marc Spaggiari 2013-10-24, 16:38
+
Vladimir Rodionov 2013-10-24, 16:35