All Products
Search
Document Center

MaxCompute:SHA1

Last Updated:Jul 24, 2023

Calculates the SHA-1 hash value of expr that is of the STRING or BINARY type and returns the SHA-1 hash value in hexadecimal string format.

Syntax

string sha1(string|binary <expr>)

Parameters

expr: required. A value of the STRING or BINARY type.

Return value

A value of the STRING type is returned. If the input parameter is set to null, null is returned.

Examples

  • Example 1: Calculate the SHA-1 hash value of string ABC. Sample statement:

    -- The return value is 3c01bdbb26f358bab27f267924aa2c9a03fcfdb8. 
    select sha1('ABC');
  • Example 2: An input parameter is set to null. Sample statement:

    -- The return value is null. 
    select sha1(null);

Related functions

For more information, see Other functions.