Getting a unique value for VARCHAR field.

Database
Fan

Re: Getting a unique value for VARCHAR field.

Thank you Fred. Much appreciated.

Enthusiast

Re: Getting a unique value for VARCHAR field.

Will the same HASHBUCKET(HASHROW()) values be generated across Teradata servers?

Ambassador

Re: Getting a unique value for VARCHAR field.

The hashing algorithm is used internally to distribute rows based on the Primary Index, thus it's always producing the same result.

 

But as the algorithm was improved several times over the last decades there might be a low probability that you access a very old system with a different imlementation.

Highlighted
Enthusiast

Re: Getting a unique value for VARCHAR field.

Thanks Dieter!