You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Yuan Tian (Jira)" <ji...@apache.org> on 2023/03/07 08:28:00 UTC
[jira] [Assigned] (IOTDB-5619) group by tags query NPE
[ 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)