Mailing-List: contact issues-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Date: Wed, 18 Nov 2015 22:38:11 +0000 (UTC)
From: "Ted Yu (JIRA)" <jira@apache.org>
To: issues@hbase.apache.org
Message-ID: <JIRA.12910421.1446659543000.113395.1447886291192@Atlassian.JIRA>
In-Reply-To: <JIRA.12910421.1446659543000@Atlassian.JIRA>
References: <JIRA.12910421.1446659543000@Atlassian.JIRA>
 <JIRA.12910421.1446659543381@arcas>
Subject: [jira] [Updated] (HBASE-14761) Deletes with and without visibility
 expression do not delete the matching mutation
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/HBASE-14761?page=3Dcom.atlassi=
an.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ted Yu updated HBASE-14761:
---------------------------
    Summary: Deletes with and without visibility expression do not delete t=
he matching mutation  (was: Deletes with and without visibility expression =
does not delete the matching mutation)

> Deletes with and without visibility expression do 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: 1.0.0, 1.0.1, 1.1.0, 1.0.2, 1.1.2, 0.98.15
>            Reporter: ramkrishna.s.vasudevan
>            Assignee: ramkrishna.s.vasudevan
>             Fix For: 2.0.0, 1.2.0, 1.3.0, 0.98.17
>
>         Attachments: HBASE-14761.patch
>
>
> 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 =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>'MANAGE=
R'}*
> 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>'MANAGE=
R'}*
> 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
> {code}


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)