Home | About | Sematext search-lucene.com search-hadoop.com
 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
do you want to delete just subset of the rows, or delete whole table?
if whole, then use "drop" it should be almost instant.
Same as in oracle, you can do "delete * from table;" and it may take forever, even give errors on rollback segment too small…
if you use "drop table" it mark it as deleted instantly, and then delete actual data during the next major compaction.

Thank you!

Leonid Fedotov

On Dec 5, 2012, at 5:03 AM, Manoj Babu 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.