You can try negating the ReturnCode from filterKeyValue() (at the root of
FilterList):

  abstract public ReturnCode filterKeyValue(final Cell v) throws
IOException;

INCLUDE -> SKIP

SKIP -> INCLUDE

Alternatively, you can use De Morgan's law to transfer the condition:

 NOT (a = '123' AND b = '456') becomes

 (NOT a = '123') OR (b = '456')

On Thu, Dec 29, 2016 at 12:56 PM, Carl M <soloning...@hotmail.com> wrote:

> Hi guys
>
>
> I'm trying to implement some kind of NOT filter in Hbase, but don't know
> if possible, I'm playing with FilterIfMissing and FilterList.Operator but
> without luck.
>
>
> I know how to return rows not having a specific column, but I mean
> something like returning rows NOT fullfilling a condition, where condition
> could be not only a SingleColumnValueFilter but a combined condition with
> FilterList. In SQL would be something like this for example
>
>
> SELECT * FROM table WHERE NOT (a = '123' AND b = '456');
>
>
> Thanks in advance,
>

Reply via email to