Skip to main content

Arithmetic Functions

Sum

Substrait definition

Calculates the sum of numeric values, if there are no rows a NULL value is returned. if a value is non numeric such as a string or null, those values are ignored.

SQL Usage

SELECT sum(column1) FROM ...

Sum0

Substrait definition

Calculates the sum of numeric values, if there are no rows a 0 value is returned. if a value is non numeric such as a string or null, those values are ignored.

SQL Usage

SELECT sum0(column1) FROM ...

Min

Substrait definition

Returns the minimum value in the result. If there are no rows a NULL value is returned. MIN ignores any null input values.

SQL Usage

SELECT min(column1) FROM ...

Max

Substrait definition

Returns the maximum value in the result. If there are no rows a NULL value is returned. MAX ignores any null input values.

SQL Usage

SELECT max(column1) FROM ...