刘珍 created IOTDB-1316: ------------------------- Summary: A sensor point value is invalid and this row can be imported successfully,but the following rows in this file are not executed Key: IOTDB-1316 URL: https://issues.apache.org/jira/browse/IOTDB-1316 Project: Apache IoTDB Issue Type: Bug Reporter: 刘珍 Attachments: image-2021-04-19-17-50-27-843.png
release 0.12.0 A sensor point value is invalid and this row can be imported successfully( the sensor point is null),but the following rows in this file are not executed。 cli execute : {color:#172b4d}CREATE TIMESERIES {color}[{color:#0052cc}root.db1.tab1.id{color}|http://root.db1.tab1.id/]{color:#172b4d} WITH DATATYPE=INT32, ENCODING=PLAIN{color} {color:#172b4d}CREATE TIMESERIES {color}[{color:#0052cc}root.db1.tab1.name{color}|http://root.db1.tab1.name/]{color:#172b4d} WITH DATATYPE=text, ENCODING=PLAIN{color} {color:#172b4d}CREATE TIMESERIES root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN{color} {color:#172b4d}CREATE TIMESERIES root.db1.tab1.country WITH DATATYPE=text, ENCODING=PLAIN{color} {color:#172b4d}CREATE TIMESERIES root.db1.tab1.salary WITH DATATYPE=float, ENCODING=PLAIN{color} {color:#172b4d}CREATE TIMESERIES root.db1.tab1.other WITH DATATYPE=double, ENCODING=PLAIN{color} {color:#172b4d}CREATE TIMESERIES root.db1.tab1.student WITH DATATYPE=boolean, ENCODING=PLAIN{color} {color:#172b4d} {color} 2 import files locate in csv_file directory : *cat csv_file/dump_ts3.csv :* Time,root.db1.tab1.country,root.db1.tab1.other,root.db1.tab1.student,root.db1.tab1.name,root.db1.tab1.id,root.db1.tab1.salary,root.db1.tab1.age 2021-04-19T16:28:19,usa,china,false,丽丽,1.0,5678.34,25.0 2021-04-19T16:28:29,usa,7.777777,false,支持,0.0,5678.34,25.0 2021-04-19T16:28:39,usa,7.777777,false,lily,1.0,5678.34,25.0 2021-04-19T16:28:49,usa,7.777777,false,lily2,2.0,5678.34,25.0 2021-04-19T16:28:59,usa,7.777777,false,lily3,3.0,5678.34,25.0 *cat csv_file/dump_ts4.csv :* Time,root.db1.tab1.country,root.db1.tab1.other,root.db1.tab1.student,root.db1.tab1.name,root.db1.tab1.id,root.db1.tab1.salary,root.db1.tab1.age 2021-04-19T16:29:19,usa,7.777777,false,lily,1.0,5678.34,25.0 2021-04-19T16:29:29,usa,7.777777,false,lily0,0.0,5678.34,25.0 2021-04-19T16:29:39,usa,7.777777,false,lily1,1.0,5678.34,25.0 2021-04-19T16:29:49,usa,7.777777,false,lily2,2.0,5678.34,25.0 2021-04-19T16:29:59,usa,7.777777,false,lily3,3.0,5678.34,25.0 import SQL: ./import-csv.sh -h 127.0.0.1 -p 6667 -u root -pw root -f ./csv_file ------------------------------------------ Starting IoTDB Client Import Script ------------------------------------------ Start to import data from: dump_ts3.csv Import from: dump_ts3.csv 0% │ │ 0/7 (0:00:00 / ?) Importing... Meet error when insert csv because org.apache.iotdb.db.exception.StorageEngineException: failed to insert measurements [other] {color:#FF0000}caused by For input string: "china";{color} Start to import data from: dump_ts4.csv Import from: dump_ts4.csv 0% │ │ 0/7 (0:00:00 / ?) Importing... Import from: dump_ts4.csv 100% │█████████████████████████████████████████████████████████│ 7/7 (0:00:00 / 0:00:00) Importing... cli: select * from root.db1.*; !image-2021-04-19-17-50-27-843.png! The last 4 rows in dump_ts3.csv are not imported. -- This message was sent by Atlassian Jira (v8.3.4#803005)