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 ?.
HASH function as a Uniqe number generator
+2
+1>> did HASH function gurenty Uniqes ?
No.
Pigeonhole principle: http://en.wikipedia.org/wiki/Pigeonhole_principle
No.
HashSo uniqueness not guaranteed, in sequence 0 <= Seq <= 2^63 + 1 must be exists at least one duplicate.
Calculates a hash value over its arguments, producing a value in the range 0 <= x < 2^63.
Pigeonhole principle: http://en.wikipedia.org/wiki/Pigeonhole_principle
+2I agree ,i more ask about vertica imlemention
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
