Amazon Kinesis Data Analytics
SQL Reference

MOD

MOD ( <dividend>, <divisor> ) <dividend> := <integer-expression> <divisor>  := <integer-expression>

Returns the remainder when the first argument (the dividend is divided by the second numeric argument (the divisor). If the divisor is zero, a divide by zero error is raised.

Examples

Function Result

MOD(4,2)

0

MOD(5,3)

2

MOD(-4,3)

-1

MOD(5,12)

5

Limitations

The Amazon Kinesis Data Analytics MOD function only supports arguments of scale 0 (integers). This is a departure from the SQL:2008 standard, which supports any numeric argument. Other numeric arguments can be CAST to an integer, of course.

On this page: