All Forums Database
karthikyn 3 posts Joined 04/14
11 May 2014
how UPI gives even distribution

i have a question on even distribution in case of  UPI defined. though the values are unique and unique row hash will be generated what would be the guarantee all the row hashes generated wouldnt  be bucketed to same amp. ie if value 5 10 15 20 25 are rowhash value generated and when bucketing takes place in a 5 amp system wouldn't all these go to the same amp ?

Duri83 17 posts Joined 01/12
11 May 2014

Yes, they would, but for small tables it would not cause any issues and for tables with every additional record the probability of that is decreasing. Probability of having 10 rows on the same AMP in TD Express ~ 0.004.

You must sign in to leave a comment.