Performs a bitwise OR operation on two INT values and returns an INT result.
Limits
This function is supported only in Realtime Compute for Apache Flink that uses Ververica Runtime (VVR) 3.0.0 or later.
Syntax
INT BITOR(INT number1, INT number2)Parameters
| Parameter | Data type |
|---|---|
| number1 | INT |
| number2 | INT |
Both input parameters and the return value are of the INT type.
Example
SELECT BITOR(a, b) AS var1
FROM T1;
-- var1: 3
-- Explanation: 2 (binary: 10) OR 3 (binary: 11) = 3 (binary: 11)Input data
| a (INT) | b (INT) |
|---|---|
| 2 | 3 |
Result
| var1 (INT) |
|---|
| 3 |