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 08:44:00 UTC

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

    [ https://issues.apache.org/jira/browse/IOTDB-4751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17623667#comment-17623667 ] 

xiaozhihong commented on IOTDB-4751:
------------------------------------

About  LIMIT, SLIMIT, OFFSET, SOFFSET is not checked currently. 
!image-2022-10-25-16-42-50-131.png!

> [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
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: image-2022-10-25-15-46-51-708.png, image-2022-10-25-16-42-50-131.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)