Teradata hash MD5 usage

Question

I need to hash a column in a teradata table by hash_md5, I tried this

select hash_md5(COLUMN_NAME) from TABLE

but it seems not worked like this way. Could anyone suggest please?

This is not a builtin function in Teradata, it must be installed. See https://downloads.teradata.com/download/extensibility/md5-message-digest-udf — dnoeth, Apr 14 '21 at 18:07

score 1 · Answer 1 · answered Nov 10 '22 at 02:47

1

You need to install MD5 UDF first than you can use it.

Please follow the instructions mentioned in below link

answered Nov 10 '22 at 02:47

Muhammad Ali

score 0 · Accepted Answer · answered Aug 12 '21 at 15:36

0

use select SYSUDTLIB.hash_md5(COLUMN_NAME) from TABLE

answered Aug 12 '21 at 15:36

merdo

2 Answers2