This topic describes how to use the BITAND function to perform a bitwise AND 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 BITAND(INT number1,INT number2)
Note The input and output parameters are both of the INT type.

Input parameters

Parameter Data type
number1 INT
number2 INT

Example

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