Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Atualizado 04/11/2024
Send us feedback
sha2
Applies to: Databricks SQL Databricks Runtime
Returns a checksum of the SHA-2 family as a hex string of expr.
SHA-2
expr
sha2(expr, bitLength)
expr: A BINARY or STRING expression.
BINARY
STRING
bitLength: An INTEGER expression.
bitLength
INTEGER
A STRING.
bitLength can be 0, 224, 256, 384, or 512. bitLength 0 is equivalent to 256.
224
256
384
512
>> SELECT sha2('Spark', 256); 529bc3b07127ecb7e53a4dcf1991d9152c24537d919178022b2c42657f79a26b
mask function
sha function
sha1 function
crc32 function
md5 function
hash function