Checksum

The checksum function generates a checksum value based on the data within documents of a specified schema. It's utilized alongside the SELECT statement to produce a checksum value that represents the content of the documents within the schema, aiding in data integrity validation and comparison.


Numeric Checksum(String text)


Selects documents from the Word schema and calculates the checksum of the text field.

SELECT
    Text,
    Checksum(Text) as CRC
FROM
    WordList:Word
WHERE
    Text LIKE 'Cat%'

• Scalar Functions