[jira] [Work logged] (BEAM-10074) Hash Functions in BeamSQL

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/BEAM-10074?focusedWorklogId=437284&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-437284 ]

ASF GitHub Bot logged work on BEAM-10074:
-----------------------------------------

                Author: ASF GitHub Bot
            Created on: 27/May/20 03:28
            Start Date: 27/May/20 03:28
    Worklog Time Spent: 10m 
      Work Description: darshanj commented on pull request #11817:
URL: https://github.com/apache/beam/pull/11817#issuecomment-634066798


   R: @amaliujia 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


Issue Time Tracking
-------------------

            Worklog Id:     (was: 437284)
    Remaining Estimate: 0h
            Time Spent: 10m

> Hash Functions in BeamSQL
> -------------------------
>
>                 Key: BEAM-10074
>                 URL: https://issues.apache.org/jira/browse/BEAM-10074
>             Project: Beam
>          Issue Type: New Feature
>          Components: dsl-sql
>            Reporter: Darshan Jani
>            Assignee: Darshan Jani
>            Priority: P2
>          Time Spent: 10m
>  Remaining Estimate: 0h
>
> I would like to propose hash functions (implemented as UDFs): 
> Optionally we can also add for below functions variants which return hex string instead of bytes. 
> # MD5
> Calculates an MD5 128-bit checksum of string or bytes and returns it as a bytes
> {code:java}
> SELECT MD5("Some String") as md5;
> {code}
> # SHA1
> Calculates a SHA-1 hash value of string or bytes and returns it as a bytes.
> {code:java}
> SELECT SHA1("Some String") as sha1;
> {code}
> # SHA256
> Calculates a SHA-256 hash value of string or bytes and returns it as a bytes
> {code:java}
> SELECT SHA256("Some String") as sha256;
> {code}
> # SHA512
> Calculates a SHA-512 hash value of string or bytes and returns it as a bytes.
> {code:java}
> SELECT SHA512("Some String") as sha512;
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)