ramkrishna.s.vasudevan created HBASE-14761:
----------------------------------------------
Summary: Deletes with and without visibility expression does not
delete the matching mutation
Key: HBASE-14761
URL: https://issues.apache.org/jira/browse/HBASE-14761
Project: HBase
Issue Type: Bug
Components: security
Affects Versions: 0.98.15, 1.1.2, 1.0.2, 1.1.0, 1.0.1, 1.0.0
Reporter: ramkrishna.s.vasudevan
Fix For: 2.0.0, 1.2.0, 1.3.0, 0.98.17
This is from the user list as reported by Anoop Sharma
{code}
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
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
