跳转到主要内容

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 |
+-------------------------+