SHA (Lakehouse v1)
Calculates an SHA-1 160-bit checksum for the string, as described in RFC 3174 (Secure Hash Algorithm). The value is returned as a string of 40 hexadecimal digits or NULL if the argument was NULL.
Analyze Syntax
Section titled “Analyze Syntax”func.sha(<expr>)Analyze Examples
Section titled “Analyze Examples”func.sha('1234567890')
┌──────────────────────────────────────────┐│ func.sha('1234567890') │├──────────────────────────────────────────┤│ 01b307acba4f54f55aafc33bb06bbbf6ca803e9a │└──────────────────────────────────────────┘SQL Syntax
Section titled “SQL Syntax”SHA(<expr>)Aliases
Section titled “Aliases”SQL Examples
Section titled “SQL Examples”SELECT SHA('1234567890'), SHA1('1234567890');
┌─────────────────────────────────────────────────────────────────────────────────────┐│ sha('1234567890') │ sha1('1234567890') │├──────────────────────────────────────────┼──────────────────────────────────────────┤│ 01b307acba4f54f55aafc33bb06bbbf6ca803e9a │ 01b307acba4f54f55aafc33bb06bbbf6ca803e9a │└─────────────────────────────────────────────────────────────────────────────────────┘