SHA1

All functions > STRING > SHA1

Returns the SHA-1 hash of a string as a 40-character hexadecimal string.

Signatures

Returns: 40-character lowercase hexadecimal SHA-1 hash

SHA1(string: VARCHAR) → VARCHAR

Notes

• Returns a 160-bit hash as a 40-character lowercase hex string
• Deterministic: same input always produces the same hash
• Not available on DataFusion
• Not suitable for security-sensitive applications; use SHA256 instead
• Returns NULL if the input is NULL

Examples

SELECT
    f1 := SHA1('ABC'),  -- Hash of uppercase string
    f2 := SHA1('hello'),  -- Hash of lowercase string
    f3 := SHA1('')  -- Hash of empty string
;