Hashing functions

Arroyo’s Scalar function implementations are based on Apache DataFusion and these docs are derived from the DataFusion function reference.

​

digest

Computes the binary hash of an expression using the specified algorithm.

digest(expression, algorithm)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of string operators.

• algorithm: String expression specifying algorithm to use. Must be one of:

  • md5
  • sha224
  • sha256
  • sha384
  • sha512
  • blake2s
  • blake2b
  • blake3

​

md5

Computes an MD5 128-bit checksum for a string expression.

md5(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of string operators.

​

sha224

Computes the SHA-224 hash of a binary string.

sha224(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of string operators.

​

sha256

Computes the SHA-256 hash of a binary string.

sha256(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of string operators.

​

sha384

Computes the SHA-384 hash of a binary string.

sha384(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of string operators.

​

sha512

Computes the SHA-512 hash of a binary string.

sha512(expression)

Arguments

• expression: String expression to operate on. Can be a constant, column, or function, and any combination of string operators.