Numeric
This page describes how to use numeric functions in Lenses SQL Processors.
Last updated
This page describes how to use numeric functions in Lenses SQL Processors.
Last updated
2024 © Lenses.io Ltd. Apache, Apache Kafka, Kafka and associated open source project names are trademarks of the Apache Software Foundation.
%
The remainder operator (%) computes the remainder after dividing its first operand by its second i.e. numExpr % numExpr
✓
✓
/
Divides one number by another (an arithmetic operator) i.e. numExpr / numExpr
✓
✓
-
Subtracts one number from another (an arithmetic operator) i.e. numExpr - numExpr
✓
✓
*
Multiplies one number with another (an arithmetic operator) i.e. numExpr * numExpr
✓
✓
+
Adds one number to another (an arithmetic operator) i.e. numExpr + numExpr
✓
✓
- (negative)
Returns the negative of the value of a numeric expression (a unary operator) i.e. -numExpr
✓
✓