This topic describes how to use the BITXOR function to perform a bitwise XOR operation.

Limits

This function is supported only in Realtime Compute for Apache Flink that uses Ververica Runtime (VVR) 3.0.0 or later.

Syntax

INT BITXOR(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 BITXOR(a, b) as var1
FROM T1;
  • Test result
    var1(INT)
    1