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.