跳转到主要内容

SIPHASH

Produces a 64-bit SipHash hash value.

Syntax​

siphash(expression)
siphash64(expression)

Arguments​

ArgumentsDescription
expressionAny expression.
This may be a column name, the result of another function, or a math operation.

Return Type​

A UInt64 data type hash value.

Examples​

SELECT SIPHASH('1234567890');
+-----------------------+
| SIPHASH('1234567890') |
+-----------------------+
|  18110648197875983073 |
+-----------------------+

SELECT SIPHASH(1);
+---------------------+
| SIPHASH(1)          |
+---------------------+
| 4952851536318644461 |
+---------------------+

SELECT SIPHASH(1.2);
+---------------------+
| SIPHASH(1.2)        |
+---------------------+
| 2854037594257667269 |
+---------------------+

SELECT SIPHASH(number) FROM numbers(2);
+----------------------+
| SIPHASH(number)      |
+----------------------+
| 13646096770106105413 |
|  2206609067086327257 |
+----------------------+

SELECT SIPHASH64('1234567890');
+-------------------------+
| SIPHASH64('1234567890') |
+-------------------------+
|    18110648197875983073 |
+-------------------------+