Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
In this article
Applies to: ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel
Returns a sha1 hash value of the source input.
hash_sha1(
source)
Learn more about syntax conventions.
Name | Type | Required | Description |
---|---|---|---|
source | scalar | ✔️ | The value to be hashed. |
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).
Warning
The algorithm used by this function (SHA1) is guaranteed to not be modified in the future, but is very complex to calculate. If you need a "lightweight" hash function for the duration of a single query, consider using hash().
print
h1=hash_sha1("World"),
h2=hash_sha1(datetime(2020-01-01))
Output
h1 | h2 |
---|---|
70c07ec18ef89c5309bbb0937f3a6342411e1fdd | e903e533f4d636b4fc0dcf3cf81e7b7f330de776 |
The following example uses the hash_sha1()
function to aggregate StormEvents based on State's SHA1 hash value.
StormEvents
| summarize StormCount = count() by State, StateHash=hash_sha1(State)
| top 5 by StormCount desc
Output
State | StateHash | StormCount |
---|---|---|
TEXAS | 3128d805194d4e6141766cc846778eeacb12e3ea | 4701 |
KANSAS | ea926e17098148921e472b1a760cd5a8117e84d6 | 3166 |
IOWA | cacf86ec119cfd5b574bde5b59604774de3273db | 2337 |
ILLINOIS | 03740763b16dae9d799097f51623fe635d8c4852 | 2022 |
MISSOURI | 26d938907240121b54d9e039473dacc96e712f61 | 2016 |