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