[
https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Alexander Pivovarov updated HIVE-10485:
---------------------------------------
Description:
MD5(str)
Calculates an MD5 128-bit checksum for UTF-8 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:
{code}
SELECT MD5('udf_md5');
'ce62ef0d2d27dc37b6d488b92f4b24fd'
{code}
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
was:
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:
{code}
SELECT MD5('udf_md5');
'ce62ef0d2d27dc37b6d488b92f4b24fd'
{code}
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
> Create md5 UDF
> --------------
>
> Key: HIVE-10485
> URL: https://issues.apache.org/jira/browse/HIVE-10485
> Project: Hive
> Issue Type: Task
> Components: UDF
> Reporter: Alexander Pivovarov
> Assignee: Alexander Pivovarov
>
> MD5(str)
> Calculates an MD5 128-bit checksum for UTF-8 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:
> {code}
> SELECT MD5('udf_md5');
> 'ce62ef0d2d27dc37b6d488b92f4b24fd'
> {code}
> 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
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
