[HBASE-6942] Endpoint implementation for bulk deletion of data

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.94.3, 0.95.0
• Component/s: Coprocessors, Performance
• Hadoop Flags: Reviewed

Release Note

This issue gives an example Endpoint implementation for efficiently deleting bulk data from tables. Which data to be deleted can be controlled using a Scan object passed to the endpoint.
We can delete rows, column families, column qualifiers or cell versions based on delete type passed.
Optionally timestamp also can be passed. When timestamp is passed for ROW, FAMILY and COLUMN delete types, all the versions before that time(specified time inclusive) will get deleted.
When the type is VERSION, if a timestamp is passed, only one version(with ts as given value) of all the cells which the Scan selected will be deleted. When no timestamp value passed for VERSION type delete it will delete all the cell versions which the Scan selected. Using appropriate Scan with Timerange etc user can control which versions to be deleted.
The API returns the number of rows deleted (In types other than ROW it is not entire row deleted) and when type is VERSION it will return total number of versions deleted also.
The Scan can be created with a rowkey range, with some filters, with Timerange etc based on the delete usecase.

• Assignee: Anoop Sam John
• Reporter: Anoop Sam John
• Created: 04/Oct/12 04:56
• Updated: 26/Feb/13 08:20
• Resolved: 24/Oct/12 03:36

Description

We can provide an end point implementation for doing a bulk deletion of data(based on a scan) at the server side. This can reduce the time taken for such an operation as right now it need to do a scan to client and issue delete(s) using rowkeys.

Query like delete from table1 where...