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 Threaded View
HBase >> mail # user >> Reg:delete performance on HBase table


Copy link to this message
-
Re: Reg:delete performance on HBase table
Hello Manoj,

     When a Delete command is issued , no data is actually deleted
instantaneously. Instead a tombstone marker is set, making the deleted
cells effectively invisible.

The tombstone markers are only deleted during major compactions (which
compacts all store files to a single one), because in order to prove that a
tombstone marker has no effect HBase needs to look at all cells.

HBase periodically removes deleted cells during compactions.

HTH

Regards,
    Mohammad Tariq

On Wed, Dec 5, 2012 at 6:33 PM, Manoj Babu <[EMAIL PROTECTED]> wrote:

> Hi All,
>
> I am having doubt on delete performance inHBase table.
>
> I have 190 million rows in oracle table it hardly took 4hours to delete it,
> If i am having the same 190 million rows in HBase table how much time by
> approx Hbase will take to delete the rows(based on row key range) and
> how internally HBase handles delete?
>
>
> Thanks in advance!
>
> Cheers!
> Manoj.
>
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