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/02/17 09:28:00 UTC

[jira] [Commented] (IOTDB-2521) Compatibility of 0.13 with 0.12 on group by level query

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

Yuan Tian commented on IOTDB-2521:
----------------------------------

It's a fake issue, group by level in 0.12.4 has been consistent with 0.13

> Compatibility of 0.13 with 0.12 on group by level query
> -------------------------------------------------------
>
>                 Key: IOTDB-2521
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2521
>             Project: Apache IoTDB
>          Issue Type: Task
>            Reporter: Jialin Qiao
>            Assignee: Minghui Liu
>            Priority: Major
>              Labels: 0.13.0
>
> Suppose we have timeseries:
> root.sg1.d1.s1
> root.sg2.d1.s1
>  
> For this sql: select count(s1) from root.sg1.d1 group by level=2
> 0.12 returns 2 column: root.sg1.d1,   root.sg2.d1
> 0.13 returns 1 column: root.*.d1
>  
> In 0.13, If we want to get the same result as 0.12, the SQL should be 
> select count(s1) from root.sg1.d1 group by level=1, 2
>  



--
This message was sent by Atlassian Jira
(v8.20.1#820001)