On this page

    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

    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.