Help Center/ Data Lake Insight/ Spark SQL Syntax Reference/ Built-In Functions/ Mathematical Functions/ abs
Updated on 2023-10-25 GMT+08:00
View PDF

abs

This function is used to calculate the absolute value of an input parameter.

Syntax

abs(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.

If the value is not of the DOUBLE type, the system will implicitly convert it to the DOUBLE type for calculation.

Return Values

The return value is of the DOUBLE or INT type.

If the value of a is NULL, NULL is returned.

Example Code

The value NULL is returned.

select abs(null);

The value 1 is returned.

select abs(-1);

The value 3.1415926 is returned.

select abs(-3.1415926);
Parent topic: Mathematical Functions