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

positive

This function is used to return the value of a.

Syntax

positive(INT 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 DECIMAL, DOUBLE, or INT type.

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

Example Code

The value 3 is returned.

SELECT positive(3);

The value -3 is returned.

SELECT positive(-3);

The value 123 is returned.

SELECT positive('123');