You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Jialin Qiao (Jira)" <ji...@apache.org> on 2022/08/10 11:40:00 UTC
[jira] [Created] (IOTDB-4095) Result contains infinity in group by aggregation on double
Jialin Qiao created IOTDB-4095:
----------------------------------
Summary: Result contains infinity in group by aggregation on double
Key: IOTDB-4095
URL: https://issues.apache.org/jira/browse/IOTDB-4095
Project: Apache IoTDB
Issue Type: Bug
Affects Versions: 0.13.1
Reporter: Jialin Qiao
Attachments: image-2022-08-10-19-38-42-930.png
Need to check if this is a bug.
SET STORAGE GROUP TO root.t0;
CREATE TIMESERIES root.t0.c0 WITH DATATYPE=FLOAT, ENCODING=PLAIN;
CREATE TIMESERIES root.t0.c1 WITH DATATYPE=DOUBLE, ENCODING=GORILLA;
INSERT INTO root.t0(timestamp, c0) VALUES (84799, 0.44634657086762375);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (55768, 0.44634657086762375, 0.19800405137717525);
INSERT INTO root.t0(timestamp, c0) VALUES (49607, 0.6106445564782438);
INSERT INTO root.t0(timestamp, c0, c1) VALUES (39503, 0.15163431440713493, 0.08816170378111365);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (12492, 0.885314087043015, 0.39447991579532504);
INSERT INTO root.t0(timestamp, c1) VALUES (95937, 0.44634657086762375);
INSERT INTO root.t0(timestamp, c1) VALUES (78893, 0.47220064168506504);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (88064, 0.05518738529563716, 0.5525404919189046);
INSERT INTO root.t0(timestamp, c1) VALUES (63835, 0.19623169851193256);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (87895, 0.8135095034368431, 0.8768828240561801);
INSERT INTO root.t0(timestamp, c0) VALUES (93697, 0.33857283740233746);
INSERT INTO root.t0(timestamp, c1) VALUES (9603, 0.732498412173562);
INSERT INTO root.t0(timestamp, c0) VALUES (15566, 0.0030418591731676825);
INSERT INTO root.t0(timestamp, c1) VALUES (25965, -1.7976931348623157E308);
INSERT INTO root.t0(timestamp, c1) VALUES (89140, 0.8365030617509025);
INSERT INTO root.t0(timestamp, c0, c1) VALUES (1746, 0.08188411530923834, 0.7147301169425502);
INSERT INTO root.t0(timestamp, c1) VALUES (77989, 0.02783998710028357);
INSERT INTO root.t0(timestamp, c0) VALUES (54652, 0.08188411530923834);
INSERT INTO root.t0(timestamp, c0, c1) VALUES (97895, 0.933989440864464, 0.5628148350685789);
INSERT INTO root.t0(timestamp, c1) VALUES (35703, 0.39447991579532504);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (35818, 0.982319798594331, 0.982319798594331);
INSERT INTO root.t0(timestamp, c1) VALUES (1748, 0.33857283740233746);
INSERT INTO root.t0(timestamp, c0, c1) VALUES (33655, 0.7147301169425502, 0.44634657086762375);
INSERT INTO root.t0(timestamp, c0, c1) VALUES (4985, 0.8541889863676835, 0.2884163155214048);
INSERT INTO root.t0(timestamp, c1) VALUES (76250, 0.6175195956502463);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (54801, 0.19623169851193256, 0.19800405137717525);
INSERT INTO root.t0(timestamp, c0) VALUES (40864, 0.8323909850340964);
INSERT INTO root.t0(timestamp, c1, c0) VALUES (96207, 0.6672599548290107, 0.5525404919189046);
select avg(c0), avg(c1) from root.* group by([1000, 100000), 20000ms);
select avg(c0), avg(c1) from root.* group by([1000, 100000), 30000ms);
select avg(c0), avg(c1) from root.* group by([1000, 100000), 40000ms);
!image-2022-08-10-19-38-42-930.png!
--
This message was sent by Atlassian Jira
(v8.20.10#820010)