关于STDDEV() 标准差聚合函数的计算问题

Describe your question

当时间区间的值不同的时候,可以算出标准差

当时间区间的值相同的时候,会返回错误:
ERR: struct { Results []*query.Result "json:"results,omitempty""; Err string "json:"error,omitempty"" }.Results: []*query.Result: json: unsupported value: NaN or ±Infinite

按照标准差计算公式,值相同返回的标准差应该为0

我是用java8的opengemini客户端去计算标准差时,如果时间区间内的值相同,返回的SeriesResult为空了
我希望值相同的时候,还是会返回SeriesResult数据,只是返回的标准差值为0,我应该怎么去做呢

补充:
1.使用openGemini版本:1.3.0
2.Java openGemini依赖版本: 0.3.3

该问题已被解决了，可以尝试拉仓库openGemini源码进行编译即可。下面是我用最新版本进行的一个复现过程。

> select * from stddev
name: stddev
+---------------------+----+------+
|        time         | t1 |  v1  |
+---------------------+----+------+
| 1755508476140013600 | t  | 12.1 |
| 1755508506053449900 | t1 | 12.1 |
| 1755508510049772100 | t2 | 12.1 |
| 1755508525602866800 | t3 |   17 |
+---------------------+----+------+
3 columns, 4 rows in set
> select v1 from stddev where time>=1755508476140013600 and time <=1755508510049772100
name: stddev
+---------------------+------+
|        time         |  v1  |
+---------------------+------+
| 1755508476140013600 | 12.1 |
| 1755508506053449900 | 12.1 |
| 1755508510049772100 | 12.1 |
+---------------------+------+
2 columns, 3 rows in set
> select stddev(v1) from stddev where time>=1755508476140013600 and time <=1755508510049772100
name: stddev
+---------------------+--------+
|        time         | stddev |
+---------------------+--------+
| 1755508476140013600 |      0 |
+---------------------+--------+

Navigation Menu

Repository navigation

关于STDDEV() 标准差聚合函数的计算问题 #876

Describe your question

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

关于STDDEV() 标准差聚合函数的计算问题 #876

Description

Describe your question

Activity

TDroyal commented on Aug 18, 2025

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions