Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
From: Anoop Sharma <anoop.sharma@esgyn.com>
MIME-Version: 1.0
Thread-Index: AdESlImnpw3yFvhZQem5e/JGgOCtWA==
Date: Thu, 29 Oct 2015 14:56:31 -0700
Message-ID: <e1aa80e85153d529eab24169eeddd36d@mail.gmail.com>
Subject: delete of cells with visibility expressions
To: user@hbase.apache.org
Content-Type: multipart/alternative; boundary=001a11468218916fc70523456393

--001a11468218916fc70523456393
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

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 =E2=80=98MANAGER=E2=80=99 au=
thorization.


*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>'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=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>'MANAGER'=
}*

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

--001a11468218916fc70523456393--