> From: [email protected]
> To: [email protected]
> Date: Tue, 31 May 2011 15:39:14 -0400
> Subject: RE: How to efficiently join HBase tables?
> 
> Re:  " Didn't see a multi-get... "
> 
> This is what I'm talking about...  
> http://hbase.apache.org/apidocs/org/apache/hadoop/hbase/client/HTable.html#get%28java.util.List%29
> 
> re:  " not sure it would buy you much."
> 
> Let's say you did these in groups of 500.  Although the reads still obviously 
> need to be performed on the RegionServer, it would cut the total RS calls 
> down by a factor of 500, which is not insignificant.
> 
> No matter what approach is taken, this won't be cheap.
> 
> As Jean Girard (Talladega Nights) would say, "That is a fair compromise, no?"
> 
> 

AH Ricky Bobby! :-P

Uhm silly question... how do you use the get(List<Get> gets) if you don't know 
the row key?

:-)

You're assuming that you're fetching against the row key. I'm assuming that 
your joining on a foreign key (at best) where the row key isn't known, which is 
why I'm suggesting sequential scans based on the join criteria.

Its a sad day in Ohio when Tressell resigns. :-(

-Mike
                                          

Reply via email to