Rows are very small (like 50 bytes max). I am accessing the latest version
after setting timerange.
HTable table = new HTable(new HBaseConfiguration(), table_name);
Get getRes = new Get(Bytes.toBytes(lkp_key));
long maxStamp = new SimpleDateFormat("yyyyMMdd").parse(date_for_ts,
new ParsePosition(0)).getTime();
getRes.setTimeRange(0, maxStamp);
Result r = table.get(getRes);
NavigableMap<byte[], byte[]> kvMap =
r.getFamilyMap((Bytes.toBytes("data")));
-----Original Message-----
From: Michael Segel [mailto:[email protected]]
Sent: Tuesday, June 29, 2010 12:46 PM
To: [email protected]
Subject: RE: speed up reads in hBase
How wide are your rows?
Are you accessing the last version or pulling back all of the versions per row?
> From: [email protected]
> To: [email protected]
> Date: Tue, 29 Jun 2010 12:11:46 -0700
> Subject: speed up reads in hBase
>
>
> I have about 2.8M rows in my HBase table with multiple versions ( max 6) .
>
> When I try to lookup 1000 records, it takes a total time of 20 minutes ! Per
> read takes about a second or more.
> Will appreciate any pointers on speeding these ?
>
> Thanks,
> -Avani
_________________________________________________________________
Hotmail has tools for the New Busy. Search, chat and e-mail from your inbox.
http://www.windowslive.com/campaign/thenewbusy?ocid=PID28326::T:WLMTAGL:ON:WL:en-US:WM_HMP:042010_1
