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

pmod

This function is used to return the positive value of the remainder after division of x by y.

Syntax

pmod(INT a, INT b)

Parameters

Table 1 Parameters

Parameter

Mandatory

Type

Description

a

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

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

b

Yes

DOUBLE, BIGINT, DECIMAL, or STRING

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

Return Values

The return value is of the DECIMAL or INT type.

  • If the value of a or b is NULL, NULL is returned.
  • If the value of b is 0, NULL is returned.

Example Code

The value 2 is returned.

select pmod(2,5);

The value 3 is returned.

select pmod (-2,5) (parse: -2=5* (-1)...3);

The value NULL is returned.

select pmod(5,0);

The value 1 is returned.

select pmod(5,2);

The value 0.877 is returned.

select pmod(5.123,2.123);
Parent topic: Mathematical Functions