Help Center> Data Lake Insight> SQL Syntax Reference (To Be Offline)> Spark SQL Syntax Reference (Unavailable Soon)> Built-in Functions> Mathematical Functions> sign
Updated on 2023-10-25 GMT+08:00
View PDF

sign

This function is used to return the positive and negative signs corresponding to a.

Syntax

sign(DOUBLE a)

Parameters

Table 1 Parameter

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

The value can be a float, integer, or string.

Return Values

The return value is of the DOUBLE type.

  • If the value of a is a positive number, 1 is returned.
  • If the value of a is a negative number, -1 is returned.
  • If the value of a is 0, 0 is returned.
  • If the value of a is NULL, NULL is returned.

Example Code

The value -1 is returned.

select sign(-3);

The value 1 is returned.

select sign(3);

The value 0 is returned.

select sign(0);

The value 1 is returned.

select sign(3.1415926);

The value NULL is returned.

select sign(null);
Parent topic: Mathematical Functions