- Release Notes and Announcements
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection Overview
- Collecting Logs in Self-Built Kubernetes Cluster
- Collecting Syslog
- Collection by LogListener
- Collecting Text Log
- Uploading Log over Kafka
- Uploading Logs via Anonymous Write
- Uploading Logs via Logback Appender
- Uploading Logs via Log4j Appender
- Uploading Log via SDK
- Uploading Log via API
- Importing Data
- Tencent Cloud Service Log Access
- Metric Collection
- Log Storage
- Metric Storage
- Search and Analysis (Log Topic)
- Syntax and Rules
- Statistical Analysis (SQL)
- Quick Analysis
- SQL Syntax
- SQL Functions
- String Function
- Date and Time Functions
- IP Geographic Function
- URL Function
- Mathematical Calculation Functions
- Mathematical Statistical Function
- General Aggregate Function
- 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
- Sampling Analysis
- Configuring Indexes
- Reindexing
- Context Search and Analysis
- Downloading Log
- Search and Analysis (Metric Topic)
- Dashboard
- Data Processing documents
- Data Processing
- Creating 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 and Mathematical Functions
- Encoding and Decoding Functions
- IP Parsing Functions
- Processing Cases
- Scheduled SQL Analysis
- SCF
- Data Processing
- Shipping and Consumption
- Monitoring Alarm
- Historical Documentation
- Practical Tutorial
- Developer Guide
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Topic Management APIs
- Log Set Management APIs
- Index APIs
- Topic Partition APIs
- Machine Group APIs
- Collection Configuration APIs
- Log APIs
- Metric APIs
- Alarm Policy APIs
- Data Processing APIs
- Kafka Protocol Consumption APIs
- CKafka Shipping Task APIs
- Kafka Data Subscription APIs
- COS Shipping Task APIs
- SCF Delivery Task APIs
- Scheduled SQL Analysis APIs
- COS Data Import Task APIs
- Data Types
- Error Codes
- FAQs
- CLS Service Level Agreement
- CLS Policy
- Contact Us
- Glossary
- Release Notes and Announcements
- User Guide
- Product Introduction
- Purchase Guide
- Getting Started
- Operation Guide
- Resource Management
- Permission Management
- Log Collection
- Collection Overview
- Collecting Logs in Self-Built Kubernetes Cluster
- Collecting Syslog
- Collection by LogListener
- Collecting Text Log
- Uploading Log over Kafka
- Uploading Logs via Anonymous Write
- Uploading Logs via Logback Appender
- Uploading Logs via Log4j Appender
- Uploading Log via SDK
- Uploading Log via API
- Importing Data
- Tencent Cloud Service Log Access
- Metric Collection
- Log Storage
- Metric Storage
- Search and Analysis (Log Topic)
- Syntax and Rules
- Statistical Analysis (SQL)
- Quick Analysis
- SQL Syntax
- SQL Functions
- String Function
- Date and Time Functions
- IP Geographic Function
- URL Function
- Mathematical Calculation Functions
- Mathematical Statistical Function
- General Aggregate Function
- 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
- Sampling Analysis
- Configuring Indexes
- Reindexing
- Context Search and Analysis
- Downloading Log
- Search and Analysis (Metric Topic)
- Dashboard
- Data Processing documents
- Data Processing
- Creating 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 and Mathematical Functions
- Encoding and Decoding Functions
- IP Parsing Functions
- Processing Cases
- Scheduled SQL Analysis
- SCF
- Data Processing
- Shipping and Consumption
- Monitoring Alarm
- Historical Documentation
- Practical Tutorial
- Developer Guide
- API Documentation
- History
- Introduction
- API Category
- Making API Requests
- Topic Management APIs
- Log Set Management APIs
- Index APIs
- Topic Partition APIs
- Machine Group APIs
- Collection Configuration APIs
- Log APIs
- Metric APIs
- Alarm Policy APIs
- Data Processing APIs
- Kafka Protocol Consumption APIs
- CKafka Shipping Task APIs
- Kafka Data Subscription APIs
- COS Shipping Task APIs
- SCF Delivery Task APIs
- Scheduled SQL Analysis APIs
- COS Data Import Task APIs
- Data Types
- Error Codes
- FAQs
- CLS Service Level Agreement
- CLS Policy
- Contact Us
- Glossary
This document introduces the basic syntax and examples of bitwise operation functions.
Function | Syntax | Description |
bit_count(x, bits) | Returns the number of ones in x in binary representation. | |
bitwise_and(x, y) | Returns the result of the bitwise AND operation on x and y in binary representation. | |
bitwise_not(x) | Inverts all bits of x in binary representation. | |
bitwise_or(x, y) | Returns the result of the bitwise OR operation on x and y in binary representation. | |
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
2
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
1
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
-5
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
7
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
6
Yes
No
Was this page helpful?