All Forums Database
11 Oct 2006
whether row hash changes when new nodes or Amp added?

Hi All, As I am going to prepare for PI and puzzled in few questions, looking to find the answer of these questions...whether hash row changes when we add new AMPs or Nodes in the existing Teradata System....?can any body put more lights on it....Thanks in Advance....

XTUPIE 42 posts Joined 11/05
26 Oct 2006

HiYes it will, providing you have more AMP's. The Row hash is always the same and a record will always be put on the same AMP but if you upgrade you system and add more AMP's this will change and not all rows will be on the same AMPs.


shankarkanth 2 posts Joined 10/06
27 Oct 2006

As you said row hash will change. Before upgrading are they going to empty the records? then reloaded to allow wider distribution of records? I am not clear about already exsting records how they will be treated.Please clarify me.with regards,shankarkanth

Fred 1096 posts Joined 08/04
28 Oct 2006

RowHash does NOT change. Only HashMap (which RowHash values go to which AMP) changes.

BBR2 96 posts Joined 12/04
29 Oct 2006

You could HASH functions to check this before and after upgrade.Vinay

Fred 1096 posts Joined 08/04
29 Oct 2006

Correct. You should find: HASHROW(...) does not change HASHBUCKET(HASHROW(...)) does not change HASHAMP(HASHBUCKET(HASHROW(...))) does change for some values

You must sign in to leave a comment.