phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <>
Subject Re: Optimisation on join in case of all the data to be joined present in the same machine (region server)
Date Mon, 16 Apr 2018 15:34:04 GMT
Short-answer: no.

You're going to be much better off de-normalizing your five tables into 
one table and eliminate the need for this JOIN.

What made you decide to want to use Phoenix in the first place?

On 4/16/18 6:04 AM, Rabin Banerjee wrote:
> HI all,
> I am new to phoenix, I wanted to know if I have to join 5 huge tables 
> where all are keyed based on the same id (i.e. one id columns is common 
> between all of them), is there any optimization to add to make this join 
> faster , as all the data for a particular key for all 5 tables will 
> reside in the same region server .
> To explain it bit more, suppose we have 5 streams all having a common id 
> that we can join with are getting stored in 5 different hbase table. And 
> we want to join them with Phoenix but we dont want cross region shuffle 
> as we already know that the key is common in all 5 tables.
> Thanks //

View raw message