- Release Notes and Announcements
- User Tutorial
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection Overview
- Collection by LogListener
- Uploading Log via Kafka
- Uploading Logs via Logback Appender
- Uploading Logs via Loghub log4j Appender
- Collection via SDK
- Importing Data
- Tencent Cloud Service Log Access
- Log Storage
- Log Search and Analytic
- Overview and Syntax Rules
- Configuring Index
- Analysis Syntax
- Analytic Functions
- String Function
- Date and Time Functions
- IP Geographic Function
- URL Function
- Mathematical Calculation Functions
- Mathematical Statistical Function
- General Aggregate Functions
- Geospatial Function
- Binary String Function
- Estimation Function
- Type Conversion Function
- Logical Function
- Operators
- Bitwise Operation
- Regular Expression Function
- Lambda Function
- Conditional Expressions
- Array Functions
- Interval-Valued Comparison and Periodicity-Valued Comparison Functions
- JSON Functions
- Window Functions
- Quick Analysis
- Context Search and Analysis
- Downloading Log
- Visual Analysis
- Data Processing
- Creating a Processing Task
- Viewing Data Processing Details
- Data Processing Functions
- Function Overview
- Key-Value Extraction Functions
- Enrichment Functions
- Flow Control
- Row Processing Functions
- Field Processing Functions
- Value Structuring Functions
- Regular Expression Processing Functions
- Time Value Processing Functions
- String Processing Functions
- Type Conversion Functions
- Logical Expression Functions
- Processing Cases
- Log Shipping
- Monitoring Alarm
- Function Processing
- Historical Documentation
- Best Practices
- Developer Guide
- API Documentation
- History
- API Category
- Making API Requests
- Log Topic APIs
- Logset APIs
- Topic Partition APIs
- Collection APIs
- Index APIs
- Log APIs
- Alarm Policy APIs
- Collection Configuration APIs
- COS Shipping Task APIs
- CKafka Shipping Task APIs
- Native Kafka Production and Consumption APIs
- Data Types
- Error Codes
- CLS API 2017
- Request Signature
- API Overview
- Collection Configuration
- Consumption Management
- Common Request Headers
- Common Response Headers
- Log Management
- Logset Management
- Log Topic Management
- Shipping Task Management (COS)
- Shipping Task Management (SCF)
- Shipping Task Management (CKafka)
- Machine Group Management
- Consumption Management
- Index Management
- Error Codes
- FAQs
- CLS Service Level Agreement
- Contact Us
- Glossary
- Release Notes and Announcements
- User Tutorial
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection Overview
- Collection by LogListener
- Uploading Log via Kafka
- Uploading Logs via Logback Appender
- Uploading Logs via Loghub log4j Appender
- Collection via SDK
- Importing Data
- Tencent Cloud Service Log Access
- Log Storage
- Log Search and Analytic
- Overview and Syntax Rules
- Configuring Index
- Analysis Syntax
- Analytic Functions
- String Function
- Date and Time Functions
- IP Geographic Function
- URL Function
- Mathematical Calculation Functions
- Mathematical Statistical Function
- General Aggregate Functions
- Geospatial Function
- Binary String Function
- Estimation Function
- Type Conversion Function
- Logical Function
- Operators
- Bitwise Operation
- Regular Expression Function
- Lambda Function
- Conditional Expressions
- Array Functions
- Interval-Valued Comparison and Periodicity-Valued Comparison Functions
- JSON Functions
- Window Functions
- Quick Analysis
- Context Search and Analysis
- Downloading Log
- Visual Analysis
- Data Processing
- Creating a Processing Task
- Viewing Data Processing Details
- Data Processing Functions
- Function Overview
- Key-Value Extraction Functions
- Enrichment Functions
- Flow Control
- Row Processing Functions
- Field Processing Functions
- Value Structuring Functions
- Regular Expression Processing Functions
- Time Value Processing Functions
- String Processing Functions
- Type Conversion Functions
- Logical Expression Functions
- Processing Cases
- Log Shipping
- Monitoring Alarm
- Function Processing
- Historical Documentation
- Best Practices
- Developer Guide
- API Documentation
- History
- API Category
- Making API Requests
- Log Topic APIs
- Logset APIs
- Topic Partition APIs
- Collection APIs
- Index APIs
- Log APIs
- Alarm Policy APIs
- Collection Configuration APIs
- COS Shipping Task APIs
- CKafka Shipping Task APIs
- Native Kafka Production and Consumption APIs
- Data Types
- Error Codes
- CLS API 2017
- Request Signature
- API Overview
- Collection Configuration
- Consumption Management
- Common Request Headers
- Common Response Headers
- Log Management
- Logset Management
- Log Topic Management
- Shipping Task Management (COS)
- Shipping Task Management (SCF)
- Shipping Task Management (CKafka)
- Machine Group Management
- Consumption Management
- Index Management
- Error Codes
- FAQs
- CLS Service Level Agreement
- Contact Us
- Glossary
This document introduces the basic syntax and examples of bitwise operation functions.
| Function | Syntax | Description |
|---|---|---|
| bit_count | bit_count(x, bits) | Returns the number of ones in x in binary representation. |
| bitwise_and | bitwise_and(x, y) | Returns the result of the bitwise AND operation on x and y in binary representation. |
| bitwise_not | bitwise_not(x) | Inverts all bits of x in binary representation. |
| bitwise_or | bitwise_or(x, y) | Returns the result of the bitwise OR operation on x and y in binary representation. |
| bitwise_xor | bitwise_xor(x, y) | Returns the result of the bitwise XOR operation on x and y in binary representation. |
bit_count
The bit_count function is used to return the number of ones in x.
Syntax
bit_count(x, bits)
Parameter description
| Parameter | Description |
|---|---|
| x | The parameter value is of the bigint type. |
| bits | Number of bits, for example, 64 bits. |
Return value type
Bigint
Example
Compute the binary representation of the number 24 and return the number of ones in the binary number.
Query and analysis statement
* | SELECT bit_count(24, 64)Query and analysis result
bitwise_and
The bitwise_and function is used to return the result of the bitwise AND operation on x and y in binary representation.
Syntax
bitwise_and(x, y)
Parameter description
| Parameter | Description |
|---|---|
| x | The parameter value is of the bigint type. |
| y | The parameter value is of the bigint type. |
Return value type
Bigint
Example
Perform an AND operation on numbers 3 and 5 in binary form.
Query and analysis statement
* | SELECT bitwise_and(3, 5)Query and analysis result
bitwise_not
The bitwise_not function is used to invert all bits of x in binary representation.
Syntax
bitwise_not(x)
Parameter description
| Parameter | Description |
|---|---|
| x | The parameter value is of the bigint type. |
Return value type
Bigint
Example
Invert all bits of the number 4 in binary form.
Query and analysis statement
* | SELECT bitwise_not(4)Query and analysis result
bitwise_or
The bitwise_or function is used to return the result of the bitwise OR operation on x and y in binary representation.
Syntax
bitwise_or(x, y)
Parameter description
| Parameter | Description |
|---|---|
| x | The parameter value is of the bigint type. |
| y | The parameter value is of the bigint type. |
Return value type
Bigint
Example
Perform an OR operation on numbers 3 and 5 in binary representation.
Query and analysis statement
* | SELECT bitwise_or(3, 5)Query and analysis result
bitwise_xor
The bitwise_xor function is used to return the result of the bitwise XOR operation on x and y in binary representation.
Syntax
bitwise_xor(x, y)
Parameter description
| Parameter | Description |
|---|---|
| x | The parameter value is of the bigint type. |
| y | The parameter value is of the bigint type. |
Return value type
Bigint
Example
Perform an XOR operation on numbers 3 and 5 in binary representation.
Query and analysis statement
* | SELECT bitwise_xor(3, 5)Query and analysis result
Yes
No
Was this page helpful?