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 < [email protected]> wrote: > 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 >> > > > >> > > >> > >> > >
