elasticsearch/docs/reference/query-languages/esql/_snippets/functions/hash.md

HASH [esql-hash]

Syntax

:::{image} ../../../../../images/hash.svg :alt: Embedded :class: text-center :::

Parameters

algorithm : Hash algorithm to use.

input : Input to hash.

Description

Computes the hash of the input using various algorithms such as MD5, SHA, SHA-224, SHA-256, SHA-384, SHA-512.

Supported types

algorithm	input	result
keyword	keyword	keyword
keyword	text	keyword
text	keyword	keyword
text	text	keyword

Example

FROM sample_data
| WHERE message != "Connection error"
| EVAL md5 = hash("md5", message), sha256 = hash("sha256", message)
| KEEP message, md5, sha256;

message:keyword	md5:keyword	sha256:keyword
Connected to 10.1.0.1	abd7d1ce2b	6d8372129ad78770f7185554dd39864749a62690216460752d6c075fa38ad85c
Connected to 10.1.0.2	8f8f1cb608	b0db24720f15857091b3c99f4c4833586d0ea3229911b8777efb8d917cf27e9a
Connected to 10.1.0.3	912b6dc135	75b0480188db8acc4d5cc666a51227eb2bc5b989cd8ca912609f33e0846eff57
Disconnected	ef70e46fd3	04dfac3671b494ad53fcd152f7a14511bfb35747278aad8ce254a0d6e4ba4718