hashteradatamd5

Teradata hash MD5 usage

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?

Solution

  • use select SYSUDTLIB.hash_md5(COLUMN_NAME) from TABLE