Same ROW-Hash Value for all the record

Teradata Applications
Enthusiast

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.

http://www.teradatatech.com/?p=470 this link suggest that row hash values cannot be same for unique as well as non unique columns.

please clarify me on this question.

Tags (1)
2 REPLIES
Teradata Employee

Re: Same ROW-Hash Value for all the record

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".

Enthusiast

Re: Same ROW-Hash Value for all the record

Thanx Fred for your time  :)