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

Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2022/10/25 07:47:00 UTC

[jira] [Created] (IOTDB-4751) [cluster]Aggregation by Tags with having clause is not checked

xiaozhihong created IOTDB-4751:
----------------------------------

             Summary: [cluster]Aggregation by Tags with having clause is not checked
                 Key: IOTDB-4751
                 URL: https://issues.apache.org/jira/browse/IOTDB-4751
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Query
    Affects Versions: 0.14.0-SNAPSHOT
            Reporter: xiaozhihong
            Assignee: Eric Pai
         Attachments: image-2022-10-25-15-46-51-708.png

commit cbc622573fe403b4e91bd576bf5b49156d1c91eb
Start 3CD, then execute write and query SQL. The limitation of Aggregation by Tags, with the having clause is not currently supported, but no verification is currently added.
{code:java}
IoTDB> SELECT COUNT(temperature) FROM root.** GROUP BY ([1000, 10000), 5s), TAGS(city, workshop) having count(temperature) > 5;
Msg: 400: null {code}
!image-2022-10-25-15-46-51-708.png|width=592,height=130!



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