HASHROW Function Syntax | Teradata Vantage - HASHROW Function Syntax - Analytics Database - Teradata Vantage

HASHROW ( [ expression [,...] ] )

Syntax Elements

expression

An optional expression or comma-separated list of expressions that can appear in the expression list of the select clause of a SELECT statement; typically a comma-separated list of column names that make up a (potential) index.

HASHROW does not support expressions that result in UDT data types.

IF expression is …	THEN HASHROW …
empty	returns the maximum hash code value.
an expression that evaluates to NULL	returns '00000000'XB.
a list of expressions where all the expressions evaluate to NULL
an expression that evaluates to 0, '', ' ', or a similar value
a valid, non-NULL expression that can appear in the select list of a SELECT statement	evaluates expression or the list of expressions and applies the hash function on the result. HASHROW returns the resulting row hash value.
a list of expressions that can appear in the select list of a SELECT statement, where some expressions can evaluate to NULL