Zhijia Cao created IOTDB-5619:
---------------------------------
Summary: 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
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)
