Description
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
SELECT MD5("Some String") as md5;
- SHA1
Calculates a SHA-1 hash value of string or bytes and returns it as a bytes.
SELECT SHA1("Some String") as sha1;
- SHA256
Calculates a SHA-256 hash value of string or bytes and returns it as a bytes
SELECT SHA256("Some String") as sha256;
- SHA512
Calculates a SHA-512 hash value of string or bytes and returns it as a bytes.
SELECT SHA512("Some String") as sha512;
Attachments
Issue Links
- is depended upon by
-
BEAM-11624 Hash functions in ZetaSQL
- Triage Needed
- links to