farmFingerprint64 function

Computes the farmhash value of the input argument using the Fingerprint64 function.

Syntax

farmFingerprint64(expression)

Argument

expression

The input expression must be a VARCHAR or VARBYTE data type.

Return type

The farmFingerprint64 function returns a BIGINT.

Example

The following example returns the farmFingerprint64 value of Amazon Redshift that is input as a VARCHAR data type.

SELECT farmFingerprint64('Amazon Redshift');

  
  farmfingerprint64
---------------------
 8085098817162212970

The following example returns the farmFingerprint64 value of Amazon Redshift that is input as a VARBYTE data type.

SELECT farmFingerprint64('Amazon Redshift'::varbyte);

  
  farmfingerprint64
---------------------
 8085098817162212970