You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Yuan Tian (Jira)" <ji...@apache.org> on 2022/11/22 07:54:00 UTC

[jira] [Assigned] (IOTDB-5018) Failed to COUNT group by level

     [ https://issues.apache.org/jira/browse/IOTDB-5018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Yuan Tian reassigned IOTDB-5018:
--------------------------------

      Sprint: 2022-11-Cluster
    Assignee: 李伟豪

> Failed to COUNT group by level
> ------------------------------
>
>                 Key: IOTDB-5018
>                 URL: https://issues.apache.org/jira/browse/IOTDB-5018
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: mpp-cluster
>            Reporter: Chao Wang
>            Assignee: 李伟豪
>            Priority: Critical
>             Fix For: 1.0.0
>
>
> INSERT INTO root.test.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (1, false, 3, 5, 6.8, 99.88, 'IoTDB');
> INSERT INTO root.test.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2, false, 3, 5, 6.8, 99.88, 'IoTDB'),(10, true, 3, 5, 6.8, 99.88, 'IoTDB');
> INSERT INTO root.test.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (11, false, 3, 5, 6.8, 99.88, 'IoTDB'),(20, false, 3, 5, 6.8, 99.88, 'IoTDB'),(12, true, 3, 5, 6.8, 99.88, 'IoTDB');
> select COUNT(ts0), FIRST_VALUE(ts1), FIRST_VALUE(ts2) , LAST_VALUE(ts3) , MAX_TIME(ts4), MIN_TIME(ts5)  from root.test.wf01.wt01 group by level = 1,3
>  
> Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "select COUNT(ts0)  from root.test.wf01.wt01 group by level = 1,3". executeStatement failed. null



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