You are viewing a plain text version of this content. The canonical link for it is here.

Posted to notifications@iotdb.apache.org by "Chao Wang (Jira)" <ji...@apache.org> on 2022/07/16 10:03:00 UTC

[jira] [Created] (IOTDB-3842) Failed to Group by

Chao Wang created IOTDB-3842:
--------------------------------

             Summary: Failed to Group by 
                 Key: IOTDB-3842
                 URL: https://issues.apache.org/jira/browse/IOTDB-3842
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Cluster
            Reporter: Chao Wang
             Fix For: 0.14.0


INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-27T23:50:00.000+08:00, true, 5, 23, 15.88, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12346");

INSERT INTO root.sgcc.wf01.wt01(timestamp,  ts1) VALUES (now(), 1);

INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (now(), true, 5, 23, 15.88, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12345")

SELECT COUNT(ts1) FROM root.sgcc.wf01.wt01 WHERE ts1 > 5 and time < 2022-05-26T14:00:00.000+08:00 GROUP BY LEVEL = 1

 

throw exception:

Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "SELECT COUNT(ts1) FROM root.sgcc.wf01.wt01 WHERE ts1 > 5 and time < 2022-05-26T14:00:00.000+08:00 GROUP BY LEVEL = 1". executeStatement failed. null



--
This message was sent by Atlassian Jira
(v8.20.10#820010)