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 | ✅ | ❌ |