================ Binary Functions ================ .. spark:function:: hash(x, ...) -> integer Computes the hash of one or more input values using seed value of 42. For multiple arguments, their types can be different. Supported types are: BOOLEAN, TINYINT, SMALLINT, INTEGER, BIGINT, VARCHAR, VARBINARY, REAL, DOUBLE, HUGEINT and TIMESTAMP. .. spark:function:: hash_with_seed(seed, x, ...) -> integer Computes the hash of one or more input values using specified seed. For multiple arguments, their types can be different. Supported types are: BOOLEAN, TINYINT, SMALLINT, INTEGER, BIGINT, VARCHAR, VARBINARY, REAL, DOUBLE, HUGEINT and TIMESTAMP. .. spark:function:: xxhash64(x, ...) -> bigint Computes the xxhash64 of one or more input values using seed value of 42. For multiple arguments, their types can be different. Supported types are: BOOLEAN, TINYINT, SMALLINT, INTEGER, BIGINT, VARCHAR, VARBINARY, REAL, DOUBLE, HUGEINT and TIMESTAMP. .. spark:function:: xxhash64_with_seed(seed, x, ...) -> bigint Computes the xxhash64 of one or more input values using specified seed. For multiple arguments, their types can be different. Supported types are: BOOLEAN, TINYINT, SMALLINT, INTEGER, BIGINT, VARCHAR, VARBINARY, REAL, DOUBLE, HUGEINT and TIMESTAMP. .. spark:function:: md5(x) -> varbinary Computes the md5 of x. .. spark:function:: might_contain(bloomFilter, value) -> boolean Returns TRUE if ``bloomFilter`` might contain ``value``. ``bloomFilter`` is a VARBINARY computed using ::spark::function::`bloom_filter_agg` aggregate function. ``value`` is a BIGINT. .. spark:function:: sha1(x) -> varchar Computes SHA-1 digest of x and convert the result to a hex string. Note: x can only be varbinary type. .. spark:function:: sha2(x, bitLength) -> varchar Calculate SHA-2 family of functions (SHA-224, SHA-256, SHA-384, and SHA-512) and convert the result to a hex string. The second argument indicates the desired bit length of the result, which must have a value of 224, 256, 384, 512, or 0 (which is equivalent to 256). If asking for an unsupported bitLength, the return value is NULL. Note: x can only be varbinary type.