This topic describes the syntax of bitwise functions. This topic also provides examples on how to use the functions.

Notice If you want to use strings in analytic statements, you must enclose strings in single quotation marks (''). Strings that are not enclosed or enclosed in double quotation marks ("") indicate field names or column names. For example, 'status' indicates the status string, and status or "status" indicates the status log field.
Function Syntax Description
bit_count function bit_count(x,bits) Returns the number of bits 1 in x in binary representation.
bitwise_and function bitwise_and(x,y) Returns the result of the bitwise AND operation on x and y in binary representation.
bitwise_not function bitwise_not(x) Returns the result of the bitwise NOT operation on x in binary representation.
bitwise_or function bitwise_or(x,y) Returns the result of the bitwise OR operation on x and y in binary representation.
bitwise_xor function bitwise_xor(x,y) Returns the result of the bitwise XOR operation on x and y in binary representation.

## bit_count function

The bit_count function returns the number of bits 1 in x in binary representation.

### Syntax

``bit_count(x,bits)``

### Parameters

Parameter Description
x The value of this parameter is of the bigint type.
bits The value of this parameter is the number of bits, such as 64 bits.

The bigint type.

### Examples

Convert the number 24 into a binary number and obtain the number of bits 1 in the binary number.

• Query statement
``* | SELECT bit_count(24, 64)``
• Query and analysis results

## bitwise_and function

The bitwise_and function returns the result of the bitwise AND operation on x and y in binary representation.

### Syntax

``bitwise_and(x,y)``

### Parameters

Parameter Description
x The value of this parameter is of the bigint type.
y The value of this parameter is of the bigint type.

The bigint type.

### Examples

Perform a bitwise AND operation on 3 and 5 in binary representation.

• Query statement
``* | SELECT bitwise_and(3, 5)``
• Query and analysis results

## bitwise_not function

The bitwise_not function returns the result of the bitwise NOT operation on x in binary representation.y

### Syntax

``bitwise_not(x)``

### Parameters

Parameter Description
x The value of this parameter is of the bigint type.

The bigint type.

### Examples

Perform a bitwise NOT operation on 4 in binary representation.

• Query statement
``* | SELECT bitwise_not(4)``
• Query and analysis results

## bitwise_or function

The bitwise_or function returns the result of the bitwise OR operation on x and y in binary representation.

### Syntax

``bitwise_or(x,y)``

### Parameters

Parameter Description
x The value of this parameter is of the bigint type.
y The value of this parameter is of the bigint type.

The bigint type.

### Examples

Perform a bitwise OR operation on 3 and 5 in binary representation.

• Query statement
``* | SELECT bitwise_or(3, 5)``
• Query and analysis results

## bitwise_xor function

The bitwise_xor function returns the result of the bitwise XOR operation on x and y in binary representation.

### Syntax

``bitwise_xor(x,y)``

### Parameters

Parameter Description
x The value of this parameter is of the bigint type.
y The value of this parameter is of the bigint type.

The bigint type.

### Examples

Perform a bitwise XOR operation on 3 and 5 in binary representation.

• Query statement
``?1* | SELECT bitwise_xor(3, 5)``
• Query and analysis results