tencent cloud

TencentDB for CTSDB

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