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

[jira] [Commented] (IOTDB-3624) Meet error when inserting data in SQL without timestamp

    [ https://issues.apache.org/jira/browse/IOTDB-3624?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17623482#comment-17623482 ] 

Minghui Liu commented on IOTDB-3624:
------------------------------------

We need to cherry-pick this PR to rel/0.13.

> Meet error when inserting data in SQL without timestamp
> -------------------------------------------------------
>
>                 Key: IOTDB-3624
>                 URL: https://issues.apache.org/jira/browse/IOTDB-3624
>             Project: Apache IoTDB
>          Issue Type: Bug
>          Components: Core/Server
>    Affects Versions: 0.13.0, 0.14.0-SNAPSHOT
>            Reporter: xiaozhihong
>            Assignee: liuyu
>            Priority: Minor
>              Labels: pull-request-available
>             Fix For: master branch
>
>         Attachments: image-2022-06-23-10-43-49-858.png, image-2022-09-14-11-27-49-721.png
>
>
> The replay scenario is: There are two time series, one is text data type, the other is float data type.  Default system time, inserted data at the same time, then there is a metadata error: the measurementList's size is not consistent with the valueList's size.
> {code:java}
> IoTDB> set storage group to root.sg;
> Msg: The statement is executed successfully.
> IoTDB> create timeseries root.sg.d1.s1 with datatype=FLOAT,encoding=RLE;
> Msg: The statement is executed successfully.
> IoTDB> create timeseries root.sg.d1.s2 with datatype=TEXT,encoding=RLE;
> Msg: 303: encoding RLE does not support TEXT
> IoTDB> create timeseries root.sg.d1.s2 with datatype=TEXT,encoding=PLAIN;
> Msg: The statement is executed successfully.
> IoTDB> show timeseries root.**;
> +-------------+-----+-------------+--------+--------+-----------+----+----------+
> |   timeseries|alias|storage group|dataType|encoding|compression|tags|attributes|
> +-------------+-----+-------------+--------+--------+-----------+----+----------+
> |root.sg.d1.s1| null|      root.sg|   FLOAT|     RLE|     SNAPPY|null|      null|
> |root.sg.d1.s2| null|      root.sg|    TEXT|   PLAIN|     SNAPPY|null|      null|
> +-------------+-----+-------------+--------+--------+-----------+----+----------+
> Total line number = 2
> It costs 0.072s
> IoTDB> insert into root.sg.d1(s1,s2) values(25,'test');
> Msg: 303: Check metadata error: the measurementList's size is not consistent with the valueList's size
>  {code}
> The log picture is as follow:
> !image-2022-06-23-10-43-49-858.png|width=557,height=226!



--
This message was sent by Atlassian Jira
(v8.20.10#820010)