This section provides reference information for the Hash functions in PlaidCloud Lakehouse.
1 - BLAKE3
Calculates a BLAKE3 256-bit checksum for a string. The value is returned as a string of 64 hexadecimal digits or NULL if the argument was NULL.
Analyze Syntax
func.blake3(<expr>)
Analyze Examples
func.blake3('1234567890')
+------------------------------------------------------------------+
| func.blake3('1234567890') |
+------------------------------------------------------------------+
| d12e417e04494572b561ba2c12c3d7f9e5107c4747e27b9a8a54f8480c63e841 |
+------------------------------------------------------------------+
SQL Syntax
BLAKE3(<expr>)
SQL Examples
SELECT BLAKE3('1234567890');
┌──────────────────────────────────────────────────────────────────┐
│ blake3('1234567890') │
├──────────────────────────────────────────────────────────────────┤
│ d12e417e04494572b561ba2c12c3d7f9e5107c4747e27b9a8a54f8480c63e841 │
└──────────────────────────────────────────────────────────────────┘
2 - CITY64WITHSEED
Calculates a City64WithSeed 64-bit hash for a string.
Analyze Syntax
func.city64withseed(<expr1>, <expr2>)
Analyze Examples
func.city64withseed('1234567890', 12)
+---------------------------------------+
| func.city64withseed('1234567890', 12) |
+---------------------------------------+
| 10660895976650300430 |
+---------------------------------------+
SQL Syntax
CITY64WITHSEED(<expr1>, <expr2>)
SQL Examples
SELECT CITY64WITHSEED('1234567890', 12);
┌──────────────────────────────────┐
│ city64withseed('1234567890', 12) │
├──────────────────────────────────┤
│ 10660895976650300430 │
└──────────────────────────────────┘
3 - MD5
Calculates an MD5 128-bit checksum for a string. The value is returned as a string of 32 hexadecimal digits or NULL if the argument was NULL.
Analyze Syntax
func.md5(<expr>)
Analyze Examples
func.md5('1234567890')
+------------------------------------------+
| func.md5('1234567890') |
+------------------------------------------+
| e807f1fcf82d132f9bb018ca6738a19f |
+------------------------------------------+
SQL Syntax
MD5(<expr>)
SQL Examples
SELECT MD5('1234567890');
┌──────────────────────────────────┐
│ md5('1234567890') │
├──────────────────────────────────┤
│ e807f1fcf82d132f9bb018ca6738a19f │
└──────────────────────────────────┘
4 - SHA
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
func.sha(<expr>)
Analyze Examples
func.sha('1234567890')
+------------------------------------------+
| func.sha('1234567890') |
+------------------------------------------+
| 01b307acba4f54f55aafc33bb06bbbf6ca803e9a |
+------------------------------------------+
SQL Syntax
SHA(<expr>)
Aliases
SQL Examples
SELECT SHA('1234567890'), SHA1('1234567890');
┌─────────────────────────────────────────────────────────────────────────────────────┐
│ sha('1234567890') │ sha1('1234567890') │
├──────────────────────────────────────────┼──────────────────────────────────────────┤
│ 01b307acba4f54f55aafc33bb06bbbf6ca803e9a │ 01b307acba4f54f55aafc33bb06bbbf6ca803e9a │
└─────────────────────────────────────────────────────────────────────────────────────┘
5 - SHA1
Alias for SHA.
6 - SHA2
Calculates the SHA-2 family of hash functions (SHA-224, SHA-256, SHA-384, and SHA-512). If the hash length is not one of the permitted values, the return value is NULL. Otherwise, the function result is a hash value containing the desired number of bits as a string of hexadecimal digits.
Analyze Syntax
func.sha2(<expr>, <expr>)
Analyze Examples
func.sha2('1234567890', 0)
+------------------------------------------------------------------+
| func.sha2('1234567890', 0)) |
+------------------------------------------------------------------+
| c775e7b757ede630cd0aa1113bd102661ab38829ca52a6422ab782862f268646 |
+------------------------------------------------------------------+
SQL Syntax
SHA2(<expr>, <expr>)
SQL Examples
SELECT SHA2('1234567890', 0);
┌──────────────────────────────────────────────────────────────────┐
│ sha2('1234567890', 0) │
├──────────────────────────────────────────────────────────────────┤
│ c775e7b757ede630cd0aa1113bd102661ab38829ca52a6422ab782862f268646 │
└──────────────────────────────────────────────────────────────────┘
7 - SIPHASH
Alias for SIPHASH64.
8 - SIPHASH64
Produces a 64-bit SipHash hash value.
Analyze Syntax
func.siphash64(<expr>)
Analyze Examples
func.siphash64('1234567890')
+-------------------------------+
| func.siphash64('1234567890') |
+-------------------------------+
| 18110648197875983073 |
+-------------------------------+
SQL Syntax
SIPHASH64(<expr>)
Aliases
SQL Examples
SELECT SIPHASH('1234567890'), SIPHASH64('1234567890');
┌─────────────────────────────────────────────────┐
│ siphash('1234567890') │ siphash64('1234567890') │
├───────────────────────┼─────────────────────────┤
│ 18110648197875983073 │ 18110648197875983073 │
└─────────────────────────────────────────────────┘
9 - XXHASH32
Calculates an xxHash32 32-bit hash value for a string. The value is returned as a UInt32 or NULL if the argument was NULL.
Analyze Syntax
func.xxhash32(<expr>)
Analyze Examples
func.xxhash32('1234567890')
+-----------------------------+
| func.xxhash32('1234567890') |
+-----------------------------+
| 3896585587 |
+-----------------------------+
SQL Syntax
XXHASH32(<expr>)
SQL Examples
SELECT XXHASH32('1234567890');
┌────────────────────────┐
│ xxhash32('1234567890') │
├────────────────────────┤
│ 3896585587 │
└────────────────────────┘
10 - XXHASH64
Calculates an xxHash64 64-bit hash value for a string. The value is returned as a UInt64 or NULL if the argument was NULL.
Analyze Syntax
func.xxhash64(<expr>)
Analyze Examples
func.xxhash64('1234567890')
+-----------------------------+
| func.xxhash64('1234567890') |
+-----------------------------+
| 12237639266330420150 |
+-----------------------------+
SQL Syntax
XXHASH64(<expr>)
SQL Examples
SELECT XXHASH64('1234567890');
┌────────────────────────┐
│ xxhash64('1234567890') │
├────────────────────────┤
│ 12237639266330420150 │
└────────────────────────┘