HASH

Takes one or more input parameters of any data type and returns a 64-bit non-cryptographic hash value. HASH uses the CityHash algorithm for string data types, implementation-specific algorithms for other data types, and the CityHash combinator to produce the resulting hash value. NULL values of any type get the same fixed value. See CITY_HASH if NULL values should produce NULL.

Syntax

HASH(<expression>, [, expression [,...]])

Parameters

Parameter	Description	Supported input types
`<expression>`	An expression that returns any data type that Firebolt supports.	Any

Return type

BIGINT

Examples

SELECT HASH('esimpson', '08-25-2016');

hash long
-6509667128195191394

Rows: 1Execution time: 4.85ms

SELECT HASH(NULL, '08-25-2016');

hash long
7610523868633494549

Rows: 1Execution time: 7.10ms

GREATEST

⌘I

Overview

Performance and Observability

Security

Self-Managed

Managed service

Guides

SQL reference

Release notes

API reference

Legal

Syntax

Parameters

Return type

Examples

​Syntax

​Parameters

​Return type

​Examples

Syntax

Parameters

Return type

Examples