[
https://issues.apache.org/jira/browse/BEAM-10074?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Anonymous updated BEAM-10074:
-----------------------------
Status: Open (was: Triage Needed)
> 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
> Fix For: 2.28.0
>
> Time Spent: 40m
> 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.20.10#820010)
