[jira] [Assigned] (IOTDB-2375) [CQ]Get a wrong result of timeseries[schema]

["Steve Yurong Su (Jira)" <ji...@apache.org>]

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

Steve Yurong Su reassigned IOTDB-2375:
--------------------------------------

    Assignee: Steve Yurong Su

> [CQ]Get a wrong result of timeseries[schema]
> --------------------------------------------
>
>                 Key: IOTDB-2375
>                 URL: https://issues.apache.org/jira/browse/IOTDB-2375
>             Project: Apache IoTDB
>          Issue Type: Bug
>    Affects Versions: 0.13.0
>            Reporter: FengQingxin
>            Assignee: Steve Yurong Su
>            Priority: Major
>         Attachments: image-2022-01-13-10-57-52-074.png, image-2022-01-13-11-11-33-190.png
>
>
> 数据模式[2个存储组管理30个设备，每个设备30个传感器]
> 期望：使用CQ创建一个持续查询所有设备的s_12传感器平均值写回到root.cqa3下，仍保留时间序列信息中的存储组信息，设备信息后添加_avg12表示是传感器s_12的平均值。
> 实际：只产生了2个时间序列。没有达到预期。
> !image-2022-01-13-10-57-52-074.png!
> CREATE CONTINUOUS QUERY cqb3 RESAMPLE EVERY 20s FOR 20s BEGIN SELECT avg(s_12) INTO root.cqb3.${2}.${3}.avg12 from root.test.*.* GROUP BY time(10s)END
> 这个语句可以产生预期的30条时间序列
> !image-2022-01-13-11-11-33-190.png!



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