Sorry for the confusion. Yes the bug exists. When I tried in the cluster the Visibilty CP was not on. So it is better we can raise a JIRA and fix this over there. Thanks Anoop Sharma and sorry for the delay from my side due to wrong info.
Regards Ram On Wed, Nov 4, 2015 at 4:15 AM, Anoop Sharma <[email protected]> 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 25 > 15:59:49 PDT 2015 > Version 1.1.2, rcc2b70cf03e3378800661ec5cab11eb43fafe0fc, Wed Aug 26 > 20:11:27 PDT 2015 > > Is there a later version that has the fix? > > thanks > > -----Original Message----- > From: ramkrishna vasudevan [mailto:[email protected]] > Sent: Sunday, November 1, 2015 11:11 PM > To: [email protected] > 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 not > that > case ? > > Regards > Ram > > On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <[email protected]> wrote: > > > I believe it is a bug.. I think I know the reason also.. Can you file > > a jira? We can discuss under that. Thanks for the test. > > > > -Anoop- > > > > On Sat, Oct 31, 2015 at 12:45 AM, Anoop Sharma > > <[email protected]> > > wrote: > > > > > Thanks Ram. > > > > > > we are using hbase 1.0.2. > > > > > > anoop > > > > > > -----Original Message----- > > > From: ramkrishna vasudevan [mailto:[email protected]] > > > Sent: Thursday, October 29, 2015 10:22 PM > > > To: [email protected] > > > 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 > > > reproduced this > > and > > > this problem no longer occurs. > > > > > > Regards > > > Ram > > > > > > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma > > > <[email protected]> > > > 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 ‘MANAGER’ > > > > authorization. > > > > > > > > > > > > > > > > *First example:* > > > > > > > > add a column with visib expr ‘MANAGER’ > > > > > > > > delete it by passing in visibility of ‘MANAGER’ > > > > > > > > This works and scan doesn’t return anything. > > > > > > > > > > > > > > > > *Second example:* > > > > > > > > add a column with visib expr ‘MANAGER’ > > > > > > > > delete it by not passing in any visibility. > > > > > > > > This doesn’t delete the column. > > > > > > > > Scan doesn’t return the row but RAW scan shows the column > > > > > > > > marked as deleteColumn. > > > > > > > > > > > > > > > > Now if delete is done again with visibility of ‘MANAGER’, > > > > > > > > it still doesn’t 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=>'MANAGER'}* > > > > > > > > > > > > > > > > hbase(main):099:0> *scan 'HBT1'* > > > > > > > > ROW > > > > COLUMN+CELL > > > > > > > > John column=cf:a, timestamp=1446154722055, > > > > value=CA > > > > > > > > 1 row(s) in 0.0030 seconds > > > > > > > > > > > > > > > > hbase(main):100:0> *delete 'HBT1', 'John', 'cf:a', > > > > {VISIBILITY=>'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=>'MANAGER'}* > > > > > > > > 0 row(s) in 0.0040 seconds > > > > > > > > > > > > > > > > hbase(main):011:0> *scan 'HBT1'* > > > > > > > > ROW > > > > COLUMN+CELL > > > > > > > > John column=cf:a, timestamp=1446155346473, > > > > value=CA > > > > > > > > 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=cf:a, timestamp=1446155346473, > > > > value=CA > > > > > > > > 1 row(s) in 0.0050 seconds > > > > > > > > > > > > > > > > hbase(main):014:0> *scan 'HBT1', {RAW => true}* > > > > > > > > ROW > > > > COLUMN+CELL > > > > > > > > John column=cf:a, timestamp=1446155346519, > > > > type=DeleteColumn > > > > > > > > 1 row(s) in 0.0060 seconds > > > > > > > > > > > > > > > > hbase(main):015:0> *delete 'HBT1', 'John', 'cf:a', > > > > {VISIBILITY=>'MANAGER'}* > > > > > > > > 0 row(s) in 0.0030 seconds > > > > > > > > > > > > > > > > hbase(main):016:0> *scan 'HBT1'* > > > > > > > > ROW > > > > COLUMN+CELL > > > > > > > > John column=cf:a, timestamp=1446155346473, > > > > value=CA > > > > > > > > 1 row(s) in 0.0040 seconds > > > > > > > > > > > > > > > > hbase(main):017:0> *scan 'HBT1', {RAW => true}* > > > > > > > > ROW > > > > COLUMN+CELL > > > > > > > > John column=cf:a, timestamp=1446155346601, > > > > type=DeleteColumn > > > > > > > > 1 row(s) in 0.0060 seconds > > > > > > > > > >
