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

{{< expand-wrapper >}}
{{% expand "View `digest` query example" %}}

_The following example uses the
[NOAA Bay Area weather sample data](/influxdb3/version/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 |

{{% /expand %}}
{{< /expand-wrapper >}}

## 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.

{{< expand-wrapper >}}
{{% expand "View `md5` query example" %}}

_The following example uses the
[NOAA Bay Area weather sample data](/influxdb3/version/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 |

{{% /expand %}}
{{< /expand-wrapper >}}

## 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.

{{< expand-wrapper >}}
{{% expand "View `sha224` query example" %}}

_The following example uses the
[NOAA Bay Area weather sample data](/influxdb3/version/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 |

{{% /expand %}}
{{< /expand-wrapper >}}

## 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.

{{< expand-wrapper >}}
{{% expand "View `sha256` query example" %}}

_The following example uses the
[NOAA Bay Area weather sample data](/influxdb3/version/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 |

{{% /expand %}}
{{< /expand-wrapper >}}

## 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.

{{< expand-wrapper >}}
{{% expand "View `sha384` query example" %}}

_The following example uses the
[NOAA Bay Area weather sample data](/influxdb3/version/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 |

{{% /expand %}}
{{< /expand-wrapper >}}

## 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.

{{< expand-wrapper >}}
{{% expand "View `sha512` query example" %}}

_The following example uses the
[NOAA Bay Area weather sample data](/influxdb3/version/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 |

{{% /expand %}}
{{< /expand-wrapper >}}