刘珍 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)
