Binary Functions

hash(x) integer

Computes the hash of x.

md5(x) varbinary

Computes the md5 of x.

sha1(x) varchar

Computes SHA-1 digest of x and convert the result to a hex string. Note: x can only be varbinary type.

sha2(x, bitLength) varchar

Calculate SHA-2 family of functions (SHA-224, SHA-256, SHA-384, and SHA-512) and convert the result to a hex string. The second argument indicates the desired bit length of the result, which must have a value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If asking for an unsupported bitLength, the return value is NULL. Note: x can only be varbinary type.

xxhash64(x) integer

Computes the xxhash64 of x.