You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@iotdb.apache.org by "Haonan Hou (Jira)" <ji...@apache.org> on 2021/05/06 13:08:00 UTC

[jira] [Commented] (IOTDB-1316) A sensor point value is invalid and this row can be imported successfully,but the following rows in this file are not executed

    [ https://issues.apache.org/jira/browse/IOTDB-1316?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17340195#comment-17340195 ] 

Haonan Hou commented on IOTDB-1316:
-----------------------------------

Hi, I'd like to make sure this.

{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 root.db1.tab1.age WITH DATATYPE=INT32, ENCODING=PLAIN{color}

 

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

The data types of id and age are not same with the types in csv data which are 1.0 and 25.0....

 

I tried to reproduce this issue, but I didn't see what you got. 

 

cat 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

 

!image-2021-05-06-21-03-07-103.png!

> 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: 刘珍
>            Priority: Major
>              Labels: pull-request-available
>         Attachments: image-2021-04-19-17-50-27-843.png, image-2021-05-06-21-03-07-103.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)