Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
+
Kevin Odell 2013-03-07, 18:42
+
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
Copy link to this message
-
Re: Possible to delete a specific cell?
Nevermind, I misread the scenario the other way around.

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
> > > cell: 1.609.577.1600
> > > twitter: @nattyice <http://www.twitter.com/nattyice>
> > >
> >
>
>
>
> --
> Kevin O'Dell
> Customer Operations Engineer, Cloudera
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB