All Forums Teradata Applications
21 Feb 2016
Same ROW-Hash Value for all the record

Hi All,
When i tried finding the Row hash value for the unique column which have all unique values ,i saw that all row hash value matches for every single record present there. this link suggest that row hash values cannot be same for unique as well as non unique columns.
please clarify me on this question.

Fred 1096 posts Joined 08/04
21 Feb 2016

The Teradata hash function is deterministic - same input values always give the same result. It's possible (but unusual) for different input values to give the same result, referred to as a "hash collision".

22 Feb 2016

Thanx Fred for your time  :)

You must sign in to leave a comment.