---
title: "Hashing functions"
description: "Scalar functions for hashing values"
---

> Documentation Index
> Fetch the complete documentation index at: https://www.arroyo.dev/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Hashing functions

_Arroyo's Scalar function implementations are based on
[Apache DataFusion](https://arrow.apache.org/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.

Source: https://www.arroyo.dev/docs/sql/scalar-functions/hashing/index.mdx
