tencent cloud

TencentDB for CTSDB

Release Notes and Announcements
Release Notes
Announcements
Product Introduction
Overview
System Architecture
Use Cases
Key Concepts
Instance Types and Specifications
Purchase Guide
Product Pricing
Purchasing an Instance
Renewal Instructions
Overdue Payment Instructions
Refund Instructions
Getting Started
Connecting to an Instance and Writing Data
Operation Guide
CAM
Managing an Instance
Automatic Backup
System Monitoring
Database Management
Account Management
Managing a Security Group
Public Network Access
InfluxQL Compatibility
Database Management
Schema Query
Data Type
Data Query
InfluxQL Functions
Client
SDK Reference
influx CLI Client
API Documentation
History
Introduction
API Category
Making API Requests
Instance APIs
Database APIs
Data Types
Error Codes
Practical Tutorial
Recommendations for the Data Table Definition
Using the Grafana Service
Integrating the Telegraf Service
Performance White Paper
Test Environment
Testing Tool
Write Performance Test
Query Performance Test
FAQs
Glossary
CTSDB Policy
Privacy Policy
Data Privacy and Security Agreement
Contact Us
DocumentationTencentDB for CTSDBInfluxQL CompatibilityInfluxQL Functions

InfluxQL Functions

PDF
Focus Mode
Font Size
Last updated: 2025-04-29 23:11:35

Functions

 For the compatibility of InfluxQL function aggregation, selection, and transformation, see the table below. For details on syntax and examples, see InfluxQL functions.
Type
Function
InfluxDB OSS
TencentDB for CTSDB 3.0
Transformations
ABS()
✅
✅
ACOS()
✅
✅
ASIN()
✅
✅
ATAN()
✅
✅
ATAN2()
✅
✅
CEIL()
✅
✅
COS()
✅
✅
CUMULATIVE_SUM()
✅
❌
DERIVATIVE()
✅
❌
DIFFERENCE()
✅
❌
ELAPSED()
✅
❌
EXP()
✅
✅
FLOOR()
✅
✅
HISTOGRAM()
✅
❌
LN()
✅
✅
LOG()
✅
✅
LOG2()
✅
✅
LOG10()
✅
✅
MOVING_AVERAGE()
✅
❌
NON_NEGATIVE_DERIVATIVE()
✅
❌
NON_NEGATIVE_DIFFERENCE()
✅
❌
POW()
✅
✅
ROUND()
✅
✅
SIN()
✅
✅
SQRT()
✅
✅
TAN()
✅
✅
Aggregations
COUNT()
✅
✅
SUM()
✅
✅
MEAN()
✅
✅
PERCENTILE()
✅
✅
DISTINCT()
✅
❌
INTEGRAL()
✅
❌
MEDIAN()
✅
❌
MODE()
✅
❌
SPREAD()
✅
❌
STDDEV()
✅
❌
Selectors
MIN()
✅
✅
MAX()
✅
✅
TOP()
✅
✅
BOTTOM()
✅
✅
FIRST()
✅
✅*
Example
SELECT FIRST("level description") FROM "h2o_feet"
LAST()
✅
✅*
Example
SELECT LAST("level description"),"location","water_level" FROM "h2o_feet"
PERCENTILE()
✅
❌
SAMPLE()
✅
❌

Mathematical Operators

TencentDB for CTSDB 3.0 does not currently support functions related to data operation algorithms.
Function
InfluxDB OSS
TencentDB for CTSDB 3.0
cumulative_sum
✅
❌
derivative
✅
❌
non_negative_derivative
✅
❌
difference
✅
❌
non_negative_difference
✅
❌
elapsed
✅
❌
moving_average
✅
❌
holt_winters
✅
❌
holt_winters_with_fit
✅
❌
Previous Topic: Data QueryNext Topic: SDK Reference

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback