hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Russell Pierce (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-10485) Create md5 UDF
Date Fri, 23 Oct 2015 05:25:27 GMT

    [ https://issues.apache.org/jira/browse/HIVE-10485?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14970469#comment-14970469
] 

Russell Pierce commented on HIVE-10485:
---------------------------------------

Is there anything that must be done to support the md5 function?  
In:
Hive 1.0.0-amzn-1
Subversion git://ip-10-155-25-185/workspace/workspace/bigtop.all-rpm-4.1.0/build/hive/rpm/BUILD/apache-hive-1.0.0-amzn-1-src
-r edd5a97db145470a8723dde24f38c83724e0959c
Compiled by ec2-user on Fri Sep 25 15:34:36 UTC 2015
>From source with checksum af54f19f33a1535ad110eda19817fa7e

I was getting:
hive> SELECT MD5('udf_md5');
FAILED: SemanticException [Error 10011]: Line 1:7 Invalid function 'MD5'


> 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, 2.0.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)

Mime
View raw message