Description
MD5(str)
Calculates an MD5 128-bit checksum for the string. The value is returned as a string of 32 hex digits, or NULL if the argument was NULL. The return value can, for example, be used as a hash key.
Example:
SELECT MD5('udf_md5'); 'ce62ef0d2d27dc37b6d488b92f4b24fd'
online md5 generator: http://www.md5.cz/
MySQL has md5 function: https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html#function_md5
PostgreSQL also has md5 function: http://www.postgresql.org/docs/9.1/static/functions-string.html
Attachments
Attachments
Issue Links
- is related to
-
HIVE-10639 create SHA1 UDF
-
- Closed
-
- relates to
-
HIVE-1262 Add security/checksum UDFs sha,crc32,md5,aes_encrypt, and aes_decrypt
-
- Resolved
-
- links to
