[ https://issues.apache.org/jira/browse/IOTDB-5619?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuan Tian reassigned IOTDB-5619: -------------------------------- Assignee: Eric Pai > group by tags query NPE > ----------------------- > > Key: IOTDB-5619 > URL: https://issues.apache.org/jira/browse/IOTDB-5619 > Project: Apache IoTDB > Issue Type: Bug > Reporter: Zhijia Cao > Assignee: Eric Pai > Priority: Major > Attachments: image-2023-03-05-13-15-00-140.png > > > *data:* > CREATE DATABASE root.db; > CREATE DATABASE root.db1; > CREATE TIMESERIES root.db.d1.s1 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Beijing); > CREATE TIMESERIES root.db.d1.s2 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db.d1.s3 WITH DATATYPE=BOOLEAN, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db.d2.s1 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db.d2.s2 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db.d2.s3 WITH DATATYPE=BOOLEAN, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db1.d1.s1 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db1.d1.s2 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db1.d1.s3 WITH DATATYPE=BOOLEAN, ENCODING=PLAIN > tags(city=Nanjing; > CREATE TIMESERIES root.db1.d2.s1 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db1.d2.s2 WITH DATATYPE=INT32, ENCODING=PLAIN > tags(city=Nanjing); > CREATE TIMESERIES root.db1.d2.s3 WITH DATATYPE=BOOLEAN, ENCODING=PLAIN > tags(city=Nanjing); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(1, 2, 10, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(2, null, 20, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(3, 10, 0, null); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(4, 303, 30, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(5, null, 20, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(6, 110, 20, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(7, 302, 20, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(8, 110, null, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(9, 60, 20, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(10,70, 20, null); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(1677570934, 30, 0, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(1, 80, 30, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(2, null, 30, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(3, 60, 30, null); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(4, 40, 20, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(5, null, 40, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(6, 40, 50, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(7, 40, 60, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(8, 40, null, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(9, 50, 70, true); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(10, 60, 80, null); > INSERT INTO root.db.d2(timestamp,s1,s2,s3) values(1677570934, 90, 90, true); > INSERT INTO root.db.d1(timestamp,s1,s2,s3) values(1, 70, 90, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(2, null, 80, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(3, 80, 70, null); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(4, 90, 70, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(5, null, 60, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(6, 20, 100, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(7, 10, 20, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(8, 20, null, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(9, 30, 20, true); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(10, 10, 20, null); > INSERT INTO root.db1.d1(timestamp,s1,s2,s3) values(1677570934, 0, 20, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(1, 10, 20, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(2, null, null, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(3, null, 20, null); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(4, 0, 0, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(5, null, 0, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(6, 0, 0, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(7, 1, 0, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(8, 1, null, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(9, null, 20, true); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(10, 1, 0, null); > INSERT INTO root.db1.d2(timestamp,s1,s2,s3) values(1677570939, 1, 0, true); > flush; > > *sql:* > select avg(s1),avg(s2) from root.** group by tags(city) > !image-2023-03-05-13-15-00-140.png! -- This message was sent by Atlassian Jira (v8.20.10#820010)