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

["Darshan Jani (Jira)" <ji...@apache.org>]

Darshan Jani created BEAM-10074:
-----------------------------------

             Summary: 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


I would like to propose hash functions: 

# MD5
Calculates an MD5 128-bit checksum of string or bytes and returns it as a hex string
_Note:_ calcite has a function with String as input but not for bytes as input.

{code:java}
SELECT MD5("Some String") as md5;
{code}

# SHA1
Calculates a SHA-1 hash value of string and returns it as a hex string.
_Note:_ calcite has a function with String as input but not for bytes as input.

{code:java}
SELECT SHA1("Some String") as sha1;
{code}

# SHA256
Calculates a SHA-256 hash value of string and returns it as a hex string.

{code:java}
SELECT SHA256("Some String") as sha256;
{code}

# SHA512
Calculates a SHA-512 hash value of string and returns it as a hex string.

{code:java}
SELECT SHA512("Some String") as sha512;
{code}




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