Paul Mackles 2012-10-05, 18:17
-Re: bulk deletes
lars hofhansl 2012-10-05, 19:39
Does it work? :)
How did you do the deletes before?I assume you used the HTable.delete(List<Delete>) API?
(Doesn't really help you, but) In 0.92+ you could hook up a coprocessor into the compactions and simply filter out any KVs you want to have removed.
From: Paul Mackles <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Friday, October 5, 2012 11:17 AM
Subject: bulk deletes
We need to do deletes pretty regularly and sometimes we could have hundreds of millions of cells to delete. TTLs won't work for us because we have a fair amount of bizlogic around the deletes.
Given their current implemention (we are on 0.90.4), this delete process can take a really long time (half a day or more with 100 or so concurrent threads). From everything I can tell, the performance issues come down to each delete being an individual RPC call (even when using the batch API). In other words, I don't see any thrashing on hbase while this process is running – just lots of waiting for the RPC calls to return.
The alternative we came up with is to use the standard bulk load facilities to handle the deletes. The code turned out to be surpisingly simple and appears to work in the small-scale tests we have tried so far. Is anyone else doing deletes in this fashion? Are there drawbacks that I might be missing? Here is a link to the code:
Pretty simple, eh? I haven't seen much mention of this technique which is why I am a tad paranoid about it.
Anoop Sam John 2012-10-08, 03:55
Paul Mackles 2012-10-08, 11:45
Jerry Lam 2012-10-10, 15:07
Anoop Sam John 2012-10-11, 04:04
Jerry Lam 2012-10-12, 21:41
Jacques 2012-10-05, 19:37