Hashing

The e6 Ingestion Engine scalar functions are based on Apache DataFusion and these docs are derived from the DataFusion function reference.

Function	Description	Example	Result
md5(str)	MD5 hash	md5('hello')	'5d41402a...'
sha224(str)	SHA-224 hash	sha224('hello')	'ea09ae9c...'
sha256(str)	SHA-256 hash	sha256('hello')	'2cf24dba...'
sha384(str)	SHA-384 hash	sha384('hello')	'59e1748777...'
sha512(str)	SHA-512 hash	sha512('hello')	'9b71d224bd...'
digest(str, algo)	Hash with algorithm	digest('hello', 'sha256')	'2cf24dba...'

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.