You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "xiaozhihong (Jira)" <ji...@apache.org> on 2022/01/11 03:26:00 UTC

[jira] [Created] (IOTDB-2346) Select INTO Reports NPE for time series containing NULL

xiaozhihong created IOTDB-2346:
----------------------------------

             Summary: Select INTO Reports NPE for time series containing NULL
                 Key: IOTDB-2346
                 URL: https://issues.apache.org/jira/browse/IOTDB-2346
             Project: Apache IoTDB
          Issue Type: Bug
          Components: Core/Server
    Affects Versions: 0.13.0-SNAPSHOT
            Reporter: xiaozhihong
         Attachments: image-2022-01-11-11-24-24-755.png

IoTDB> select * from root.sg.d2
+-----------------------------+-------------+-------------+-------------+-------------+
|                         Time|root.sg.d2.s3|root.sg.d2.s4|root.sg.d2.s1|root.sg.d2.s2|
+-----------------------------+-------------+-------------+-------------+-------------+
|1970-01-01T08:00:00.001+08:00|         true|           V1|            1|          1.0|
|1970-01-01T08:00:00.002+08:00|         true|           V1|            1|          1.0|
|1970-01-01T08:00:00.003+08:00|         true|           V1|            1|          1.0|
|1970-01-01T08:00:00.004+08:00|         true|           V1|            1|          1.0|
|1970-01-01T08:00:00.005+08:00|         true|           V1|            1|          1.0|
|2020-08-18T10:22:41.093+08:00|         null|         null|            1|          2.0|
|2020-08-18T10:22:52.603+08:00|         true|         null|            1|          2.0|
|2020-08-18T11:22:52.603+08:00|         null|         null|            2|         null|
|2020-08-18T12:22:52.603+08:00|         null|         null|            2|         null|
|2020-08-18T13:22:52.603+08:00|         null|         null|            3|         null|
|2020-08-18T14:22:52.603+08:00|         null|         null|            3|         null|
|2020-08-18T15:22:52.603+08:00|         null|         null|            3|         null|
+-----------------------------+-------------+-------------+-------------+-------------+
Total line number = 12
It costs 0.005s
IoTDB> select s1, s2, s3, s4
> into ${1}_t1, ${2}, root.${2}.${1}.t2, root.sg.d2.t3
> from root.sg.d2
Msg: 500: [INTERNAL_SERVER_ERROR(500)] Exception occurred: executeNonQueryPlan failed. null

 

Server log:

!image-2022-01-11-11-24-24-755.png!



--
This message was sent by Atlassian Jira
(v8.20.1#820001)