You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@hbase.apache.org by Anoop Sharma <an...@esgyn.com> on 2015/10/29 22:56:31 UTC
delete of cells with visibility expressions
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
RE: delete of cells with visibility expressions
Posted by Anoop Sharma <an...@esgyn.com>.
Thanks for finding the issue, appreciate your help.
Yes, please go ahead and file a JIRA or let me know if you would like me to file it.
Which release would the fix be in? Could it be backported on an earlier release?
anoop
-----Original Message-----
From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
Sent: Tuesday, November 3, 2015 9:51 PM
To: user@hbase.apache.org
Subject: Re: delete of cells with visibility expressions
Seeing the code I think we have identified the issue as Anoop John said. We could fix this probably in the next release. Let us know if you want us to file a JIRA for this.
Regards
Ram
On Wed, Nov 4, 2015 at 11:09 AM, ramkrishna vasudevan < ramkrishna.s.vasudevan@gmail.com> wrote:
> Sorry for the confusion. Yes the bug exists. When I tried in the
> cluster the Visibilty CP was not on. So it is better we can raise a
> JIRA and fix this over there. Thanks Anoop Sharma and sorry for the
> delay from my side due to wrong info.
>
> Regards
> Ram
>
> On Wed, Nov 4, 2015 at 4:15 AM, Anoop Sharma <an...@esgyn.com>
> wrote:
>
>> hi
>>
>> which hbase version did you try this on?
>> We tried on the following 2 hbase versions and see the delete problem.
>>
>> Version 1.0.2, r76745a2cbffe08b812be16e0e19e637a23a923c5, Tue Aug
>> 25
>> 15:59:49 PDT 2015
>> Version 1.1.2, rcc2b70cf03e3378800661ec5cab11eb43fafe0fc, Wed Aug
>> 26
>> 20:11:27 PDT 2015
>>
>> Is there a later version that has the fix?
>>
>> thanks
>>
>> -----Original Message-----
>> From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
>> Sent: Sunday, November 1, 2015 11:11 PM
>> To: user@hbase.apache.org
>> Subject: Re: delete of cells with visibility expressions
>>
>> Is it still a bug? I reproduced the above steps in latest trunk and I
>> thought the behaviour was corrected due to a recent bug fix? Is it
>> not that case ?
>>
>> Regards
>> Ram
>>
>> On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <an...@gmail.com>
>> wrote:
>>
>> > 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
>> > <an...@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
>> > and
>> > > this problem no longer occurs.
>> > >
>> > > Regards
>> > > Ram
>> > >
>> > > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma
>> > > <an...@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 ‘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
>> > > >
>> > >
>> >
>>
>
>
Re: delete of cells with visibility expressions
Posted by ramkrishna vasudevan <ra...@gmail.com>.
Seeing the code I think we have identified the issue as Anoop John said. We
could fix this probably in the next release. Let us know if you want us to
file a JIRA for this.
Regards
Ram
On Wed, Nov 4, 2015 at 11:09 AM, ramkrishna vasudevan <
ramkrishna.s.vasudevan@gmail.com> wrote:
> Sorry for the confusion. Yes the bug exists. When I tried in the cluster
> the Visibilty CP was not on. So it is better we can raise a JIRA and fix
> this over there. Thanks Anoop Sharma and sorry for the delay from my side
> due to wrong info.
>
> Regards
> Ram
>
> On Wed, Nov 4, 2015 at 4:15 AM, Anoop Sharma <an...@esgyn.com>
> wrote:
>
>> hi
>>
>> which hbase version did you try this on?
>> We tried on the following 2 hbase versions and see the delete problem.
>>
>> Version 1.0.2, r76745a2cbffe08b812be16e0e19e637a23a923c5, Tue Aug 25
>> 15:59:49 PDT 2015
>> Version 1.1.2, rcc2b70cf03e3378800661ec5cab11eb43fafe0fc, Wed Aug 26
>> 20:11:27 PDT 2015
>>
>> Is there a later version that has the fix?
>>
>> thanks
>>
>> -----Original Message-----
>> From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
>> Sent: Sunday, November 1, 2015 11:11 PM
>> To: user@hbase.apache.org
>> Subject: Re: delete of cells with visibility expressions
>>
>> Is it still a bug? I reproduced the above steps in latest trunk and I
>> thought the behaviour was corrected due to a recent bug fix? Is it not
>> that
>> case ?
>>
>> Regards
>> Ram
>>
>> On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <an...@gmail.com>
>> wrote:
>>
>> > 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
>> > <an...@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
>> > and
>> > > this problem no longer occurs.
>> > >
>> > > Regards
>> > > Ram
>> > >
>> > > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma
>> > > <an...@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 ‘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
>> > > >
>> > >
>> >
>>
>
>
Re: delete of cells with visibility expressions
Posted by ramkrishna vasudevan <ra...@gmail.com>.
Sorry for the confusion. Yes the bug exists. When I tried in the cluster
the Visibilty CP was not on. So it is better we can raise a JIRA and fix
this over there. Thanks Anoop Sharma and sorry for the delay from my side
due to wrong info.
Regards
Ram
On Wed, Nov 4, 2015 at 4:15 AM, Anoop Sharma <an...@esgyn.com> wrote:
> hi
>
> which hbase version did you try this on?
> We tried on the following 2 hbase versions and see the delete problem.
>
> Version 1.0.2, r76745a2cbffe08b812be16e0e19e637a23a923c5, Tue Aug 25
> 15:59:49 PDT 2015
> Version 1.1.2, rcc2b70cf03e3378800661ec5cab11eb43fafe0fc, Wed Aug 26
> 20:11:27 PDT 2015
>
> Is there a later version that has the fix?
>
> thanks
>
> -----Original Message-----
> From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
> Sent: Sunday, November 1, 2015 11:11 PM
> To: user@hbase.apache.org
> Subject: Re: delete of cells with visibility expressions
>
> Is it still a bug? I reproduced the above steps in latest trunk and I
> thought the behaviour was corrected due to a recent bug fix? Is it not
> that
> case ?
>
> Regards
> Ram
>
> On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <an...@gmail.com> wrote:
>
> > 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
> > <an...@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
> > and
> > > this problem no longer occurs.
> > >
> > > Regards
> > > Ram
> > >
> > > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma
> > > <an...@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 ‘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
> > > >
> > >
> >
>
RE: delete of cells with visibility expressions
Posted by Anoop Sharma <an...@esgyn.com>.
hi
which hbase version did you try this on?
We tried on the following 2 hbase versions and see the delete problem.
Version 1.0.2, r76745a2cbffe08b812be16e0e19e637a23a923c5, Tue Aug 25
15:59:49 PDT 2015
Version 1.1.2, rcc2b70cf03e3378800661ec5cab11eb43fafe0fc, Wed Aug 26
20:11:27 PDT 2015
Is there a later version that has the fix?
thanks
-----Original Message-----
From: ramkrishna vasudevan [mailto:ramkrishna.s.vasudevan@gmail.com]
Sent: Sunday, November 1, 2015 11:11 PM
To: user@hbase.apache.org
Subject: Re: delete of cells with visibility expressions
Is it still a bug? I reproduced the above steps in latest trunk and I
thought the behaviour was corrected due to a recent bug fix? Is it not that
case ?
Regards
Ram
On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <an...@gmail.com> wrote:
> 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
> <an...@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
> and
> > this problem no longer occurs.
> >
> > Regards
> > Ram
> >
> > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma
> > <an...@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 ‘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
> > >
> >
>
Re: delete of cells with visibility expressions
Posted by ramkrishna vasudevan <ra...@gmail.com>.
Is it still a bug? I reproduced the above steps in latest trunk and I
thought the behaviour was corrected due to a recent bug fix? Is it not
that case ?
Regards
Ram
On Mon, Nov 2, 2015 at 12:20 PM, Anoop John <an...@gmail.com> wrote:
> 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 <an...@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
> and
> > this problem no longer occurs.
> >
> > Regards
> > Ram
> >
> > On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma <an...@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 ‘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
> > >
> >
>
Re: delete of cells with visibility expressions
Posted by Anoop John <an...@gmail.com>.
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 <an...@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 and
> this problem no longer occurs.
>
> Regards
> Ram
>
> On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma <an...@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 ‘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
> >
>
RE: delete of cells with visibility expressions
Posted by Anoop Sharma <an...@esgyn.com>.
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 and
this problem no longer occurs.
Regards
Ram
On Fri, Oct 30, 2015 at 3:26 AM, Anoop Sharma <an...@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 ‘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
>
Re: delete of cells with visibility expressions
Posted by ramkrishna vasudevan <ra...@gmail.com>.
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 <an...@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 ‘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
>