hash_sha1

The hash_sha1 function returns a SHA1 hash value for the input value.

Syntax

​

    hash_sha1( Source )

Arguments

​

• Source: The value to be hashed.

Returns

​

The SHA1 hash value of the given scalar, encoded as a hex string (a string of characters, each two of which represent a single Hex number between 0 and 255).

Examples

​

• h1=hash_sha1("World")
• h2=hash_sha1(datetime(2020-01-01))

Aggregate by hash

​

This example uses the hash_sha1 function to aggregate StormEvents based on the State’s SHA1 hash value.

dataset=StormEvents
| summarize StormCount = count() by State, StateHash=hash_sha1(State)
| top 5 by StormCount desc

Returns the following: