[ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14531001#comment-14531001 ]
Alexander Pivovarov commented on HIVE-10485: -------------------------------------------- added md5 UDF description to Misc. Functions https://cwiki.apache.org/confluence/display/Hive/LanguageManual+UDF#LanguageManualUDF-Misc.Functions > 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 > Fix For: 1.3.0 > > Attachments: HIVE-10485.1.patch, HIVE-10485.2.patch, > HIVE-10485.3.patch > > > 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 -- This message was sent by Atlassian JIRA (v6.3.4#6332)