https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-hash-function-unique-values/m-p/119489#M47113 <P>Hi,</P><P>Can someone confirm if the hash function would always result with unique integer value, say even for millions of unique account numbers, and the same number would not repeat again?</P> Thu, 24 Nov 2016 03:14:25 GMT ashsskum 2016-11-24T03:14:25Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-hash-function-unique-values/m-p/119489#M47113 <P>Hi,</P><P>Can someone confirm if the hash function would always result with unique integer value, say even for millions of unique account numbers, and the same number would not repeat again?</P> Thu, 24 Nov 2016 03:14:25 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-hash-function-unique-values/m-p/119489#M47113 ashsskum 2016-11-24T03:14:25Z https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-hash-function-unique-values/m-p/119490#M47114 <P>Depends on what arguments you are providing to the hash function. If your argument values are unique, you would most likely get unique value from hash. Keep in mind hive hash function return int (which is 32bit) so you may see -ve numbers as well. You can use something like reflect('java.util.UUID','randomUUID') to generate uniqueID or comeup with some unique code. I would not suggest using hash function, if you want to generate unique ids.</P> Thu, 24 Nov 2016 04:59:04 GMT https://community.cloudera.com/t5/Archives-of-Support-Questions/Hive-hash-function-unique-values/m-p/119490#M47114 kkhan 2016-11-24T04:59:04Z