Mailing-List: contact user-help@hbase.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hbase.apache.org
MIME-Version: 1.0
In-Reply-To: <72dd2c48875386a8341ca999d1363202@mail.gmail.com>
References: <e1aa80e85153d529eab24169eeddd36d@mail.gmail.com>
	<CAAT7Mkq5feVa7WJ8=HPKNZCuQwJe4hZEZKi=zVeWMCR1NNWJXQ@mail.gmail.com>
	<72dd2c48875386a8341ca999d1363202@mail.gmail.com>
Date: Mon, 2 Nov 2015 12:20:44 +0530
Message-ID: 
 <CAOtJ30qPWu=X0gOnXRFFRBP+yy_7WyQXzSJQt4qkyGWgjxX3jQ@mail.gmail.com>
Subject: Re: delete of cells with visibility expressions
From: Anoop John <anoop.hbase@gmail.com>
To: "user@hbase.apache.org" <user@hbase.apache.org>
Content-Type: multipart/alternative; boundary=001a11403c6644926f0523893294

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

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 <anoop.sharma@esgyn.com>
wrote:

> Thanks Ram.
>
> we are using hbase 1.0.2.
>
> anoop
>
> -----Original Message-----
> From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
> Sent: Thursday, October 29, 2015 10:22 PM
> To: user@hbase.apache.org
> 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 an=
d
> this problem no longer occurs.
>
> Regards
> Ram
>
> On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma <anoop.sharma@esgyn.com>
> 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 =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 colu=
mn.
> >
> >
> >
> >
> >
> >
> >
> > *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
> >
>

--001a11403c6644926f0523893294--