View a markdown version of this page

CHECKSUM function - Amazon Redshift

Amazon Redshift will no longer support the use of Python UDFs after June 30, 2026. We will start enforcing it in phases. For more information on the details of Python end of life and migration options, see the blog post that was published on June 30, 2025.

CHECKSUM function

Computes a checksum value for building a hash index.

Syntax

CHECKSUM(expression)

Argument

expression

The input expression must be a VARCHAR, INTEGER, or DECIMAL data type.

Return type

The CHECKSUM function returns an integer.

Example

The following example computes a checksum value for the COMMISSION column:

select checksum(commission) from sales order by salesid limit 10; checksum ---------- 10920 1140 5250 2625 2310 5910 11820 2955 8865 975 (10 rows)