[SPARK-28122] Binary String Functions: SHA functions

• Type: Sub-task
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.0.0
• Component/s: SQL
• Assignee: Unassigned
• Reporter: Yuming Wang
• Created: 20/Jun/19 09:04
• Updated: 09/Jan/20 02:23
• Resolved: 09/Jan/20 02:23

Description

Function	Return Type	Description	Example	Result
sha224(bytea)	bytea	SHA-224 hash	sha224('abc')	\x23097d223405d8228642a477bda255b32aadbce4bda0b3f7e36c9da7
sha256(bytea)	bytea	SHA-256 hash	sha256('abc')	\xba7816bf8f01cfea414140de5dae2223b00361a396177a9cb410ff61f20015ad
sha384(bytea)	bytea	SHA-384 hash	sha384('abc')	\xcb00753f45a35e8bb5a03d699ac65007272c32ab0eded1631a8b605a43ff5bed8086072ba1e7cc2358baeca134c825a7
sha512(bytea)	bytea	SHA-512 hash	sha512('abc')	\xddaf35a193617abacc417349ae20413112e6fa4e89a97ea20a9eeee64b55d39a2192992a274fc1a836ba3c23a3feebbd454d4423643ce80e2a9ac94fa54ca49f

More details: https://www.postgresql.org/docs/11/functions-binarystring.html