Sha256Agg

Table of Contents



Returns a single SHA-256 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.

String Sha256Agg(AggregationArray valuesArray)

Ordering

The values are sorted before they are hashed, so the result does not depend on the order in which documents are read. Two groups with the same values produce the same hash.


round-pushpin Hashes the words of each language.
SELECT LanguageId, Sha256Agg(Text) as Hash FROM WordList:Word GROUP BY LanguageId