You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Chao Wang (Jira)" <ji...@apache.org> on 2022/08/08 09:55:00 UTC
[jira] [Created] (IOTDB-4063) An error is reported when data from version 0.12 is exported to version 0.14.
Chao Wang created IOTDB-4063:
--------------------------------
Summary: An error is reported when data from version 0.12 is exported to version 0.14.
Key: IOTDB-4063
URL: https://issues.apache.org/jira/browse/IOTDB-4063
Project: Apache IoTDB
Issue Type: Bug
Components: Tools/Others
Reporter: Chao Wang
Fix For: 0.14.0
1. execute in 0.12 version
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-27T23:50:00.000+08:00, true, 5, 23, 15.88, 8888.88, "IOTDB!IOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-26T23:50:00.000+08:00, 1, 11, 8, 88.88, 8888.88, "IOTDB!@#B12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-22T00:00:00.000+08:00, true, 12, 25, 88.88, 8888.88, "12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-20T23:01:14.857+08:00, 0, 3, 15, 88.88, 8888.88, "@#$%IOTDB");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-20T16:05:02.001+08:00, 1, 7, 88, 83.08, 8888.88, "IOTDB!@#$%IOTDB!@#$%IOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T01:05:02.258+08:00, false, 9, 24, 88.88, 8888.88, "@#$%!@#$%12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:40:04.147+08:00, true, 10, 36, 88.88, 8888.88, "IOTDB!@#$%&IOTDB!@#$%IOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:39:04.147+08:00, false, 2, 36, 88.88, 8888.88, "IOTDBexcellent");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:40:25.976+08:00, false, 7, 36, 88.88, 8888.88, "GoodIOTDB12345");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:56:56.249+08:00, true, 14, 36, 88.88, 8888.88, "Hello_word");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:57:40.256+08:00, true, 14, 36, 88.88, 8888.88, "Nihao!");
INSERT INTO root.sgcc.wf01.wt01(timestamp, ts0, ts1, ts2, ts3, ts4, ts5) VALUES (2022-05-21T08:58:55.260+08:00, true, 14, 36, 88.88, 8888.88, "My&Name&Is&gaga");
2. ./export-csv.sh -h XXXXXXXX -p XXXX
3. in 0.14 version
./import-csv.sh -h XXXX -p XXXX
Import the data created in 313 to 320. The data is incompatible. The data type and encoding mode are changed. The data type changes from float to double and text to int32. The encoding mode is changed from PLAIN to RLE.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)