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)

Reply via email to