[
https://issues.apache.org/jira/browse/IOTDB-3413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Minghui Liu reassigned IOTDB-3413:
----------------------------------
Assignee: Alima777 (was: Minghui Liu)
> aggregate query by level and meet error
> ---------------------------------------
>
> Key: IOTDB-3413
> URL: https://issues.apache.org/jira/browse/IOTDB-3413
> Project: Apache IoTDB
> Issue Type: Bug
> Components: Core/Cluster, mpp-cluster
> Affects Versions: 0.14.0-SNAPSHOT
> Reporter: xiaozhihong
> Assignee: Alima777
> Priority: Major
> Attachments: image-2022-06-07-11-38-10-612.png
>
>
> Start 3 confignodes, 3 datanodes ,execute sql about aggregate query by level,
> then meet error.
> {code:java}
> IoTDB> select count(s1) from root.*.* group by level = 1;
> Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: "select count(s1)
> from root.*.* group by level = 1". executeStatement failed. Meet error when
> analyzing the query statement {code}
> The log picture is:
> !image-2022-06-07-11-38-10-612.png!
> Steps to reproduce:
> step1: start 3 confignodes and 3 datanodes
> step2: enter CLI, execute sql
> {code:java}
> create storage group root.sg;
> create timeseries root.sg.d1.s1 with datatype=float,encoding=RLE;
> create timeseries root.sg.d1.s2 with datatype=double,encoding=RLE;
> create timeseries root.sg.d1.s3 with datatype=int32,encoding=RLE;
> create timeseries root.sg.d1.s4 with datatype=int64,encoding=RLE;
> create timeseries root.sg.d1.s5 with datatype=int64,encoding=RLE;
> create timeseries root.sg.d2.s1 with datatype=INT32,encoding=RLE;
> create timeseries root.sg.d2.s2 with datatype=INT64,encoding=RLE;
> create timeseries root.sg.d2.s3 with datatype=Boolean,encoding=RLE;
> create timeseries root.sg.d2.s4 with datatype=TEXT,encoding=PLAIN;
> insert into root.sg.d1(time,s1,s2,s3,s4) values(1,1.1,2.2,2,2);
> insert into root.sg.d1(time,s1,s2,s3,s4) values(2,2.2,3.3,3,3);
> insert into root.sg.d1(time,s1,s2,s3,s4) values(5,3.2,4.5,5,14);
> insert into root.sg.d1(time,s1,s2,s3,s4) values(10,7.8,43.1,12,22);
> insert into root.sg.d2(time,s1,s2,s3,s4) values(1,1,2,TRUE,'10');
> insert into root.sg.d2(time,s1,s2,s3,s4) values(2,1,6,FALSE,'11');
> insert into root.sg.d2(time,s1,s2,s3,s4) values(5,13,32,TRUE,'13');
> insert into root.sg.d2(time,s1,s2,s3,s4) values(10,22,26,FALSE,'18');
> //aggregate query by level
> select count(s1) from root.*.* group by level = 1;{code}
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
