Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
0.12.0
-
None
-
None
Description
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 :
CREATE TIMESERIES root.db1.tab1.id WITH DATATYPE=INT32, ENCODING=PLAIN
CREATE TIMESERIES root.db1.tab1.name WITH DATATYPE=text, ENCODING=PLAIN
CREATE TIMESERIES root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN
CREATE TIMESERIES root.db1.tab1.country WITH DATATYPE=text, ENCODING=PLAIN
CREATE TIMESERIES root.db1.tab1.salary WITH DATATYPE=float, ENCODING=PLAIN
CREATE TIMESERIES root.db1.tab1.other WITH DATATYPE=double, ENCODING=PLAIN
CREATE TIMESERIES root.db1.tab1.student WITH DATATYPE=boolean, ENCODING=PLAIN
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] caused by For input string: "china";
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.*;
The last 4 rows in dump_ts3.csv are not imported.
Attachments
Attachments
Issue Links
- is a child of
-
IOTDB-842 Better Export/Import-CSV Tool
- Closed
- links to