This topic describes mathematical and logical operations between different data types in Realtime Compute for Apache Flink.

Note The data types of numeric1 and numeric2 in a mathematical operation must be the same.
Mathematical operation Description Data types supported by numeric1 and numeric2 Example
numeric1 + numeric2 Returns the sum of two numbers in a mathematical operation.
• INT
• DOUBLE
• DECIMAL
• BIGINT
`2+4.2`
numeric1 - numeric2 Returns the difference between two numbers in a mathematical operation. `3-5.3`
numeric1 * numeric2 Returns the product of two numbers in a mathematical operation. `2*4`
numeric1 / numeric2 Returns the quotient of two numbers in a mathematical operation. `2.4/5`
numeric1 > numeric2 Checks whether the first number is greater than the second number in a mathematical operation. `2.4>5`
numeric1 < numeric2 Checks whether the first number is less than the second number in a mathematical operation. `2.4<5`
numeric1 >= numeric2 Checks whether the first number is greater than or equal to the second number in a mathematical operation. `2.4>=5`
numeric1 <= numeric2 Checks whether the first number is less than or equal to the second number in a mathematical operation. `2.4<=5`
numeric1 = numeric2 Checks whether the two numbers in a mathematical operation are equal to each other.
• INT
• DOUBLE
• DECIMAL
• BIGINT
• VARCHAR
`'iphone' = 5`
numeric1 <> numeric2 Checks whether the two numbers in a mathematical operation are not equal to each other. `'iphone' <> 5`