HASHROW Function Syntax | VantageCloud Lake - HASHROW Function Syntax - 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.

expression	HASHROW Action
Empty	Returns maximum hash code value.
Evaluates to NULL	Returns '00000000'XB.
List of expressions that all evaluate to NULL
Evaluates to 0, '', ' ', or similar value
Valid, non-NULL expression that can appear in select list of SELECT statement	Evaluates expression or each expression in list, applies hash function to result, and returns resulting row hash value.
List of expressions that can appear in select list of SELECT statement, some of which can evaluate to NULL