时序数据库 CTSDB InfluxQL 函数-时序数据库 InfluxDB 版-文档中心-腾讯云

Functions
 InfluxQL 函数聚合、选择、转换的兼容性，请参见下表。具体使用语法、示例等详情，请参见 InfluxQL functions。
类型
函数
开源 InfluxDB 版
时序数据库 InfluxDB 版
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()
✅
✅*
执行示例
SELECT FIRST("level description") FROM "h2o_feet"
﻿
LAST()
✅
✅*
执行示例
SELECT LAST("level description"),"location","water_level" FROM "h2o_feet"
﻿
PERCENTILE()
✅
❌
﻿
SAMPLE()
✅
❌
数学运算符（mathematical operators）
时序数据库 InfluxDB 版当前暂不支持数据运算法相关的函数。
函数
开源 InfluxDB 
时序数据库 InfluxDB 版
cumulative_sum
✅
❌
derivative
✅
❌
non_negative_derivative
✅
❌
difference
✅
❌
non_negative_difference
✅
❌
elapsed
✅
❌
moving_average
✅
❌
holt_winters
✅
❌
holt_winters_with_fit
✅
❌
﻿

类型	函数	开源 InfluxDB 版	时序数据库 InfluxDB 版
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()	✅	✅* 执行示例 `SELECT FIRST("level description") FROM "h2o_feet"`
		LAST()	✅	✅* 执行示例 `SELECT LAST("level description"),"location","water_level" FROM "h2o_feet"`
		PERCENTILE()	✅	❌
		SAMPLE()	✅	❌

函数	开源 InfluxDB	时序数据库 InfluxDB 版
cumulative_sum	✅	❌
derivative	✅	❌
non_negative_derivative	✅	❌
difference	✅	❌
non_negative_difference	✅	❌
elapsed	✅	❌
moving_average	✅	❌
holt_winters	✅	❌
holt_winters_with_fit	✅	❌

InfluxQL 函数

本页目录：

Functions

数学运算符（mathematical operators）