You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Zhijia Cao (Jira)" <ji...@apache.org> on 2023/03/05 05:17:00 UTC
[jira] [Created] (IOTDB-5619) group by tags query NPE

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)