[HBASE-33] Add a HTable get/obtainScanner method that retrieves all versions of a particular column and row between two timestamps

• Type: Sub-task
• Status: Closed
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.20.0
• Component/s: Client
• Assignee: Jonathan Gray
• Reporter: Peter Dolan
• Created: 08/Jan/08 22:53
• Updated: 20/Sep/18 18:37
• Resolved: 06/Jun/09 20:46

Description

The use case:

• A weblog application for which rows are user ids and posts are stored in a single column, with post date specified by the cell's timestamp. The application would then need to be able to display all posts for the last week or month.
• A feedfetcher for which rows are URLs and feed posts are stored in a single column with the post publish date or fetch time stored in the cell's timestamp. The application would then need to be able to display all posts for the last week or month.

Proposed API:

// Get all versions of the specified row and column whose timestamps are in [minTimestamp, maxTimestamp]
SortedMap<long, byte[]> getTimestamps(Text row, Text column, long minTimestamp, long maxTimestamp);

// Get all versions of the specified row and column whose timestamps are >= minTimestamp
SortedMap<long, byte[]> getTimestamps(Text row, Text column, long minTimestamp);

I'd be happy to take this on myself, as I need it for the above use cases before migrating my application over to HBase.

Issue Links

• blocks: HBASE-1304 New client server implementation of how gets and puts are handled.
• incorporates: HBASE-30 [hbase] Method to get a list of a row's timestamps accompanied by the columns at that version
• is blocked by: HBASE-733 Enhance Cell so that it can contain multiple values at multiple timestamps
• is blocked by: HBASE-52 [hbase] Add a means of scanning over all versions