This documentation is related to an older version of Firebolt. For the most current documentation, see Firebolt documentation.
CITY_HASH
Takes one or more input parameters of any data type and returns a 64-bit non-cryptographic hash value. CITY_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.
Syntax
CITY_HASH(<exp>, [, expr2 [,...]])
| Parameter | Description |
|---|---|
<exp> | An expression that returns any data type that Firebolt supports. |
Example
SELECT CITY_HASH('15', 'apple', '02-25-1918')
Returns: 2383463095444788470