Re: Hash algorithm issues

2015-01-21 Thread Furcy Pin
Hi Murali, As you can see from the source code of Hive's hash UDF: https://github.com/apache/hive/blob/trunk/ql/src/java/org/apache/hadoop/hive/ql/udf/generic/GenericUDFHash.java https://github.com/apache/hive/blob/trunk/serde/src/java/org/apache/hadoop/hive/serde2/objectinspector/ObjectInspector

Hash algorithm issues

2015-01-21 Thread murali parimi
Hello team, We are extracting data from netezza and loading into hive tables. While loading data, we are using hash function to mask few PII data for security reasons. One such column is acct_num stored as bigint in netezza, which we are storing in a string column after converting hash of that