Hash Functions in Confluent Cloud for Apache Flink¶
Confluent Cloud for Apache Flink®️ provides these built-in functions to generate hash codes in SQL queries:
MD5¶
Gets the MD5 hash of a string.
- Syntax
MD5(string)
- Description
The
MD5
function returns the MD5 hash of the specified string as a string of 32 hexadecimal digits.Returns NULL if
string
is NULL.- Example
-- returns 99dc0ea422440e5b3f675cffe6d... SELECT MD5('string-to-hash');
SHA1¶
Gets the SHA-1 hash of a string.
- Syntax
SHA1(string)
- Description
The
SHA1
function returns the SHA-1 hash of the specified string as a string of 40 hexadecimal digits.Returns NULL if
string
is NULL.- Example
-- returns 771a2b04044f8c51e3383a2675a... SELECT SHA1('string-to-hash');
SHA2¶
Hashes a string with one of the SHA-2 functions.
- Syntax
SHA2(string, hashLength)
- Description
The
SHA2
function returns the hash using the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and SHA-512).- The first argument,
string
, is the string to be hashed. - The second argument,
hashLength
, is the bit length of the result.
These are the valid bit lengths for
hashLength
:- 224
- 256
- 384
- 512
Returns NULL if
string
orhashLength
is NULL.- The first argument,
- Example
-- returns 222145560dbaa2abc1617e2c7ce... SELECT SHA2('string-to-hash', 512);
SHA224¶
Gets the SHA-224 hash of a string.
- Syntax
SHA224(string)
- Description
The
SHA224
function returns the SHA-224 hash of the specified string as a string of 56 hexadecimal digits.Returns NULL if
string
is NULL.- Example
-- returns af1f1c988d9154f2ddb6201f60f... SELECT SHA224('string-to-hash');
SHA256¶
Gets the SHA-256 hash of a string.
- Syntax
SHA256(string)
- Description
The
SHA256
function returns the SHA-256 hash of the specified string as a string of 64 hexadecimal digits.Returns NULL if
string
is NULL.- Example
-- returns 2267d414e45335fd02e64057d55... SELECT SHA256('string-to-hash');
SHA384¶
Gets the SHA-384 hash of a string.
- Syntax
SHA384(string)
- Description
The
SHA5384
function returns the SHA-384 hash of the specified string as a string of 96 hexadecimal digits.Returns NULL if
string
is NULL.- Example
-- returns 02ba979b23f1b4a098732463ea8... SELECT SHA384('string-to-hash');
SHA512¶
Gets the SHA-512 hash of a string.
- Syntax
SHA512(string)
- Description
The
SHA512
function returns the SHA-512 hash of the specified string as a string of 128 hexadecimal digits.Returns NULL if
string
is NULL.- Example
-- returns 222145560dbaa2abc1617e2c7ce... SELECT SHA512('string-to-hash');