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




SQL :: Sha512Agg
Returns a single SHA-512 hash of all of the values in each group, as a lower case hex string. Useful for detecting changes to a set of documents.
SQL :: ShowAggregateFunctions
Lists the built-in aggregate functions with their parameters and descriptions.
SQL :: Sum
Returns the total of the values in each group.
SQL :: Syntax
Basic KBSQL syntax and some examples.
SQL :: Variance
Returns the population variance of the values in each group: how far the values are spread from their mean.