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

Switch to Plain View
HBase >> mail # user >> Possible to delete a specific cell?


+
Jonathan Natkins 2013-03-07, 17:55
+
Ted Yu 2013-03-07, 18:04
+
Jean-Marc Spaggiari 2013-03-07, 18:04
+
Jonathan Natkins 2013-03-07, 18:12
+
Sergey Shelukhin 2013-03-07, 18:22
+
Kevin Odell 2013-03-07, 18:26
+
Jeff Kolesky 2013-03-07, 18:31
+
Kevin Odell 2013-03-07, 18:37
+
Jean-Marc Spaggiari 2013-03-07, 18:37
Copy link to this message
-
Re: Possible to delete a specific cell?
JM,

  If you delete t2, you will also wipe out t3 right now.

On Thu, Mar 7, 2013 at 1:37 PM, Jean-Marc Spaggiari <[EMAIL PROTECTED]
> wrote:

> Kevin,
>
> How do you see that? Like a specific cell format which can "cancel"
> once timestamp and no delete all the previous one?
>
> Like before compaction we can have
>
> v1:t1
> v1:t2
> v1:t3
> v1:d2 <= Delete only t2 version.
>
> And at compaction time we only keep that in mind and give this as a result:
> v1:t1
> v1:t3
>
> ?
>
> 2013/3/7 Jeff Kolesky <[EMAIL PROTECTED]>:
> > Yes, this behavior would be fantastic.  If you follow the Kiji/Wibi model
> > of using many versioned cells, being able to delete a specific cell
> without
> > deleting all cells prior to it would be very useful.
> >
> > Jeff
> >
> >
> > On Thu, Mar 7, 2013 at 10:26 AM, Kevin O'dell <[EMAIL PROTECTED]
> >wrote:
> >
> >> 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

Kevin O'Dell
Customer Operations Engineer, Cloudera
+
Ted Yu 2013-03-07, 18:48
+
Kevin Odell 2013-03-07, 18:49
+
Jonathan Natkins 2013-03-07, 20:25
+
yonghu 2013-03-07, 20:56
+
ramkrishna vasudevan 2013-03-08, 03:20
+
Jean-Marc Spaggiari 2013-03-07, 18:44
+
Kevin Odell 2013-03-07, 18:48
+
Sergey Shelukhin 2013-03-07, 18:39