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 2023/05/30 11:12:00 UTC

[jira] [Created] (IOTDB-5941) Same Column in one group by level query

Yuan Tian created IOTDB-5941:
--------------------------------

             Summary: Same Column in one group by level query
                 Key: IOTDB-5941
                 URL: https://issues.apache.org/jira/browse/IOTDB-5941
             Project: Apache IoTDB
          Issue Type: Bug
            Reporter: Yuan Tian
            Assignee: 李伟豪


初始化数据如下: insert into root.ln.wf01.wt01(timestamp,temp1)values(0,21); insert into root.ln.wf01.wt01(timestamp,temp1)values(3600000,22); insert into root.ln.wf01.wt01(timestamp,temp2)values(0,23); insert into root.ln.wf01.wt01(timestamp,temp2)values(3600000,24); insert into root.ln.wf01.wt02(timestamp,temp1)values(0,25); insert into root.ln.wf01.wt02(timestamp,temp1)values(3600000,26); insert into root.ln.wf01.wt02(timestamp,temp2)values(0,27); insert into root.ln.wf01.wt02(timestamp,temp2)values(3600000,28); insert into root.ln.wf01.wt03(timestamp,temp1)values(0,29); insert into root.ln.wf01.wt03(timestamp,temp1)values(3600000,30); insert into root.ln.wf01.wt03(timestamp,temp2)values(0,31); insert into root.ln.wf01.wt03(timestamp,temp2)values(3600000,32); 查询sql:  select avg(temp1) from root.ln.wf01.wt03, root.ln.wf01.wt01 group by ([1970-01-01T08:00:00,1970-01-01T10:00:00),1h),level=2



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