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 >
