Skip to main content
Version: 24.3.x

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