I don't know what the row start and end keys are - they GUID keys (improves 
writes across cluster - had help with this from this user-group before).
I need to export data written between "startDate" and "endDate" into a 
relational database so I can interrogate the data (SUM/AVG, etc).

That is why I am are using: scan.setTimeRange(fromDate.getTime(), 
toDate.getTime());
In my test with live data, I only took between 2010-03-26 00:00:00 and 
2010-03-26 01:00:00 - there should only be a few thousand rows in-between those 
dates.

Will hbase still take forever to find the data I look for unless I use 
startRow/endRow?

-----Original Message-----
From: TuX RaceR [mailto:tuxrace...@gmail.com] 
Sent: 04 May 2010 05:52 PM
To: hbase-user@hadoop.apache.org
Subject: Re: Improving HBase scanner

Michelan Arendse wrote:
> Is there a way to speed up the fetching of data from HBase?
>
>   

Divide your key space in smaller chunks?
using closer |startRow, and ||stopRow?|
|*cf: 
<http://hadoop.apache.org/hbase/docs/current/api/org/apache/hadoop/hbase/client/Scan.html#Scan%28byte%5B%5D,%20byte%5B%5D%29>

Scan 
<http://hadoop.apache.org/hbase/docs/current/api/org/apache/hadoop/hbase/client/Scan.html#Scan%28byte%5B%5D,%20byte%5B%5D%29>*(byte[]
 startRow, 
byte[] stopRow)|


TuX

Reply via email to