Categories: Conversion

HASH64

Returns 64-bit hash of input value, with optional seed.

Syntax

HASH64(value ANY [, seed BIGINT]) → BIGINT

• value: Input value for hash calculation.
• seed (optional): Optional seed for hash calculation.

Examples

HASH64 example

SELECT HASH64('abc')
-- -5434086359492102041

HASH64 example

SELECT HASH64(5.127)
-- -1149762993205326574

HASH64 example

SELECT HASH64(null)
-- 0

HASH64 example

SELECT HASH64('abc',123)
-- 1489494923063836066