This topic describes how to use the BITOR function to perform a bitwise OR operation.

Notice This topic applies only to Ververica Platform (VVP) 2.4.0, Ververica Runtime (VVR) 3.0.0, and their later versions.

Syntax

INT BITOR(INT number1, INT number2)

Input parameters

Parameter Data type
number1 INT
number2 INT
Note The input and output parameters are both of the INT type.

Example

  • Test data
    a(INT) b(INT)
    2 3
  • Test statement
    SELECT BITOR(a, b) as var1
    FROM T1;                
  • Test result
    var1(INT)
    3