Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
From: "Anoop Sharma" <anoop.sharma@esgyn.com>
To: <user@hbase.apache.org>
References: <e1aa80e85153d529eab24169eeddd36d@mail.gmail.com>
	<CAAT7Mkq5feVa7WJ8=HPKNZCuQwJe4hZEZKi=zVeWMCR1NNWJXQ@mail.gmail.com>
	<72dd2c48875386a8341ca999d1363202@mail.gmail.com>
	<CAOtJ30qPWu=X0gOnXRFFRBP+yy_7WyQXzSJQt4qkyGWgjxX3jQ@mail.gmail.com>
	<CAAT7MkrvX96HJEy633mnM0eF14XHR5Pivaabr8r3zSU4K4f=4A@mail.gmail.com>
	<bd452b8576a24f5d98f74a4d9c6b33e4@mail.gmail.com>
	<CAAT7MkqsOxsZOh415eRYbLSuOLUJm7zgoAu=uYPMsO6j3EmYDw@mail.gmail.com>
 <CAAT7MkqToEXxKp=m=_JkyC8fwM7EOaCZq0Y03XOeVvw70Cdqpw@mail.gmail.com>
In-Reply-To: 
 <CAAT7MkqToEXxKp=m=_JkyC8fwM7EOaCZq0Y03XOeVvw70Cdqpw@mail.gmail.com>
Subject: RE: delete of cells with visibility expressions
Date: Wed, 4 Nov 2015 07:55:49 -0800
Message-ID: <004d01d11719$472f52c0$d58df840$@esgyn.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Thread-Index: 
 AQL1fg4F5FPBxddsvX2TzRGZQaeaugINs6/FAs8MWzsBrdu3iAIAHeRFAmAmMEUCzCypjAFO12Snm8sGo2A=
Content-Language: en-us

Thanks for finding the issue, appreciate your help.

Yes, please go ahead and file a JIRA or let me know if you would like me =
to  file it.

Which release would the fix be in?  Could it be backported on an earlier =
release?

anoop

-----Original Message-----
From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]=20
Sent: Tuesday, November 3, 2015 9:51 PM
To: user@hbase.apache.org
Subject: Re: delete of cells with visibility expressions

Seeing the code I think we have identified the issue as Anoop John said. =
We could fix this probably in the next release.  Let us know if you want =
us to file a JIRA for this.

Regards
Ram


On Wed, Nov 4, 2015 at 11:09 AM, ramkrishna vasudevan < =
ramkrishna.s.vasudevan@gmail.com> wrote:

> Sorry for the confusion. Yes the bug exists. When I tried in the=20
> cluster the Visibilty CP was not on. So it is better we can raise a=20
> JIRA and fix this over there. Thanks Anoop Sharma and sorry for the=20
> delay from my side due to wrong info.
>
> Regards
> Ram
>
> On Wed, Nov 4, 2015 at 4:15 AM, Anoop Sharma <anoop.sharma@esgyn.com>
> wrote:
>
>> hi
>>
>> which hbase version did you try this on?
>> We tried on the following 2 hbase versions and see the delete =
problem.
>>
>>    Version 1.0.2, r76745a2cbffe08b812be16e0e19e637a23a923c5, Tue Aug=20
>> 25
>> 15:59:49 PDT 2015
>>    Version 1.1.2, rcc2b70cf03e3378800661ec5cab11eb43fafe0fc, Wed Aug=20
>> 26
>> 20:11:27 PDT 2015
>>
>> Is there a later version that has the fix?
>>
>> thanks
>>
>> -----Original Message-----
>> From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
>> Sent: Sunday, November 1, 2015 11:11 PM
>> To: user@hbase.apache.org
>> Subject: Re: delete of cells with visibility expressions
>>
>> Is it still a bug? I reproduced the above steps in latest trunk and I =

>> thought the behaviour was corrected due to a recent bug fix?  Is it=20
>> not that case ?
>>
>> Regards
>> Ram
>>
>> On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <anoop.hbase@gmail.com>
>> wrote:
>>
>> > I believe it is a bug.. I think I know the reason also..  Can you=20
>> > file a jira?  We can discuss under that.  Thanks for the test.
>> >
>> > -Anoop-
>> >
>> > On Sat, Oct 31, 2015 at 12:45 AM, Anoop Sharma=20
>> > <anoop.sharma@esgyn.com>
>> > wrote:
>> >
>> > > Thanks Ram.
>> > >
>> > > we are using hbase 1.0.2.
>> > >
>> > > anoop
>> > >
>> > > -----Original Message-----
>> > > From: ramkrishna vasudevan=20
>> > > [mailto:ramkrishna.s.vasudevan@gmail.com]
>> > > Sent: Thursday, October 29, 2015 10:22 PM
>> > > To: user@hbase.apache.org
>> > > Subject: Re: delete of cells with visibility expressions
>> > >
>> > > Hi Anoop
>> > >
>> > > Which version of the HBase are you using?  This got solved in the =

>> > > latest version of 0.98 and above. Could you try that?  I just=20
>> > > reproduced this
>> > and
>> > > this problem no longer occurs.
>> > >
>> > > Regards
>> > > Ram
>> > >
>> > > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma=20
>> > > <anoop.sharma@esgyn.com>
>> > > wrote:
>> > >
>> > > > hi
>> > > >
>> > > >   running into an issue related to visibility expressions and
>> delete.
>> > > >
>> > > > Example run from hbase shell is listed below.
>> > > >
>> > > > Will appreciate any help on this issue.
>> > > >
>> > > > thanks.
>> > > >
>> > > >
>> > > >
>> > > > In the example below, user running queries has =
=E2=80=98MANAGER=E2=80=99
>> > > > authorization.
>> > > >
>> > > >
>> > > >
>> > > > *First example:*
>> > > >
>> > > >   add a column with visib expr =E2=80=98MANAGER=E2=80=99
>> > > >
>> > > >   delete it by passing in visibility of =
=E2=80=98MANAGER=E2=80=99
>> > > >
>> > > >   This works and scan doesn=E2=80=99t return anything.
>> > > >
>> > > >
>> > > >
>> > > > *Second example:*
>> > > >
>> > > >   add a column with visib expr =E2=80=98MANAGER=E2=80=99
>> > > >
>> > > >   delete it by not passing in any visibility.
>> > > >
>> > > >   This doesn=E2=80=99t delete the column.
>> > > >
>> > > >   Scan doesn=E2=80=99t return the row but RAW scan shows the =
column
>> > > >
>> > > >   marked as deleteColumn.
>> > > >
>> > > >
>> > > >
>> > > >   Now if delete is done again with visibility of =
=E2=80=98MANAGER=E2=80=99,
>> > > >
>> > > >   it still doesn=E2=80=99t delete it and scan returns the =
original column.
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > > *Example 1:*
>> > > >
>> > > > hbase(main):096:0> create 'HBT1', 'cf'
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):098:0* *put 'HBT1', 'John', 'cf:a', 'CA',
>> > > > {VISIBILITY=3D>'MANAGER'}*
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):099:0> *scan 'HBT1'*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > >  John                 column=3Dcf:a, timestamp=3D1446154722055,
>> > > > value=3DCA
>> > > >
>> > > > 1 row(s) in 0.0030 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):100:0> *delete 'HBT1', 'John', 'cf:a',
>> > > > {VISIBILITY=3D>'MANAGER'}*
>> > > >
>> > > > 0 row(s) in 0.0030 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):101:0> *scan 'HBT1'*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > > 0 row(s) in 0.0030 seconds
>> > > >
>> > > >
>> > > >
>> > > >
>> > > >
>> > > > *Example 2:*
>> > > >
>> > > > hbase(main):010:0* *put 'HBT1', 'John', 'cf:a', 'CA',
>> > > > {VISIBILITY=3D>'MANAGER'}*
>> > > >
>> > > > 0 row(s) in 0.0040 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):011:0> *scan 'HBT1'*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > >  John                 column=3Dcf:a, timestamp=3D1446155346473,
>> > > > value=3DCA
>> > > >
>> > > > 1 row(s) in 0.0060 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):012:0> *delete 'HBT1', 'John', 'cf:a'*
>> > > >
>> > > > 0 row(s) in 0.0090 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):013:0> *scan 'HBT1'*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > >  John                 column=3Dcf:a, timestamp=3D1446155346473,
>> > > > value=3DCA
>> > > >
>> > > > 1 row(s) in 0.0050 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):014:0> *scan 'HBT1', {RAW =3D> true}*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > >  John                 column=3Dcf:a, timestamp=3D1446155346519,
>> > > > type=3DDeleteColumn
>> > > >
>> > > > 1 row(s) in 0.0060 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):015:0> *delete 'HBT1', 'John', 'cf:a',
>> > > > {VISIBILITY=3D>'MANAGER'}*
>> > > >
>> > > > 0 row(s) in 0.0030 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):016:0> *scan 'HBT1'*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > >  John                 column=3Dcf:a, timestamp=3D1446155346473,
>> > > > value=3DCA
>> > > >
>> > > > 1 row(s) in 0.0040 seconds
>> > > >
>> > > >
>> > > >
>> > > > hbase(main):017:0> *scan 'HBT1', {RAW =3D> true}*
>> > > >
>> > > > ROW
>> > > > COLUMN+CELL
>> > > >
>> > > >  John                 column=3Dcf:a, timestamp=3D1446155346601,
>> > > > type=3DDeleteColumn
>> > > >
>> > > > 1 row(s) in 0.0060 seconds
>> > > >
>> > >
>> >
>>
>
>