Skip to main content

Categories: Conversion

HASH

Returns a hash value of the arguments. HASH does not return NULL, even for NULL inputs.

Syntax​

HASH(expression any) → numeric​

  • expression: Can be a general expression of any Dremio-supported data type.

Examples

HASH example 
SELECT HASH(host_id)
FROM "Samples"."samples.dremio.com"."Dremio University"."airbnb_listings.csv"
LIMIT 5
-- 1110609030
-- 1283762365
-- -1745730253
-- 0
-- 0

Usage Notes​

HASH is a proprietary function that can accept different input expressions of arbitrary Dremio supported data types and returns a signed value. It is not a cryptographic hash function and should not be used as such.