Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
HBase, mail # user - Possible to delete a specific cell?


Copy link to this message
-
Re: Possible to delete a specific cell?
Kevin O'dell 2013-03-07, 18:26
The problem is it kills all older cells.  We should probably file a JIRA
for this, as this behavior would be nice.  Thoughts?:

hbase(main):028:0> truncate 'tre'

Truncating 'tre' table (it may take a while):

- Disabling table...

- Dropping table...

- Creating table...

0 row(s) in 4.6060 seconds
hbase(main):029:0> put 'tre', 'row1', 'cf1:c1', 'abc', 111

0 row(s) in 0.0220 seconds
hbase(main):030:0> put 'tre', 'row1', 'cf1:c1', 'abcd', 112

0 row(s) in 0.0060 seconds
hbase(main):031:0> put 'tre', 'row1', 'cf1:c1', 'abce', 113

0 row(s) in 0.0120 seconds
hbase(main):032:0> scan 'tre', {NAME => 'cf1:c1', VERSIONS => 4}

ROW                                                          COLUMN+CELL
row1                                                        column=cf1:c1,
timestamp=113, value=abce

row1                                                        column=cf1:c1,
timestamp=112, value=abcd

row1                                                        column=cf1:c1,
timestamp=111, value=abc
hbase(main):033:0> delete 'tre', 'row1', 'cf1:c1', 112

0 row(s) in 0.0110 seconds
hbase(main):034:0> scan 'tre', {NAME => 'cf1:c1', VERSIONS => 4}

ROW                                                          COLUMN+CELL
 row1                                                        column=cf1:c1,
timestamp=113, value=abce

1 row(s) in 0.0290 seconds
On Thu, Mar 7, 2013 at 1:22 PM, Sergey Shelukhin <[EMAIL PROTECTED]>wrote:

> Shouldn't you be able to insert delete with t belonging to (t2, t3) to
> achieve this effect?
>
> On Thu, Mar 7, 2013 at 10:12 AM, Jonathan Natkins <[EMAIL PROTECTED]
> >wrote:
>
> > Yep, that's the scenario I was curious about. Thanks!
> >
> >
> > On Thu, Mar 7, 2013 at 10:04 AM, Jean-Marc Spaggiari <
> > [EMAIL PROTECTED]> wrote:
> >
> > > Hi Jonathan,
> > >
> > > Is that what you mean?
> > >
> > > In the same CF:C
> > > insert r1 v1 t1
> > > insert r1 v2 t2
> > > insert r1 v3 t3
> > >
> > > Then you want to be able to delete r1 v3 t3 to see r1 v2?
> > >
> > > This is not possible. If you put a delete with t4, everything older
> > > than t4 will be deleted when the compression will occur.
> > >
> > > JM
> > >
> > > 2013/3/7 Jonathan Natkins <[EMAIL PROTECTED]>:
> > > > It was suggested to me that there might be a way to delete a cell in
> a
> > > > column for a particular timestamp, without masking all older values.
> Is
> > > > this true? Or have I been fed lies?
> > > >
> > > > Thanks!
> > > > Natty
> > > >
> > > > --
> > > > http://www.wibidata.com
> > > > office: 1.415.496.9424 x208
> > > > cell: 1.609.577.1600
> > > > twitter: @nattyice <http://www.twitter.com/nattyice>
> > >
> >
> >
> >
> > --
> > http://www.wibidata.com
> > office: 1.415.496.9424 x208
> > cell: 1.609.577.1600
> > twitter: @nattyice <http://www.twitter.com/nattyice>
> >
>

--
Kevin O'Dell
Customer Operations Engineer, Cloudera