---
title: SQL hashing functions
description: Use hashing functions to hash string values in SQL queries using established hashing algorithms.
url: https://docs.influxdata.com/influxdb3/cloud-serverless/reference/sql/functions/hashing/
estimated_tokens: 2109
publisher: InfluxData
canonical: https://docs.influxdata.com/influxdb3/cloud-serverless/reference/sql/functions/hashing/
date: '2025-09-05T08:26:38-06:00'
lastmod: '2025-09-05T08:26:38-06:00'
---

Use hashing functions to hash string values in SQL queries using established
hashing algorithms.

* [digest](#digest)
* [md5](#md5)
* [sha224](#sha224)
* [sha256](#sha256)
* [sha384](#sha384)
* [sha512](#sha512)

## digest

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

```sql
digest(expression, algorithm)
```

### Arguments

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

* **algorithm**: String expression specifying algorithm to use.
  Must be one of the following:

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

[](#view-digest-query-example)

View `digest` query example

*The following example uses the[NOAA Bay Area weather sample data](/influxdb3/cloud-serverless/reference/sample-data/#noaa-bay-area-weather-data).*

```sql
SELECT DISTINCT
  location,
  digest(location, 'sha256') AS location_digest
FROM weather
```

|  location   |                        location\_digest                        |
|-------------|----------------------------------------------------------------|
|   Concord   |21e60acfb20fca2e38c5e51191d44235949de045912dca77e978333c1ec965a2|
|   Hayward   |5d5b651a71084f3117cca3381ff7102efbc318c2026e1d09d5d4707354883102|
|San Francisco|5aa34886f7f3741de8460690b636f4c8b7c2044df88e2e8adbb4f7e6f8534931|

## md5

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

```sql
md5(expression)
```

### Arguments

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

[](#view-md5-query-example)

View `md5` query example

*The following example uses the[NOAA Bay Area weather sample data](/influxdb3/cloud-serverless/reference/sample-data/#noaa-bay-area-weather-data).*

```sql
SELECT DISTINCT
  location,
  md5(location) AS location_md5
FROM weather
```

|  location   |         location\_md5          |
|-------------|--------------------------------|
|   Concord   |7c6a8e5769c20331e6a1b93a44021dbc|
|   Hayward   |5823ccc25b256955c4e97cb4a23865ee|
|San Francisco|f4334fdfa1c728eae375fe781e2e2d9d|

## sha224

Computes the SHA-224 hash of a binary string.

```sql
sha224(expression)
```

### Arguments

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

[](#view-sha224-query-example)

View `sha224` query example

*The following example uses the[NOAA Bay Area weather sample data](/influxdb3/cloud-serverless/reference/sample-data/#noaa-bay-area-weather-data).*

```sql
SELECT DISTINCT
  location,
  sha224(location) AS location_sha224
FROM weather
```

|  location   |                    location\_sha224                    |
|-------------|--------------------------------------------------------|
|   Concord   |3f6c0456de97d3d752672161db8e6f0df115979460a2276d64386114|
|   Hayward   |767cfab6a1562e54f6906c8b5c9ee64583caa3f4b6c37a4298a7639f|
|San Francisco|f723898f95bd53cdaf9c057b6f2cf0537b29e0bff077dabb39059b76|

## sha256

Computes the SHA-256 hash of a binary string.

```sql
sha256(expression)
```

### Arguments

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

[](#view-sha256-query-example)

View `sha256` query example

*The following example uses the[NOAA Bay Area weather sample data](/influxdb3/cloud-serverless/reference/sample-data/#noaa-bay-area-weather-data).*

```sql
SELECT DISTINCT
  location,
  sha256(location) AS location_sha256
FROM weather
```

|  location   |                        location\_sha256                        |
|-------------|----------------------------------------------------------------|
|   Concord   |21e60acfb20fca2e38c5e51191d44235949de045912dca77e978333c1ec965a2|
|   Hayward   |5d5b651a71084f3117cca3381ff7102efbc318c2026e1d09d5d4707354883102|
|San Francisco|5aa34886f7f3741de8460690b636f4c8b7c2044df88e2e8adbb4f7e6f8534931|

## sha384

Computes the SHA-384 hash of a binary string.

```sql
sha384(expression)
```

### Arguments

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

[](#view-sha384-query-example)

View `sha384` query example

*The following example uses the[NOAA Bay Area weather sample data](/influxdb3/cloud-serverless/reference/sample-data/#noaa-bay-area-weather-data).*

```sql
SELECT DISTINCT
  location,
  sha384(location) AS location_sha384
FROM weather
```

|  location   |                                        location\_sha384                                        |
|-------------|------------------------------------------------------------------------------------------------|
|   Concord   |19bf5ba95a6c4a28d2a997fa4e03e542d24b111593395b587a3b357af50cc687364f27b4e96935c234e2ae69236c7883|
|   Hayward   |8b034ee0f7c8d191e145002722bf296a7f310f455458b9ffdbafcb2da2e2300d0f1e7868c6b1d512c81ae0c055979abd|
|San Francisco|15c0c4a0e80f198e922235ee30a5c2b1e288c88f61bfc55ef9723903a0e948a7de04b65aa35b4ba46251b90460bab625|

## sha512

Computes the SHA-512 hash of a binary string.

```sql
sha512(expression)
```

### Arguments

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

[](#view-sha512-query-example)

View `sha512` query example

*The following example uses the[NOAA Bay Area weather sample data](/influxdb3/cloud-serverless/reference/sample-data/#noaa-bay-area-weather-data).*

```sql
SELECT DISTINCT
  location,
  sha512(location) AS location_sha512
FROM weather
```

|  location   |                                                        location\_sha512                                                        |
|-------------|--------------------------------------------------------------------------------------------------------------------------------|
|   Concord   |227e28fd661eebb39b10f49728d17b03e3a1f0cc2d2a413a9f124292d77249a2c0d7cf99941fd3d2eabea1b2894698bbd12c2cf3a7137ec67fca221ee57e0ca7|
|   Hayward   |2db79fba2fc2888f9826d95ce6bb2605d95b841da61f049e8a92467de0d6ec3161f3919275208a3c385f6412d7848bfc957e81cde550f4f28cd834a332381142|
|San Francisco|4c84f24d166978fb59d77779bf9a54ac112cba8e5f826c50440b2d3063fa0cbb0e2ccd30c93261a0f96805f71d15c3e726c9e00426161880e6a5dad267b2d883|
| location | location_digest |
| --- | --- |
| location | location_digest |
| Concord | 21e60acfb20fca2e38c5e51191d44235949de045912dca77e978333c1ec965a2 |
| Hayward | 5d5b651a71084f3117cca3381ff7102efbc318c2026e1d09d5d4707354883102 |
| San Francisco | 5aa34886f7f3741de8460690b636f4c8b7c2044df88e2e8adbb4f7e6f8534931 |

| location | location_md5 |
| --- | --- |
| location | location_md5 |
| Concord | 7c6a8e5769c20331e6a1b93a44021dbc |
| Hayward | 5823ccc25b256955c4e97cb4a23865ee |
| San Francisco | f4334fdfa1c728eae375fe781e2e2d9d |

| location | location_sha224 |
| --- | --- |
| location | location_sha224 |
| Concord | 3f6c0456de97d3d752672161db8e6f0df115979460a2276d64386114 |
| Hayward | 767cfab6a1562e54f6906c8b5c9ee64583caa3f4b6c37a4298a7639f |
| San Francisco | f723898f95bd53cdaf9c057b6f2cf0537b29e0bff077dabb39059b76 |

| location | location_sha256 |
| --- | --- |
| location | location_sha256 |
| Concord | 21e60acfb20fca2e38c5e51191d44235949de045912dca77e978333c1ec965a2 |
| Hayward | 5d5b651a71084f3117cca3381ff7102efbc318c2026e1d09d5d4707354883102 |
| San Francisco | 5aa34886f7f3741de8460690b636f4c8b7c2044df88e2e8adbb4f7e6f8534931 |

| location | location_sha384 |
| --- | --- |
| location | location_sha384 |
| Concord | 19bf5ba95a6c4a28d2a997fa4e03e542d24b111593395b587a3b357af50cc687364f27b4e96935c234e2ae69236c7883 |
| Hayward | 8b034ee0f7c8d191e145002722bf296a7f310f455458b9ffdbafcb2da2e2300d0f1e7868c6b1d512c81ae0c055979abd |
| San Francisco | 15c0c4a0e80f198e922235ee30a5c2b1e288c88f61bfc55ef9723903a0e948a7de04b65aa35b4ba46251b90460bab625 |

| location | location_sha512 |
| --- | --- |
| location | location_sha512 |
| Concord | 227e28fd661eebb39b10f49728d17b03e3a1f0cc2d2a413a9f124292d77249a2c0d7cf99941fd3d2eabea1b2894698bbd12c2cf3a7137ec67fca221ee57e0ca7 |
| Hayward | 2db79fba2fc2888f9826d95ce6bb2605d95b841da61f049e8a92467de0d6ec3161f3919275208a3c385f6412d7848bfc957e81cde550f4f28cd834a332381142 |
| San Francisco | 4c84f24d166978fb59d77779bf9a54ac112cba8e5f826c50440b2d3063fa0cbb0e2ccd30c93261a0f96805f71d15c3e726c9e00426161880e6a5dad267b2d883 |