tencent cloud

InfluxQL Functions
Download PDF
Last updated: 2025-04-29 23:11:35
InfluxQL Functions
Last updated: 2025-04-29 23:11:35
Download PDF

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
✅
❌
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback