Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
HASH function as a Uniqe number generator
Hi
We like to use Vertica HASH() function, for generating numbers on top of scripts , did HASH function gurenty Uniqes ? so two diffrent string will never have the same same hash number ?.
We like to use Vertica HASH() function, for generating numbers on top of scripts , did HASH function gurenty Uniqes ? so two diffrent string will never have the same same hash number ?.
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
No. So uniqueness not guaranteed, in sequence 0 <= Seq <= 2^63 + 1 must be exists at least one duplicate.
Pigeonhole principle: http://en.wikipedia.org/wiki/Pigeonhole_principle