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)