Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
MIME-Version: 1.0
In-Reply-To: <CALte62y4kWYm3eYB01fiiMfhGtv81pFGWLUnu64DKvfa6gvwTw@mail.gmail.com>
References: <CY4PR14MB12721E51E01895443787F4CFAA6B0@CY4PR14MB1272.namprd14.prod.outlook.com>
 <CALte62y4kWYm3eYB01fiiMfhGtv81pFGWLUnu64DKvfa6gvwTw@mail.gmail.com>
From: Ted Yu <yuzhihong@gmail.com>
Date: Thu, 29 Dec 2016 13:11:18 -0800
Message-ID: <CALte62wHdzGj1oART3E5EiRQCHEtb_fBSdZatY6nqFHVnsqzDQ@mail.gmail.com>
Subject: Re: Is it possible to implement a NOT filter in Hbase?
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a1140b770d0a1b70544d2865a
archived-at: Thu, 29 Dec 2016 21:11:24 -0000

--001a1140b770d0a1b70544d2865a
Content-Type: text/plain; charset=UTF-8

Last line should have read:

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

On Thu, Dec 29, 2016 at 1:10 PM, Ted Yu <yuzhihong@gmail.com> wrote:

> 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 <soloninguno@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,
>>
>
>

--001a1140b770d0a1b70544d2865a--